eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_CMGT_ACCOUNT_MERGE dependencies on HZ_ACCT_MERGE_UTIL

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

58: NULL;
59: ELSE
60: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
61: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_CMGT_CASE_FOLDERS',FALSE);
62: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
63: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
64:
65: open merged_records;
66: LOOP

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

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

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

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

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

210: NULL;
211: ELSE
212: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
213: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_CMGT_CREDIT_REQUESTS',FALSE);
214: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
215: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
216:
217: open merged_records;
218: LOOP

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

228: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
229: exit;
230: END IF;
231: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
232: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
233: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
234: END LOOP;
235: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
236: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

229: exit;
230: END IF;
231: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
232: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
233: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
234: END LOOP;
235: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
236: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
237: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

471: NULL;
472: ELSE
473: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
474: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_TRX_BAL_SUMMARY',FALSE);
475: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
476: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
477:
478: open merged_records;
479: LOOP

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

519: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
520: exit;
521: END IF;
522: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
523: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
524: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
525: arp_message.set_line( 'Request Id ='||req_id);
526: arp_message.set_line( 'NUM_COL1_NEW_LIST(I)='||NUM_COL1_NEW_LIST(I));
527: arp_message.set_line( 'NUM_COL2_NEW_LIST(I)='||NUM_COL2_NEW_LIST(I));

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

520: exit;
521: END IF;
522: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
523: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
524: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
525: arp_message.set_line( 'Request Id ='||req_id);
526: arp_message.set_line( 'NUM_COL1_NEW_LIST(I)='||NUM_COL1_NEW_LIST(I));
527: arp_message.set_line( 'NUM_COL2_NEW_LIST(I)='||NUM_COL2_NEW_LIST(I));
528: END LOOP;

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

1023: NULL;
1024: ELSE
1025: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1026: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','AR_TRX_SUMMARY',FALSE);
1027: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1028: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1029:
1030: open merged_records;
1031: LOOP

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

1079: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
1080: exit;
1081: END IF;
1082: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1083: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1084: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1085:
1086: END LOOP;
1087: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

1080: exit;
1081: END IF;
1082: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1083: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1084: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1085:
1086: END LOOP;
1087: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1088: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT