[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),
280: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
281: END LOOP;
282: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
283: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
284: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
285: MERGE_LOG_ID,
286: TABLE_NAME,
287: MERGE_HEADER_ID,
288: PRIMARY_KEY_ID,
294: CREATION_DATE,
295: LAST_UPDATE_LOGIN,
296: LAST_UPDATE_DATE,
297: LAST_UPDATED_BY
298: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
299: 'FV_CUST_VEND_XREFS',
300: MERGE_HEADER_ID_LIST(I),
301: PRIMARY_KEY_ID_LIST(I),
302: NUM_COL1_ORIG_LIST(I),
411: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
412: END LOOP;
413: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
414: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
415: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
416: MERGE_LOG_ID,
417: TABLE_NAME,
418: MERGE_HEADER_ID,
419: PRIMARY_KEY_ID,
425: CREATION_DATE,
426: LAST_UPDATE_LOGIN,
427: LAST_UPDATE_DATE,
428: LAST_UPDATED_BY
429: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
430: 'FV_INTERAGENCY_FUNDS',
431: MERGE_HEADER_ID_LIST(I),
432: PRIMARY_KEY_ID_LIST(I),
433: NUM_COL1_ORIG_LIST(I),
571: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_SITE_USE(NUM_COL2_ORIG_LIST(I));
572: END LOOP;
573: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
574: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
575: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
576: MERGE_LOG_ID,
577: TABLE_NAME,
578: MERGE_HEADER_ID,
579: PRIMARY_KEY1,
590: CREATION_DATE,
591: LAST_UPDATE_LOGIN,
592: LAST_UPDATE_DATE,
593: LAST_UPDATED_BY
594: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
595: 'FV_INTERIM_CASH_RECEIPTS',
596: MERGE_HEADER_ID_LIST(I),
597: PRIMARY_KEY1_LIST(I),
598: PRIMARY_KEY2_LIST(I),
730: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
731: END LOOP;
732: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
733: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
734: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
735: MERGE_LOG_ID,
736: TABLE_NAME,
737: MERGE_HEADER_ID,
738: PRIMARY_KEY1,
746: CREATION_DATE,
747: LAST_UPDATE_LOGIN,
748: LAST_UPDATE_DATE,
749: LAST_UPDATED_BY
750: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
751: 'FV_INVOICE_FINANCE_CHRGS',
752: MERGE_HEADER_ID_LIST(I),
753: PRIMARY_KEY1_LIST(I),
754: PRIMARY_KEY2_LIST(I),
868: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
869: END LOOP;
870: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
871: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
872: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
873: MERGE_LOG_ID,
874: TABLE_NAME,
875: MERGE_HEADER_ID,
876: PRIMARY_KEY1,
882: CREATION_DATE,
883: LAST_UPDATE_LOGIN,
884: LAST_UPDATE_DATE,
885: LAST_UPDATED_BY
886: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
887: 'FV_IPAC_TRX',
888: MERGE_HEADER_ID_LIST(I),
889: PRIMARY_KEY1_LIST(I),
890: NUM_COL1_ORIG_LIST(I),