[Home] [Help]
92: NUM_COL2_NEW_LIST(I) := HZ_ACCT_MERGE_UTIL.GETDUP_ACCOUNT(NUM_COL2_ORIG_LIST(I));
93: END LOOP;
94: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
95: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
96: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
97: MERGE_LOG_ID,
98: TABLE_NAME,
99: MERGE_HEADER_ID,
100: PRIMARY_KEY_ID,
108: CREATION_DATE,
109: LAST_UPDATE_LOGIN,
110: LAST_UPDATE_DATE,
111: LAST_UPDATED_BY
112: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
113: 'OE_AGREEMENTS_B',
114: MERGE_HEADER_ID_LIST(I),
115: PRIMARY_KEY_ID_LIST(I),
116: NUM_COL1_ORIG_LIST(I),
295:
296: END LOOP;
297: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
298: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
299: INSERT INTO HZ_CUSTOMER_MERGE_LOG (
300: MERGE_LOG_ID,
301: TABLE_NAME,
302: MERGE_HEADER_ID,
303: PRIMARY_KEY_ID,
312: CREATION_DATE,
313: LAST_UPDATE_LOGIN,
314: LAST_UPDATE_DATE,
315: LAST_UPDATED_BY
316: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
317: 'QP_QUALIFIERS',
318: MERGE_HEADER_ID_LIST(I),
319: PRIMARY_KEY_ID_LIST(I),
320: VCHAR_COL1_ORIG_LIST(I),