APPS.POS_MERGE_SUPPLIER_PKG dependencies on HZ_UTILITY_PUB

Line 161: last_update_date = hz_utility_pub.last_update_date,

157:
158: /* Set the status to MERGED */
159: UPDATE pos_bus_class_attr
160: SET status = 'M',
161: last_update_date = hz_utility_pub.last_update_date,
162: last_updated_by = hz_utility_pub.user_id,
163: last_update_login = hz_utility_pub.last_update_login
164: WHERE party_id = p_from_fk_id
165: AND classification_id = p_from_id;

Line 162: last_updated_by = hz_utility_pub.user_id,

158: /* Set the status to MERGED */
159: UPDATE pos_bus_class_attr
160: SET status = 'M',
161: last_update_date = hz_utility_pub.last_update_date,
162: last_updated_by = hz_utility_pub.user_id,
163: last_update_login = hz_utility_pub.last_update_login
164: WHERE party_id = p_from_fk_id
165: AND classification_id = p_from_id;
166:

Line 163: last_update_login = hz_utility_pub.last_update_login

159: UPDATE pos_bus_class_attr
160: SET status = 'M',
161: last_update_date = hz_utility_pub.last_update_date,
162: last_updated_by = hz_utility_pub.user_id,
163: last_update_login = hz_utility_pub.last_update_login
164: WHERE party_id = p_from_fk_id
165: AND classification_id = p_from_id;
166:
167: fnd_file.put_line(fnd_file.log, 'Rowcount: ' || SQL%ROWCOUNT);

Line 584: last_updated_by = hz_utility_pub.user_id,

580: /* Set the status to MERGED */
581: UPDATE pos_sup_products_services
582: SET status = 'M',
583: last_update_date = SYSDATE,
584: last_updated_by = hz_utility_pub.user_id,
585: last_update_login = hz_utility_pub.last_update_login
586: WHERE vendor_id = l_from_vendor_id
587: AND classification_id = p_from_id;
588:

Line 585: last_update_login = hz_utility_pub.last_update_login

581: UPDATE pos_sup_products_services
582: SET status = 'M',
583: last_update_date = SYSDATE,
584: last_updated_by = hz_utility_pub.user_id,
585: last_update_login = hz_utility_pub.last_update_login
586: WHERE vendor_id = l_from_vendor_id
587: AND classification_id = p_from_id;
588:
589: DELETE FROM pos_supplier_mappings a