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

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

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

Line 94: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(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_SITE(NUM_COL1_ORIG_LIST(I));
95:
96: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
97: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
98: END LOOP;

Line 96: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_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_SITE(NUM_COL1_ORIG_LIST(I));
95:
96: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
97: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
98: END LOOP;
99: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
100: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

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

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

218: NULL;
219: ELSE
220: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
221: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claim_lines',FALSE);
222: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
223: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
224:
225: open merged_records;
226: LOOP

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

236: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
237: exit;
238: END IF;
239: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
240: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
241: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
242: END LOOP;
243: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
244: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

237: exit;
238: END IF;
239: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
240: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
241: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
242: END LOOP;
243: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
244: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
245: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

362: NULL;
363: ELSE
364: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
365: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claim_lines_hist',FALSE);
366: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
367: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
368:
369: open merged_records;
370: LOOP

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

380: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
381: exit;
382: END IF;
383: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
384: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
385: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
386: END LOOP;
387: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
388: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

381: exit;
382: END IF;
383: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
384: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
385: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
386: END LOOP;
387: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
388: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
389: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

538: NULL;
539: ELSE
540: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
541: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claims',FALSE);
542: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
543: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
544:
545: open merged_records;
546: LOOP

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

560: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
561: exit;
562: END IF;
563: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
564: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
565: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
566: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
567: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
568: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));

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

561: exit;
562: END IF;
563: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
564: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
565: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
566: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
567: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
568: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));
569: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));

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

562: END IF;
563: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
564: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
565: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
566: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
567: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
568: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));
569: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));
570: END LOOP;

Line 567: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));

563: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
564: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
565: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
566: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
567: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
568: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));
569: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));
570: END LOOP;
571: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

Line 568: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));

564: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
565: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
566: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
567: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
568: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));
569: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));
570: END LOOP;
571: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
572: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

565: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
566: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
567: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
568: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));
569: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));
570: END LOOP;
571: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
572: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
573: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

742: NULL;
743: ELSE
744: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
745: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_claims_history',FALSE);
746: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
747: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
748:
749: open merged_records;
750: LOOP

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

764: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
765: exit;
766: END IF;
767: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
768: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
769: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
770: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
771: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
772: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));

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

765: exit;
766: END IF;
767: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
768: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
769: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
770: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
771: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
772: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));
773: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));

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

766: END IF;
767: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
768: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
769: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
770: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
771: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
772: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));
773: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));
774: END LOOP;

Line 771: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));

767: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
768: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
769: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
770: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
771: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
772: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));
773: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));
774: END LOOP;
775: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

Line 772: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));

768: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
769: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
770: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
771: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
772: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));
773: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));
774: END LOOP;
775: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
776: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

769: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
770: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
771: NUM_COL4_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL4_ORIG_LIST(I));
772: NUM_COL5_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL5_ORIG_LIST(I));
773: NUM_COL6_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL6_ORIG_LIST(I));
774: END LOOP;
775: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
776: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
777: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

906: NULL;
907: ELSE
908: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
909: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_code_conversions',FALSE);
910: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
911: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
912:
913: open merged_records;
914: LOOP

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

923: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
924: exit;
925: END IF;
926: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
927: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
928: END LOOP;
929: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
930: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
931: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

1046: NULL;
1047: ELSE
1048: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1049: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_cust_daily_facts',FALSE);
1050: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1051: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1052:
1053: open merged_records;
1054: LOOP

Line 1069: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));

1065: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
1066: exit;
1067: END IF;
1068: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1069: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
1070:
1071: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1072: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1073: END LOOP;

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

1067: END IF;
1068: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1069: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
1070:
1071: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1072: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1073: END LOOP;
1074: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1075: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

1068: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1069: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
1070:
1071: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1072: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1073: END LOOP;
1074: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1075: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1076: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

1193: NULL;
1194: ELSE
1195: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1196: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_funds_utilized_all_b',FALSE);
1197: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1198: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1199:
1200: open merged_records;
1201: LOOP

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

1211: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
1212: exit;
1213: END IF;
1214: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1215: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1216: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
1217: END LOOP;
1218: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1219: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

1212: exit;
1213: END IF;
1214: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1215: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1216: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
1217: END LOOP;
1218: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1219: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1220: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

1343: NULL;
1344: ELSE
1345: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1346: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_activity_customers',FALSE);
1347: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1348: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1349:
1350: open merged_records;
1351: LOOP

Line 1366: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));

1362: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
1363: exit;
1364: END IF;
1365: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1366: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
1367:
1368: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1369: END LOOP;
1370: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

1364: END IF;
1365: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1366: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
1367:
1368: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1369: END LOOP;
1370: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1371: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1372: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

1480: NULL;
1481: ELSE
1482: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1483: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_offers',FALSE);
1484: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1485: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1486:
1487: open merged_records;
1488: LOOP

Line 1501: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));

1497: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
1498: exit;
1499: END IF;
1500: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1501: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
1502:
1503: END LOOP;
1504: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1505: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

1622: NULL;
1623: ELSE
1624: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1625: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_request_headers_all_b',FALSE);
1626: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1627: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1628:
1629: open merged_records;
1630: LOOP

Line 1645: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));

1641: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
1642: exit;
1643: END IF;
1644: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1645: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));
1646: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1647: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1648: END LOOP;
1649: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

1642: exit;
1643: END IF;
1644: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1645: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));
1646: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1647: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1648: END LOOP;
1649: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1650: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

1643: END IF;
1644: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1645: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL1_ORIG_LIST(I));
1646: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1647: NUM_COL3_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL3_ORIG_LIST(I));
1648: END LOOP;
1649: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1650: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1651: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

1773: NULL;
1774: ELSE
1775: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1776: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_retail_price_points',FALSE);
1777: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1778: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1779:
1780: open merged_records;
1781: LOOP

Line 1795: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));

1791: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
1792: exit;
1793: END IF;
1794: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1795: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
1796:
1797: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1798: END LOOP;
1799: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN

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

1793: END IF;
1794: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1795: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE(NUM_COL1_ORIG_LIST(I));
1796:
1797: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1798: END LOOP;
1799: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1800: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1801: INSERT INTO HZ_CUSTOMER_MERGE_LOG (

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

1914: NULL;
1915: ELSE
1916: ARP_MESSAGE.SET_NAME('AR','AR_UPDATING_TABLE');
1917: ARP_MESSAGE.SET_TOKEN('TABLE_NAME','ozf_cust_trd_prfls',FALSE);
1918: HZ_ACCT_MERGE_UTIL.load_set(set_num, req_id);
1919: l_profile_val := FND_PROFILE.VALUE('HZ_AUDIT_ACCT_MERGE');
1920:
1921: open merged_records;
1922: LOOP

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

1932: IF MERGE_HEADER_ID_LIST.COUNT = 0 and l_last_fetch then
1933: exit;
1934: END IF;
1935: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1936: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1937: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1938: END LOOP;
1939: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1940: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT

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

1933: exit;
1934: END IF;
1935: FOR I in 1..MERGE_HEADER_ID_LIST.COUNT LOOP
1936: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
1937: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1938: END LOOP;
1939: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1940: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1941: INSERT INTO HZ_CUSTOMER_MERGE_LOG (