231: NUM_COL1_ORIG_LIST(I),
232: NUM_COL1_NEW_LIST(I),
233: 'U',
234: req_id,
235: hz_utility_pub.CREATED_BY,
236: hz_utility_pub.CREATION_DATE,
237: hz_utility_pub.LAST_UPDATE_LOGIN,
238: hz_utility_pub.LAST_UPDATE_DATE,
239: hz_utility_pub.LAST_UPDATED_BY);
232: NUM_COL1_NEW_LIST(I),
233: 'U',
234: req_id,
235: hz_utility_pub.CREATED_BY,
236: hz_utility_pub.CREATION_DATE,
237: hz_utility_pub.LAST_UPDATE_LOGIN,
238: hz_utility_pub.LAST_UPDATE_DATE,
239: hz_utility_pub.LAST_UPDATED_BY);
240: END IF;
233: 'U',
234: req_id,
235: hz_utility_pub.CREATED_BY,
236: hz_utility_pub.CREATION_DATE,
237: hz_utility_pub.LAST_UPDATE_LOGIN,
238: hz_utility_pub.LAST_UPDATE_DATE,
239: hz_utility_pub.LAST_UPDATED_BY);
240: END IF;
241:
234: req_id,
235: hz_utility_pub.CREATED_BY,
236: hz_utility_pub.CREATION_DATE,
237: hz_utility_pub.LAST_UPDATE_LOGIN,
238: hz_utility_pub.LAST_UPDATE_DATE,
239: hz_utility_pub.LAST_UPDATED_BY);
240: END IF;
241:
242: /*
235: hz_utility_pub.CREATED_BY,
236: hz_utility_pub.CREATION_DATE,
237: hz_utility_pub.LAST_UPDATE_LOGIN,
238: hz_utility_pub.LAST_UPDATE_DATE,
239: hz_utility_pub.LAST_UPDATED_BY);
240: END IF;
241:
242: /*
243: Update all corresponding deliver_to_location_id of
711: VCHAR_COL16_ORIG_LIST(I),
712: VCHAR_COL17_ORIG_LIST(I),
713: 'D',
714: req_id,
715: hz_utility_pub.CREATED_BY,
716: hz_utility_pub.CREATION_DATE,
717: hz_utility_pub.LAST_UPDATE_LOGIN,
718: hz_utility_pub.LAST_UPDATE_DATE,
719: hz_utility_pub.LAST_UPDATED_BY);
712: VCHAR_COL17_ORIG_LIST(I),
713: 'D',
714: req_id,
715: hz_utility_pub.CREATED_BY,
716: hz_utility_pub.CREATION_DATE,
717: hz_utility_pub.LAST_UPDATE_LOGIN,
718: hz_utility_pub.LAST_UPDATE_DATE,
719: hz_utility_pub.LAST_UPDATED_BY);
720: END IF;
713: 'D',
714: req_id,
715: hz_utility_pub.CREATED_BY,
716: hz_utility_pub.CREATION_DATE,
717: hz_utility_pub.LAST_UPDATE_LOGIN,
718: hz_utility_pub.LAST_UPDATE_DATE,
719: hz_utility_pub.LAST_UPDATED_BY);
720: END IF;
721:
714: req_id,
715: hz_utility_pub.CREATED_BY,
716: hz_utility_pub.CREATION_DATE,
717: hz_utility_pub.LAST_UPDATE_LOGIN,
718: hz_utility_pub.LAST_UPDATE_DATE,
719: hz_utility_pub.LAST_UPDATED_BY);
720: END IF;
721:
722: /*
715: hz_utility_pub.CREATED_BY,
716: hz_utility_pub.CREATION_DATE,
717: hz_utility_pub.LAST_UPDATE_LOGIN,
718: hz_utility_pub.LAST_UPDATE_DATE,
719: hz_utility_pub.LAST_UPDATED_BY);
720: END IF;
721:
722: /*
723: Delete all old or redundant records from the affected
852: NUM_COL2_ORIG_LIST(I),
853: NUM_COL2_NEW_LIST(I),
854: 'U',
855: req_id,
856: hz_utility_pub.CREATED_BY,
857: hz_utility_pub.CREATION_DATE,
858: hz_utility_pub.LAST_UPDATE_LOGIN,
859: hz_utility_pub.LAST_UPDATE_DATE,
860: hz_utility_pub.LAST_UPDATED_BY);
853: NUM_COL2_NEW_LIST(I),
854: 'U',
855: req_id,
856: hz_utility_pub.CREATED_BY,
857: hz_utility_pub.CREATION_DATE,
858: hz_utility_pub.LAST_UPDATE_LOGIN,
859: hz_utility_pub.LAST_UPDATE_DATE,
860: hz_utility_pub.LAST_UPDATED_BY);
861: END IF;
854: 'U',
855: req_id,
856: hz_utility_pub.CREATED_BY,
857: hz_utility_pub.CREATION_DATE,
858: hz_utility_pub.LAST_UPDATE_LOGIN,
859: hz_utility_pub.LAST_UPDATE_DATE,
860: hz_utility_pub.LAST_UPDATED_BY);
861: END IF;
862:
855: req_id,
856: hz_utility_pub.CREATED_BY,
857: hz_utility_pub.CREATION_DATE,
858: hz_utility_pub.LAST_UPDATE_LOGIN,
859: hz_utility_pub.LAST_UPDATE_DATE,
860: hz_utility_pub.LAST_UPDATED_BY);
861: END IF;
862:
863: /*
856: hz_utility_pub.CREATED_BY,
857: hz_utility_pub.CREATION_DATE,
858: hz_utility_pub.LAST_UPDATE_LOGIN,
859: hz_utility_pub.LAST_UPDATE_DATE,
860: hz_utility_pub.LAST_UPDATED_BY);
861: END IF;
862:
863: /*
864: Update all corresponding customer_id and site_use_id