DBA Data[Home] [Help]

APPS.AP_PAY_SINGLE_INVOICE_PKG dependencies on AP_SUPPLIERS

Line 91: l_hold_all_payments_flag ap_suppliers.hold_all_payments_flag%TYPE;

87: l_name VARCHAR2(80);
88: l_dummy_rowid VARCHAR2(18);
89: l_seq_num_profile VARCHAR2(80);
90:
91: l_hold_all_payments_flag ap_suppliers.hold_all_payments_flag%TYPE;
92: l_active_pay_sites ap_supplier_sites_all.pay_site_flag%TYPE;
93: l_accounting_event_id NUMBER(38);
94: l_quick_check_id AP_CHECKS.checkrun_name%type;
95: l_next_check_number AP_CHECKS.check_number%type;

Line 135: l_vendor_type_lookup_code ap_suppliers.vendor_type_lookup_code%TYPE;

131: l_payment_document_id ce_payment_documents.payment_document_id %TYPE;
132: l_bills_payable iby_payment_methods_vl.support_bills_payable_flag%TYPE;
133: l_maturity_date_offset_days iby_payment_methods_vl.maturity_date_offset_days%TYPE;
134: l_maturity_date ap_checks.future_pay_due_date%TYPE;
135: l_vendor_type_lookup_code ap_suppliers.vendor_type_lookup_code%TYPE;
136:
137: l_return_status VARCHAR2(100);
138: l_return_message VARCHAR2(3000);
139: l_msg_count NUMBER;

Line 197: ,Vendor_Id AP_SUPPLIERS.Vendor_ID%TYPE

193: ,State HZ_LOCATIONS.State%TYPE
194: ,Address_Line4 HZ_LOCATIONS.Address4%TYPE
195: ,County HZ_LOCATIONS.Country%TYPE
196: ,Address_Style HZ_LOCATIONS.Address_Style%TYPE
197: ,Vendor_Id AP_SUPPLIERS.Vendor_ID%TYPE
198: ,Vendor_Site_Id AP_SUPPLIER_SITES_ALL.Vendor_Site_ID%TYPE
199: ,Pay_Site_Flag AP_SUPPLIER_SITES_ALL.Pay_Site_Flag%TYPE
200: ,Primary_Pay_Site AP_SUPPLIER_SITES_ALL.Primary_Pay_Site_Flag%TYPE
201: );

Line 205: Auto_calc_int_flag AP_SUPPLIERS.Auto_calculate_interest_flag%TYPE

201: );
202:
203: TYPE r_vendor_info IS RECORD
204: (
205: Auto_calc_int_flag AP_SUPPLIERS.Auto_calculate_interest_flag%TYPE
206: ,Vendor_name AP_SUPPLIERS.Vendor_name%TYPE
207: );
208:
209:

Line 206: ,Vendor_name AP_SUPPLIERS.Vendor_name%TYPE

202:
203: TYPE r_vendor_info IS RECORD
204: (
205: Auto_calc_int_flag AP_SUPPLIERS.Auto_calculate_interest_flag%TYPE
206: ,Vendor_name AP_SUPPLIERS.Vendor_name%TYPE
207: );
208:
209:
210: TYPE r_apinv_info IS RECORD

Line 613: FROM ap_suppliers asup,

609: asup.vendor_type_lookup_code
610: INTO l_hold_all_payments_flag,
611: l_active_pay_sites,
612: l_vendor_type_lookup_code
613: FROM ap_suppliers asup,
614: ap_supplier_sites_all assp
615: WHERE asup.vendor_id = l_inv_rec.vendor_id
616: AND asup.vendor_id = assp.vendor_id
617: AND assp.vendor_site_id = l_inv_rec.vendor_site_id;

Line 943: FROM ap_suppliers asup,

939: SELECT asup.auto_calculate_interest_flag,
940: hp.party_name
941: INTO l_vendor_rec.Auto_calc_int_flag,
942: l_vendor_rec.Vendor_name
943: FROM ap_suppliers asup,
944: hz_parties hp
945: WHERE asup.vendor_id = l_inv_rec.vendor_id
946: AND asup.party_id = hp.party_id;
947: