136: NUM_COL2_ORIG_LIST(I),
137: NUM_COL2_NEW_LIST(I),
138: 'U',
139: req_id,
140: hz_utility_pub.CREATED_BY,
141: hz_utility_pub.CREATION_DATE,
142: hz_utility_pub.LAST_UPDATE_LOGIN,
143: hz_utility_pub.LAST_UPDATE_DATE,
144: hz_utility_pub.LAST_UPDATED_BY
137: NUM_COL2_NEW_LIST(I),
138: 'U',
139: req_id,
140: hz_utility_pub.CREATED_BY,
141: hz_utility_pub.CREATION_DATE,
142: hz_utility_pub.LAST_UPDATE_LOGIN,
143: hz_utility_pub.LAST_UPDATE_DATE,
144: hz_utility_pub.LAST_UPDATED_BY
145: );
138: 'U',
139: req_id,
140: hz_utility_pub.CREATED_BY,
141: hz_utility_pub.CREATION_DATE,
142: hz_utility_pub.LAST_UPDATE_LOGIN,
143: hz_utility_pub.LAST_UPDATE_DATE,
144: hz_utility_pub.LAST_UPDATED_BY
145: );
146:
139: req_id,
140: hz_utility_pub.CREATED_BY,
141: hz_utility_pub.CREATION_DATE,
142: hz_utility_pub.LAST_UPDATE_LOGIN,
143: hz_utility_pub.LAST_UPDATE_DATE,
144: hz_utility_pub.LAST_UPDATED_BY
145: );
146:
147: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
140: hz_utility_pub.CREATED_BY,
141: hz_utility_pub.CREATION_DATE,
142: hz_utility_pub.LAST_UPDATE_LOGIN,
143: hz_utility_pub.LAST_UPDATE_DATE,
144: hz_utility_pub.LAST_UPDATED_BY
145: );
146:
147: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
148: UPDATE CSC_CUSTOMERS yt SET
249: NUM_COL1_ORIG_LIST(I),
250: NUM_COL1_NEW_LIST(I),
251: 'U',
252: req_id,
253: hz_utility_pub.CREATED_BY,
254: hz_utility_pub.CREATION_DATE,
255: hz_utility_pub.LAST_UPDATE_LOGIN,
256: hz_utility_pub.LAST_UPDATE_DATE,
257: hz_utility_pub.LAST_UPDATED_BY
250: NUM_COL1_NEW_LIST(I),
251: 'U',
252: req_id,
253: hz_utility_pub.CREATED_BY,
254: hz_utility_pub.CREATION_DATE,
255: hz_utility_pub.LAST_UPDATE_LOGIN,
256: hz_utility_pub.LAST_UPDATE_DATE,
257: hz_utility_pub.LAST_UPDATED_BY
258: );
251: 'U',
252: req_id,
253: hz_utility_pub.CREATED_BY,
254: hz_utility_pub.CREATION_DATE,
255: hz_utility_pub.LAST_UPDATE_LOGIN,
256: hz_utility_pub.LAST_UPDATE_DATE,
257: hz_utility_pub.LAST_UPDATED_BY
258: );
259:
252: req_id,
253: hz_utility_pub.CREATED_BY,
254: hz_utility_pub.CREATION_DATE,
255: hz_utility_pub.LAST_UPDATE_LOGIN,
256: hz_utility_pub.LAST_UPDATE_DATE,
257: hz_utility_pub.LAST_UPDATED_BY
258: );
259:
260: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
253: hz_utility_pub.CREATED_BY,
254: hz_utility_pub.CREATION_DATE,
255: hz_utility_pub.LAST_UPDATE_LOGIN,
256: hz_utility_pub.LAST_UPDATE_DATE,
257: hz_utility_pub.LAST_UPDATED_BY
258: );
259:
260: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
261: UPDATE CSC_CUSTOMERS_AUDIT_HIST yt SET
373: NUM_COL2_ORIG_LIST(I),
374: NUM_COL2_NEW_LIST(I),
375: 'U',
376: req_id,
377: hz_utility_pub.CREATED_BY,
378: hz_utility_pub.CREATION_DATE,
379: hz_utility_pub.LAST_UPDATE_LOGIN,
380: hz_utility_pub.LAST_UPDATE_DATE,
381: hz_utility_pub.LAST_UPDATED_BY
374: NUM_COL2_NEW_LIST(I),
375: 'U',
376: req_id,
377: hz_utility_pub.CREATED_BY,
378: hz_utility_pub.CREATION_DATE,
379: hz_utility_pub.LAST_UPDATE_LOGIN,
380: hz_utility_pub.LAST_UPDATE_DATE,
381: hz_utility_pub.LAST_UPDATED_BY
382: );
375: 'U',
376: req_id,
377: hz_utility_pub.CREATED_BY,
378: hz_utility_pub.CREATION_DATE,
379: hz_utility_pub.LAST_UPDATE_LOGIN,
380: hz_utility_pub.LAST_UPDATE_DATE,
381: hz_utility_pub.LAST_UPDATED_BY
382: );
383:
376: req_id,
377: hz_utility_pub.CREATED_BY,
378: hz_utility_pub.CREATION_DATE,
379: hz_utility_pub.LAST_UPDATE_LOGIN,
380: hz_utility_pub.LAST_UPDATE_DATE,
381: hz_utility_pub.LAST_UPDATED_BY
382: );
383:
384: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
377: hz_utility_pub.CREATED_BY,
378: hz_utility_pub.CREATION_DATE,
379: hz_utility_pub.LAST_UPDATE_LOGIN,
380: hz_utility_pub.LAST_UPDATE_DATE,
381: hz_utility_pub.LAST_UPDATED_BY
382: );
383:
384: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
385: UPDATE CSC_CUSTOMIZED_PLANS yt SET
507: NUM_COL2_ORIG_LIST(I),
508: NUM_COL2_NEW_LIST(I),
509: 'U',
510: req_id,
511: hz_utility_pub.CREATED_BY,
512: hz_utility_pub.CREATION_DATE,
513: hz_utility_pub.LAST_UPDATE_LOGIN,
514: hz_utility_pub.LAST_UPDATE_DATE,
515: hz_utility_pub.LAST_UPDATED_BY
508: NUM_COL2_NEW_LIST(I),
509: 'U',
510: req_id,
511: hz_utility_pub.CREATED_BY,
512: hz_utility_pub.CREATION_DATE,
513: hz_utility_pub.LAST_UPDATE_LOGIN,
514: hz_utility_pub.LAST_UPDATE_DATE,
515: hz_utility_pub.LAST_UPDATED_BY
516: );
509: 'U',
510: req_id,
511: hz_utility_pub.CREATED_BY,
512: hz_utility_pub.CREATION_DATE,
513: hz_utility_pub.LAST_UPDATE_LOGIN,
514: hz_utility_pub.LAST_UPDATE_DATE,
515: hz_utility_pub.LAST_UPDATED_BY
516: );
517:
510: req_id,
511: hz_utility_pub.CREATED_BY,
512: hz_utility_pub.CREATION_DATE,
513: hz_utility_pub.LAST_UPDATE_LOGIN,
514: hz_utility_pub.LAST_UPDATE_DATE,
515: hz_utility_pub.LAST_UPDATED_BY
516: );
517:
518: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
511: hz_utility_pub.CREATED_BY,
512: hz_utility_pub.CREATION_DATE,
513: hz_utility_pub.LAST_UPDATE_LOGIN,
514: hz_utility_pub.LAST_UPDATE_DATE,
515: hz_utility_pub.LAST_UPDATED_BY
516: );
517:
518: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
519: UPDATE CSC_CUST_PLANS yt SET
663: NUM_COL2_ORIG_LIST(I),
664: NUM_COL2_NEW_LIST(I),
665: 'U',
666: req_id,
667: hz_utility_pub.CREATED_BY,
668: hz_utility_pub.CREATION_DATE,
669: hz_utility_pub.LAST_UPDATE_LOGIN,
670: hz_utility_pub.LAST_UPDATE_DATE,
671: hz_utility_pub.LAST_UPDATED_BY
664: NUM_COL2_NEW_LIST(I),
665: 'U',
666: req_id,
667: hz_utility_pub.CREATED_BY,
668: hz_utility_pub.CREATION_DATE,
669: hz_utility_pub.LAST_UPDATE_LOGIN,
670: hz_utility_pub.LAST_UPDATE_DATE,
671: hz_utility_pub.LAST_UPDATED_BY
672: );
665: 'U',
666: req_id,
667: hz_utility_pub.CREATED_BY,
668: hz_utility_pub.CREATION_DATE,
669: hz_utility_pub.LAST_UPDATE_LOGIN,
670: hz_utility_pub.LAST_UPDATE_DATE,
671: hz_utility_pub.LAST_UPDATED_BY
672: );
673:
666: req_id,
667: hz_utility_pub.CREATED_BY,
668: hz_utility_pub.CREATION_DATE,
669: hz_utility_pub.LAST_UPDATE_LOGIN,
670: hz_utility_pub.LAST_UPDATE_DATE,
671: hz_utility_pub.LAST_UPDATED_BY
672: );
673:
674: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
667: hz_utility_pub.CREATED_BY,
668: hz_utility_pub.CREATION_DATE,
669: hz_utility_pub.LAST_UPDATE_LOGIN,
670: hz_utility_pub.LAST_UPDATE_DATE,
671: hz_utility_pub.LAST_UPDATED_BY
672: );
673:
674: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
675: UPDATE CSC_CUST_PLANS_AUDIT yt SET