APPS.POS_AP_SUPPLIER_BO_PKG dependencies on AP_SUPPLIERS

Line 240: FROM ap_suppliers

236: NULL,
237: NULL,
238: 'SUPP_LEVEL'))
239: INTO l_pos_ap_supplier_bo
240: FROM ap_suppliers
241: WHERE party_id = l_party_id;
242: x_ap_suplier_bo := l_pos_ap_supplier_bo;
243: x_ap_suplier_bo.p_pos_supp_uda_obj_tbl := pos_supplier_uda_bo_pkg.get_uda_for_supplier_site(l_party_id,
244: NULL,

Line 301: l_orig_sys_reference_rec.created_by_module := 'AP_SUPPLIERS_API';

297: l_orig_sys_reference_rec.orig_system := p_orig_system;
298: l_orig_sys_reference_rec.orig_system_reference := p_orig_system_reference;
299: l_orig_sys_reference_rec.owner_table_name := 'HZ_PARTIES';
300: l_orig_sys_reference_rec.owner_table_id := p_party_id;
301: l_orig_sys_reference_rec.created_by_module := 'AP_SUPPLIERS_API';
302:
303: hz_orig_system_ref_pub.create_orig_system_reference(fnd_api.g_false,
304: l_orig_sys_reference_rec,
305: l_return_status,

Line 572: FROM ap_suppliers

568: p_pos_ap_supplier_bo.vendor_id = 0 THEN
569: BEGIN
570: SELECT vendor_id
571: INTO l_vendor_id
572: FROM ap_suppliers
573: WHERE party_id = l_party_id;
574: l_ap_suplier_bo.vendor_id := l_vendor_id;
575: EXCEPTION
576: WHEN no_data_found THEN

Line 637: -- Customer Check in ap_suppliers table

633: AND hr.orig_system = p_orig_system
634: AND hr.orig_system_reference = p_orig_system_reference
635: AND nvl(hr.end_date_active, SYSDATE) >= SYSDATE;
636:
637: -- Customer Check in ap_suppliers table
638: IF l_party_id <> -9999 THEN
639: SELECT nvl(party_id, -9999)
640: INTO l_party_id_supp
641: FROM ap_suppliers

Line 641: FROM ap_suppliers

637: -- Customer Check in ap_suppliers table
638: IF l_party_id <> -9999 THEN
639: SELECT nvl(party_id, -9999)
640: INTO l_party_id_supp
641: FROM ap_suppliers
642: WHERE party_id = l_party_id;
643: ELSE
644: l_party_id_supp := -9999;
645: END IF;

Line 693: FROM ap_suppliers

689: p_orig_system_reference);
690:
691: SELECT vendor_id
692: INTO l_vendor_id
693: FROM ap_suppliers
694: WHERE party_id = l_party_id;
695:
696: l_ext_payee_rec.payee_party_id := l_party_id;
697: l_ext_payee_rec.payment_function := p_pos_external_payee_bo.payment_function;