APPS.OKS_K_ACTIONS_PVT dependencies on OKS_EMAIL_DETAILS

Line 758: into OKS_EMAIL_DETAILS table and

754:
755:
756: /*
757: This method will insert the email details
758: into OKS_EMAIL_DETAILS table and
759: will return email_id as the output parameter value.-Bug#4911901
760: */
761:
762: PROCEDURE STORE_EMAIL_DTLS

Line 827: INSERT INTO oks_email_details

823: END IF;
824:
825: BEGIN
826:
827: INSERT INTO oks_email_details
828: (
829: email_id,
830: from_address,
831: to_address,

Line 847: oks_email_details_s1.nextval,

843: LAST_UPDATE_LOGIN
844: )
845: VALUES
846: (
847: oks_email_details_s1.nextval,
848: p_from_address,
849: p_to_address,
850: p_cc_address,
851: p_reply_to_address,

Line 928: This API will retrieve email details from OKS_EMAIL_DETAILS table.-Bug#4911901

924: END STORE_EMAIL_DTLS;
925:
926:
927: /*
928: This API will retrieve email details from OKS_EMAIL_DETAILS table.-Bug#4911901
929: */
930:
931: PROCEDURE GET_EMAIL_DTLS
932: (

Line 965: FROM OKS_EMAIL_DETAILS

961:
962:
963: SELECT email_body
964: INTO x_email_body
965: FROM OKS_EMAIL_DETAILS
966: WHERE email_id = p_email_id;
967:
968: -- end debug log
969: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1006: This API will delete email details from OKS_EMAIL_DETAILS table.-Bug#4911901

1002: END GET_EMAIL_DTLS;
1003:
1004:
1005: /*
1006: This API will delete email details from OKS_EMAIL_DETAILS table.-Bug#4911901
1007: */
1008: PROCEDURE DEL_EMAIL_DTLS
1009: (
1010: p_email_id IN NUMBER,

Line 1039: DELETE FROM OKS_EMAIL_DETAILS WHERE email_id = p_email_id;

1035:
1036: -- set context to multi org
1037: mo_global.init('OKC');
1038:
1039: DELETE FROM OKS_EMAIL_DETAILS WHERE email_id = p_email_id;
1040:
1041: IF SQL%ROWCOUNT = 0 THEN
1042:
1043: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1046: '402: Rows are deleted successfully from OKS_EMAIL_DETAILS table');

1042:
1043: IF (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1044: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE ,
1045: G_MODULE||l_api_name,
1046: '402: Rows are deleted successfully from OKS_EMAIL_DETAILS table');
1047: END IF;
1048:
1049: END IF;
1050: