APPS.CAC_SYNC_CONTACTS_PVT dependencies on CAC_SYNC_CONTACT_TEMPS

Line 17: SELECT CAC_SYNC_CONTACT_TEMPS_S.NEXTVAL SYNC_CONTACT_TEMP_ID,

13: b_bookmark_category VARCHAR2,
14: b_bookmark_preference VARCHAR2)
15:
16: IS
17: SELECT CAC_SYNC_CONTACT_TEMPS_S.NEXTVAL SYNC_CONTACT_TEMP_ID,
18: HPP.VALUE_NUMBER REL_CONTACT_PARTY_ID
19: , ORG.PARTY_ID ORG_PARTY_ID
20: , ORG.PARTY_NAME ORG_NAME
21: , PERSON.PARTY_ID PERSON_PARTY_ID

Line 238: SELECT CAC_SYNC_CONTACT_TEMPS_S.NEXTVAL SYNC_CONTACT_TEMP_ID

234: b_bookmark_module VARCHAR2,
235: b_bookmark_category VARCHAR2,
236: b_bookmark_preference VARCHAR2)
237: IS
238: SELECT CAC_SYNC_CONTACT_TEMPS_S.NEXTVAL SYNC_CONTACT_TEMP_ID
239: , REL_CONTACT_PARTY_ID
240: , ORG_PARTY_ID
241: , ORG_NAME
242: , PERSON_PARTY_ID

Line 585: CAC_SYNC_CONTACT_TEMPS_S.NEXTVAL SYNC_CONTACT_TEMP_ID,

581: b_bookmark_preference VARCHAR2)
582:
583: IS
584: SELECT
585: CAC_SYNC_CONTACT_TEMPS_S.NEXTVAL SYNC_CONTACT_TEMP_ID,
586: CSUM.GUID REL_CONTACT_PARTY_ID,
587: -1 ORG_PARTY_ID,
588: NULL ORG_NAME,
589: -1 PERSON_PARTY_ID,

Line 630: IS SELECT CAC_SYNC_CONTACT_TEMPS_S.NEXTVAL SYNC_CONTACT_TEMP_ID

626: b_bookmark_category VARCHAR2,
627: b_bookmark_preference VARCHAR2
628: )
629:
630: IS SELECT CAC_SYNC_CONTACT_TEMPS_S.NEXTVAL SYNC_CONTACT_TEMP_ID
631: , HPP.VALUE_NUMBER REL_CONTACT_PARTY_ID
632: , ORG.PARTY_ID ORG_PARTY_ID
633: , ORG.PARTY_NAME ORG_NAME
634: , PERSON.PARTY_ID PERSON_PARTY_ID

Line 847: ** and populates the CAC_SYNC_CONTACT_TEMPS table

843: **
844: ** PREPARE_FASTSYNC
845: **
846: ** Performs a fetch from HZ tables based on the timestamp
847: ** and populates the CAC_SYNC_CONTACT_TEMPS table
848: **
849: *******************************************************************************/
850: (
851: p_api_version IN NUMBER -- Standard version parameter

Line 885: -- Emptying the CAC_SYNC_CONTACT_TEMPS table not reqd as using ON COMMIT DELETE ROWS clause

881: THEN
882: fnd_msg_pub.initialize;
883: END IF;
884:
885: -- Emptying the CAC_SYNC_CONTACT_TEMPS table not reqd as using ON COMMIT DELETE ROWS clause
886: cac_sync_contact_util_pvt.log(p_message=>'Querying the new contacts...',
887: p_msg_level=>fnd_log.level_procedure,
888: p_module_prefix=>'PREPARE_FASTSYNC');
889:

Line 897: INSERT INTO CAC_SYNC_CONTACT_TEMPS

893: l_bkm_module,
894: l_bkm_category,
895: l_bkm_preference_code)
896: LOOP
897: INSERT INTO CAC_SYNC_CONTACT_TEMPS
898: (sync_contact_temp_id
899: ,rel_contact_party_id
900: ,org_party_id
901: ,org_name

Line 970: INSERT INTO CAC_SYNC_CONTACT_TEMPS

966: l_bkm_module,
967: l_bkm_category,
968: l_bkm_preference_code)
969: LOOP
970: INSERT INTO CAC_SYNC_CONTACT_TEMPS
971: (sync_contact_temp_id
972: ,rel_contact_party_id
973: ,org_party_id
974: ,org_name

Line 1042: INSERT INTO CAC_SYNC_CONTACT_TEMPS

1038: l_bkm_module,
1039: l_bkm_category,
1040: l_bkm_preference_code)
1041: LOOP
1042: INSERT INTO CAC_SYNC_CONTACT_TEMPS
1043: (sync_contact_temp_id
1044: ,rel_contact_party_id
1045: ,org_party_id
1046: ,org_name

Line 1138: ** and populates the CAC_SYNC_CONTACT_TEMPS table

1134: **
1135: ** PREPARE_SLOWSYNC
1136: **
1137: ** Performs a fetch from HZ tables for ALL synchronizable contact records
1138: ** and populates the CAC_SYNC_CONTACT_TEMPS table
1139: **
1140: *******************************************************************************/
1141: (
1142: p_api_version IN NUMBER -- Standard version parameter

Line 1172: -- Emptying the CAC_SYNC_CONTACT_TEMPS table not reqd as using ON COMMIT DELETE ROWS clause

1168: THEN
1169: fnd_msg_pub.initialize;
1170: END IF;
1171:
1172: -- Emptying the CAC_SYNC_CONTACT_TEMPS table not reqd as using ON COMMIT DELETE ROWS clause
1173:
1174: cac_sync_contact_util_pvt.log(p_message=>'Retrieving all the contacts...',
1175: p_msg_level=>fnd_log.level_procedure,
1176: p_module_prefix=>'PREPARE_SLOWSYNC');

Line 1184: INSERT INTO CAC_SYNC_CONTACT_TEMPS

1180: l_bkm_module,
1181: l_bkm_category,
1182: l_bkm_preference_code)
1183: LOOP
1184: INSERT INTO CAC_SYNC_CONTACT_TEMPS
1185: (sync_contact_temp_id
1186: ,rel_contact_party_id
1187: ,org_party_id
1188: ,org_name