DBA Data[Home] [Help]

APPS.AP_WEB_EXPORT_ER dependencies on AP_SUPPLIERS

Line 29: vendor_id ap_suppliers.vendor_id%TYPE,

25: postal_code hr_locations.postal_code%TYPE,
26: province hr_locations.region_1%TYPE,
27: county hr_locations.region_1%TYPE,
28: country hr_locations.country%TYPE,
29: vendor_id ap_suppliers.vendor_id%TYPE,
30: header_vendor_id ap_expense_report_headers.vendor_id%TYPE,
31: --hold_lookup_code ap_expense_report_headers.hold_lookup_code%TYPE,
32: --nls_hold_code ap_lookup_codes.displayed_field%TYPE,
33: --hold_description ap_lookup_codes.description%TYPE,

Line 112: payment_method_code ap_suppliers.payment_method_lookup_code%TYPE);

108: invoice_type_lookup_code ap_invoices_interface.invoice_type_lookup_code%TYPE,
109: gl_date ap_invoices_interface.gl_date%TYPE,
110: alternate_name per_all_people_f.full_name%TYPE,
111: amount_app_to_discount ap_invoices_interface.amount_applicable_to_discount%TYPE,
112: payment_method_code ap_suppliers.payment_method_lookup_code%TYPE);
113:
114: -----------------------------------------------------------------------
115: -- Table Types for Expense Lines
116: -----------------------------------------------------------------------

Line 221: vendor_id ap_suppliers.vendor_id%TYPE,

