186: NUM_COL3_ORIG_LIST(I),
187: NUM_COL3_NEW_LIST(I),
188: 'U',
189: req_id,
190: hz_utility_pub.CREATED_BY,
191: hz_utility_pub.CREATION_DATE,
192: hz_utility_pub.LAST_UPDATE_LOGIN,
193: hz_utility_pub.LAST_UPDATE_DATE,
194: hz_utility_pub.LAST_UPDATED_BY
187: NUM_COL3_NEW_LIST(I),
188: 'U',
189: req_id,
190: hz_utility_pub.CREATED_BY,
191: hz_utility_pub.CREATION_DATE,
192: hz_utility_pub.LAST_UPDATE_LOGIN,
193: hz_utility_pub.LAST_UPDATE_DATE,
194: hz_utility_pub.LAST_UPDATED_BY
195: );
188: 'U',
189: req_id,
190: hz_utility_pub.CREATED_BY,
191: hz_utility_pub.CREATION_DATE,
192: hz_utility_pub.LAST_UPDATE_LOGIN,
193: hz_utility_pub.LAST_UPDATE_DATE,
194: hz_utility_pub.LAST_UPDATED_BY
195: );
196: END IF;
189: req_id,
190: hz_utility_pub.CREATED_BY,
191: hz_utility_pub.CREATION_DATE,
192: hz_utility_pub.LAST_UPDATE_LOGIN,
193: hz_utility_pub.LAST_UPDATE_DATE,
194: hz_utility_pub.LAST_UPDATED_BY
195: );
196: END IF;
197: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
190: hz_utility_pub.CREATED_BY,
191: hz_utility_pub.CREATION_DATE,
192: hz_utility_pub.LAST_UPDATE_LOGIN,
193: hz_utility_pub.LAST_UPDATE_DATE,
194: hz_utility_pub.LAST_UPDATED_BY
195: );
196: END IF;
197: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
198: UPDATE CN_COMMISSION_HEADERS_ALL yt SET
400: NUM_COL3_ORIG_LIST(I),
401: NUM_COL3_NEW_LIST(I),
402: 'U',
403: req_id,
404: hz_utility_pub.CREATED_BY,
405: hz_utility_pub.CREATION_DATE,
406: hz_utility_pub.LAST_UPDATE_LOGIN,
407: hz_utility_pub.LAST_UPDATE_DATE,
408: hz_utility_pub.LAST_UPDATED_BY
401: NUM_COL3_NEW_LIST(I),
402: 'U',
403: req_id,
404: hz_utility_pub.CREATED_BY,
405: hz_utility_pub.CREATION_DATE,
406: hz_utility_pub.LAST_UPDATE_LOGIN,
407: hz_utility_pub.LAST_UPDATE_DATE,
408: hz_utility_pub.LAST_UPDATED_BY
409: );
402: 'U',
403: req_id,
404: hz_utility_pub.CREATED_BY,
405: hz_utility_pub.CREATION_DATE,
406: hz_utility_pub.LAST_UPDATE_LOGIN,
407: hz_utility_pub.LAST_UPDATE_DATE,
408: hz_utility_pub.LAST_UPDATED_BY
409: );
410:
403: req_id,
404: hz_utility_pub.CREATED_BY,
405: hz_utility_pub.CREATION_DATE,
406: hz_utility_pub.LAST_UPDATE_LOGIN,
407: hz_utility_pub.LAST_UPDATE_DATE,
408: hz_utility_pub.LAST_UPDATED_BY
409: );
410:
411: END IF;
404: hz_utility_pub.CREATED_BY,
405: hz_utility_pub.CREATION_DATE,
406: hz_utility_pub.LAST_UPDATE_LOGIN,
407: hz_utility_pub.LAST_UPDATE_DATE,
408: hz_utility_pub.LAST_UPDATED_BY
409: );
410:
411: END IF;
412: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT