DBA Data[Home] [Help]

APPS.AR_CMGT_CONTROLS dependencies on AR_CMGT_CF_DNB_DTLS

Line 15: INSERT INTO ar_cmgt_cf_dnb_dtls (

11: p_resultout OUT NOCOPY VARCHAR2) IS
12: BEGIN
13: p_resultout := 0;
14:
15: INSERT INTO ar_cmgt_cf_dnb_dtls (
16: case_folder_id,
17: source_table_name,
18: source_key,
19: source_key_type,

Line 41: p_errmsg := 'Error while inserting into ar_cmgt_cf_dnb_dtls '||sqlerrm;

37: sysdate,
38: fnd_global.login_id);
39: EXCEPTION
40: WHEN OTHERS THEN
41: p_errmsg := 'Error while inserting into ar_cmgt_cf_dnb_dtls '||sqlerrm;
42: p_resultout := 1;
43: END;
44:
45: PROCEDURE POPULATE_CF_DETAILS_PVT (

Line 951: INSERT INTO AR_CMGT_CF_DNB_DTLS

947: IF l_processing_flag = 'Y'
948: THEN
949:
950: BEGIN
951: INSERT INTO AR_CMGT_CF_DNB_DTLS
952: (CASE_FOLDER_ID,
953: SOURCE_TABLE_NAME,
954: SOURCE_KEY,
955: SOURCE_KEY_TYPE,

Line 974: FROM AR_CMGT_CF_DNB_DTLS

970: sysdate,
971: fnd_global.login_id,
972: sysdate,
973: fnd_global.user_id
974: FROM AR_CMGT_CF_DNB_DTLS
975: WHERE CASE_FOLDER_ID=p_parnt_case_folder_id);
976: EXCEPTION
977: WHEN OTHERS
978: THEN