107: NUM_COL1_ORIG_LIST(I),
108: NUM_COL1_NEW_LIST(I),
109: 'U',
110: req_id,
111: hz_utility_pub.CREATED_BY,
112: hz_utility_pub.CREATION_DATE,
113: hz_utility_pub.LAST_UPDATE_LOGIN,
114: hz_utility_pub.LAST_UPDATE_DATE,
115: hz_utility_pub.LAST_UPDATED_BY
108: NUM_COL1_NEW_LIST(I),
109: 'U',
110: req_id,
111: hz_utility_pub.CREATED_BY,
112: hz_utility_pub.CREATION_DATE,
113: hz_utility_pub.LAST_UPDATE_LOGIN,
114: hz_utility_pub.LAST_UPDATE_DATE,
115: hz_utility_pub.LAST_UPDATED_BY
116: );
109: 'U',
110: req_id,
111: hz_utility_pub.CREATED_BY,
112: hz_utility_pub.CREATION_DATE,
113: hz_utility_pub.LAST_UPDATE_LOGIN,
114: hz_utility_pub.LAST_UPDATE_DATE,
115: hz_utility_pub.LAST_UPDATED_BY
116: );
117:
110: req_id,
111: hz_utility_pub.CREATED_BY,
112: hz_utility_pub.CREATION_DATE,
113: hz_utility_pub.LAST_UPDATE_LOGIN,
114: hz_utility_pub.LAST_UPDATE_DATE,
115: hz_utility_pub.LAST_UPDATED_BY
116: );
117:
118: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
111: hz_utility_pub.CREATED_BY,
112: hz_utility_pub.CREATION_DATE,
113: hz_utility_pub.LAST_UPDATE_LOGIN,
114: hz_utility_pub.LAST_UPDATE_DATE,
115: hz_utility_pub.LAST_UPDATED_BY
116: );
117:
118: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
119: UPDATE JL_BR_AR_BANK_RETURNS yt SET
256: NUM_COL2_ORIG_LIST(I),
257: NUM_COL2_NEW_LIST(I),
258: 'U',
259: req_id,
260: hz_utility_pub.CREATED_BY,
261: hz_utility_pub.CREATION_DATE,
262: hz_utility_pub.LAST_UPDATE_LOGIN,
263: hz_utility_pub.LAST_UPDATE_DATE,
264: hz_utility_pub.LAST_UPDATED_BY
257: NUM_COL2_NEW_LIST(I),
258: 'U',
259: req_id,
260: hz_utility_pub.CREATED_BY,
261: hz_utility_pub.CREATION_DATE,
262: hz_utility_pub.LAST_UPDATE_LOGIN,
263: hz_utility_pub.LAST_UPDATE_DATE,
264: hz_utility_pub.LAST_UPDATED_BY
265: );
258: 'U',
259: req_id,
260: hz_utility_pub.CREATED_BY,
261: hz_utility_pub.CREATION_DATE,
262: hz_utility_pub.LAST_UPDATE_LOGIN,
263: hz_utility_pub.LAST_UPDATE_DATE,
264: hz_utility_pub.LAST_UPDATED_BY
265: );
266: END IF;
259: req_id,
260: hz_utility_pub.CREATED_BY,
261: hz_utility_pub.CREATION_DATE,
262: hz_utility_pub.LAST_UPDATE_LOGIN,
263: hz_utility_pub.LAST_UPDATE_DATE,
264: hz_utility_pub.LAST_UPDATED_BY
265: );
266: END IF;
267:
260: hz_utility_pub.CREATED_BY,
261: hz_utility_pub.CREATION_DATE,
262: hz_utility_pub.LAST_UPDATE_LOGIN,
263: hz_utility_pub.LAST_UPDATE_DATE,
264: hz_utility_pub.LAST_UPDATED_BY
265: );
266: END IF;
267:
268: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
392: NUM_COL1_ORIG_LIST(I),
393: NUM_COL1_NEW_LIST(I),
394: 'U',
395: req_id,
396: hz_utility_pub.CREATED_BY,
397: hz_utility_pub.CREATION_DATE,
398: hz_utility_pub.LAST_UPDATE_LOGIN,
399: hz_utility_pub.LAST_UPDATE_DATE,
400: hz_utility_pub.LAST_UPDATED_BY
393: NUM_COL1_NEW_LIST(I),
394: 'U',
395: req_id,
396: hz_utility_pub.CREATED_BY,
397: hz_utility_pub.CREATION_DATE,
398: hz_utility_pub.LAST_UPDATE_LOGIN,
399: hz_utility_pub.LAST_UPDATE_DATE,
400: hz_utility_pub.LAST_UPDATED_BY
401: );
394: 'U',
395: req_id,
396: hz_utility_pub.CREATED_BY,
397: hz_utility_pub.CREATION_DATE,
398: hz_utility_pub.LAST_UPDATE_LOGIN,
399: hz_utility_pub.LAST_UPDATE_DATE,
400: hz_utility_pub.LAST_UPDATED_BY
401: );
402:
395: req_id,
396: hz_utility_pub.CREATED_BY,
397: hz_utility_pub.CREATION_DATE,
398: hz_utility_pub.LAST_UPDATE_LOGIN,
399: hz_utility_pub.LAST_UPDATE_DATE,
400: hz_utility_pub.LAST_UPDATED_BY
401: );
402:
403: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
396: hz_utility_pub.CREATED_BY,
397: hz_utility_pub.CREATION_DATE,
398: hz_utility_pub.LAST_UPDATE_LOGIN,
399: hz_utility_pub.LAST_UPDATE_DATE,
400: hz_utility_pub.LAST_UPDATED_BY
401: );
402:
403: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
404: UPDATE JL_BR_AR_PAY_SCHED_AUX yt SET
764: VCHAR_COL1_ORIG_LIST(I),
765: VCHAR_COL1_NEW_LIST(I),
766: 'U',
767: req_id,
768: hz_utility_pub.CREATED_BY,
769: hz_utility_pub.CREATION_DATE,
770: hz_utility_pub.LAST_UPDATE_LOGIN,
771: hz_utility_pub.LAST_UPDATE_DATE,
772: hz_utility_pub.LAST_UPDATED_BY
765: VCHAR_COL1_NEW_LIST(I),
766: 'U',
767: req_id,
768: hz_utility_pub.CREATED_BY,
769: hz_utility_pub.CREATION_DATE,
770: hz_utility_pub.LAST_UPDATE_LOGIN,
771: hz_utility_pub.LAST_UPDATE_DATE,
772: hz_utility_pub.LAST_UPDATED_BY
773: );
766: 'U',
767: req_id,
768: hz_utility_pub.CREATED_BY,
769: hz_utility_pub.CREATION_DATE,
770: hz_utility_pub.LAST_UPDATE_LOGIN,
771: hz_utility_pub.LAST_UPDATE_DATE,
772: hz_utility_pub.LAST_UPDATED_BY
773: );
774:
767: req_id,
768: hz_utility_pub.CREATED_BY,
769: hz_utility_pub.CREATION_DATE,
770: hz_utility_pub.LAST_UPDATE_LOGIN,
771: hz_utility_pub.LAST_UPDATE_DATE,
772: hz_utility_pub.LAST_UPDATED_BY
773: );
774:
775: END IF;
768: hz_utility_pub.CREATED_BY,
769: hz_utility_pub.CREATION_DATE,
770: hz_utility_pub.LAST_UPDATE_LOGIN,
771: hz_utility_pub.LAST_UPDATE_DATE,
772: hz_utility_pub.LAST_UPDATED_BY
773: );
774:
775: END IF;
776:
1642: NUM_COL5_ORIG_LIST(I),
1643: NUM_COL6_ORIG_LIST(I),
1644: 'D',
1645: req_id,
1646: hz_utility_pub.CREATED_BY,
1647: hz_utility_pub.CREATION_DATE,
1648: hz_utility_pub.LAST_UPDATE_LOGIN,
1649: hz_utility_pub.LAST_UPDATE_DATE,
1650: hz_utility_pub.LAST_UPDATED_BY
1643: NUM_COL6_ORIG_LIST(I),
1644: 'D',
1645: req_id,
1646: hz_utility_pub.CREATED_BY,
1647: hz_utility_pub.CREATION_DATE,
1648: hz_utility_pub.LAST_UPDATE_LOGIN,
1649: hz_utility_pub.LAST_UPDATE_DATE,
1650: hz_utility_pub.LAST_UPDATED_BY
1651: );
1644: 'D',
1645: req_id,
1646: hz_utility_pub.CREATED_BY,
1647: hz_utility_pub.CREATION_DATE,
1648: hz_utility_pub.LAST_UPDATE_LOGIN,
1649: hz_utility_pub.LAST_UPDATE_DATE,
1650: hz_utility_pub.LAST_UPDATED_BY
1651: );
1652:
1645: req_id,
1646: hz_utility_pub.CREATED_BY,
1647: hz_utility_pub.CREATION_DATE,
1648: hz_utility_pub.LAST_UPDATE_LOGIN,
1649: hz_utility_pub.LAST_UPDATE_DATE,
1650: hz_utility_pub.LAST_UPDATED_BY
1651: );
1652:
1653: END IF;
1646: hz_utility_pub.CREATED_BY,
1647: hz_utility_pub.CREATION_DATE,
1648: hz_utility_pub.LAST_UPDATE_LOGIN,
1649: hz_utility_pub.LAST_UPDATE_DATE,
1650: hz_utility_pub.LAST_UPDATED_BY
1651: );
1652:
1653: END IF;
1654: