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 247: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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