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
305: NUM_COL1_ORIG_LIST(I),
306: NUM_COL1_NEW_LIST(I),
307: 'U',
308: req_id,
309: hz_utility_pub.CREATED_BY,
310: hz_utility_pub.CREATION_DATE,
311: hz_utility_pub.LAST_UPDATE_LOGIN,
312: hz_utility_pub.LAST_UPDATE_DATE,
313: hz_utility_pub.LAST_UPDATED_BY
306: NUM_COL1_NEW_LIST(I),
307: 'U',
308: req_id,
309: hz_utility_pub.CREATED_BY,
310: hz_utility_pub.CREATION_DATE,
311: hz_utility_pub.LAST_UPDATE_LOGIN,
312: hz_utility_pub.LAST_UPDATE_DATE,
313: hz_utility_pub.LAST_UPDATED_BY
314: );
307: 'U',
308: req_id,
309: hz_utility_pub.CREATED_BY,
310: hz_utility_pub.CREATION_DATE,
311: hz_utility_pub.LAST_UPDATE_LOGIN,
312: hz_utility_pub.LAST_UPDATE_DATE,
313: hz_utility_pub.LAST_UPDATED_BY
314: );
315:
308: req_id,
309: hz_utility_pub.CREATED_BY,
310: hz_utility_pub.CREATION_DATE,
311: hz_utility_pub.LAST_UPDATE_LOGIN,
312: hz_utility_pub.LAST_UPDATE_DATE,
313: hz_utility_pub.LAST_UPDATED_BY
314: );
315:
316: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
309: hz_utility_pub.CREATED_BY,
310: hz_utility_pub.CREATION_DATE,
311: hz_utility_pub.LAST_UPDATE_LOGIN,
312: hz_utility_pub.LAST_UPDATE_DATE,
313: hz_utility_pub.LAST_UPDATED_BY
314: );
315:
316: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
317: UPDATE FV_CUST_VEND_XREFS yt SET
436: NUM_COL1_ORIG_LIST(I),
437: NUM_COL1_NEW_LIST(I),
438: 'U',
439: req_id,
440: hz_utility_pub.CREATED_BY,
441: hz_utility_pub.CREATION_DATE,
442: hz_utility_pub.LAST_UPDATE_LOGIN,
443: hz_utility_pub.LAST_UPDATE_DATE,
444: hz_utility_pub.LAST_UPDATED_BY
437: NUM_COL1_NEW_LIST(I),
438: 'U',
439: req_id,
440: hz_utility_pub.CREATED_BY,
441: hz_utility_pub.CREATION_DATE,
442: hz_utility_pub.LAST_UPDATE_LOGIN,
443: hz_utility_pub.LAST_UPDATE_DATE,
444: hz_utility_pub.LAST_UPDATED_BY
445: );
438: 'U',
439: req_id,
440: hz_utility_pub.CREATED_BY,
441: hz_utility_pub.CREATION_DATE,
442: hz_utility_pub.LAST_UPDATE_LOGIN,
443: hz_utility_pub.LAST_UPDATE_DATE,
444: hz_utility_pub.LAST_UPDATED_BY
445: );
446:
439: req_id,
440: hz_utility_pub.CREATED_BY,
441: hz_utility_pub.CREATION_DATE,
442: hz_utility_pub.LAST_UPDATE_LOGIN,
443: hz_utility_pub.LAST_UPDATE_DATE,
444: hz_utility_pub.LAST_UPDATED_BY
445: );
446:
447: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
440: hz_utility_pub.CREATED_BY,
441: hz_utility_pub.CREATION_DATE,
442: hz_utility_pub.LAST_UPDATE_LOGIN,
443: hz_utility_pub.LAST_UPDATE_DATE,
444: hz_utility_pub.LAST_UPDATED_BY
445: );
446:
447: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
448: UPDATE FV_INTERAGENCY_FUNDS yt SET
606: NUM_COL2_ORIG_LIST(I),
607: NUM_COL2_NEW_LIST(I),
608: 'U',
609: req_id,
610: hz_utility_pub.CREATED_BY,
611: hz_utility_pub.CREATION_DATE,
612: hz_utility_pub.LAST_UPDATE_LOGIN,
613: hz_utility_pub.LAST_UPDATE_DATE,
614: hz_utility_pub.LAST_UPDATED_BY
607: NUM_COL2_NEW_LIST(I),
608: 'U',
609: req_id,
610: hz_utility_pub.CREATED_BY,
611: hz_utility_pub.CREATION_DATE,
612: hz_utility_pub.LAST_UPDATE_LOGIN,
613: hz_utility_pub.LAST_UPDATE_DATE,
614: hz_utility_pub.LAST_UPDATED_BY
615: );
608: 'U',
609: req_id,
610: hz_utility_pub.CREATED_BY,
611: hz_utility_pub.CREATION_DATE,
612: hz_utility_pub.LAST_UPDATE_LOGIN,
613: hz_utility_pub.LAST_UPDATE_DATE,
614: hz_utility_pub.LAST_UPDATED_BY
615: );
616:
609: req_id,
610: hz_utility_pub.CREATED_BY,
611: hz_utility_pub.CREATION_DATE,
612: hz_utility_pub.LAST_UPDATE_LOGIN,
613: hz_utility_pub.LAST_UPDATE_DATE,
614: hz_utility_pub.LAST_UPDATED_BY
615: );
616:
617: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
610: hz_utility_pub.CREATED_BY,
611: hz_utility_pub.CREATION_DATE,
612: hz_utility_pub.LAST_UPDATE_LOGIN,
613: hz_utility_pub.LAST_UPDATE_DATE,
614: hz_utility_pub.LAST_UPDATED_BY
615: );
616:
617: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
618: UPDATE FV_INTERIM_CASH_RECEIPTS yt SET
759: NUM_COL1_ORIG_LIST(I),
760: NUM_COL1_NEW_LIST(I),
761: 'U',
762: req_id,
763: hz_utility_pub.CREATED_BY,
764: hz_utility_pub.CREATION_DATE,
765: hz_utility_pub.LAST_UPDATE_LOGIN,
766: hz_utility_pub.LAST_UPDATE_DATE,
767: hz_utility_pub.LAST_UPDATED_BY
760: NUM_COL1_NEW_LIST(I),
761: 'U',
762: req_id,
763: hz_utility_pub.CREATED_BY,
764: hz_utility_pub.CREATION_DATE,
765: hz_utility_pub.LAST_UPDATE_LOGIN,
766: hz_utility_pub.LAST_UPDATE_DATE,
767: hz_utility_pub.LAST_UPDATED_BY
768: );
761: 'U',
762: req_id,
763: hz_utility_pub.CREATED_BY,
764: hz_utility_pub.CREATION_DATE,
765: hz_utility_pub.LAST_UPDATE_LOGIN,
766: hz_utility_pub.LAST_UPDATE_DATE,
767: hz_utility_pub.LAST_UPDATED_BY
768: );
769:
762: req_id,
763: hz_utility_pub.CREATED_BY,
764: hz_utility_pub.CREATION_DATE,
765: hz_utility_pub.LAST_UPDATE_LOGIN,
766: hz_utility_pub.LAST_UPDATE_DATE,
767: hz_utility_pub.LAST_UPDATED_BY
768: );
769:
770: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
763: hz_utility_pub.CREATED_BY,
764: hz_utility_pub.CREATION_DATE,
765: hz_utility_pub.LAST_UPDATE_LOGIN,
766: hz_utility_pub.LAST_UPDATE_DATE,
767: hz_utility_pub.LAST_UPDATED_BY
768: );
769:
770: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
771: UPDATE FV_INVOICE_FINANCE_CHRGS yt SET
893: NUM_COL1_ORIG_LIST(I),
894: NUM_COL1_NEW_LIST(I),
895: 'U',
896: req_id,
897: hz_utility_pub.CREATED_BY,
898: hz_utility_pub.CREATION_DATE,
899: hz_utility_pub.LAST_UPDATE_LOGIN,
900: hz_utility_pub.LAST_UPDATE_DATE,
901: hz_utility_pub.LAST_UPDATED_BY
894: NUM_COL1_NEW_LIST(I),
895: 'U',
896: req_id,
897: hz_utility_pub.CREATED_BY,
898: hz_utility_pub.CREATION_DATE,
899: hz_utility_pub.LAST_UPDATE_LOGIN,
900: hz_utility_pub.LAST_UPDATE_DATE,
901: hz_utility_pub.LAST_UPDATED_BY
902: );
895: 'U',
896: req_id,
897: hz_utility_pub.CREATED_BY,
898: hz_utility_pub.CREATION_DATE,
899: hz_utility_pub.LAST_UPDATE_LOGIN,
900: hz_utility_pub.LAST_UPDATE_DATE,
901: hz_utility_pub.LAST_UPDATED_BY
902: );
903:
896: req_id,
897: hz_utility_pub.CREATED_BY,
898: hz_utility_pub.CREATION_DATE,
899: hz_utility_pub.LAST_UPDATE_LOGIN,
900: hz_utility_pub.LAST_UPDATE_DATE,
901: hz_utility_pub.LAST_UPDATED_BY
902: );
903:
904: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
897: hz_utility_pub.CREATED_BY,
898: hz_utility_pub.CREATION_DATE,
899: hz_utility_pub.LAST_UPDATE_LOGIN,
900: hz_utility_pub.LAST_UPDATE_DATE,
901: hz_utility_pub.LAST_UPDATED_BY
902: );
903:
904: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
905: UPDATE FV_IPAC_TRX yt SET