[Home] [Help]
127: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
128: END LOOP;
129: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
130: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
131: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
132: MERGE_LOG_ID,
133: TABLE_NAME,
134: MERGE_HEADER_ID,
135: PRIMARY_KEY1,
142: CREATION_DATE,
143: LAST_UPDATE_LOGIN,
144: LAST_UPDATE_DATE,
145: LAST_UPDATED_BY
146: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
147: 'FV_CUST_FINANCE_CHRGS',
148: MERGE_HEADER_ID_LIST(I),
149: PRIMARY_KEY1_LIST(I),
150: PRIMARY_KEY2_LIST(I),
283: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
284: END LOOP;
285: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
286: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
287: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
288: MERGE_LOG_ID,
289: TABLE_NAME,
290: MERGE_HEADER_ID,
291: PRIMARY_KEY_ID,
297: CREATION_DATE,
298: LAST_UPDATE_LOGIN,
299: LAST_UPDATE_DATE,
300: LAST_UPDATED_BY
301: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
302: 'FV_CUST_VEND_XREFS',
303: MERGE_HEADER_ID_LIST(I),
304: PRIMARY_KEY_ID_LIST(I),
305: NUM_COL1_ORIG_LIST(I),
414: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
415: END LOOP;
416: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
417: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
418: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
419: MERGE_LOG_ID,
420: TABLE_NAME,
421: MERGE_HEADER_ID,
422: PRIMARY_KEY_ID,
428: CREATION_DATE,
429: LAST_UPDATE_LOGIN,
430: LAST_UPDATE_DATE,
431: LAST_UPDATED_BY
432: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
433: 'FV_INTERAGENCY_FUNDS',
434: MERGE_HEADER_ID_LIST(I),
435: PRIMARY_KEY_ID_LIST(I),
436: NUM_COL1_ORIG_LIST(I),
574: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
575: END LOOP;
576: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
577: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
578: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
579: MERGE_LOG_ID,
580: TABLE_NAME,
581: MERGE_HEADER_ID,
582: PRIMARY_KEY1,
593: CREATION_DATE,
594: LAST_UPDATE_LOGIN,
595: LAST_UPDATE_DATE,
596: LAST_UPDATED_BY
597: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
598: 'FV_INTERIM_CASH_RECEIPTS',
599: MERGE_HEADER_ID_LIST(I),
600: PRIMARY_KEY1_LIST(I),
601: PRIMARY_KEY2_LIST(I),
733: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
734: END LOOP;
735: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
736: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
737: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
738: MERGE_LOG_ID,
739: TABLE_NAME,
740: MERGE_HEADER_ID,
741: PRIMARY_KEY1,
749: CREATION_DATE,
750: LAST_UPDATE_LOGIN,
751: LAST_UPDATE_DATE,
752: LAST_UPDATED_BY
753: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
754: 'FV_INVOICE_FINANCE_CHRGS',
755: MERGE_HEADER_ID_LIST(I),
756: PRIMARY_KEY1_LIST(I),
757: PRIMARY_KEY2_LIST(I),
871: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
872: END LOOP;
873: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
874: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
875: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
876: MERGE_LOG_ID,
877: TABLE_NAME,
878: MERGE_HEADER_ID,
879: PRIMARY_KEY1,
885: CREATION_DATE,
886: LAST_UPDATE_LOGIN,
887: LAST_UPDATE_DATE,
888: LAST_UPDATED_BY
889: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
890: 'FV_IPAC_TRX',
891: MERGE_HEADER_ID_LIST(I),
892: PRIMARY_KEY1_LIST(I),
893: NUM_COL1_ORIG_LIST(I),