217:
218: TYPE InvoiceLinesRecTabType is TABLE of InvoiceLinesInfoRecType index by BINARY_INTEGER;
219:
220: TYPE VendorInfoRecType IS RECORD(
221: vendor_id ap_suppliers.vendor_id%TYPE,
222: vendor_site_id ap_supplier_sites.vendor_site_id%TYPE,
223: employee_id ap_expense_report_headers.employee_id%TYPE,
224: party_id ap_suppliers.party_id%TYPE,
225: party_site_id ap_supplier_sites.party_site_id%TYPE,

Line 224: party_id ap_suppliers.party_id%TYPE,

220: TYPE VendorInfoRecType IS RECORD(
221: vendor_id ap_suppliers.vendor_id%TYPE,
222: vendor_site_id ap_supplier_sites.vendor_site_id%TYPE,
223: employee_id ap_expense_report_headers.employee_id%TYPE,
224: party_id ap_suppliers.party_id%TYPE,
225: party_site_id ap_supplier_sites.party_site_id%TYPE,
226: home_or_office VARCHAR2(2),
227: terms_date_basis ap_suppliers.terms_date_basis%TYPE,
228: terms_id ap_suppliers.terms_id%TYPE,

Line 227: terms_date_basis ap_suppliers.terms_date_basis%TYPE,

223: employee_id ap_expense_report_headers.employee_id%TYPE,
224: party_id ap_suppliers.party_id%TYPE,
225: party_site_id ap_supplier_sites.party_site_id%TYPE,
226: home_or_office VARCHAR2(2),
227: terms_date_basis ap_suppliers.terms_date_basis%TYPE,
228: terms_id ap_suppliers.terms_id%TYPE,
229: pay_group ap_suppliers.pay_group_lookup_code%TYPE,
230: payment_priority ap_suppliers.payment_priority%TYPE,
231: liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE,

Line 228: terms_id ap_suppliers.terms_id%TYPE,

224: party_id ap_suppliers.party_id%TYPE,
225: party_site_id ap_supplier_sites.party_site_id%TYPE,
226: home_or_office VARCHAR2(2),
227: terms_date_basis ap_suppliers.terms_date_basis%TYPE,
228: terms_id ap_suppliers.terms_id%TYPE,
229: pay_group ap_suppliers.pay_group_lookup_code%TYPE,
230: payment_priority ap_suppliers.payment_priority%TYPE,
231: liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE,
232: prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE,

Line 229: pay_group ap_suppliers.pay_group_lookup_code%TYPE,

225: party_site_id ap_supplier_sites.party_site_id%TYPE,
226: home_or_office VARCHAR2(2),
227: terms_date_basis ap_suppliers.terms_date_basis%TYPE,
228: terms_id ap_suppliers.terms_id%TYPE,
229: pay_group ap_suppliers.pay_group_lookup_code%TYPE,
230: payment_priority ap_suppliers.payment_priority%TYPE,
231: liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE,
232: prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE,
233: always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE,

Line 230: payment_priority ap_suppliers.payment_priority%TYPE,

226: home_or_office VARCHAR2(2),
227: terms_date_basis ap_suppliers.terms_date_basis%TYPE,
228: terms_id ap_suppliers.terms_id%TYPE,
229: pay_group ap_suppliers.pay_group_lookup_code%TYPE,
230: payment_priority ap_suppliers.payment_priority%TYPE,
231: liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE,
232: prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE,
233: always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE,
234: pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE,

Line 231: liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE,

227: terms_date_basis ap_suppliers.terms_date_basis%TYPE,
228: terms_id ap_suppliers.terms_id%TYPE,
229: pay_group ap_suppliers.pay_group_lookup_code%TYPE,
230: payment_priority ap_suppliers.payment_priority%TYPE,
231: liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE,
232: prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE,
233: always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE,
234: pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE,
235: vendor_name ap_suppliers.vendor_name%TYPE,

Line 232: prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE,

228: terms_id ap_suppliers.terms_id%TYPE,
229: pay_group ap_suppliers.pay_group_lookup_code%TYPE,
230: payment_priority ap_suppliers.payment_priority%TYPE,
231: liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE,
232: prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE,
233: always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE,
234: pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE,
235: vendor_name ap_suppliers.vendor_name%TYPE,
236: vendor_num ap_suppliers.segment1%TYPE,

Line 233: always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE,

229: pay_group ap_suppliers.pay_group_lookup_code%TYPE,
230: payment_priority ap_suppliers.payment_priority%TYPE,
231: liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE,
232: prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE,
233: always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE,
234: pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE,
235: vendor_name ap_suppliers.vendor_name%TYPE,
236: vendor_num ap_suppliers.segment1%TYPE,
237: allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE,

Line 234: pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE,

230: payment_priority ap_suppliers.payment_priority%TYPE,
231: liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE,
232: prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE,
233: always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE,
234: pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE,
235: vendor_name ap_suppliers.vendor_name%TYPE,
236: vendor_num ap_suppliers.segment1%TYPE,
237: allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE,
238: org_id ap_expense_report_headers.org_id%TYPE,

Line 235: vendor_name ap_suppliers.vendor_name%TYPE,

231: liab_acc ap_suppliers.accts_pay_code_combination_id%TYPE,
232: prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE,
233: always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE,
234: pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE,
235: vendor_name ap_suppliers.vendor_name%TYPE,
236: vendor_num ap_suppliers.segment1%TYPE,
237: allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE,
238: org_id ap_expense_report_headers.org_id%TYPE,
239: address_line_1 hr_locations.address_line_1%TYPE,

Line 236: vendor_num ap_suppliers.segment1%TYPE,

232: prepay_ccid ap_suppliers.prepay_code_combination_id%TYPE,
233: always_take_disc_flag ap_suppliers.always_take_disc_flag%TYPE,
234: pay_date_basis ap_suppliers.pay_date_basis_lookup_code%TYPE,
235: vendor_name ap_suppliers.vendor_name%TYPE,
236: vendor_num ap_suppliers.segment1%TYPE,
237: allow_awt_flag ap_supplier_sites.allow_awt_flag%TYPE,
238: org_id ap_expense_report_headers.org_id%TYPE,
239: address_line_1 hr_locations.address_line_1%TYPE,
240: address_line_2 hr_locations.address_line_2%TYPE,

Line 290: FUNCTION CreatePayee(p_party_id IN ap_suppliers.party_id%TYPE,

286: ------------------------------------------------------------------------
287: FUNCTION GetVendorinfo(p_vendor_rec IN OUT NOCOPY VendorInfoRecType,
288: p_reject_code OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
289: ------------------------------------------------------------------------
290: FUNCTION CreatePayee(p_party_id IN ap_suppliers.party_id%TYPE,
291: p_org_id IN ap_expense_report_headers.org_id%TYPE,
292: p_reject_code OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
293: ------------------------------------------------------------------------
294: