151: NUM_COL1_ORIG_LIST(I),
152: NUM_COL1_NEW_LIST(I),
153: 'U',
154: req_id,
155: hz_utility_pub.CREATED_BY,
156: hz_utility_pub.CREATION_DATE,
157: hz_utility_pub.LAST_UPDATE_LOGIN,
158: hz_utility_pub.LAST_UPDATE_DATE,
159: hz_utility_pub.LAST_UPDATED_BY
152: NUM_COL1_NEW_LIST(I),
153: 'U',
154: req_id,
155: hz_utility_pub.CREATED_BY,
156: hz_utility_pub.CREATION_DATE,
157: hz_utility_pub.LAST_UPDATE_LOGIN,
158: hz_utility_pub.LAST_UPDATE_DATE,
159: hz_utility_pub.LAST_UPDATED_BY
160: );
153: 'U',
154: req_id,
155: hz_utility_pub.CREATED_BY,
156: hz_utility_pub.CREATION_DATE,
157: hz_utility_pub.LAST_UPDATE_LOGIN,
158: hz_utility_pub.LAST_UPDATE_DATE,
159: hz_utility_pub.LAST_UPDATED_BY
160: );
161:
154: req_id,
155: hz_utility_pub.CREATED_BY,
156: hz_utility_pub.CREATION_DATE,
157: hz_utility_pub.LAST_UPDATE_LOGIN,
158: hz_utility_pub.LAST_UPDATE_DATE,
159: hz_utility_pub.LAST_UPDATED_BY
160: );
161:
162: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
155: hz_utility_pub.CREATED_BY,
156: hz_utility_pub.CREATION_DATE,
157: hz_utility_pub.LAST_UPDATE_LOGIN,
158: hz_utility_pub.LAST_UPDATE_DATE,
159: hz_utility_pub.LAST_UPDATED_BY
160: );
161:
162: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
163: UPDATE FV_CUST_FINANCE_CHRGS yt SET
302: NUM_COL1_ORIG_LIST(I),
303: NUM_COL1_NEW_LIST(I),
304: 'U',
305: req_id,
306: hz_utility_pub.CREATED_BY,
307: hz_utility_pub.CREATION_DATE,
308: hz_utility_pub.LAST_UPDATE_LOGIN,
309: hz_utility_pub.LAST_UPDATE_DATE,
310: hz_utility_pub.LAST_UPDATED_BY
303: NUM_COL1_NEW_LIST(I),
304: 'U',
305: req_id,
306: hz_utility_pub.CREATED_BY,
307: hz_utility_pub.CREATION_DATE,
308: hz_utility_pub.LAST_UPDATE_LOGIN,
309: hz_utility_pub.LAST_UPDATE_DATE,
310: hz_utility_pub.LAST_UPDATED_BY
311: );
304: 'U',
305: req_id,
306: hz_utility_pub.CREATED_BY,
307: hz_utility_pub.CREATION_DATE,
308: hz_utility_pub.LAST_UPDATE_LOGIN,
309: hz_utility_pub.LAST_UPDATE_DATE,
310: hz_utility_pub.LAST_UPDATED_BY
311: );
312:
305: req_id,
306: hz_utility_pub.CREATED_BY,
307: hz_utility_pub.CREATION_DATE,
308: hz_utility_pub.LAST_UPDATE_LOGIN,
309: hz_utility_pub.LAST_UPDATE_DATE,
310: hz_utility_pub.LAST_UPDATED_BY
311: );
312:
313: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
306: hz_utility_pub.CREATED_BY,
307: hz_utility_pub.CREATION_DATE,
308: hz_utility_pub.LAST_UPDATE_LOGIN,
309: hz_utility_pub.LAST_UPDATE_DATE,
310: hz_utility_pub.LAST_UPDATED_BY
311: );
312:
313: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
314: UPDATE FV_CUST_VEND_XREFS yt SET
433: NUM_COL1_ORIG_LIST(I),
434: NUM_COL1_NEW_LIST(I),
435: 'U',
436: req_id,
437: hz_utility_pub.CREATED_BY,
438: hz_utility_pub.CREATION_DATE,
439: hz_utility_pub.LAST_UPDATE_LOGIN,
440: hz_utility_pub.LAST_UPDATE_DATE,
441: hz_utility_pub.LAST_UPDATED_BY
434: NUM_COL1_NEW_LIST(I),
435: 'U',
436: req_id,
437: hz_utility_pub.CREATED_BY,
438: hz_utility_pub.CREATION_DATE,
439: hz_utility_pub.LAST_UPDATE_LOGIN,
440: hz_utility_pub.LAST_UPDATE_DATE,
441: hz_utility_pub.LAST_UPDATED_BY
442: );
435: 'U',
436: req_id,
437: hz_utility_pub.CREATED_BY,
438: hz_utility_pub.CREATION_DATE,
439: hz_utility_pub.LAST_UPDATE_LOGIN,
440: hz_utility_pub.LAST_UPDATE_DATE,
441: hz_utility_pub.LAST_UPDATED_BY
442: );
443:
436: req_id,
437: hz_utility_pub.CREATED_BY,
438: hz_utility_pub.CREATION_DATE,
439: hz_utility_pub.LAST_UPDATE_LOGIN,
440: hz_utility_pub.LAST_UPDATE_DATE,
441: hz_utility_pub.LAST_UPDATED_BY
442: );
443:
444: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
437: hz_utility_pub.CREATED_BY,
438: hz_utility_pub.CREATION_DATE,
439: hz_utility_pub.LAST_UPDATE_LOGIN,
440: hz_utility_pub.LAST_UPDATE_DATE,
441: hz_utility_pub.LAST_UPDATED_BY
442: );
443:
444: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
445: UPDATE FV_INTERAGENCY_FUNDS yt SET
603: NUM_COL2_ORIG_LIST(I),
604: NUM_COL2_NEW_LIST(I),
605: 'U',
606: req_id,
607: hz_utility_pub.CREATED_BY,
608: hz_utility_pub.CREATION_DATE,
609: hz_utility_pub.LAST_UPDATE_LOGIN,
610: hz_utility_pub.LAST_UPDATE_DATE,
611: hz_utility_pub.LAST_UPDATED_BY
604: NUM_COL2_NEW_LIST(I),
605: 'U',
606: req_id,
607: hz_utility_pub.CREATED_BY,
608: hz_utility_pub.CREATION_DATE,
609: hz_utility_pub.LAST_UPDATE_LOGIN,
610: hz_utility_pub.LAST_UPDATE_DATE,
611: hz_utility_pub.LAST_UPDATED_BY
612: );
605: 'U',
606: req_id,
607: hz_utility_pub.CREATED_BY,
608: hz_utility_pub.CREATION_DATE,
609: hz_utility_pub.LAST_UPDATE_LOGIN,
610: hz_utility_pub.LAST_UPDATE_DATE,
611: hz_utility_pub.LAST_UPDATED_BY
612: );
613:
606: req_id,
607: hz_utility_pub.CREATED_BY,
608: hz_utility_pub.CREATION_DATE,
609: hz_utility_pub.LAST_UPDATE_LOGIN,
610: hz_utility_pub.LAST_UPDATE_DATE,
611: hz_utility_pub.LAST_UPDATED_BY
612: );
613:
614: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
607: hz_utility_pub.CREATED_BY,
608: hz_utility_pub.CREATION_DATE,
609: hz_utility_pub.LAST_UPDATE_LOGIN,
610: hz_utility_pub.LAST_UPDATE_DATE,
611: hz_utility_pub.LAST_UPDATED_BY
612: );
613:
614: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
615: UPDATE FV_INTERIM_CASH_RECEIPTS yt SET
756: NUM_COL1_ORIG_LIST(I),
757: NUM_COL1_NEW_LIST(I),
758: 'U',
759: req_id,
760: hz_utility_pub.CREATED_BY,
761: hz_utility_pub.CREATION_DATE,
762: hz_utility_pub.LAST_UPDATE_LOGIN,
763: hz_utility_pub.LAST_UPDATE_DATE,
764: hz_utility_pub.LAST_UPDATED_BY
757: NUM_COL1_NEW_LIST(I),
758: 'U',
759: req_id,
760: hz_utility_pub.CREATED_BY,
761: hz_utility_pub.CREATION_DATE,
762: hz_utility_pub.LAST_UPDATE_LOGIN,
763: hz_utility_pub.LAST_UPDATE_DATE,
764: hz_utility_pub.LAST_UPDATED_BY
765: );
758: 'U',
759: req_id,
760: hz_utility_pub.CREATED_BY,
761: hz_utility_pub.CREATION_DATE,
762: hz_utility_pub.LAST_UPDATE_LOGIN,
763: hz_utility_pub.LAST_UPDATE_DATE,
764: hz_utility_pub.LAST_UPDATED_BY
765: );
766:
759: req_id,
760: hz_utility_pub.CREATED_BY,
761: hz_utility_pub.CREATION_DATE,
762: hz_utility_pub.LAST_UPDATE_LOGIN,
763: hz_utility_pub.LAST_UPDATE_DATE,
764: hz_utility_pub.LAST_UPDATED_BY
765: );
766:
767: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
760: hz_utility_pub.CREATED_BY,
761: hz_utility_pub.CREATION_DATE,
762: hz_utility_pub.LAST_UPDATE_LOGIN,
763: hz_utility_pub.LAST_UPDATE_DATE,
764: hz_utility_pub.LAST_UPDATED_BY
765: );
766:
767: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
768: UPDATE FV_INVOICE_FINANCE_CHRGS yt SET
890: NUM_COL1_ORIG_LIST(I),
891: NUM_COL1_NEW_LIST(I),
892: 'U',
893: req_id,
894: hz_utility_pub.CREATED_BY,
895: hz_utility_pub.CREATION_DATE,
896: hz_utility_pub.LAST_UPDATE_LOGIN,
897: hz_utility_pub.LAST_UPDATE_DATE,
898: hz_utility_pub.LAST_UPDATED_BY
891: NUM_COL1_NEW_LIST(I),
892: 'U',
893: req_id,
894: hz_utility_pub.CREATED_BY,
895: hz_utility_pub.CREATION_DATE,
896: hz_utility_pub.LAST_UPDATE_LOGIN,
897: hz_utility_pub.LAST_UPDATE_DATE,
898: hz_utility_pub.LAST_UPDATED_BY
899: );
892: 'U',
893: req_id,
894: hz_utility_pub.CREATED_BY,
895: hz_utility_pub.CREATION_DATE,
896: hz_utility_pub.LAST_UPDATE_LOGIN,
897: hz_utility_pub.LAST_UPDATE_DATE,
898: hz_utility_pub.LAST_UPDATED_BY
899: );
900:
893: req_id,
894: hz_utility_pub.CREATED_BY,
895: hz_utility_pub.CREATION_DATE,
896: hz_utility_pub.LAST_UPDATE_LOGIN,
897: hz_utility_pub.LAST_UPDATE_DATE,
898: hz_utility_pub.LAST_UPDATED_BY
899: );
900:
901: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
894: hz_utility_pub.CREATED_BY,
895: hz_utility_pub.CREATION_DATE,
896: hz_utility_pub.LAST_UPDATE_LOGIN,
897: hz_utility_pub.LAST_UPDATE_DATE,
898: hz_utility_pub.LAST_UPDATED_BY
899: );
900:
901: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
902: UPDATE FV_IPAC_TRX yt SET