APPS.HZ_MERGE_PKG dependencies on HZ_DQM_SYNC_INTERFACE

Line 3022: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N'

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,

Line 3179: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N'

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,

Line 4687: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N' AND ENTITY='CONTACTS'

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,

Line 4860: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE STAGED_FLAG='N' AND ENTITY='CONTACTS'

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,

Line 6564: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE

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;

Line 6575: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE record_id = p_from_id

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

Line 6690: UPDATE HZ_DQM_SYNC_INTERFACE

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(