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_INTERIM_CASH_RECEIPTS yt SET
229: NUM_COL1_ORIG_LIST(I),
230: NUM_COL1_NEW_LIST(I),
231: 'U',
232: req_id,
233: hz_utility_pub.CREATED_BY,
234: hz_utility_pub.CREATION_DATE,
235: hz_utility_pub.LAST_UPDATE_LOGIN,
236: hz_utility_pub.LAST_UPDATE_DATE,
237: hz_utility_pub.LAST_UPDATED_BY
230: NUM_COL1_NEW_LIST(I),
231: 'U',
232: req_id,
233: hz_utility_pub.CREATED_BY,
234: hz_utility_pub.CREATION_DATE,
235: hz_utility_pub.LAST_UPDATE_LOGIN,
236: hz_utility_pub.LAST_UPDATE_DATE,
237: hz_utility_pub.LAST_UPDATED_BY
238: );
231: 'U',
232: req_id,
233: hz_utility_pub.CREATED_BY,
234: hz_utility_pub.CREATION_DATE,
235: hz_utility_pub.LAST_UPDATE_LOGIN,
236: hz_utility_pub.LAST_UPDATE_DATE,
237: hz_utility_pub.LAST_UPDATED_BY
238: );
239:
232: req_id,
233: hz_utility_pub.CREATED_BY,
234: hz_utility_pub.CREATION_DATE,
235: hz_utility_pub.LAST_UPDATE_LOGIN,
236: hz_utility_pub.LAST_UPDATE_DATE,
237: hz_utility_pub.LAST_UPDATED_BY
238: );
239:
240: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
233: hz_utility_pub.CREATED_BY,
234: hz_utility_pub.CREATION_DATE,
235: hz_utility_pub.LAST_UPDATE_LOGIN,
236: hz_utility_pub.LAST_UPDATE_DATE,
237: hz_utility_pub.LAST_UPDATED_BY
238: );
239:
240: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
241: UPDATE AR_INTERIM_CASH_RECEIPT_LINES yt SET