[Home] [Help]
381: END LOOP;
382:
383: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
384: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
385: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
386: MERGE_LOG_ID,
387: TABLE_NAME,
388: MERGE_HEADER_ID,
389: PRIMARY_KEY_ID,
396: LAST_UPDATE_LOGIN,
397: LAST_UPDATE_DATE,
398: LAST_UPDATED_BY
399: ) VALUES (
400: HZ_CUSTOMER_MERGE_LOG_s.NEXTVAL,
401: 'PN_LEASES',
402: MERGE_HEADER_ID_LIST(I),
403: PRIMARY_KEY_ID_LIST(I),
404: NUM_COL1_ORIG_LIST(I),
546: END LOOP;
547:
548: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
549: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
550: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
551: MERGE_LOG_ID,
552: TABLE_NAME,
553: MERGE_HEADER_ID,
554: PRIMARY_KEY_ID,
563: LAST_UPDATE_LOGIN,
564: LAST_UPDATE_DATE,
565: LAST_UPDATED_BY
566: ) VALUES (
567: HZ_CUSTOMER_MERGE_LOG_s.NEXTVAL,
568: 'PN_TENANCIES',
569: MERGE_HEADER_ID_LIST(I),
570: PRIMARY_KEY_ID_LIST(I),
571: NUM_COL1_ORIG_LIST(I),
717: END LOOP;
718:
719: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
720: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
721: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
722: MERGE_LOG_ID,
723: TABLE_NAME,
724: MERGE_HEADER_ID,
725: PRIMARY_KEY_ID,
734: LAST_UPDATE_LOGIN,
735: LAST_UPDATE_DATE,
736: LAST_UPDATED_BY
737: ) VALUES (
738: HZ_CUSTOMER_MERGE_LOG_s.NEXTVAL,
739: 'PN_TENANCIES_HISTORY',
740: MERGE_HEADER_ID_LIST(I),
741: PRIMARY_KEY_ID_LIST(I),
742: NUM_COL1_ORIG_LIST(I),
897: END LOOP;
898:
899: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
900: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
901: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
902: MERGE_LOG_ID,
903: TABLE_NAME,
904: MERGE_HEADER_ID,
905: PRIMARY_KEY_ID,
916: LAST_UPDATE_LOGIN,
917: LAST_UPDATE_DATE,
918: LAST_UPDATED_BY
919: ) VALUES (
920: HZ_CUSTOMER_MERGE_LOG_s.NEXTVAL,
921: 'PN_TERM_TEMPLATES',
922: MERGE_HEADER_ID_LIST(I),
923: PRIMARY_KEY_ID_LIST(I),
924: NUM_COL1_ORIG_LIST(I),
1084: END LOOP;
1085:
1086: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1087: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1088: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1089: MERGE_LOG_ID,
1090: TABLE_NAME,
1091: MERGE_HEADER_ID,
1092: PRIMARY_KEY_ID,
1103: LAST_UPDATE_LOGIN,
1104: LAST_UPDATE_DATE,
1105: LAST_UPDATED_BY
1106: ) VALUES (
1107: HZ_CUSTOMER_MERGE_LOG_s.NEXTVAL,
1108: 'PN_PAYMENT_TERMS',
1109: MERGE_HEADER_ID_LIST(I),
1110: PRIMARY_KEY_ID_LIST(I),
1111: NUM_COL1_ORIG_LIST(I),
1270: END LOOP;
1271:
1272: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1273: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1274: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1275: MERGE_LOG_ID,
1276: TABLE_NAME,
1277: MERGE_HEADER_ID,
1278: PRIMARY_KEY_ID,
1289: LAST_UPDATE_LOGIN,
1290: LAST_UPDATE_DATE,
1291: LAST_UPDATED_BY
1292: ) VALUES (
1293: HZ_CUSTOMER_MERGE_LOG_s.NEXTVAL,
1294: 'PN_PAYMENT_ITEMS',
1295: MERGE_HEADER_ID_LIST(I),
1296: PRIMARY_KEY_ID_LIST(I),
1297: NUM_COL1_ORIG_LIST(I),
1442: END LOOP;
1443:
1444: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1445: FORALL I IN 1..MERGE_HEADER_ID_LIST.COUNT
1446: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1447: MERGE_LOG_ID,
1448: TABLE_NAME,
1449: MERGE_HEADER_ID,
1450: PRIMARY_KEY_ID,
1459: LAST_UPDATE_LOGIN,
1460: LAST_UPDATE_DATE,
1461: LAST_UPDATED_BY
1462: ) VALUES (
1463: HZ_CUSTOMER_MERGE_LOG_s.NEXTVAL,
1464: 'PN_REC_AGREEMENTS',
1465: MERGE_HEADER_ID_LIST(I),
1466: PRIMARY_KEY_ID_LIST(I),
1467: NUM_COL1_ORIG_LIST(I),
1600: END LOOP;
1601:
1602: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1603: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1604: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1605: MERGE_LOG_ID,
1606: TABLE_NAME,
1607: MERGE_HEADER_ID,
1608: PRIMARY_KEY_ID,
1615: LAST_UPDATE_LOGIN,
1616: LAST_UPDATE_DATE,
1617: LAST_UPDATED_BY
1618: ) VALUES (
1619: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1620: 'PN_REC_ARCL_DTLLN',
1621: MERGE_HEADER_ID_LIST(I),
1622: PRIMARY_KEY_ID_LIST(I),
1623: NUM_COL1_ORIG_LIST(I),
1751: END LOOP;
1752:
1753: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1754: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
1755: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1756: MERGE_LOG_ID,
1757: TABLE_NAME,
1758: MERGE_HEADER_ID,
1759: PRIMARY_KEY_ID,
1766: LAST_UPDATE_LOGIN,
1767: LAST_UPDATE_DATE,
1768: LAST_UPDATED_BY
1769: ) VALUES (
1770: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1771: 'PN_REC_EXPCL_DTLLN',
1772: MERGE_HEADER_ID_LIST(I),
1773: PRIMARY_KEY_ID_LIST(I),
1774: NUM_COL1_ORIG_LIST(I),
1900: END LOOP;
1901:
1902: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
1903: FORALL I IN 1..MERGE_HEADER_ID_LIST.COUNT
1904: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
1905: MERGE_LOG_ID,
1906: TABLE_NAME,
1907: MERGE_HEADER_ID,
1908: PRIMARY_KEY_ID,
1915: LAST_UPDATE_LOGIN,
1916: LAST_UPDATE_DATE,
1917: LAST_UPDATED_BY
1918: ) VALUES (
1919: HZ_CUSTOMER_MERGE_LOG_s.nextval,
1920: 'PN_REC_PERIOD_LINES',
1921: MERGE_HEADER_ID_LIST(I),
1922: PRIMARY_KEY_ID_LIST(I),
1923: NUM_COL1_ORIG_LIST(I),
2064: END LOOP;
2065:
2066: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
2067: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
2068: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
2069: MERGE_LOG_ID,
2070: TABLE_NAME,
2071: MERGE_HEADER_ID,
2072: PRIMARY_KEY_ID,
2081: LAST_UPDATE_LOGIN,
2082: LAST_UPDATE_DATE,
2083: LAST_UPDATED_BY
2084: ) VALUES (
2085: HZ_CUSTOMER_MERGE_LOG_s.NEXTVAL,
2086: 'PN_SPACE_ASSIGN_CUST',
2087: MERGE_HEADER_ID_LIST(I),
2088: PRIMARY_KEY_ID_LIST(I),
2089: NUM_COL1_ORIG_LIST(I),