APPS.ARP_CMERGE_ARCOL dependencies on HZ_ACCT_MERGE_UTIL

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

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

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

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

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

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

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

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

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

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

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

204: exit;
205: END IF;
206: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
207: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
208: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
209: END LOOP;
210: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
211: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
212: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

318: NULL;
319: ELSE
320: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
321: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_STATEMENTS_HISTORY',FALSE);
322: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
323: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
324:
325: open merged_records;
326: LOOP

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

336: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
337: exit;
338: END IF;
339: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
340: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
341: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
342: END LOOP;
343: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
344: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

337: exit;
338: END IF;
339: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
340: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
341: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
342: END LOOP;
343: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
344: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
345: INSERT INTO HZ_CUSTOMER_MERGE_LOG (