APPS.FV_CMERGE dependencies on HZ_ACCT_MERGE_UTIL

Line 93: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

89: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
90: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
91: END IF;
92:
93: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
94: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
95:
96: --remove records from table that will be duplicates when merged.
97: delete from fv_cust_finance_chrgs

Line 127: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

123: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
124: exit;
125: END IF;
126: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
127: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
128: END LOOP;
129: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
130: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
131: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 244: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

240: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_CUST_VEND_XREFS',FALSE);
241: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
242: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
243: END IF;
244: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
245: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
246:
247: -- remove the records that will be duplicates when merged.
248: delete from fv_cust_vend_xrefs

Line 280: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

276: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
277: exit;
278: END IF;
279: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
280: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
281: END LOOP;
282: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
283: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
284: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 393: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

389: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_INTERAGENCY_FUNDS',FALSE);
390: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
391: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
392: END IF;
393: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
394: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
395:
396: open merged_records;
397: LOOP

Line 411: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

407: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
408: exit;
409: END IF;
410: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
411: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
412: END LOOP;
413: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
414: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
415: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 548: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

544: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_INTERIM_CASH_RECEIPTS',FALSE);
545: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
546: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
547: END IF;
548: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
549: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
550:
551: open merged_records;
552: LOOP

Line 570: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

566: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
567: exit;
568: END IF;
569: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
570: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
571: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
572: END LOOP;
573: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
574: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 571: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));

567: exit;
568: END IF;
569: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
570: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
571: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
572: END LOOP;
573: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
574: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
575: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 710: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

706: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_INVOICE_FINANCE_CHRGS',FALSE);
707: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
708: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
709: END IF;
710: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
711: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
712:
713: open merged_records;
714: LOOP

Line 730: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

726: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
727: exit;
728: END IF;
729: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
730: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
731: END LOOP;
732: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
733: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
734: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

Line 850: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

846: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','FV_IPAC_TRX',FALSE);
847: IF ( FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
848: FV_UTILITY.MESSAGE(FND_LOG.LEVEL_EVENT, l_module_name);
849: END IF;
850: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
851: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
852:
853: open merged_records;
854: LOOP

Line 868: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

864: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
865: exit;
866: END IF;
867: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
868: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
869: END LOOP;
870: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
871: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
872: INSERT INTO HZ_CUSTOMER_MERGE_LOG (