236: NUM_COL1_ORIG_LIST(I),
237: NUM_COL1_NEW_LIST(I),
238: 'U',
239: req_id,
240: hz_utility_pub.CREATED_BY,
241: hz_utility_pub.CREATION_DATE,
242: hz_utility_pub.LAST_UPDATE_LOGIN,
243: hz_utility_pub.LAST_UPDATE_DATE,
244: hz_utility_pub.LAST_UPDATED_BY);
237: NUM_COL1_NEW_LIST(I),
238: 'U',
239: req_id,
240: hz_utility_pub.CREATED_BY,
241: hz_utility_pub.CREATION_DATE,
242: hz_utility_pub.LAST_UPDATE_LOGIN,
243: hz_utility_pub.LAST_UPDATE_DATE,
244: hz_utility_pub.LAST_UPDATED_BY);
245:
238: 'U',
239: req_id,
240: hz_utility_pub.CREATED_BY,
241: hz_utility_pub.CREATION_DATE,
242: hz_utility_pub.LAST_UPDATE_LOGIN,
243: hz_utility_pub.LAST_UPDATE_DATE,
244: hz_utility_pub.LAST_UPDATED_BY);
245:
246: END IF;
239: req_id,
240: hz_utility_pub.CREATED_BY,
241: hz_utility_pub.CREATION_DATE,
242: hz_utility_pub.LAST_UPDATE_LOGIN,
243: hz_utility_pub.LAST_UPDATE_DATE,
244: hz_utility_pub.LAST_UPDATED_BY);
245:
246: END IF;
247:
240: hz_utility_pub.CREATED_BY,
241: hz_utility_pub.CREATION_DATE,
242: hz_utility_pub.LAST_UPDATE_LOGIN,
243: hz_utility_pub.LAST_UPDATE_DATE,
244: hz_utility_pub.LAST_UPDATED_BY);
245:
246: END IF;
247:
248: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
364: NUM_COL1_ORIG_LIST(I),
365: NUM_COL1_NEW_LIST(I),
366: 'U',
367: req_id,
368: hz_utility_pub.CREATED_BY,
369: hz_utility_pub.CREATION_DATE,
370: hz_utility_pub.LAST_UPDATE_LOGIN,
371: hz_utility_pub.LAST_UPDATE_DATE,
372: hz_utility_pub.LAST_UPDATED_BY
365: NUM_COL1_NEW_LIST(I),
366: 'U',
367: req_id,
368: hz_utility_pub.CREATED_BY,
369: hz_utility_pub.CREATION_DATE,
370: hz_utility_pub.LAST_UPDATE_LOGIN,
371: hz_utility_pub.LAST_UPDATE_DATE,
372: hz_utility_pub.LAST_UPDATED_BY
373: );
366: 'U',
367: req_id,
368: hz_utility_pub.CREATED_BY,
369: hz_utility_pub.CREATION_DATE,
370: hz_utility_pub.LAST_UPDATE_LOGIN,
371: hz_utility_pub.LAST_UPDATE_DATE,
372: hz_utility_pub.LAST_UPDATED_BY
373: );
374:
367: req_id,
368: hz_utility_pub.CREATED_BY,
369: hz_utility_pub.CREATION_DATE,
370: hz_utility_pub.LAST_UPDATE_LOGIN,
371: hz_utility_pub.LAST_UPDATE_DATE,
372: hz_utility_pub.LAST_UPDATED_BY
373: );
374:
375: END IF;
368: hz_utility_pub.CREATED_BY,
369: hz_utility_pub.CREATION_DATE,
370: hz_utility_pub.LAST_UPDATE_LOGIN,
371: hz_utility_pub.LAST_UPDATE_DATE,
372: hz_utility_pub.LAST_UPDATED_BY
373: );
374:
375: END IF;
376: