DBA Data[Home] [Help]

APPS.HZ_MERGE_DUP_PVT dependencies on HZ_MERGE_PARTIES_PKG

Line 208: HZ_MERGE_PARTIES_PKG.INSERT_ROW(

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

Line 269: HZ_MERGE_PARTIES_PKG.INSERT_ROW(

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

Line 731: HZ_MERGE_PARTIES_PKG.Insert_Row(

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

Line 763: HZ_MERGE_PARTIES_PKG.delete_Row(rel_batch_party_id);

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

Line 1214: HZ_MERGE_PARTIES_PKG.Insert_Row(

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

Line 1261: HZ_MERGE_PARTIES_PKG.delete_Row(rel_batch_party_id);

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

Line 1622: HZ_MERGE_PARTIES_PKG.Insert_Row(

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