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 6776: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;

6772: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
6773:
6774: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
6775: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
6776: l_ship_to_location_id ap_supplier_sites_all.ship_to_location_id%type;
6777: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
6778:
6779: -- Purchase Order Info
6780: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;

Line 6841: FROM ap_supplier_sites_all

6837: ----------------------------------------------------------------------
6838: BEGIN
6839: SELECT location_id, ship_to_location_id, fob_lookup_code
6840: INTO l_location_id, l_ship_to_location_id, l_fob_point
6841: FROM ap_supplier_sites_all
6842: WHERE vendor_site_id = P_Invoice_Header_Rec.vendor_site_id;
6843:
6844: EXCEPTION
6845: WHEN no_data_found THEN

Line 9314: FROM ap_supplier_sites_all

9310: ----------------------------------------------------------------------
9311: BEGIN
9312: SELECT location_id, fob_lookup_code
9313: INTO l_location_id, l_fob_point
9314: FROM ap_supplier_sites_all
9315: WHERE vendor_site_id = P_Invoice_Header_Rec.vendor_site_id;
9316:
9317: EXCEPTION
9318: WHEN no_data_found THEN

Line 13215: FROM ap_supplier_sites_all

13211: ----------------------------------------------------------------------
13212: BEGIN
13213: SELECT location_id, fob_lookup_code
13214: INTO l_location_id, l_fob_point
13215: FROM ap_supplier_sites_all
13216: WHERE vendor_site_id = P_Invoice_Header_Rec.vendor_site_id;
13217: END;
13218:
13219: ----------------------------------------------------------------------

Line 14121: p_vendor_site_id IN ap_supplier_sites_all.vendor_site_id%type,

14117: END Update_Distributions;
14118:
14119: PROCEDURE Cache_Line_Defaults
14120: (p_org_id IN ap_invoices_all.org_id%type,
14121: p_vendor_site_id IN ap_supplier_sites_all.vendor_site_id%type,
14122: p_calling_sequence IN VARCHAR2) IS
14123:
14124: l_api_name VARCHAR2(30) := 'Cache_Line_Defaults';
14125: l_curr_calling_sequence VARCHAR2(2000);

Line 14165: FROM ap_supplier_sites_all

14161: SELECT location_id
14162: ,fob_lookup_code
14163: INTO AP_ETAX_SERVICES_PKG.g_site_attributes(p_vendor_site_id).location_id
14164: ,AP_ETAX_SERVICES_PKG.g_site_attributes(p_vendor_site_id).fob_lookup_code
14165: FROM ap_supplier_sites_all
14166: WHERE vendor_site_id = p_vendor_site_id;
14167: END IF;
14168:
14169: END IF;

Line 14726: ap_supplier_sites_all aps,

14722: zls.tax_rate, -- tax_rate
14723: null -- tax_code_id
14724: FROM ap_invoices_all ai,
14725: ap_suppliers ap,
14726: ap_supplier_sites_all aps,
14727: zx_lines_summary zls,
14728: ap_invoice_lines_all prepay
14729: WHERE ai.invoice_id = p_invoice_header_rec.invoice_id
14730: AND ai.vendor_id = ap.vendor_id