[Home] [Help]
640: SELECT oc.ORG_CONTACT_ID
641: FROM HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACTS soc
642: WHERE oc.PARTY_RELATIONSHIP_ID = p_from_id
643: AND SOC.ORG_CONTACT_ID=oc.ORG_CONTACT_ID) LOOP
644: HZ_DQM_SYNC.stage_contact_merge(
645: 'HZ_STAGED_CONTACTS',
646: ORG_CT.ORG_CONTACT_ID,l_dummy_id,
647: ORG_CT.ORG_CONTACT_ID,ORG_CT.ORG_CONTACT_ID,
648: 'HZ_ORG_CONTACTS',
699: SELECT oc.ORG_CONTACT_ID
700: FROM HZ_ORG_CONTACTS oc, HZ_STAGED_CONTACTS soc
701: WHERE oc.PARTY_RELATIONSHIP_ID = p_from_id
702: AND SOC.ORG_CONTACT_ID=oc.ORG_CONTACT_ID) LOOP
703: HZ_DQM_SYNC.stage_contact_merge(
704: 'HZ_STAGED_CONTACTS',
705: ORG_CT.ORG_CONTACT_ID,l_dummy_id,
706: ORG_CT.ORG_CONTACT_ID,ORG_CT.ORG_CONTACT_ID,
707: 'HZ_ORG_CONTACTS',
797: FOR ORG_CT IN (
798: SELECT soc.ORG_CONTACT_ID
799: FROM HZ_STAGED_CONTACTS soc
800: WHERE SOC.ORG_CONTACT_ID= p_from_id) LOOP
801: HZ_DQM_SYNC.stage_contact_merge(
802: 'HZ_STAGED_CONTACTS',
803: ORG_CT.ORG_CONTACT_ID,l_dummy_id,
804: ORG_CT.ORG_CONTACT_ID,ORG_CT.ORG_CONTACT_ID,
805: 'HZ_ORG_CONTACTS',
1277: FOR CPT IN (
1278: SELECT CONTACT_POINT_ID FROM HZ_STAGED_CONTACT_POINTS
1279: WHERE CONTACT_POINT_ID=p_from_id) LOOP
1280:
1281: HZ_DQM_SYNC.stage_contact_point_merge(
1282: 'HZ_STAGED_CONTACT_POINTS',
1283: p_from_id,l_dummy_id,p_from_id,p_from_id,
1284: 'HZ_CONTACT_POINTS',
1285: p_batch_id,p_batch_party_id,x_return_status);
2387: FOR CPT IN (
2388: SELECT CONTACT_POINT_ID FROM HZ_STAGED_CONTACT_POINTS
2389: WHERE CONTACT_POINT_ID=p_from_id) LOOP
2390:
2391: HZ_DQM_SYNC.stage_contact_point_merge(
2392: 'HZ_STAGED_CONTACT_POINTS',
2393: p_from_id,l_dummy_id,p_from_id,p_from_id,
2394: 'HZ_CONTACT_POINTS',
2395: p_batch_id,p_batch_party_id,x_return_status);
3018: program_id = hz_utility_pub.program_id,
3019: program_update_date = sysdate
3020: WHERE contact_point_id = p_from_id;
3021:
3022: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N'
3023: AND RECORD_ID=p_from_id AND ENTITY='CONTACT_POINTS';
3024:
3025: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
3026: p_init_msg_list => FND_API.G_FALSE,
3175: program_id = hz_utility_pub.program_id,
3176: program_update_date = sysdate
3177: WHERE contact_point_id = p_from_id;
3178:
3179: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N'
3180: AND RECORD_ID=p_from_id AND ENTITY='CONTACT_POINTS';
3181:
3182: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
3183: p_init_msg_list => FND_API.G_FALSE,
4683: program_id = hz_utility_pub.program_id,
4684: program_update_date = sysdate
4685: WHERE org_contact_id = p_from_id;
4686:
4687: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N' AND ENTITY='CONTACTS'
4688: AND RECORD_ID=p_from_id;
4689:
4690: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
4691: p_init_msg_list => FND_API.G_FALSE,
4856: program_id = hz_utility_pub.program_id,
4857: program_update_date = sysdate
4858: WHERE org_contact_id = p_from_id;
4859:
4860: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N' AND ENTITY='CONTACTS'
4861: AND RECORD_ID=p_from_id;
4862:
4863: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
4864: p_init_msg_list => FND_API.G_FALSE,
6560:
6561: SAVEPOINT party_site_sync;
6562: BEGIN
6563: HZ_STAGE_MAP_TRANSFORM.sync_single_party_site(x_to_id,'C');
6564: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE
6565: RECORD_ID=x_to_id and entity='PARTY_SITES' AND STAGED_FLAG='N';
6566: EXCEPTION
6567: WHEN OTHERS THEN
6568: ROLLBACK TO party_site_sync;
6571: x_return_status := 'N';
6572:
6573: END IF;
6574:
6575: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE record_id = p_from_id
6576: AND ENTITY = 'PARTY_SITES' AND STAGED_FLAG='N';
6577:
6578: EXCEPTION
6579: WHEN OTHERS THEN
6686: program_id = hz_utility_pub.program_id,
6687: program_update_date = sysdate
6688: WHERE party_id = p_from_id;
6689:
6690: UPDATE HZ_DQM_SYNC_INTERFACE
6691: SET party_id = x_to_id WHERE STAGED_FLAG='N'
6692: AND PARTY_ID = p_from_id AND ENTITY<>'PARTY';
6693:
6694: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(