194: NUM_COL2_ORIG_LIST(I),
195: NUM_COL2_NEW_LIST(I),
196: 'U',
197: req_id,
198: hz_utility_pub.CREATED_BY,
199: hz_utility_pub.CREATION_DATE,
200: hz_utility_pub.LAST_UPDATE_LOGIN,
201: hz_utility_pub.LAST_UPDATE_DATE,
202: hz_utility_pub.LAST_UPDATED_BY
195: NUM_COL2_NEW_LIST(I),
196: 'U',
197: req_id,
198: hz_utility_pub.CREATED_BY,
199: hz_utility_pub.CREATION_DATE,
200: hz_utility_pub.LAST_UPDATE_LOGIN,
201: hz_utility_pub.LAST_UPDATE_DATE,
202: hz_utility_pub.LAST_UPDATED_BY
203: );
196: 'U',
197: req_id,
198: hz_utility_pub.CREATED_BY,
199: hz_utility_pub.CREATION_DATE,
200: hz_utility_pub.LAST_UPDATE_LOGIN,
201: hz_utility_pub.LAST_UPDATE_DATE,
202: hz_utility_pub.LAST_UPDATED_BY
203: );
204: END IF;
197: req_id,
198: hz_utility_pub.CREATED_BY,
199: hz_utility_pub.CREATION_DATE,
200: hz_utility_pub.LAST_UPDATE_LOGIN,
201: hz_utility_pub.LAST_UPDATE_DATE,
202: hz_utility_pub.LAST_UPDATED_BY
203: );
204: END IF;
205: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
198: hz_utility_pub.CREATED_BY,
199: hz_utility_pub.CREATION_DATE,
200: hz_utility_pub.LAST_UPDATE_LOGIN,
201: hz_utility_pub.LAST_UPDATE_DATE,
202: hz_utility_pub.LAST_UPDATED_BY
203: );
204: END IF;
205: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
206: UPDATE OKS_BILLING_PROFILES_B yt SET
403: NUM_COL4_ORIG_LIST(I),
404: NUM_COL4_NEW_LIST(I),
405: 'U',
406: req_id,
407: hz_utility_pub.CREATED_BY,
408: hz_utility_pub.CREATION_DATE,
409: hz_utility_pub.LAST_UPDATE_LOGIN,
410: hz_utility_pub.LAST_UPDATE_DATE,
411: hz_utility_pub.LAST_UPDATED_BY
404: NUM_COL4_NEW_LIST(I),
405: 'U',
406: req_id,
407: hz_utility_pub.CREATED_BY,
408: hz_utility_pub.CREATION_DATE,
409: hz_utility_pub.LAST_UPDATE_LOGIN,
410: hz_utility_pub.LAST_UPDATE_DATE,
411: hz_utility_pub.LAST_UPDATED_BY
412: );
405: 'U',
406: req_id,
407: hz_utility_pub.CREATED_BY,
408: hz_utility_pub.CREATION_DATE,
409: hz_utility_pub.LAST_UPDATE_LOGIN,
410: hz_utility_pub.LAST_UPDATE_DATE,
411: hz_utility_pub.LAST_UPDATED_BY
412: );
413:
406: req_id,
407: hz_utility_pub.CREATED_BY,
408: hz_utility_pub.CREATION_DATE,
409: hz_utility_pub.LAST_UPDATE_LOGIN,
410: hz_utility_pub.LAST_UPDATE_DATE,
411: hz_utility_pub.LAST_UPDATED_BY
412: );
413:
414: END IF;
407: hz_utility_pub.CREATED_BY,
408: hz_utility_pub.CREATION_DATE,
409: hz_utility_pub.LAST_UPDATE_LOGIN,
410: hz_utility_pub.LAST_UPDATE_DATE,
411: hz_utility_pub.LAST_UPDATED_BY
412: );
413:
414: END IF;
415: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
480: NUM_COL2_ORIG_LIST_QUOTE(I),
481: NUM_COL2_NEW_LIST_QUOTE(I),
482: 'U',
483: req_id,
484: hz_utility_pub.CREATED_BY,
485: hz_utility_pub.CREATION_DATE,
486: hz_utility_pub.LAST_UPDATE_LOGIN,
487: hz_utility_pub.LAST_UPDATE_DATE,
488: hz_utility_pub.LAST_UPDATED_BY
481: NUM_COL2_NEW_LIST_QUOTE(I),
482: 'U',
483: req_id,
484: hz_utility_pub.CREATED_BY,
485: hz_utility_pub.CREATION_DATE,
486: hz_utility_pub.LAST_UPDATE_LOGIN,
487: hz_utility_pub.LAST_UPDATE_DATE,
488: hz_utility_pub.LAST_UPDATED_BY
489: );
482: 'U',
483: req_id,
484: hz_utility_pub.CREATED_BY,
485: hz_utility_pub.CREATION_DATE,
486: hz_utility_pub.LAST_UPDATE_LOGIN,
487: hz_utility_pub.LAST_UPDATE_DATE,
488: hz_utility_pub.LAST_UPDATED_BY
489: );
490:
483: req_id,
484: hz_utility_pub.CREATED_BY,
485: hz_utility_pub.CREATION_DATE,
486: hz_utility_pub.LAST_UPDATE_LOGIN,
487: hz_utility_pub.LAST_UPDATE_DATE,
488: hz_utility_pub.LAST_UPDATED_BY
489: );
490:
491: END IF;
484: hz_utility_pub.CREATED_BY,
485: hz_utility_pub.CREATION_DATE,
486: hz_utility_pub.LAST_UPDATE_LOGIN,
487: hz_utility_pub.LAST_UPDATE_DATE,
488: hz_utility_pub.LAST_UPDATED_BY
489: );
490:
491: END IF;
492: