108: NUM_COL1_ORIG_LIST(I),
109: NUM_COL1_NEW_LIST(I),
110: 'U',
111: req_id,
112: hz_utility_pub.CREATED_BY,
113: hz_utility_pub.CREATION_DATE,
114: hz_utility_pub.LAST_UPDATE_LOGIN,
115: hz_utility_pub.LAST_UPDATE_DATE,
116: hz_utility_pub.LAST_UPDATED_BY
109: NUM_COL1_NEW_LIST(I),
110: 'U',
111: req_id,
112: hz_utility_pub.CREATED_BY,
113: hz_utility_pub.CREATION_DATE,
114: hz_utility_pub.LAST_UPDATE_LOGIN,
115: hz_utility_pub.LAST_UPDATE_DATE,
116: hz_utility_pub.LAST_UPDATED_BY
117: );
110: 'U',
111: req_id,
112: hz_utility_pub.CREATED_BY,
113: hz_utility_pub.CREATION_DATE,
114: hz_utility_pub.LAST_UPDATE_LOGIN,
115: hz_utility_pub.LAST_UPDATE_DATE,
116: hz_utility_pub.LAST_UPDATED_BY
117: );
118:
111: req_id,
112: hz_utility_pub.CREATED_BY,
113: hz_utility_pub.CREATION_DATE,
114: hz_utility_pub.LAST_UPDATE_LOGIN,
115: hz_utility_pub.LAST_UPDATE_DATE,
116: hz_utility_pub.LAST_UPDATED_BY
117: );
118:
119: END IF;
112: hz_utility_pub.CREATED_BY,
113: hz_utility_pub.CREATION_DATE,
114: hz_utility_pub.LAST_UPDATE_LOGIN,
115: hz_utility_pub.LAST_UPDATE_DATE,
116: hz_utility_pub.LAST_UPDATED_BY
117: );
118:
119: END IF;
120: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
243: NUM_COL1_ORIG_LIST(I),
244: NUM_COL1_NEW_LIST(I),
245: 'U',
246: req_id,
247: hz_utility_pub.CREATED_BY,
248: hz_utility_pub.CREATION_DATE,
249: hz_utility_pub.LAST_UPDATE_LOGIN,
250: hz_utility_pub.LAST_UPDATE_DATE,
251: hz_utility_pub.LAST_UPDATED_BY
244: NUM_COL1_NEW_LIST(I),
245: 'U',
246: req_id,
247: hz_utility_pub.CREATED_BY,
248: hz_utility_pub.CREATION_DATE,
249: hz_utility_pub.LAST_UPDATE_LOGIN,
250: hz_utility_pub.LAST_UPDATE_DATE,
251: hz_utility_pub.LAST_UPDATED_BY
252: );
245: 'U',
246: req_id,
247: hz_utility_pub.CREATED_BY,
248: hz_utility_pub.CREATION_DATE,
249: hz_utility_pub.LAST_UPDATE_LOGIN,
250: hz_utility_pub.LAST_UPDATE_DATE,
251: hz_utility_pub.LAST_UPDATED_BY
252: );
253:
246: req_id,
247: hz_utility_pub.CREATED_BY,
248: hz_utility_pub.CREATION_DATE,
249: hz_utility_pub.LAST_UPDATE_LOGIN,
250: hz_utility_pub.LAST_UPDATE_DATE,
251: hz_utility_pub.LAST_UPDATED_BY
252: );
253:
254: END IF;
247: hz_utility_pub.CREATED_BY,
248: hz_utility_pub.CREATION_DATE,
249: hz_utility_pub.LAST_UPDATE_LOGIN,
250: hz_utility_pub.LAST_UPDATE_DATE,
251: hz_utility_pub.LAST_UPDATED_BY
252: );
253:
254: END IF;
255: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT