168: NUM_COL6_ORIG_LIST(I),
169: NUM_COL6_NEW_LIST(I),
170: 'U',
171: req_id,
172: hz_utility_pub.CREATED_BY,
173: hz_utility_pub.CREATION_DATE,
174: hz_utility_pub.LAST_UPDATE_LOGIN,
175: hz_utility_pub.LAST_UPDATE_DATE,
176: hz_utility_pub.LAST_UPDATED_BY
169: NUM_COL6_NEW_LIST(I),
170: 'U',
171: req_id,
172: hz_utility_pub.CREATED_BY,
173: hz_utility_pub.CREATION_DATE,
174: hz_utility_pub.LAST_UPDATE_LOGIN,
175: hz_utility_pub.LAST_UPDATE_DATE,
176: hz_utility_pub.LAST_UPDATED_BY
177: );
170: 'U',
171: req_id,
172: hz_utility_pub.CREATED_BY,
173: hz_utility_pub.CREATION_DATE,
174: hz_utility_pub.LAST_UPDATE_LOGIN,
175: hz_utility_pub.LAST_UPDATE_DATE,
176: hz_utility_pub.LAST_UPDATED_BY
177: );
178:
171: req_id,
172: hz_utility_pub.CREATED_BY,
173: hz_utility_pub.CREATION_DATE,
174: hz_utility_pub.LAST_UPDATE_LOGIN,
175: hz_utility_pub.LAST_UPDATE_DATE,
176: hz_utility_pub.LAST_UPDATED_BY
177: );
178:
179: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
172: hz_utility_pub.CREATED_BY,
173: hz_utility_pub.CREATION_DATE,
174: hz_utility_pub.LAST_UPDATE_LOGIN,
175: hz_utility_pub.LAST_UPDATE_DATE,
176: hz_utility_pub.LAST_UPDATED_BY
177: );
178:
179: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
180: UPDATE GMS_AWARDS yt SET
321: NUM_COL1_ORIG_LIST(I),
322: NUM_COL1_NEW_LIST(I),
323: 'U',
324: req_id,
325: hz_utility_pub.CREATED_BY,
326: hz_utility_pub.CREATION_DATE,
327: hz_utility_pub.LAST_UPDATE_LOGIN,
328: hz_utility_pub.LAST_UPDATE_DATE,
329: hz_utility_pub.LAST_UPDATED_BY
322: NUM_COL1_NEW_LIST(I),
323: 'U',
324: req_id,
325: hz_utility_pub.CREATED_BY,
326: hz_utility_pub.CREATION_DATE,
327: hz_utility_pub.LAST_UPDATE_LOGIN,
328: hz_utility_pub.LAST_UPDATE_DATE,
329: hz_utility_pub.LAST_UPDATED_BY
330: );
323: 'U',
324: req_id,
325: hz_utility_pub.CREATED_BY,
326: hz_utility_pub.CREATION_DATE,
327: hz_utility_pub.LAST_UPDATE_LOGIN,
328: hz_utility_pub.LAST_UPDATE_DATE,
329: hz_utility_pub.LAST_UPDATED_BY
330: );
331:
324: req_id,
325: hz_utility_pub.CREATED_BY,
326: hz_utility_pub.CREATION_DATE,
327: hz_utility_pub.LAST_UPDATE_LOGIN,
328: hz_utility_pub.LAST_UPDATE_DATE,
329: hz_utility_pub.LAST_UPDATED_BY
330: );
331:
332: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
325: hz_utility_pub.CREATED_BY,
326: hz_utility_pub.CREATION_DATE,
327: hz_utility_pub.LAST_UPDATE_LOGIN,
328: hz_utility_pub.LAST_UPDATE_DATE,
329: hz_utility_pub.LAST_UPDATED_BY
330: );
331:
332: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
333: UPDATE GMS_AWARDS_CONTACTS yt SET
448: NUM_COL1_ORIG_LIST(I),
449: NUM_COL1_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_COL1_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:
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:
459: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
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:
459: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
460: UPDATE GMS_REPORTS yt SET
572: NUM_COL1_ORIG_LIST(I),
573: NUM_COL1_NEW_LIST(I),
574: 'U',
575: req_id,
576: hz_utility_pub.CREATED_BY,
577: hz_utility_pub.CREATION_DATE,
578: hz_utility_pub.LAST_UPDATE_LOGIN,
579: hz_utility_pub.LAST_UPDATE_DATE,
580: hz_utility_pub.LAST_UPDATED_BY
573: NUM_COL1_NEW_LIST(I),
574: 'U',
575: req_id,
576: hz_utility_pub.CREATED_BY,
577: hz_utility_pub.CREATION_DATE,
578: hz_utility_pub.LAST_UPDATE_LOGIN,
579: hz_utility_pub.LAST_UPDATE_DATE,
580: hz_utility_pub.LAST_UPDATED_BY
581: );
574: 'U',
575: req_id,
576: hz_utility_pub.CREATED_BY,
577: hz_utility_pub.CREATION_DATE,
578: hz_utility_pub.LAST_UPDATE_LOGIN,
579: hz_utility_pub.LAST_UPDATE_DATE,
580: hz_utility_pub.LAST_UPDATED_BY
581: );
582:
575: req_id,
576: hz_utility_pub.CREATED_BY,
577: hz_utility_pub.CREATION_DATE,
578: hz_utility_pub.LAST_UPDATE_LOGIN,
579: hz_utility_pub.LAST_UPDATE_DATE,
580: hz_utility_pub.LAST_UPDATED_BY
581: );
582:
583: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
576: hz_utility_pub.CREATED_BY,
577: hz_utility_pub.CREATION_DATE,
578: hz_utility_pub.LAST_UPDATE_LOGIN,
579: hz_utility_pub.LAST_UPDATE_DATE,
580: hz_utility_pub.LAST_UPDATED_BY
581: );
582:
583: END IF; FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
584: UPDATE GMS_DEFAULT_REPORTS yt SET