374: NUM_COL1_ORIG_LIST(I),
375: NUM_COL1_NEW_LIST(I),
376: 'U',
377: req_id,
378: hz_utility_pub.CREATED_BY,
379: hz_utility_pub.CREATION_DATE,
380: hz_utility_pub.LAST_UPDATE_LOGIN,
381: hz_utility_pub.LAST_UPDATE_DATE,
382: hz_utility_pub.LAST_UPDATED_BY);
375: NUM_COL1_NEW_LIST(I),
376: 'U',
377: req_id,
378: hz_utility_pub.CREATED_BY,
379: hz_utility_pub.CREATION_DATE,
380: hz_utility_pub.LAST_UPDATE_LOGIN,
381: hz_utility_pub.LAST_UPDATE_DATE,
382: hz_utility_pub.LAST_UPDATED_BY);
383:
376: 'U',
377: req_id,
378: hz_utility_pub.CREATED_BY,
379: hz_utility_pub.CREATION_DATE,
380: hz_utility_pub.LAST_UPDATE_LOGIN,
381: hz_utility_pub.LAST_UPDATE_DATE,
382: hz_utility_pub.LAST_UPDATED_BY);
383:
384: END IF;
377: req_id,
378: hz_utility_pub.CREATED_BY,
379: hz_utility_pub.CREATION_DATE,
380: hz_utility_pub.LAST_UPDATE_LOGIN,
381: hz_utility_pub.LAST_UPDATE_DATE,
382: hz_utility_pub.LAST_UPDATED_BY);
383:
384: END IF;
385:
378: hz_utility_pub.CREATED_BY,
379: hz_utility_pub.CREATION_DATE,
380: hz_utility_pub.LAST_UPDATE_LOGIN,
381: hz_utility_pub.LAST_UPDATE_DATE,
382: hz_utility_pub.LAST_UPDATED_BY);
383:
384: END IF;
385:
386: LogMessage(FND_LOG.LEVEL_STATEMENT,'Insertion Completed');
468: NUM_COL2_ORIG_LIST(I),
469: NUM_COL2_NEW_LIST(I),
470: 'U',
471: req_id,
472: hz_utility_pub.CREATED_BY,
473: hz_utility_pub.CREATION_DATE,
474: hz_utility_pub.LAST_UPDATE_LOGIN,
475: hz_utility_pub.LAST_UPDATE_DATE,
476: hz_utility_pub.LAST_UPDATED_BY);
469: NUM_COL2_NEW_LIST(I),
470: 'U',
471: req_id,
472: hz_utility_pub.CREATED_BY,
473: hz_utility_pub.CREATION_DATE,
474: hz_utility_pub.LAST_UPDATE_LOGIN,
475: hz_utility_pub.LAST_UPDATE_DATE,
476: hz_utility_pub.LAST_UPDATED_BY);
477:
470: 'U',
471: req_id,
472: hz_utility_pub.CREATED_BY,
473: hz_utility_pub.CREATION_DATE,
474: hz_utility_pub.LAST_UPDATE_LOGIN,
475: hz_utility_pub.LAST_UPDATE_DATE,
476: hz_utility_pub.LAST_UPDATED_BY);
477:
478: END IF;
471: req_id,
472: hz_utility_pub.CREATED_BY,
473: hz_utility_pub.CREATION_DATE,
474: hz_utility_pub.LAST_UPDATE_LOGIN,
475: hz_utility_pub.LAST_UPDATE_DATE,
476: hz_utility_pub.LAST_UPDATED_BY);
477:
478: END IF;
479:
472: hz_utility_pub.CREATED_BY,
473: hz_utility_pub.CREATION_DATE,
474: hz_utility_pub.LAST_UPDATE_LOGIN,
475: hz_utility_pub.LAST_UPDATE_DATE,
476: hz_utility_pub.LAST_UPDATED_BY);
477:
478: END IF;
479:
480: LogMessage(FND_LOG.LEVEL_STATEMENT,'Insertion of custAcctSites Completed');
639: NUM_COL1_ORIG_LIST(I),
640: NUM_COL1_NEW_LIST(I),
641: 'U',
642: req_id,
643: hz_utility_pub.CREATED_BY,
644: hz_utility_pub.CREATION_DATE,
645: hz_utility_pub.LAST_UPDATE_LOGIN,
646: hz_utility_pub.LAST_UPDATE_DATE,
647: hz_utility_pub.LAST_UPDATED_BY
640: NUM_COL1_NEW_LIST(I),
641: 'U',
642: req_id,
643: hz_utility_pub.CREATED_BY,
644: hz_utility_pub.CREATION_DATE,
645: hz_utility_pub.LAST_UPDATE_LOGIN,
646: hz_utility_pub.LAST_UPDATE_DATE,
647: hz_utility_pub.LAST_UPDATED_BY
648: );
641: 'U',
642: req_id,
643: hz_utility_pub.CREATED_BY,
644: hz_utility_pub.CREATION_DATE,
645: hz_utility_pub.LAST_UPDATE_LOGIN,
646: hz_utility_pub.LAST_UPDATE_DATE,
647: hz_utility_pub.LAST_UPDATED_BY
648: );
649:
642: req_id,
643: hz_utility_pub.CREATED_BY,
644: hz_utility_pub.CREATION_DATE,
645: hz_utility_pub.LAST_UPDATE_LOGIN,
646: hz_utility_pub.LAST_UPDATE_DATE,
647: hz_utility_pub.LAST_UPDATED_BY
648: );
649:
650: END IF;
643: hz_utility_pub.CREATED_BY,
644: hz_utility_pub.CREATION_DATE,
645: hz_utility_pub.LAST_UPDATE_LOGIN,
646: hz_utility_pub.LAST_UPDATE_DATE,
647: hz_utility_pub.LAST_UPDATED_BY
648: );
649:
650: END IF;
651:
734: NUM_COL2_ORIG_LIST(I),
735: NUM_COL2_NEW_LIST(I),
736: 'U',
737: req_id,
738: hz_utility_pub.CREATED_BY,
739: hz_utility_pub.CREATION_DATE,
740: hz_utility_pub.LAST_UPDATE_LOGIN,
741: hz_utility_pub.LAST_UPDATE_DATE,
742: hz_utility_pub.LAST_UPDATED_BY);
735: NUM_COL2_NEW_LIST(I),
736: 'U',
737: req_id,
738: hz_utility_pub.CREATED_BY,
739: hz_utility_pub.CREATION_DATE,
740: hz_utility_pub.LAST_UPDATE_LOGIN,
741: hz_utility_pub.LAST_UPDATE_DATE,
742: hz_utility_pub.LAST_UPDATED_BY);
743:
736: 'U',
737: req_id,
738: hz_utility_pub.CREATED_BY,
739: hz_utility_pub.CREATION_DATE,
740: hz_utility_pub.LAST_UPDATE_LOGIN,
741: hz_utility_pub.LAST_UPDATE_DATE,
742: hz_utility_pub.LAST_UPDATED_BY);
743:
744: END IF;
737: req_id,
738: hz_utility_pub.CREATED_BY,
739: hz_utility_pub.CREATION_DATE,
740: hz_utility_pub.LAST_UPDATE_LOGIN,
741: hz_utility_pub.LAST_UPDATE_DATE,
742: hz_utility_pub.LAST_UPDATED_BY);
743:
744: END IF;
745:
738: hz_utility_pub.CREATED_BY,
739: hz_utility_pub.CREATION_DATE,
740: hz_utility_pub.LAST_UPDATE_LOGIN,
741: hz_utility_pub.LAST_UPDATE_DATE,
742: hz_utility_pub.LAST_UPDATED_BY);
743:
744: END IF;
745:
746: LogMessage(FND_LOG.LEVEL_STATEMENT,'Insertion of custAcctSites Completed');