Non-Function #124 » KORAIL_kakao_message_ORACLE_procedure.txt
| 1 |
*Procedure name |
|---|---|
| 2 |
|
| 3 |
PR_CM_SY_SMS_SEND_STORYWAYAPP |
| 4 |
|
| 5 |
|
| 6 |
|
| 7 |
* parameters |
| 8 |
|
| 9 |
( |
| 10 |
|
| 11 |
P_MESSAGE_TITLE IN VARCHAR2 /* not set */ |
| 12 |
|
| 13 |
,P_MESSAGE IN VARCHAR2 /* message content */ |
| 14 |
|
| 15 |
,P_RECV_TEL_NO IN VARCHAR2 /* reciver phone no */ |
| 16 |
|
| 17 |
,P_SEND_DATE IN VARCHAR2 DEFAULT TO_CHAR(SYSDATE,'YYYYMMDDHH24MISS') /* message send date time */ |
| 18 |
|
| 19 |
,P_KAKAO_MSG_ID IN VARCHAR2 DEFAULT '' /* kakao message template id */ |
| 20 |
|
| 21 |
) |
| 22 |
|
| 23 |
|
| 24 |
|
| 25 |
* 카카오 메세지 템플릿 ID (소문자) |
| 26 |
|
| 27 |
1) 모바일앱_배송알림 : ap0001 |
| 28 |
|
| 29 |
2) 모바일앱_포인트소멸안내 : ap0002 |
| 30 |
|
| 31 |
2) 모바일앱_휴면회원안내 : ap0003 |
| 32 |
|