DBA Data[Home] [Help]

APPS.POP_CMERGE_REQ dependencies on HZ_UTILITY_PUB

Line 235: hz_utility_pub.CREATED_BY,

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);

Line 236: hz_utility_pub.CREATION_DATE,

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;

Line 237: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 238: hz_utility_pub.LAST_UPDATE_DATE,

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: /*

Line 239: hz_utility_pub.LAST_UPDATED_BY);

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

Line 715: hz_utility_pub.CREATED_BY,

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);

Line 716: hz_utility_pub.CREATION_DATE,

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;

Line 717: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 718: hz_utility_pub.LAST_UPDATE_DATE,

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: /*

Line 719: hz_utility_pub.LAST_UPDATED_BY);

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

Line 856: hz_utility_pub.CREATED_BY,

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);

Line 857: hz_utility_pub.CREATION_DATE,

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;

Line 858: hz_utility_pub.LAST_UPDATE_LOGIN,

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:

Line 859: hz_utility_pub.LAST_UPDATE_DATE,

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: /*

Line 860: hz_utility_pub.LAST_UPDATED_BY);

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