APPS.AP_ETAX_SERVICES_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 44: p_vendor_site_id IN ap_supplier_sites_all.vendor_site_id%type,

40: l_inv_header_rec2 ap_invoices_all%rowtype; -- For bug 6064593
41:
42: PROCEDURE Cache_Line_Defaults
43: (p_org_id IN ap_invoices_all.org_id%type,
44: p_vendor_site_id IN ap_supplier_sites_all.vendor_site_id%type,
45: p_calling_sequence IN VARCHAR2);
46:
47: FUNCTION CANCEL_INVOICE
48: (p_invoice_id IN NUMBER,

Line 8199: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;

8195: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
8196:
8197: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
8198: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
8199: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
8200: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
8201:
8202: -- Purchase Order Info
8203: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

Line 8280: FROM ap_supplier_sites_all

8276: ----------------------------------------------------------------------
8277: BEGIN
8278: SELECT location_id, ship_to_location_id, fob_lookup_code
8279: INTO l_location_id, l_ship_to_location_id, l_fob_point
8280: FROM ap_supplier_sites_all
8281: WHERE vendor_site_id = P_Invoice_Header_Rec.vendor_site_id;
8282:
8283: EXCEPTION
8284: WHEN no_data_found THEN

Line 11902: FROM ap_supplier_sites_all

11898: ----------------------------------------------------------------------
11899: BEGIN
11900: SELECT location_id, fob_lookup_code
11901: INTO l_location_id, l_fob_point
11902: FROM ap_supplier_sites_all
11903: WHERE vendor_site_id = P_Invoice_Header_Rec.vendor_site_id;
11904:
11905: EXCEPTION
11906: WHEN no_data_found THEN

Line 16849: FROM ap_supplier_sites_all

16845: ----------------------------------------------------------------------
16846: BEGIN
16847: SELECT location_id, fob_lookup_code
16848: INTO l_location_id, l_fob_point
16849: FROM ap_supplier_sites_all
16850: WHERE vendor_site_id = P_Invoice_Header_Rec.vendor_site_id;
16851: END;
16852: ----------------------------------------------------------------------
16853: l_debug_info := 'fob_lookup_code from po_vendor_sites_all '||l_fob_point ||'& '||l_location_id||'& '||P_Invoice_Header_Rec.vendor_site_id;

Line 17922: p_vendor_site_id IN ap_supplier_sites_all.vendor_site_id%type,

17918: END Update_Distributions;
17919:
17920: PROCEDURE Cache_Line_Defaults
17921: (p_org_id IN ap_invoices_all.org_id%type,
17922: p_vendor_site_id IN ap_supplier_sites_all.vendor_site_id%type,
17923: p_calling_sequence IN VARCHAR2) IS
17924:
17925: l_api_name VARCHAR2(30) := 'Cache_Line_Defaults';
17926: l_curr_calling_sequence VARCHAR2(2000);

Line 17989: FROM ap_supplier_sites_all

17985: SELECT location_id
17986: ,fob_lookup_code
17987: INTO AP_ETAX_SERVICES_PKG.g_site_attributes(p_vendor_site_id).location_id
17988: ,AP_ETAX_SERVICES_PKG.g_site_attributes(p_vendor_site_id).fob_lookup_code
17989: FROM ap_supplier_sites_all
17990: WHERE vendor_site_id = p_vendor_site_id;
17991: END IF;
17992:
17993: END IF;

Line 18557: ap_supplier_sites_all aps,

18553: zls.tax_rate, -- tax_rate
18554: null -- tax_code_id
18555: FROM ap_invoices_all ai,
18556: ap_suppliers ap,
18557: ap_supplier_sites_all aps,
18558: zx_lines_summary zls,
18559: ap_invoice_lines_all prepay
18560: WHERE ai.invoice_id = p_invoice_header_rec.invoice_id
18561: AND ai.vendor_id = ap.vendor_id