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.OTAP_CMERGE dependencies on HZ_ACCT_MERGE_UTIL

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

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

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

73: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
74: exit;
75: END IF;
76: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
77: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_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 207: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

203: NULL;
204: ELSE
205: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
206: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_DELEGATE_BOOKINGS',FALSE);
207: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
208: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
209:
210:
211: open merged_records;

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

224: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
225: exit;
226: END IF;
227: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
228: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
229: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
230: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
231:
232: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));

Line 229: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));

225: exit;
226: END IF;
227: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
228: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
229: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
230: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
231:
232: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));
233:

Line 230: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));

226: END IF;
227: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
228: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
229: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
230: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
231:
232: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));
233:
234: END LOOP;

Line 232: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));

228: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
229: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
230: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL3_ORIG_LIST(I));
231:
232: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL4_ORIG_LIST(I));
233:
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 393: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);

389: NULL;
390: ELSE
391: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
392: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_FINANCE_HEADERS',FALSE);
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 412: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));

408: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
409: exit;
410: END IF;
411: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
412: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
413: -- Bug 3590109 Address Merge
414: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
415:
416: --Retrieve concat address for NUM_COL2_NEW_LIST(I)

Line 414: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));

410: END IF;
411: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
412: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
413: -- Bug 3590109 Address Merge
414: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL2_ORIG_LIST(I));
415:
416: --Retrieve concat address for NUM_COL2_NEW_LIST(I)
417: OPEN csr_new_invoice_addr_str(NUM_COL2_NEW_LIST(I));
418: FETCH csr_new_invoice_addr_str into l_new_invoice_addr_str;

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

561: NULL;
562: ELSE
563: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
564: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_EVENT_ASSOCIATIONS',FALSE);
565: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
566: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
567:
568: open merged_records;
569: LOOP

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

579: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
580: exit;
581: END IF;
582: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
583: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
584: END LOOP;
585:
586: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
587: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP

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

856: NULL;
857: ELSE
858: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
859: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','OTA_NOTRNG_HISTORIES',FALSE);
860: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
861: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
862:
863: open merged_records;
864: LOOP

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

873: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
874: exit;
875: END IF;
876: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
877: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
878: END LOOP;
879: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
880: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
881: INSERT INTO HZ_CUSTOMER_MERGE_LOG (