103: NUM_COL2_ORIG_LIST(I),
104: NUM_COL2_NEW_LIST(I),
105: 'U',
106: req_id,
107: hz_utility_pub.CREATED_BY,
108: hz_utility_pub.CREATION_DATE,
109: hz_utility_pub.LAST_UPDATE_LOGIN,
110: hz_utility_pub.LAST_UPDATE_DATE,
111: hz_utility_pub.LAST_UPDATED_BY
104: NUM_COL2_NEW_LIST(I),
105: 'U',
106: req_id,
107: hz_utility_pub.CREATED_BY,
108: hz_utility_pub.CREATION_DATE,
109: hz_utility_pub.LAST_UPDATE_LOGIN,
110: hz_utility_pub.LAST_UPDATE_DATE,
111: hz_utility_pub.LAST_UPDATED_BY
112: );
105: 'U',
106: req_id,
107: hz_utility_pub.CREATED_BY,
108: hz_utility_pub.CREATION_DATE,
109: hz_utility_pub.LAST_UPDATE_LOGIN,
110: hz_utility_pub.LAST_UPDATE_DATE,
111: hz_utility_pub.LAST_UPDATED_BY
112: );
113:
106: req_id,
107: hz_utility_pub.CREATED_BY,
108: hz_utility_pub.CREATION_DATE,
109: hz_utility_pub.LAST_UPDATE_LOGIN,
110: hz_utility_pub.LAST_UPDATE_DATE,
111: hz_utility_pub.LAST_UPDATED_BY
112: );
113:
114: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
107: hz_utility_pub.CREATED_BY,
108: hz_utility_pub.CREATION_DATE,
109: hz_utility_pub.LAST_UPDATE_LOGIN,
110: hz_utility_pub.LAST_UPDATE_DATE,
111: hz_utility_pub.LAST_UPDATED_BY
112: );
113:
114: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
115: UPDATE AR_CUSTOMER_CALL_TOPICS yt SET
234: NUM_COL2_ORIG_LIST(I),
235: NUM_COL2_NEW_LIST(I),
236: 'U',
237: req_id,
238: hz_utility_pub.CREATED_BY,
239: hz_utility_pub.CREATION_DATE,
240: hz_utility_pub.LAST_UPDATE_LOGIN,
241: hz_utility_pub.LAST_UPDATE_DATE,
242: hz_utility_pub.LAST_UPDATED_BY
235: NUM_COL2_NEW_LIST(I),
236: 'U',
237: req_id,
238: hz_utility_pub.CREATED_BY,
239: hz_utility_pub.CREATION_DATE,
240: hz_utility_pub.LAST_UPDATE_LOGIN,
241: hz_utility_pub.LAST_UPDATE_DATE,
242: hz_utility_pub.LAST_UPDATED_BY
243: );
236: 'U',
237: req_id,
238: hz_utility_pub.CREATED_BY,
239: hz_utility_pub.CREATION_DATE,
240: hz_utility_pub.LAST_UPDATE_LOGIN,
241: hz_utility_pub.LAST_UPDATE_DATE,
242: hz_utility_pub.LAST_UPDATED_BY
243: );
244:
237: req_id,
238: hz_utility_pub.CREATED_BY,
239: hz_utility_pub.CREATION_DATE,
240: hz_utility_pub.LAST_UPDATE_LOGIN,
241: hz_utility_pub.LAST_UPDATE_DATE,
242: hz_utility_pub.LAST_UPDATED_BY
243: );
244:
245: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
238: hz_utility_pub.CREATED_BY,
239: hz_utility_pub.CREATION_DATE,
240: hz_utility_pub.LAST_UPDATE_LOGIN,
241: hz_utility_pub.LAST_UPDATE_DATE,
242: hz_utility_pub.LAST_UPDATED_BY
243: );
244:
245: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
246: UPDATE AR_CUSTOMER_CALLS yt SET
367: NUM_COL2_ORIG_LIST(I),
368: NUM_COL2_NEW_LIST(I),
369: 'U',
370: req_id,
371: hz_utility_pub.CREATED_BY,
372: hz_utility_pub.CREATION_DATE,
373: hz_utility_pub.LAST_UPDATE_LOGIN,
374: hz_utility_pub.LAST_UPDATE_DATE,
375: hz_utility_pub.LAST_UPDATED_BY
368: NUM_COL2_NEW_LIST(I),
369: 'U',
370: req_id,
371: hz_utility_pub.CREATED_BY,
372: hz_utility_pub.CREATION_DATE,
373: hz_utility_pub.LAST_UPDATE_LOGIN,
374: hz_utility_pub.LAST_UPDATE_DATE,
375: hz_utility_pub.LAST_UPDATED_BY
376: );
369: 'U',
370: req_id,
371: hz_utility_pub.CREATED_BY,
372: hz_utility_pub.CREATION_DATE,
373: hz_utility_pub.LAST_UPDATE_LOGIN,
374: hz_utility_pub.LAST_UPDATE_DATE,
375: hz_utility_pub.LAST_UPDATED_BY
376: );
377:
370: req_id,
371: hz_utility_pub.CREATED_BY,
372: hz_utility_pub.CREATION_DATE,
373: hz_utility_pub.LAST_UPDATE_LOGIN,
374: hz_utility_pub.LAST_UPDATE_DATE,
375: hz_utility_pub.LAST_UPDATED_BY
376: );
377:
378: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
371: hz_utility_pub.CREATED_BY,
372: hz_utility_pub.CREATION_DATE,
373: hz_utility_pub.LAST_UPDATE_LOGIN,
374: hz_utility_pub.LAST_UPDATE_DATE,
375: hz_utility_pub.LAST_UPDATED_BY
376: );
377:
378: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
379: UPDATE AR_STATEMENTS_HISTORY yt SET