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: AND OPERATION <> 'D';
3025:
3026: HZ_ORIG_SYSTEM_REF_PVT.remap_internal_identifier(

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

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(

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

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,

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

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,

Line 6703: DELETE FROM HZ_DQM_SYNC_INTERFACE WHERE record_id = p_from_id

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

Line 6818: UPDATE HZ_DQM_SYNC_INTERFACE

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(