APPS.POS_PRODUCT_SERVICE_BO_PKG dependencies on POS_SUP_PRODUCTS_SERVICES

Line 233: FROM pos_sup_products_services ps,

229: ps.last_updated_by,
230: ps.last_update_date,
231: ps.last_update_login) BULK COLLECT
232: INTO l_pos_product_service_bo_tbl
233: FROM pos_sup_products_services ps,
234: ap_suppliers ap
235: WHERE ap.party_id = l_party_id
236: AND ps.vendor_id = ap.vendor_id;
237:

Line 394: -- pos_sup_products_services table

390: l_req_id := pos_product_service_utl_pkg.get_requestid(x_segment_code => l_segment_code,
391: x_mapp_id => l_mapping_id);
392:
393: -- Using the request_id make a call to the following Api to approve the data and insert it into the
394: -- pos_sup_products_services table
395: pos_profile_change_request_pkg.approve_ps_req(p_request_id => l_req_id,
396: x_return_status => l_return_status,
397: x_msg_count => l_msg_count,
398: x_msg_data => l_msg_data);

Line 450: UPDATE pos_sup_products_services

446: x_msg_count OUT NOCOPY NUMBER,
447: x_msg_data OUT NOCOPY VARCHAR2) IS
448: BEGIN
449:
450: UPDATE pos_sup_products_services
451: SET status = p_status,
452: last_updated_by = fnd_global.user_id,
453: last_update_date = SYSDATE,
454: last_update_login = fnd_global.login_id