APPS.ARP_CMERGE_ARATC dependencies on HZ_ACCT_MERGE_UTIL

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

53: NULL;
54: ELSE
55: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
56: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_INTERIM_CASH_RECEIPTS',FALSE);
57: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
58: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
59:
60: open merged_records;
61: LOOP

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

71: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
72: exit;
73: END IF;
74: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
75: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
76: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
77: END LOOP;
78: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
79: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

72: exit;
73: END IF;
74: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
75: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
76: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
77: END LOOP;
78: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
79: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
80: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

183: NULL;
184: ELSE
185: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
186: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_INTERIM_CASH_RECEIPT_LINES',FALSE);
187: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
188: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
189:
190: open merged_records;
191: LOOP

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

201: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
202: exit;
203: END IF;
204: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
205: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
206: END LOOP;
207: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
208: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
209: INSERT INTO HZ_CUSTOMER_MERGE_LOG (