[Home] [Help]
77: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
78: END LOOP;
79: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
80: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
81: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
82: MERGE_LOG_ID,
83: TABLE_NAME,
84: MERGE_HEADER_ID,
85: PRIMARY_KEY_ID,
91: CREATION_DATE,
92: LAST_UPDATE_LOGIN,
93: LAST_UPDATE_DATE,
94: LAST_UPDATED_BY
95: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
96: 'OTA_BOOKING_DEALS',
97: MERGE_HEADER_ID_LIST(I),
98: PRIMARY_KEY_ID_LIST(I),
99: NUM_COL1_ORIG_LIST(I),
233:
234: END LOOP;
235: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
236: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
237: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
238: MERGE_LOG_ID,
239: TABLE_NAME,
240: MERGE_HEADER_ID,
241: PRIMARY_KEY_ID,
253: CREATION_DATE,
254: LAST_UPDATE_LOGIN,
255: LAST_UPDATE_DATE,
256: LAST_UPDATED_BY
257: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
258: 'OTA_DELEGATE_BOOKINGS',
259: MERGE_HEADER_ID_LIST(I),
260: PRIMARY_KEY_ID_LIST(I),
261: NUM_COL1_ORIG_LIST(I),
423:
424: END LOOP;
425: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
426: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
427: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
428: MERGE_LOG_ID,
429: TABLE_NAME,
430: MERGE_HEADER_ID,
431: PRIMARY_KEY_ID,
442: CREATION_DATE,
443: LAST_UPDATE_LOGIN,
444: LAST_UPDATE_DATE,
445: LAST_UPDATED_BY
446: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
447: 'OTA_FINANCE_HEADERS',
448: MERGE_HEADER_ID_LIST(I),
449: PRIMARY_KEY_ID_LIST(I),
450: NUM_COL1_ORIG_LIST(I),
590: FETCH csr_duplicate_record into l_duplicate_result;
591:
592: IF csr_duplicate_record%FOUND THEN
593:
594: --Retrieve OTA_EVENT_ASSOCIATIONS data for HZ_CUSTOMER_MERGE_LOG record
595: OPEN csr_evt_assoc(PRIMARY_KEY_ID1_LIST(I));
596: FETCH csr_evt_assoc into l_evt_assoc_rec;
597:
598: IF csr_evt_assoc%FOUND THEN
595: OPEN csr_evt_assoc(PRIMARY_KEY_ID1_LIST(I));
596: FETCH csr_evt_assoc into l_evt_assoc_rec;
597:
598: IF csr_evt_assoc%FOUND THEN
599: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
600: MERGE_LOG_ID,
601: TABLE_NAME,
602: MERGE_HEADER_ID,
603: PRIMARY_KEY_ID1,
651: CREATION_DATE,
652: LAST_UPDATE_LOGIN,
653: LAST_UPDATE_DATE,
654: LAST_UPDATED_BY
655: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval
656: , 'OTA_EVENT_ASSOCIATIONS'
657: , MERGE_HEADER_ID_LIST(I)
658: , PRIMARY_KEY_ID1_LIST(I)
659: , NUM_COL1_ORIG_LIST(I)
721: --commit;
722: END IF;
723: CLOSE csr_evt_assoc;
724: ELSE
725: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
726: MERGE_LOG_ID,
727: TABLE_NAME,
728: MERGE_HEADER_ID,
729: PRIMARY_KEY_ID1,
735: CREATION_DATE,
736: LAST_UPDATE_LOGIN,
737: LAST_UPDATE_DATE,
738: LAST_UPDATED_BY
739: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
740: 'OTA_EVENT_ASSOCIATIONS',
741: MERGE_HEADER_ID_LIST(I),
742: PRIMARY_KEY_ID1_LIST(I),
743: NUM_COL1_ORIG_LIST(I),
877: NUM_COL1_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL1_ORIG_LIST(I));
878: END LOOP;
879: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
880: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
881: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
882: MERGE_LOG_ID,
883: TABLE_NAME,
884: MERGE_HEADER_ID,
885: PRIMARY_KEY_ID1,
891: CREATION_DATE,
892: LAST_UPDATE_LOGIN,
893: LAST_UPDATE_DATE,
894: LAST_UPDATED_BY
895: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
896: 'OTA_NOTRNG_HISTORIES',
897: MERGE_HEADER_ID_LIST(I),
898: PRIMARY_KEY_ID1_LIST(I),
899: NUM_COL1_ORIG_LIST(I),