DBA Data[Home] [Help]

APPS.HZ_MERGE_DUP_PVT dependencies on HZ_MERGE_PARTIES_PKG

Line 209: HZ_MERGE_PARTIES_PKG.INSERT_ROW(

205: l_merge_type2 := 'PARTY_MERGE';
206: END IF;
207:
208: -- call table-handler to insert the record in HZ_MERGE_PARTIES
209: HZ_MERGE_PARTIES_PKG.INSERT_ROW(
210: px_BATCH_PARTY_ID => l_batch_party_id,
211: p_batch_id => l_batch_id,
212: p_merge_type => l_merge_type2,
213: p_from_party_id => l_merge_from,

Line 270: HZ_MERGE_PARTIES_PKG.INSERT_ROW(

266: l_batch_party_id := null;
267: l_merge_from := l_merge_to;
268:
269: -- call table-handler to insert the record in HZ_MERGE_PARTIES
270: HZ_MERGE_PARTIES_PKG.INSERT_ROW(
271: px_BATCH_PARTY_ID => l_batch_party_id,
272: p_batch_id => l_batch_id,
273: p_merge_type => 'SAME_PARTY_MERGE',
274: p_from_party_id => l_merge_from,

Line 732: HZ_MERGE_PARTIES_PKG.Insert_Row(

728:
729: IF l_from_rel_party_id IS NOT NULL AND
730: l_to_rel_party_id IS NOT NULL THEN
731:
732: HZ_MERGE_PARTIES_PKG.Insert_Row(
733: rel_batch_party_id,
734: l_BATCH_ID,
735: 'PARTY_MERGE',
736: l_from_rel_party_id,

Line 764: HZ_MERGE_PARTIES_PKG.delete_Row(rel_batch_party_id);

760: where batch_id = l_batch_id
761: and merge_type = 'PARTY_MERGE'
762: and from_party_id = l_from_rel_party_id;
763:
764: HZ_MERGE_PARTIES_PKG.delete_Row(rel_batch_party_id);
765:
766: DELETE FROM hz_merge_party_details
767: WHERE batch_party_id = rel_batch_party_id;
768:

Line 1215: HZ_MERGE_PARTIES_PKG.Insert_Row(

1211:
1212: --Insert parties if the rel party is not present already
1213: IF l_rel_party_count = 0 THEN
1214:
1215: HZ_MERGE_PARTIES_PKG.Insert_Row(
1216: rel_batch_party_id,
1217: l_batch_id,
1218: 'PARTY_MERGE',
1219: l_from_rel_party_id,

Line 1262: HZ_MERGE_PARTIES_PKG.delete_Row(rel_batch_party_id);

1258: WHERE batch_id = l_batch_id
1259: AND merge_type = 'PARTY_MERGE'
1260: AND from_party_id = l_from_rel_party_id;
1261:
1262: HZ_MERGE_PARTIES_PKG.delete_Row(rel_batch_party_id);
1263:
1264: DELETE FROM hz_merge_party_details
1265: WHERE batch_party_id = rel_batch_party_id;
1266:

Line 1623: HZ_MERGE_PARTIES_PKG.Insert_Row(

1619: l_from_reln_party_id := l_to_reln_party_id;
1620: l_to_reln_party_id := l_id;
1621: end if;
1622: END IF; --Bug6703948
1623: HZ_MERGE_PARTIES_PKG.Insert_Row(
1624: l_batch_party_id,
1625: p_BATCH_ID,
1626: 'PARTY_MERGE',
1627: l_from_reln_party_id,