APPS.HZ_MERGE_PARTIES_PUB dependencies on HZ_MERGE_UTIL

Line 138: hz_merge_util.insert_party_site_details(

134: cp_from_party_id IN NUMBER,
135: cp_to_party_id IN NUMBER) IS
136: BEGIN
137: -----Insert Party Site details
138: hz_merge_util.insert_party_site_details(
139: cp_from_party_id,
140: cp_to_party_id,
141: cp_batch_party_id,
142: HZ_UTILITY_PUB.CREATED_BY,

Line 149: hz_merge_util.insert_party_reln_details(

145: HZ_UTILITY_PUB.LAST_UPDATE_DATE,
146: HZ_UTILITY_PUB.LAST_UPDATED_BY);
147:
148: -----Insert Party Relations details
149: hz_merge_util.insert_party_reln_details(
150: cp_from_party_id,
151: cp_to_party_id,
152: cp_batch_party_id,
153: HZ_UTILITY_PUB.CREATED_BY,

Line 167: HZ_MERGE_UTIL.get_reln_party_id(merge_from_entity_id) from_reln_party_id,

163: cp_batch_id IN NUMBER)IS
164:
165: CURSOR merged_relns(cp_batch_party_id NUMBER) IS
166: SELECT merge_from_entity_id, merge_to_entity_id,
167: HZ_MERGE_UTIL.get_reln_party_id(merge_from_entity_id) from_reln_party_id,
168: HZ_MERGE_UTIL.get_reln_party_id(merge_to_entity_id) to_reln_party_id
169: FROM hz_merge_party_details
170: WHERE batch_party_id = cp_batch_party_id
171: AND entity_name = 'HZ_PARTY_RELATIONSHIPS'

Line 168: HZ_MERGE_UTIL.get_reln_party_id(merge_to_entity_id) to_reln_party_id

164:
165: CURSOR merged_relns(cp_batch_party_id NUMBER) IS
166: SELECT merge_from_entity_id, merge_to_entity_id,
167: HZ_MERGE_UTIL.get_reln_party_id(merge_from_entity_id) from_reln_party_id,
168: HZ_MERGE_UTIL.get_reln_party_id(merge_to_entity_id) to_reln_party_id
169: FROM hz_merge_party_details
170: WHERE batch_party_id = cp_batch_party_id
171: AND entity_name = 'HZ_PARTY_RELATIONSHIPS'
172: AND merge_to_entity_id IS NOT NULL