[Home] [Help]
119: END IF;
120:
121: SELECT SHIP_TO_ORGANIZATION_ID
122: INTO l_po_ship_to_org_id
123: FROM po_line_locations_all pll
124: WHERE pll.line_location_id = p_po_line_location_Id;
125:
126: return l_po_ship_to_org_id;
127:
5958:
5959: l_api_name VARCHAR2(30) := 'Populate_Lines_GT';
5960: l_tax_already_calculated_line VARCHAR2(1);
5961:
5962: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269
5963:
5964: BEGIN
5965:
5966: l_curr_calling_sequence := 'AP_ETAX_SERVICES_PKG.Populate_Lines_GT<-' ||
6808:
6809: l_prorating_total NUMBER;
6810: l_total_prorated NUMBER;
6811:
6812: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269
6813:
6814: l_api_name CONSTANT VARCHAR2(100) := 'Populate_Lines_Import_GT';
6815:
6816: BEGIN
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:
7949: l_return_status BOOLEAN := TRUE;
8644: l_ref_doc_trx_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
8645: l_ref_doc_trx_level_type zx_itm_distributions_gt.ref_doc_trx_level_type%TYPE;
8646: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
8647: l_ref_doc_trx_line_dist_qty zx_itm_distributions_gt.ref_doc_trx_line_dist_qty%TYPE;
8648: l_po_unit_price po_line_locations_all.price_override%TYPE;
8649: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
8650: l_po_release_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
8651: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
8652: l_uom_code mtl_units_of_measure.uom_code%TYPE;
8645: l_ref_doc_trx_level_type zx_itm_distributions_gt.ref_doc_trx_level_type%TYPE;
8646: l_ref_doc_line_quantity zx_transaction_lines_gt.ref_doc_line_quantity%TYPE;
8647: l_ref_doc_trx_line_dist_qty zx_itm_distributions_gt.ref_doc_trx_line_dist_qty%TYPE;
8648: l_po_unit_price po_line_locations_all.price_override%TYPE;
8649: l_po_line_location_id po_line_locations_all.line_location_id%TYPE;
8650: l_po_release_id zx_itm_distributions_gt.ref_doc_trx_id%TYPE;
8651: l_product_org_id zx_transaction_lines_gt.product_org_id%TYPE;
8652: l_uom_code mtl_units_of_measure.uom_code%TYPE;
8653:
12873: rsl.item_id rcv_item_id
12874: FROM ap_invoice_distributions_all D,
12875: po_distributions_all PD,
12876: po_lines_all PL,
12877: po_line_locations_all PLL,
12878: rcv_transactions RTXN,
12879: rcv_shipment_lines RSL
12880: WHERE D.invoice_distribution_id = c_inv_dist_id
12881: AND D.po_distribution_id = PD.po_distribution_id
13179: l_user_def_fisc_class zx_lines_det_factors.user_defined_fisc_class%type;
13180: l_assessable_value zx_lines_det_factors.assessable_value%type;
13181: l_dflt_tax_class_code zx_transaction_lines_gt.input_tax_classification_code%type;
13182: l_allow_tax_code_override VARCHAR2(10);
13183: l_ship_to_party_id po_line_locations_all.ship_to_organization_id%type; -- 7262269
13184:
13185: l_debug_info Varchar2(240);
13186: l_curr_calling_sequence Varchar2(4000);
13187: l_return_status BOOLEAN := TRUE;