102: NUM_COL2_ORIG_LIST(I),
103: NUM_COL2_NEW_LIST(I),
104: 'U',
105: req_id,
106: hz_utility_pub.CREATED_BY,
107: hz_utility_pub.CREATION_DATE,
108: hz_utility_pub.LAST_UPDATE_LOGIN,
109: hz_utility_pub.LAST_UPDATE_DATE,
110: hz_utility_pub.LAST_UPDATED_BY
103: NUM_COL2_NEW_LIST(I),
104: 'U',
105: req_id,
106: hz_utility_pub.CREATED_BY,
107: hz_utility_pub.CREATION_DATE,
108: hz_utility_pub.LAST_UPDATE_LOGIN,
109: hz_utility_pub.LAST_UPDATE_DATE,
110: hz_utility_pub.LAST_UPDATED_BY
111: );
104: 'U',
105: req_id,
106: hz_utility_pub.CREATED_BY,
107: hz_utility_pub.CREATION_DATE,
108: hz_utility_pub.LAST_UPDATE_LOGIN,
109: hz_utility_pub.LAST_UPDATE_DATE,
110: hz_utility_pub.LAST_UPDATED_BY
111: );
112:
105: req_id,
106: hz_utility_pub.CREATED_BY,
107: hz_utility_pub.CREATION_DATE,
108: hz_utility_pub.LAST_UPDATE_LOGIN,
109: hz_utility_pub.LAST_UPDATE_DATE,
110: hz_utility_pub.LAST_UPDATED_BY
111: );
112:
113: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
106: hz_utility_pub.CREATED_BY,
107: hz_utility_pub.CREATION_DATE,
108: hz_utility_pub.LAST_UPDATE_LOGIN,
109: hz_utility_pub.LAST_UPDATE_DATE,
110: hz_utility_pub.LAST_UPDATED_BY
111: );
112:
113: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
114: UPDATE AR_CASH_RECEIPTS yt SET
233: NUM_COL2_ORIG_LIST(I),
234: NUM_COL2_NEW_LIST(I),
235: 'U',
236: req_id,
237: hz_utility_pub.CREATED_BY,
238: hz_utility_pub.CREATION_DATE,
239: hz_utility_pub.LAST_UPDATE_LOGIN,
240: hz_utility_pub.LAST_UPDATE_DATE,
241: hz_utility_pub.LAST_UPDATED_BY
234: NUM_COL2_NEW_LIST(I),
235: 'U',
236: req_id,
237: hz_utility_pub.CREATED_BY,
238: hz_utility_pub.CREATION_DATE,
239: hz_utility_pub.LAST_UPDATE_LOGIN,
240: hz_utility_pub.LAST_UPDATE_DATE,
241: hz_utility_pub.LAST_UPDATED_BY
242: );
235: 'U',
236: req_id,
237: hz_utility_pub.CREATED_BY,
238: hz_utility_pub.CREATION_DATE,
239: hz_utility_pub.LAST_UPDATE_LOGIN,
240: hz_utility_pub.LAST_UPDATE_DATE,
241: hz_utility_pub.LAST_UPDATED_BY
242: );
243:
236: req_id,
237: hz_utility_pub.CREATED_BY,
238: hz_utility_pub.CREATION_DATE,
239: hz_utility_pub.LAST_UPDATE_LOGIN,
240: hz_utility_pub.LAST_UPDATE_DATE,
241: hz_utility_pub.LAST_UPDATED_BY
242: );
243:
244: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
237: hz_utility_pub.CREATED_BY,
238: hz_utility_pub.CREATION_DATE,
239: hz_utility_pub.LAST_UPDATE_LOGIN,
240: hz_utility_pub.LAST_UPDATE_DATE,
241: hz_utility_pub.LAST_UPDATED_BY
242: );
243:
244: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
245: UPDATE AR_PAYMENT_SCHEDULES yt SET
448: NUM_COL8_ORIG_LIST(I),
449: NUM_COL8_NEW_LIST(I),
450: 'U',
451: req_id,
452: hz_utility_pub.CREATED_BY,
453: hz_utility_pub.CREATION_DATE,
454: hz_utility_pub.LAST_UPDATE_LOGIN,
455: hz_utility_pub.LAST_UPDATE_DATE,
456: hz_utility_pub.LAST_UPDATED_BY
449: NUM_COL8_NEW_LIST(I),
450: 'U',
451: req_id,
452: hz_utility_pub.CREATED_BY,
453: hz_utility_pub.CREATION_DATE,
454: hz_utility_pub.LAST_UPDATE_LOGIN,
455: hz_utility_pub.LAST_UPDATE_DATE,
456: hz_utility_pub.LAST_UPDATED_BY
457: );
450: 'U',
451: req_id,
452: hz_utility_pub.CREATED_BY,
453: hz_utility_pub.CREATION_DATE,
454: hz_utility_pub.LAST_UPDATE_LOGIN,
455: hz_utility_pub.LAST_UPDATE_DATE,
456: hz_utility_pub.LAST_UPDATED_BY
457: );
458: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
451: req_id,
452: hz_utility_pub.CREATED_BY,
453: hz_utility_pub.CREATION_DATE,
454: hz_utility_pub.LAST_UPDATE_LOGIN,
455: hz_utility_pub.LAST_UPDATE_DATE,
456: hz_utility_pub.LAST_UPDATED_BY
457: );
458: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
459: UPDATE RA_CUSTOMER_TRX yt SET
452: hz_utility_pub.CREATED_BY,
453: hz_utility_pub.CREATION_DATE,
454: hz_utility_pub.LAST_UPDATE_LOGIN,
455: hz_utility_pub.LAST_UPDATE_DATE,
456: hz_utility_pub.LAST_UPDATED_BY
457: );
458: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
459: UPDATE RA_CUSTOMER_TRX yt SET
460: bill_to_customer_id=NUM_COL1_NEW_LIST(I)
758: VCHAR_COL5_ORIG_LIST(I),
759: VCHAR_COL5_NEW_LIST(I),
760: 'U',
761: req_id,
762: hz_utility_pub.CREATED_BY,
763: hz_utility_pub.CREATION_DATE,
764: hz_utility_pub.LAST_UPDATE_LOGIN,
765: hz_utility_pub.LAST_UPDATE_DATE,
766: hz_utility_pub.LAST_UPDATED_BY
759: VCHAR_COL5_NEW_LIST(I),
760: 'U',
761: req_id,
762: hz_utility_pub.CREATED_BY,
763: hz_utility_pub.CREATION_DATE,
764: hz_utility_pub.LAST_UPDATE_LOGIN,
765: hz_utility_pub.LAST_UPDATE_DATE,
766: hz_utility_pub.LAST_UPDATED_BY
767: );
760: 'U',
761: req_id,
762: hz_utility_pub.CREATED_BY,
763: hz_utility_pub.CREATION_DATE,
764: hz_utility_pub.LAST_UPDATE_LOGIN,
765: hz_utility_pub.LAST_UPDATE_DATE,
766: hz_utility_pub.LAST_UPDATED_BY
767: );
768:
761: req_id,
762: hz_utility_pub.CREATED_BY,
763: hz_utility_pub.CREATION_DATE,
764: hz_utility_pub.LAST_UPDATE_LOGIN,
765: hz_utility_pub.LAST_UPDATE_DATE,
766: hz_utility_pub.LAST_UPDATED_BY
767: );
768:
769: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
762: hz_utility_pub.CREATED_BY,
763: hz_utility_pub.CREATION_DATE,
764: hz_utility_pub.LAST_UPDATE_LOGIN,
765: hz_utility_pub.LAST_UPDATE_DATE,
766: hz_utility_pub.LAST_UPDATED_BY
767: );
768:
769: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
770: UPDATE RA_INTERFACE_LINES yt SET
893: NUM_COL2_ORIG_LIST(I),
894: NUM_COL2_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_COL2_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 AR_DISTRIBUTIONS yt SET