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

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

70: NULL;
71: ELSE
72: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
73: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_FORECAST_DATES',FALSE);
74: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
75: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
76:
77: open merged_records;
78: LOOP

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

90: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
91: exit;
92: END IF;
93: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
94: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
95: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
96: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
97: END LOOP;
98: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

91: exit;
92: END IF;
93: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
94: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
95: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
96: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
97: END LOOP;
98: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
99: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 96: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));

92: END IF;
93: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
94: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
95: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
96: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
97: END LOOP;
98: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
99: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
100: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

236: NULL;
237: ELSE
238: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
239: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_FORECAST_DESIGNATORS',FALSE);
240: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
241: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
242:
243: open merged_records;
244: LOOP

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

257: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
258: exit;
259: END IF;
260: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
261: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
262: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
263: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
264: END LOOP;
265: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

258: exit;
259: END IF;
260: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
261: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
262: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
263: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
264: END LOOP;
265: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
266: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 263: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));

259: END IF;
260: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
261: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
262: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
263: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
264: END LOOP;
265: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
266: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
267: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

401: NULL;
402: ELSE
403: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
404: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_FORECAST_UPDATES',FALSE);
405: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
406: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
407:
408: open merged_records;
409: LOOP

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

421: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
422: exit;
423: END IF;
424: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
425: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
426: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
427: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
428: END LOOP;
429: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

422: exit;
423: END IF;
424: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
425: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
426: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
427: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
428: END LOOP;
429: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
430: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 427: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));

423: END IF;
424: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
425: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
426: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
427: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
428: END LOOP;
429: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
430: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
431: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

588: NULL;
589: ELSE
590: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
591: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_SALES_ORDER_UPDATES',FALSE);
592: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
593: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
594:
595: open merged_records;
596: LOOP

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

611: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
612: exit;
613: END IF;
614: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
615: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
616: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
617: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
618: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL4_ORIG_LIST(I));
619: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL5_ORIG_LIST(I));

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

612: exit;
613: END IF;
614: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
615: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
616: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
617: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
618: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL4_ORIG_LIST(I));
619: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL5_ORIG_LIST(I));
620: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));

Line 617: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));

613: END IF;
614: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
615: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
616: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
617: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
618: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL4_ORIG_LIST(I));
619: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL5_ORIG_LIST(I));
620: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));
621: END LOOP;

Line 618: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL4_ORIG_LIST(I));

614: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
615: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
616: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
617: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
618: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL4_ORIG_LIST(I));
619: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL5_ORIG_LIST(I));
620: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));
621: END LOOP;
622: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

Line 619: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL5_ORIG_LIST(I));

615: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
616: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
617: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
618: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL4_ORIG_LIST(I));
619: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL5_ORIG_LIST(I));
620: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));
621: END LOOP;
622: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
623: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

Line 620: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));

616: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
617: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
618: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL4_ORIG_LIST(I));
619: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL5_ORIG_LIST(I));
620: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));
621: END LOOP;
622: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
623: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
624: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

810: NULL;
811: ELSE
812: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
813: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','MRP_SR_ASSIGNMENTS',FALSE);
814: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
815: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
816:
817: /* Fix for bug 1292873, part 2. */
818: select msc_form_query_s.nextval

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

910: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
911: exit;
912: END IF;
913: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
914: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
915: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
916: END LOOP;
917: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
918: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

911: exit;
912: END IF;
913: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
914: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
915: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
916: END LOOP;
917: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
918: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
919: INSERT INTO HZ_CUSTOMER_MERGE_LOG (