[Home] [Help]
76: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
77: END LOOP;
78: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
79: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
80: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
81: MERGE_LOG_ID,
82: TABLE_NAME,
83: MERGE_HEADER_ID,
84: PRIMARY_KEY_ID,
92: CREATION_DATE,
93: LAST_UPDATE_LOGIN,
94: LAST_UPDATE_DATE,
95: LAST_UPDATED_BY
96: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
97: 'AR_CASH_RECEIPTS',
98: MERGE_HEADER_ID_LIST(I),
99: PRIMARY_KEY_ID_LIST(I),
100: NUM_COL1_ORIG_LIST(I),
207: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
208: END LOOP;
209: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
210: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
211: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
212: MERGE_LOG_ID,
213: TABLE_NAME,
214: MERGE_HEADER_ID,
215: PRIMARY_KEY_ID,
223: CREATION_DATE,
224: LAST_UPDATE_LOGIN,
225: LAST_UPDATE_DATE,
226: LAST_UPDATED_BY
227: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
228: 'AR_PAYMENT_SCHEDULES',
229: MERGE_HEADER_ID_LIST(I),
230: PRIMARY_KEY_ID_LIST(I),
231: NUM_COL1_ORIG_LIST(I),
420: NUM_COL10_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL10_ORIG_LIST(I));
421: END LOOP;
422: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
423: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
424: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
425: MERGE_LOG_ID,
426: TABLE_NAME,
427: MERGE_HEADER_ID,
428: PRIMARY_KEY_ID,
452: CREATION_DATE,
453: LAST_UPDATE_LOGIN,
454: LAST_UPDATE_DATE,
455: LAST_UPDATED_BY
456: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
457: 'RA_CUSTOMER_TRX',
458: MERGE_HEADER_ID_LIST(I),
459: PRIMARY_KEY_ID_LIST(I),
460: NUM_COL1_ORIG_LIST(I),
599:
600: END LOOP;
601: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
602: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
603: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
604: MERGE_LOG_ID,
605: TABLE_NAME,
606: MERGE_HEADER_ID,
607: PRIMARY_KEY_ID,
615: CREATION_DATE,
616: LAST_UPDATE_LOGIN,
617: LAST_UPDATE_DATE,
618: LAST_UPDATED_BY
619: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
620: 'RA_CUSTOMER_TRX_LINES',
621: MERGE_HEADER_ID_LIST(I),
622: PRIMARY_KEY_ID_LIST(I),
623: NUM_COL1_ORIG_LIST(I),
734: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
735: END LOOP;
736: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
737: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
738: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
739: MERGE_LOG_ID,
740: TABLE_NAME,
741: MERGE_HEADER_ID,
742: PRIMARY_KEY_ID,
750: CREATION_DATE,
751: LAST_UPDATE_LOGIN,
752: LAST_UPDATE_DATE,
753: LAST_UPDATED_BY
754: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
755: 'ar_receivable_applications',
756: MERGE_HEADER_ID_LIST(I),
757: PRIMARY_KEY_ID_LIST(I),
758: NUM_COL1_ORIG_LIST(I),
1186:
1187: /*Additional change for ra_interface_lines under bug2447449*/
1188: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1189: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1190: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1191: MERGE_LOG_ID,
1192: TABLE_NAME,
1193: MERGE_HEADER_ID,
1194: PRIMARY_KEY1,
1218: CREATION_DATE,
1219: LAST_UPDATE_LOGIN,
1220: LAST_UPDATE_DATE,
1221: LAST_UPDATED_BY
1222: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1223: 'RA_INTERFACE_LINES',
1224: MERGE_HEADER_ID_LIST(I),
1225: PRIMARY_KEY1_LIST(I),
1226: NUM_COL1_ORIG_LIST(I),
1353: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
1354: END LOOP;
1355: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1356: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1357: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1358: MERGE_LOG_ID,
1359: TABLE_NAME,
1360: MERGE_HEADER_ID,
1361: PRIMARY_KEY_ID,
1369: CREATION_DATE,
1370: LAST_UPDATE_LOGIN,
1371: LAST_UPDATE_DATE,
1372: LAST_UPDATED_BY
1373: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
1374: 'AR_DISTRIBUTIONS',
1375: MERGE_HEADER_ID_LIST(I),
1376: PRIMARY_KEY_ID_LIST(I),
1377: NUM_COL1_ORIG_LIST(I),