155:
156:
157: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
158: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
159: INSERT INTO HZ_CUSTOMER_MERGE_LOG
160: (
161: MERGE_LOG_ID,
162: TABLE_NAME,
163: MERGE_HEADER_ID,
174: CREATION_DATE,
175: LAST_UPDATE_LOGIN,
176: LAST_UPDATE_DATE,
177: LAST_UPDATED_BY
178: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
179: 'CN_COMMISSION_HEADERS',
180: MERGE_HEADER_ID_LIST(I),
181: PRIMARY_KEY_ID_LIST(I),
182: NUM_COL1_ORIG_LIST(I),
369:
370:
371: IF l_profile_val IS NOT NULL AND l_profile_val = 'Y' THEN
372: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
373: INSERT INTO HZ_CUSTOMER_MERGE_LOG
374: (
375: MERGE_LOG_ID,
376: TABLE_NAME,
377: MERGE_HEADER_ID,
388: CREATION_DATE,
389: LAST_UPDATE_LOGIN,
390: LAST_UPDATE_DATE,
391: LAST_UPDATED_BY
392: ) VALUES ( HZ_CUSTOMER_MERGE_LOG_s.nextval,
393: 'CN_COMM_LINES_API',
394: MERGE_HEADER_ID_LIST(I),
395: PRIMARY_KEY_ID_LIST(I),
396: NUM_COL1_ORIG_LIST(I),