166: NUM_COL1_ORIG_LIST(I),
167: NUM_COL1_NEW_LIST(I),
168: 'U',
169: p_request_id,
170: hz_utility_pub.CREATED_BY,
171: hz_utility_pub.CREATION_DATE,
172: hz_utility_pub.LAST_UPDATE_LOGIN,
173: hz_utility_pub.LAST_UPDATE_DATE,
174: hz_utility_pub.LAST_UPDATED_BY
167: NUM_COL1_NEW_LIST(I),
168: 'U',
169: p_request_id,
170: hz_utility_pub.CREATED_BY,
171: hz_utility_pub.CREATION_DATE,
172: hz_utility_pub.LAST_UPDATE_LOGIN,
173: hz_utility_pub.LAST_UPDATE_DATE,
174: hz_utility_pub.LAST_UPDATED_BY
175: );
168: 'U',
169: p_request_id,
170: hz_utility_pub.CREATED_BY,
171: hz_utility_pub.CREATION_DATE,
172: hz_utility_pub.LAST_UPDATE_LOGIN,
173: hz_utility_pub.LAST_UPDATE_DATE,
174: hz_utility_pub.LAST_UPDATED_BY
175: );
176:
169: p_request_id,
170: hz_utility_pub.CREATED_BY,
171: hz_utility_pub.CREATION_DATE,
172: hz_utility_pub.LAST_UPDATE_LOGIN,
173: hz_utility_pub.LAST_UPDATE_DATE,
174: hz_utility_pub.LAST_UPDATED_BY
175: );
176:
177: END IF;
170: hz_utility_pub.CREATED_BY,
171: hz_utility_pub.CREATION_DATE,
172: hz_utility_pub.LAST_UPDATE_LOGIN,
173: hz_utility_pub.LAST_UPDATE_DATE,
174: hz_utility_pub.LAST_UPDATED_BY
175: );
176:
177: END IF;
178:
305: NUM_COL2_ORIG_LIST(I),
306: NUM_COL2_NEW_LIST(I),
307: 'U',
308: p_request_id,
309: hz_utility_pub.CREATED_BY,
310: hz_utility_pub.CREATION_DATE,
311: hz_utility_pub.LAST_UPDATE_LOGIN,
312: hz_utility_pub.LAST_UPDATE_DATE,
313: hz_utility_pub.LAST_UPDATED_BY
306: NUM_COL2_NEW_LIST(I),
307: 'U',
308: p_request_id,
309: hz_utility_pub.CREATED_BY,
310: hz_utility_pub.CREATION_DATE,
311: hz_utility_pub.LAST_UPDATE_LOGIN,
312: hz_utility_pub.LAST_UPDATE_DATE,
313: hz_utility_pub.LAST_UPDATED_BY
314: );
307: 'U',
308: p_request_id,
309: hz_utility_pub.CREATED_BY,
310: hz_utility_pub.CREATION_DATE,
311: hz_utility_pub.LAST_UPDATE_LOGIN,
312: hz_utility_pub.LAST_UPDATE_DATE,
313: hz_utility_pub.LAST_UPDATED_BY
314: );
315:
308: p_request_id,
309: hz_utility_pub.CREATED_BY,
310: hz_utility_pub.CREATION_DATE,
311: hz_utility_pub.LAST_UPDATE_LOGIN,
312: hz_utility_pub.LAST_UPDATE_DATE,
313: hz_utility_pub.LAST_UPDATED_BY
314: );
315:
316: END IF;
309: hz_utility_pub.CREATED_BY,
310: hz_utility_pub.CREATION_DATE,
311: hz_utility_pub.LAST_UPDATE_LOGIN,
312: hz_utility_pub.LAST_UPDATE_DATE,
313: hz_utility_pub.LAST_UPDATED_BY
314: );
315:
316: END IF;
317:
451: VCHAR_COL1_ORIG_LIST(I),
452: VCHAR_COL1_NEW_LIST(I),
453: 'U',
454: p_request_id,
455: hz_utility_pub.CREATED_BY,
456: hz_utility_pub.CREATION_DATE,
457: hz_utility_pub.LAST_UPDATE_LOGIN,
458: hz_utility_pub.LAST_UPDATE_DATE,
459: hz_utility_pub.LAST_UPDATED_BY
452: VCHAR_COL1_NEW_LIST(I),
453: 'U',
454: p_request_id,
455: hz_utility_pub.CREATED_BY,
456: hz_utility_pub.CREATION_DATE,
457: hz_utility_pub.LAST_UPDATE_LOGIN,
458: hz_utility_pub.LAST_UPDATE_DATE,
459: hz_utility_pub.LAST_UPDATED_BY
460: );
453: 'U',
454: p_request_id,
455: hz_utility_pub.CREATED_BY,
456: hz_utility_pub.CREATION_DATE,
457: hz_utility_pub.LAST_UPDATE_LOGIN,
458: hz_utility_pub.LAST_UPDATE_DATE,
459: hz_utility_pub.LAST_UPDATED_BY
460: );
461:
454: p_request_id,
455: hz_utility_pub.CREATED_BY,
456: hz_utility_pub.CREATION_DATE,
457: hz_utility_pub.LAST_UPDATE_LOGIN,
458: hz_utility_pub.LAST_UPDATE_DATE,
459: hz_utility_pub.LAST_UPDATED_BY
460: );
461:
462: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
455: hz_utility_pub.CREATED_BY,
456: hz_utility_pub.CREATION_DATE,
457: hz_utility_pub.LAST_UPDATE_LOGIN,
458: hz_utility_pub.LAST_UPDATE_DATE,
459: hz_utility_pub.LAST_UPDATED_BY
460: );
461:
462: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
463: -- Log account number
483: VCHAR_CN_ORIG_LIST(I),
484: VCHAR_CN_NEW_LIST(I),
485: 'U',
486: p_request_id,
487: hz_utility_pub.CREATED_BY,
488: hz_utility_pub.CREATION_DATE,
489: hz_utility_pub.LAST_UPDATE_LOGIN,
490: hz_utility_pub.LAST_UPDATE_DATE,
491: hz_utility_pub.LAST_UPDATED_BY
484: VCHAR_CN_NEW_LIST(I),
485: 'U',
486: p_request_id,
487: hz_utility_pub.CREATED_BY,
488: hz_utility_pub.CREATION_DATE,
489: hz_utility_pub.LAST_UPDATE_LOGIN,
490: hz_utility_pub.LAST_UPDATE_DATE,
491: hz_utility_pub.LAST_UPDATED_BY
492: );
485: 'U',
486: p_request_id,
487: hz_utility_pub.CREATED_BY,
488: hz_utility_pub.CREATION_DATE,
489: hz_utility_pub.LAST_UPDATE_LOGIN,
490: hz_utility_pub.LAST_UPDATE_DATE,
491: hz_utility_pub.LAST_UPDATED_BY
492: );
493: END IF;
486: p_request_id,
487: hz_utility_pub.CREATED_BY,
488: hz_utility_pub.CREATION_DATE,
489: hz_utility_pub.LAST_UPDATE_LOGIN,
490: hz_utility_pub.LAST_UPDATE_DATE,
491: hz_utility_pub.LAST_UPDATED_BY
492: );
493: END IF;
494:
487: hz_utility_pub.CREATED_BY,
488: hz_utility_pub.CREATION_DATE,
489: hz_utility_pub.LAST_UPDATE_LOGIN,
490: hz_utility_pub.LAST_UPDATE_DATE,
491: hz_utility_pub.LAST_UPDATED_BY
492: );
493: END IF;
494:
495: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT