[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: AND OPERATION <> 'D';
3025:
3026: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
3176: program_id = hz_utility_pub.program_id,
3177: program_update_date = sysdate
3178: WHERE contact_point_id = p_from_id;
3179:
3180: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N'
3181: AND RECORD_ID=p_from_id AND ENTITY='CONTACT_POINTS'
3182: AND OPERATION <> 'D';
3183:
3184: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
4689: program_id = hz_utility_pub.program_id,
4690: program_update_date = sysdate
4691: WHERE org_contact_id = p_from_id;
4692:
4693: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N' AND ENTITY='CONTACTS'
4694: AND RECORD_ID=p_from_id AND OPERATION <> 'D';
4695:
4696: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
4697: p_init_msg_list => FND_API.G_FALSE,
4862: program_id = hz_utility_pub.program_id,
4863: program_update_date = sysdate
4864: WHERE org_contact_id = p_from_id;
4865:
4866: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N' AND ENTITY='CONTACTS'
4867: AND RECORD_ID=p_from_id AND OPERATION <> 'D';
4868:
4869: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(
4870: p_init_msg_list => FND_API.G_FALSE,
6689: AND entity_name = 'HZ_PARTY_SITES';
6690:
6691: SAVEPOINT party_site_sync;
6692: BEGIN
6693: hz_dqm_sync.sync_party_site(x_to_id,'C'); --Bug 13810656
6694: EXCEPTION
6695: WHEN OTHERS THEN
6696: ROLLBACK TO party_site_sync;
6697: END;
6699: x_return_status := 'N';
6700:
6701: END IF;
6702:
6703: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE record_id = p_from_id
6704: AND ENTITY = 'PARTY_SITES' AND STAGED_FLAG='N' AND OPERATION <> 'D';
6705:
6706: EXCEPTION
6707: WHEN OTHERS THEN
6814: program_id = hz_utility_pub.program_id,
6815: program_update_date = sysdate
6816: WHERE party_id = p_from_id;
6817:
6818: UPDATE HZ_DQM_SYNC_INTERFACE
6819: SET party_id = x_to_id WHERE STAGED_FLAG='N'
6820: AND PARTY_ID = p_from_id AND ENTITY<>'PARTY';
6821:
6822: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(