APPS.AP_ETAX_SERVICES_PKG dependencies on AP_INVOICE_LINES_INTERFACE

Line 6733: | existing in the ap_invoice_lines_interface table

6729: |
6730: | PARAMETERS
6731: | P_Invoice_Header_Rec - record with invoice header information
6732: | P_Invoice_Lines_Tab - List of trx and tax lines for the invoice
6733: | existing in the ap_invoice_lines_interface table
6734: | P_Calling_Mode - calling mode. it is used to
6735: | P_Event_Class_Code - Event class code for document
6736: | P_error_code - Error code to be returned
6737: | P_calling_sequence - Calling sequence

Line 6774: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;

6770: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
6771: l_uom_code mtl_units_of_measure.uom_code%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:

Line 7296: FROM ap_invoice_lines_interface aili

7292: p_inv_line_list(i).line_number, -- summary_tax_line_number
7293: AP_UTILITIES_PKG.ap_round_currency(
7294: p_inv_line_list(i).amount*aili.amount/l_prorating_total,
7295: P_Invoice_Header_Rec.invoice_currency_code) -- line_amt
7296: FROM ap_invoice_lines_interface aili
7297: WHERE aili.invoice_id = P_Invoice_Header_Rec.invoice_id
7298: AND aili.line_number <> p_inv_line_list(i).line_number
7299: AND aili.line_type_lookup_code <> 'TAX'
7300: AND NVL(aili.taxable_flag, 'N') = 'Y';

Line 7323: FROM ap_invoice_lines_interface aili

7319: WHERE trx_id = P_Invoice_Header_Rec.invoice_id
7320: AND trx_line_id <> p_inv_line_list(i).line_number
7321: AND trx_line_id =
7322: (SELECT (MAX(aili.line_number))
7323: FROM ap_invoice_lines_interface aili
7324: WHERE aili.invoice_id = P_Invoice_Header_Rec.invoice_id
7325: AND aili.line_number <> p_inv_line_list(i).line_number
7326: AND aili.amount <> 0
7327: AND aili.line_type_lookup_code <> 'TAX'

Line 7331: FROM ap_invoice_lines_interface ail2

7327: AND aili.line_type_lookup_code <> 'TAX'
7328: AND NVL(aili.taxable_flag, 'N') = 'Y'
7329: AND ABS(aili.amount) >=
7330: ( SELECT MAX(ABS(ail2.amount))
7331: FROM ap_invoice_lines_interface ail2
7332: WHERE ail2.invoice_id = aili.invoice_id
7333: AND ail2.line_number <> p_inv_line_list(i).line_number
7334: AND ail2.line_number <> aili.line_number
7335: AND ail2.line_type_lookup_code <> 'TAX'

Line 7358: FROM ap_invoice_lines_interface

7354: l_debug_info := 'Step 17: Get prorated total';
7355: --------------------------------------------------------------
7356: SELECT SUM(NVL(amount, 0))
7357: INTO l_prorating_total
7358: FROM ap_invoice_lines_interface
7359: WHERE invoice_id = P_Invoice_Header_Rec.invoice_id
7360: AND line_number <> p_inv_line_list(i).line_number
7361: AND line_type_lookup_code <> 'TAX' --Bug6608702**
7362: AND line_group_number = p_inv_line_list(i).line_group_number;

Line 7388: FROM ap_invoice_lines_interface aili

7384: p_inv_line_list(i).line_number, -- summary_tax_line_number
7385: AP_UTILITIES_PKG.ap_round_currency(
7386: p_inv_line_list(i).amount*aili.amount/l_prorating_total,
7387: P_Invoice_Header_Rec.invoice_currency_code) -- line_amt
7388: FROM ap_invoice_lines_interface aili
7389: WHERE aili.invoice_id = P_Invoice_Header_Rec.invoice_id
7390: AND aili.line_number <> p_inv_line_list(i).line_number
7391: AND aili.line_type_lookup_code <> 'TAX' --Bug6608702**
7392: AND aili.line_group_number = p_inv_line_list(i).line_group_number;

Line 7415: FROM ap_invoice_lines_interface aili

7411: WHERE trx_id = P_Invoice_Header_Rec.invoice_id
7412: AND trx_line_id <> p_inv_line_list(i).line_number
7413: AND trx_line_id =
7414: (SELECT (MAX(aili.line_number))
7415: FROM ap_invoice_lines_interface aili
7416: WHERE aili.invoice_id = P_Invoice_Header_Rec.invoice_id
7417: AND aili.line_number <> p_inv_line_list(i).line_number
7418: AND aili.line_type_lookup_code <> 'TAX' --Bug6608702**
7419: AND aili.amount <> 0

Line 7423: FROM ap_invoice_lines_interface ail2

7419: AND aili.amount <> 0
7420: AND aili.line_group_number = p_inv_line_list(i).line_group_number
7421: AND ABS(aili.amount) >=
7422: ( SELECT MAX(ABS(ail2.amount))
7423: FROM ap_invoice_lines_interface ail2
7424: WHERE ail2.invoice_id = aili.invoice_id
7425: AND ail2.line_number <> p_inv_line_list(i).line_number
7426: AND ail2.line_number <> aili.line_number
7427: AND ail2.line_type_lookup_code <> 'TAX' --Bug6608702**

Line 7944: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;

7940:
7941: l_fob_point po_vendor_sites_all.fob_lookup_code%TYPE;
7942: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
7943: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
7944: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
7945: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269
7946:
7947: k INT := 1;
7948:

Line 13154: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;

13150: l_bill_to_location_id zx_transaction_lines_gt.bill_to_location_id%TYPE;
13151: l_location_id zx_transaction_lines_gt.ship_from_location_id%type;
13152: l_fob_point zx_transaction_lines_gt.fob_point%TYPE;
13153:
13154: l_po_line_location_id ap_invoice_lines_interface.po_line_location_id%TYPE;
13155:
13156: -- Purchase Order
13157: l_ref_doc_application_id zx_transaction_lines_gt.ref_doc_application_id%TYPE;
13158: l_ref_doc_entity_code zx_transaction_lines_gt.ref_doc_entity_code%TYPE;