109: NUM_COL2_ORIG_LIST(I),
110: NUM_COL2_NEW_LIST(I),
111: 'U',
112: req_id,
113: hz_utility_pub.CREATED_BY,
114: hz_utility_pub.CREATION_DATE,
115: hz_utility_pub.LAST_UPDATE_LOGIN,
116: hz_utility_pub.LAST_UPDATE_DATE,
117: hz_utility_pub.LAST_UPDATED_BY
110: NUM_COL2_NEW_LIST(I),
111: 'U',
112: req_id,
113: hz_utility_pub.CREATED_BY,
114: hz_utility_pub.CREATION_DATE,
115: hz_utility_pub.LAST_UPDATE_LOGIN,
116: hz_utility_pub.LAST_UPDATE_DATE,
117: hz_utility_pub.LAST_UPDATED_BY
118: );
111: 'U',
112: req_id,
113: hz_utility_pub.CREATED_BY,
114: hz_utility_pub.CREATION_DATE,
115: hz_utility_pub.LAST_UPDATE_LOGIN,
116: hz_utility_pub.LAST_UPDATE_DATE,
117: hz_utility_pub.LAST_UPDATED_BY
118: );
119:
112: req_id,
113: hz_utility_pub.CREATED_BY,
114: hz_utility_pub.CREATION_DATE,
115: hz_utility_pub.LAST_UPDATE_LOGIN,
116: hz_utility_pub.LAST_UPDATE_DATE,
117: hz_utility_pub.LAST_UPDATED_BY
118: );
119:
120: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
113: hz_utility_pub.CREATED_BY,
114: hz_utility_pub.CREATION_DATE,
115: hz_utility_pub.LAST_UPDATE_LOGIN,
116: hz_utility_pub.LAST_UPDATE_DATE,
117: hz_utility_pub.LAST_UPDATED_BY
118: );
119:
120: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
121: UPDATE ISC_BOOK_SUM2_PDUE_F yt SET
247: NUM_COL2_ORIG_LIST(I),
248: NUM_COL2_NEW_LIST(I),
249: 'U',
250: req_id,
251: hz_utility_pub.CREATED_BY,
252: hz_utility_pub.CREATION_DATE,
253: hz_utility_pub.LAST_UPDATE_LOGIN,
254: hz_utility_pub.LAST_UPDATE_DATE,
255: hz_utility_pub.LAST_UPDATED_BY
248: NUM_COL2_NEW_LIST(I),
249: 'U',
250: req_id,
251: hz_utility_pub.CREATED_BY,
252: hz_utility_pub.CREATION_DATE,
253: hz_utility_pub.LAST_UPDATE_LOGIN,
254: hz_utility_pub.LAST_UPDATE_DATE,
255: hz_utility_pub.LAST_UPDATED_BY
256: );
249: 'U',
250: req_id,
251: hz_utility_pub.CREATED_BY,
252: hz_utility_pub.CREATION_DATE,
253: hz_utility_pub.LAST_UPDATE_LOGIN,
254: hz_utility_pub.LAST_UPDATE_DATE,
255: hz_utility_pub.LAST_UPDATED_BY
256: );
257:
250: req_id,
251: hz_utility_pub.CREATED_BY,
252: hz_utility_pub.CREATION_DATE,
253: hz_utility_pub.LAST_UPDATE_LOGIN,
254: hz_utility_pub.LAST_UPDATE_DATE,
255: hz_utility_pub.LAST_UPDATED_BY
256: );
257:
258: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
251: hz_utility_pub.CREATED_BY,
252: hz_utility_pub.CREATION_DATE,
253: hz_utility_pub.LAST_UPDATE_LOGIN,
254: hz_utility_pub.LAST_UPDATE_DATE,
255: hz_utility_pub.LAST_UPDATED_BY
256: );
257:
258: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
259: UPDATE ISC_BOOK_SUM2_PDUE2_F yt SET
385: NUM_COL2_ORIG_LIST(I),
386: NUM_COL2_NEW_LIST(I),
387: 'U',
388: req_id,
389: hz_utility_pub.CREATED_BY,
390: hz_utility_pub.CREATION_DATE,
391: hz_utility_pub.LAST_UPDATE_LOGIN,
392: hz_utility_pub.LAST_UPDATE_DATE,
393: hz_utility_pub.LAST_UPDATED_BY
386: NUM_COL2_NEW_LIST(I),
387: 'U',
388: req_id,
389: hz_utility_pub.CREATED_BY,
390: hz_utility_pub.CREATION_DATE,
391: hz_utility_pub.LAST_UPDATE_LOGIN,
392: hz_utility_pub.LAST_UPDATE_DATE,
393: hz_utility_pub.LAST_UPDATED_BY
394: );
387: 'U',
388: req_id,
389: hz_utility_pub.CREATED_BY,
390: hz_utility_pub.CREATION_DATE,
391: hz_utility_pub.LAST_UPDATE_LOGIN,
392: hz_utility_pub.LAST_UPDATE_DATE,
393: hz_utility_pub.LAST_UPDATED_BY
394: );
395:
388: req_id,
389: hz_utility_pub.CREATED_BY,
390: hz_utility_pub.CREATION_DATE,
391: hz_utility_pub.LAST_UPDATE_LOGIN,
392: hz_utility_pub.LAST_UPDATE_DATE,
393: hz_utility_pub.LAST_UPDATED_BY
394: );
395:
396: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
389: hz_utility_pub.CREATED_BY,
390: hz_utility_pub.CREATION_DATE,
391: hz_utility_pub.LAST_UPDATE_LOGIN,
392: hz_utility_pub.LAST_UPDATE_DATE,
393: hz_utility_pub.LAST_UPDATED_BY
394: );
395:
396: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
397: UPDATE ISC_BOOK_SUM2_BKORD_F yt SET