eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_PO_PROC_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 538: REM prec_po_location IN PO_LINE_LOCATIONS_ALL%ROWTYPE N PO Shipment line.

534: REM
535: REM Parameter IN/OUT Type Required Description and Purpose
536: REM ----------------------- ------ --------------------- ---------- ------------------------------------
537: REM prec_po_line IN PO_LINES_ALL%ROWTYPE N PO Line info.
538: REM prec_po_location IN PO_LINE_LOCATIONS_ALL%ROWTYPE N PO Shipment line.
539: REM pv_retro_price_flag IN Varchar2 N retroactive price changed flag.
540: REM CALLED BY
541: REM process_po, process_po_line, process_po_shipment_line
542: REM +================================================================================================+

Line 546: ,prec_po_location IN PO_LINE_LOCATIONS_ALL%ROWTYPE DEFAULT NULL

542: REM +================================================================================================+
543: */
544: PROCEDURE process_po_tax_wrapper (prec_po_header IN po_headers_all%ROWTYPE DEFAULT NULL--Added by Wenqiong for bug16288154
545: ,prec_po_line IN PO_LINES_ALL%ROWTYPE DEFAULT NULL
546: ,prec_po_location IN PO_LINE_LOCATIONS_ALL%ROWTYPE DEFAULT NULL
547: ,pv_retro_price_flag IN VARCHAR2 DEFAULT 'N'
548: )
549: IS
550: l_api_name CONSTANT VARCHAR2(30) := 'process_po_tax_wrapper';

Line 563: v_line_loc_id PO_LINE_LOCATIONS_ALL.Line_Location_Id%TYPE;

559: v_last_upd_dt PO_LINES_ALL.Last_Update_Date%type;
560: v_last_upd_by PO_LINES_ALL.Last_Updated_By%type;
561: v_last_upd_login PO_LINES_ALL.Last_Update_Login%type;
562:
563: v_line_loc_id PO_LINE_LOCATIONS_ALL.Line_Location_Id%TYPE;
564: v_from_line_loc_id PO_LINE_LOCATIONS_ALL.From_Line_Location_Id%TYPE;
565: v_qty PO_LINE_LOCATIONS_ALL.Quantity%TYPE;
566: v_old_qty PO_LINE_LOCATIONS_ALL.Quantity%TYPE;
567: v_price PO_LINE_LOCATIONS_ALL.Price_Override%TYPE;

Line 564: v_from_line_loc_id PO_LINE_LOCATIONS_ALL.From_Line_Location_Id%TYPE;

560: v_last_upd_by PO_LINES_ALL.Last_Updated_By%type;
561: v_last_upd_login PO_LINES_ALL.Last_Update_Login%type;
562:
563: v_line_loc_id PO_LINE_LOCATIONS_ALL.Line_Location_Id%TYPE;
564: v_from_line_loc_id PO_LINE_LOCATIONS_ALL.From_Line_Location_Id%TYPE;
565: v_qty PO_LINE_LOCATIONS_ALL.Quantity%TYPE;
566: v_old_qty PO_LINE_LOCATIONS_ALL.Quantity%TYPE;
567: v_price PO_LINE_LOCATIONS_ALL.Price_Override%TYPE;
568: v_shipment_type PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE%TYPE;

Line 565: v_qty PO_LINE_LOCATIONS_ALL.Quantity%TYPE;

561: v_last_upd_login PO_LINES_ALL.Last_Update_Login%type;
562:
563: v_line_loc_id PO_LINE_LOCATIONS_ALL.Line_Location_Id%TYPE;
564: v_from_line_loc_id PO_LINE_LOCATIONS_ALL.From_Line_Location_Id%TYPE;
565: v_qty PO_LINE_LOCATIONS_ALL.Quantity%TYPE;
566: v_old_qty PO_LINE_LOCATIONS_ALL.Quantity%TYPE;
567: v_price PO_LINE_LOCATIONS_ALL.Price_Override%TYPE;
568: v_shipment_type PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE%TYPE;
569: v_src_ship_id prec_po_location.Source_Shipment_Id%TYPE;

Line 566: v_old_qty PO_LINE_LOCATIONS_ALL.Quantity%TYPE;

562:
563: v_line_loc_id PO_LINE_LOCATIONS_ALL.Line_Location_Id%TYPE;
564: v_from_line_loc_id PO_LINE_LOCATIONS_ALL.From_Line_Location_Id%TYPE;
565: v_qty PO_LINE_LOCATIONS_ALL.Quantity%TYPE;
566: v_old_qty PO_LINE_LOCATIONS_ALL.Quantity%TYPE;
567: v_price PO_LINE_LOCATIONS_ALL.Price_Override%TYPE;
568: v_shipment_type PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE%TYPE;
569: v_src_ship_id prec_po_location.Source_Shipment_Id%TYPE;
570: v_po_rel_id prec_po_location.Po_Release_Id%TYPE;

Line 567: v_price PO_LINE_LOCATIONS_ALL.Price_Override%TYPE;

563: v_line_loc_id PO_LINE_LOCATIONS_ALL.Line_Location_Id%TYPE;
564: v_from_line_loc_id PO_LINE_LOCATIONS_ALL.From_Line_Location_Id%TYPE;
565: v_qty PO_LINE_LOCATIONS_ALL.Quantity%TYPE;
566: v_old_qty PO_LINE_LOCATIONS_ALL.Quantity%TYPE;
567: v_price PO_LINE_LOCATIONS_ALL.Price_Override%TYPE;
568: v_shipment_type PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE%TYPE;
569: v_src_ship_id prec_po_location.Source_Shipment_Id%TYPE;
570: v_po_rel_id prec_po_location.Po_Release_Id%TYPE;
571:

Line 568: v_shipment_type PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE%TYPE;

564: v_from_line_loc_id PO_LINE_LOCATIONS_ALL.From_Line_Location_Id%TYPE;
565: v_qty PO_LINE_LOCATIONS_ALL.Quantity%TYPE;
566: v_old_qty PO_LINE_LOCATIONS_ALL.Quantity%TYPE;
567: v_price PO_LINE_LOCATIONS_ALL.Price_Override%TYPE;
568: v_shipment_type PO_LINE_LOCATIONS_ALL.SHIPMENT_TYPE%TYPE;
569: v_src_ship_id prec_po_location.Source_Shipment_Id%TYPE;
570: v_po_rel_id prec_po_location.Po_Release_Id%TYPE;
571:
572: ln_line_id NUMBER;

Line 1025: -- Cursor definition for picking line_location_id from po_line_locations_all

1021: v_vendor_site_id number;
1022: v_service_type_code varchar2(30);
1023:
1024: /* move to function get_line_loc_id since mutating error.
1025: -- Cursor definition for picking line_location_id from po_line_locations_all
1026: CURSOR Fetch_Line_Loc_Id_Cur IS
1027: SELECT jpll.Line_Location_Id
1028: FROM po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jpll,
1029: po_lines_all pla, po_headers_all pha

Line 1028: FROM po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jpll,

1024: /* move to function get_line_loc_id since mutating error.
1025: -- Cursor definition for picking line_location_id from po_line_locations_all
1026: CURSOR Fetch_Line_Loc_Id_Cur IS
1027: SELECT jpll.Line_Location_Id
1028: FROM po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jpll,
1029: po_lines_all pla, po_headers_all pha
1030: WHERE pha.po_header_id = pla.po_header_id
1031: AND jpll.line_location_id = plla.line_location_id
1032: AND pha.po_header_id = plla.po_header_id

Line 1898: SELECT * FROM PO_LINE_LOCATIONS_ALL

1894: SELECT * FROM PO_LINES_ALL
1895: WHERE po_line_id = pn_line_id;
1896:
1897: CURSOR po_line_loc_cur IS
1898: SELECT * FROM PO_LINE_LOCATIONS_ALL
1899: WHERE po_line_id = pn_line_id
1900: AND shipment_type NOT IN ( 'SCHEDULED', 'BLANKET' );
1901:
1902: CURSOR Fetch_Lines_Cur IS

Line 1904: FROM Po_Line_Locations_All

1900: AND shipment_type NOT IN ( 'SCHEDULED', 'BLANKET' );
1901:
1902: CURSOR Fetch_Lines_Cur IS
1903: SELECT Line_location_id, Price_Override, Quantity
1904: FROM Po_Line_Locations_All
1905: WHERE Po_Line_Id = pn_line_id;
1906:
1907: CURSOR Fetch_UOMCode_Cur( v_uom IN VARCHAR2 ) IS
1908: SELECT Uom_Code

Line 1938: r_po_line_loc PO_LINE_LOCATIONS_ALL%ROWTYPE;

1934: AND pha.po_header_id =pla.po_header_id;
1935:
1936: r_po_header PO_HEADERS_ALL%ROWTYPE;
1937: r_po_line PO_LINES_ALL%ROWTYPE;
1938: r_po_line_loc PO_LINE_LOCATIONS_ALL%ROWTYPE;
1939: r_jai_po_line_loc c_get_po_line_loc_details%ROWTYPE;
1940:
1941: BEGIN
1942:

Line 2212: po_line_loc_rec PO_LINE_LOCATIONS_ALL%ROWTYPE;

2208: */
2209: PROCEDURE process_po_shipment_line (pn_line_loc_id IN NUMBER,pr_po_header IN PO_HEADERS_ALL%ROWTYPE DEFAULT NULL,pr_po_line IN PO_LINES_ALL%ROWTYPE DEFAULT NULL, pv_action IN VARCHAR2) IS
2210: l_api_name CONSTANT VARCHAR2(30) := 'process_po_shipment_line';
2211: r_get_po_line_loc_details JAI_PO_LINE_LOCATIONS%ROWTYPE;
2212: po_line_loc_rec PO_LINE_LOCATIONS_ALL%ROWTYPE;
2213: old_po_line_loce_rec PO_LINE_LOCATIONS_ALL%ROWTYPE;
2214:
2215:
2216: lv_retro_price_flag VARCHAR2(1) := 'N';

Line 2213: old_po_line_loce_rec PO_LINE_LOCATIONS_ALL%ROWTYPE;

2209: PROCEDURE process_po_shipment_line (pn_line_loc_id IN NUMBER,pr_po_header IN PO_HEADERS_ALL%ROWTYPE DEFAULT NULL,pr_po_line IN PO_LINES_ALL%ROWTYPE DEFAULT NULL, pv_action IN VARCHAR2) IS
2210: l_api_name CONSTANT VARCHAR2(30) := 'process_po_shipment_line';
2211: r_get_po_line_loc_details JAI_PO_LINE_LOCATIONS%ROWTYPE;
2212: po_line_loc_rec PO_LINE_LOCATIONS_ALL%ROWTYPE;
2213: old_po_line_loce_rec PO_LINE_LOCATIONS_ALL%ROWTYPE;
2214:
2215:
2216: lv_retro_price_flag VARCHAR2(1) := 'N';
2217: lv_process_flag VARCHAR2(10);

Line 2261: SELECT * FROM PO_LINE_LOCATIONS_ALL

2257: v_hook_value VARCHAR2(10);
2258: v_src_loc_id NUMBER;
2259:
2260: CURSOR po_line_loc_cur IS
2261: SELECT * FROM PO_LINE_LOCATIONS_ALL
2262: WHERE line_location_id = pn_line_loc_id;
2263:
2264: CURSOR c_get_po_line_loc_details (p_line_location_id IN NUMBER) IS
2265: SELECT *

Line 2289: -- Cursor definition for picking line_location_id from po_line_locations_all

2285: SELECT *
2286: FROM PO_LINES_ALL
2287: WHERE po_line_id = cn_po_line_id;
2288:
2289: -- Cursor definition for picking line_location_id from po_line_locations_all
2290: CURSOR Fetch_Line_Loc_Id_Cur(p_from_hdr_id NUMBER,p_line_num NUMBER ,p_item_id NUMBER, p_ship_num NUMBER) IS
2291: SELECT jpll.Line_Location_Id
2292: FROM po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jpll,
2293: po_lines_all pla, po_headers_all pha

Line 2292: FROM po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jpll,

2288:
2289: -- Cursor definition for picking line_location_id from po_line_locations_all
2290: CURSOR Fetch_Line_Loc_Id_Cur(p_from_hdr_id NUMBER,p_line_num NUMBER ,p_item_id NUMBER, p_ship_num NUMBER) IS
2291: SELECT jpll.Line_Location_Id
2292: FROM po_line_locations_all plla, JAI_PO_LINE_LOCATIONS jpll,
2293: po_lines_all pla, po_headers_all pha
2294: WHERE pha.po_header_id = pla.po_header_id
2295: AND jpll.line_location_id = plla.line_location_id
2296: AND pha.po_header_id = plla.po_header_id

Line 2316: v_hook_value := jai_cmn_hook_pkg.Ja_In_po_line_locations_all(

2312: OPEN po_line_loc_cur;
2313: FETCH po_line_loc_cur INTO po_line_loc_rec;
2314: CLOSE po_line_loc_cur;
2315:
2316: v_hook_value := jai_cmn_hook_pkg.Ja_In_po_line_locations_all(
2317: po_line_loc_rec.LINE_LOCATION_ID ,
2318: po_line_loc_rec.PO_HEADER_ID ,
2319: po_line_loc_rec.PO_LINE_ID ,
2320: po_line_loc_rec.QUANTITY ,

Line 3209: from po_line_locations_all

3205: IS
3206: l_api_name CONSTANT VARCHAR2(30) := 'process_split_line';
3207: CURSOR cur_get_prev_qty IS
3208: select quantity
3209: from po_line_locations_all
3210: where line_location_id = pn_orig_ship_id;
3211:
3212: CURSOR c_get_po_line_loc_details IS
3213: SELECT *

Line 3330: REM prec_po_location IN PO_LINE_LOCATIONS_ALL%ROWTYPE Y PO Line location

3326: REM Assumptions :
3327: REM
3328: REM Parameter IN/OUT Type Required Description and Purpose
3329: REM ----------------------- ------ ----------------------------- ---------- ------------------------------------
3330: REM prec_po_location IN PO_LINE_LOCATIONS_ALL%ROWTYPE Y PO Line location
3331: REM
3332: REM Call by process_po_shipment_line
3333: REM +================================================================================================+
3334: */

Line 3335: PROCEDURE process_dist(prec_po_location IN PO_LINE_LOCATIONS_ALL%ROWTYPE) IS

3331: REM
3332: REM Call by process_po_shipment_line
3333: REM +================================================================================================+
3334: */
3335: PROCEDURE process_dist(prec_po_location IN PO_LINE_LOCATIONS_ALL%ROWTYPE) IS
3336:
3337: rec_dist PO_DISTRIBUTIONS_ALL%ROWTYPE;
3338:
3339: /*v_po_line_id PO_DISTRIBUTIONS_ALL.Po_Line_Id%TYPE ;

Line 3893: lv_unit_meas_lookup po_line_locations_all.unit_meas_lookup_code%TYPE;

3889: lv_apps_source_code po_requisition_headers_all.apps_source_code%type;
3890: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE;
3891: v_modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%type;
3892: v_parent_req_line_id po_requisition_lines_all.parent_req_line_id%type;
3893: lv_unit_meas_lookup po_line_locations_all.unit_meas_lookup_code%TYPE;
3894: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
3895: r_req_line PO_REQUISITION_LINES_ALL%ROWTYPE;
3896:
3897: /* CURSOR get_requesition_info IS

Line 4444: lv_unit_meas_lookup po_line_locations_all.unit_meas_lookup_code%TYPE;

4440: v_type_lookup_code Po_Requisition_Headers_All.Type_Lookup_Code%TYPE;
4441: lv_apps_source_code po_requisition_headers_all.apps_source_code%type;
4442: v_modified_by_agent_flag po_requisition_lines_all.modified_by_agent_flag%type;
4443: v_parent_req_line_id po_requisition_lines_all.parent_req_line_id%type;
4444: lv_unit_meas_lookup po_line_locations_all.unit_meas_lookup_code%TYPE;
4445: l_func_curr_det jai_plsql_cache_pkg.func_curr_details;
4446: r_req_line PO_REQUISITION_LINES_ALL%ROWTYPE;
4447:
4448: /* CURSOR get_requesition_info IS

Line 4479: FROM Po_Line_Locations_All

4475: (A.Org_Id is NULL AND v_org_id is NULL)) ;
4476:
4477: CURSOR cur_bpa_unit_measure(p_blanket_hdr IN NUMBER, p_blanket_line NUMBER) IS
4478: SELECT unit_meas_lookup_code
4479: FROM Po_Line_Locations_All
4480: WHERE Po_Line_Id IN (SELECT Po_Line_Id
4481: FROM Po_Lines_All
4482: WHERE Po_Header_Id = p_blanket_hdr
4483: AND Line_Num = p_blanket_line);

Line 4759: REM prec_po_location IN Po_Line_Locations_All%ROWTYPE Y PO Requisition Line Id.

4755: REM Assumptions :
4756: REM
4757: REM Parameter IN/OUT Type Required Description and Purpose
4758: REM ----------------------- ------ ------------------------------ ---------- ------------------------------------
4759: REM prec_po_location IN Po_Line_Locations_All%ROWTYPE Y PO Requisition Line Id.
4760: REM
4761: REM CALLED BY
4762: REM process_req_line_inserting , process_req_line_updating.
4763: REM +================================================================================================+

Line 4765: PROCEDURE copy_req_to_po(prec_po_location IN Po_Line_Locations_All%ROWTYPE) IS

4761: REM CALLED BY
4762: REM process_req_line_inserting , process_req_line_updating.
4763: REM +================================================================================================+
4764: */
4765: PROCEDURE copy_req_to_po(prec_po_location IN Po_Line_Locations_All%ROWTYPE) IS
4766: v_requisition_line_id NUMBER;
4767: v_sugg_vendor_name VARCHAR2(360);
4768: v_dest_org_id NUMBER;
4769: v_sugg_vendor_location VARCHAR2(360);

Line 4860: v_price_override PO_LINE_LOCATIONS_ALL.price_override%TYPE;

4856: v_inventory_org_id HR_LOCATIONS.Inventory_Organization_Id%TYPE;
4857: v_line_loc_cnt NUMBER;
4858: v_ship_to_organization_id NUMBER;
4859: v_ship_to_location_id NUMBER;
4860: v_price_override PO_LINE_LOCATIONS_ALL.price_override%TYPE;
4861: v_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;
4862: v_line_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE;
4863: v_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
4864: v_quot_class_code PO_HEADERS_ALL.quotation_class_code%TYPE;

Line 4861: v_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;

4857: v_line_loc_cnt NUMBER;
4858: v_ship_to_organization_id NUMBER;
4859: v_ship_to_location_id NUMBER;
4860: v_price_override PO_LINE_LOCATIONS_ALL.price_override%TYPE;
4861: v_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;
4862: v_line_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE;
4863: v_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
4864: v_quot_class_code PO_HEADERS_ALL.quotation_class_code%TYPE;
4865:

Line 5460: REM prec_po_location IN Po_Line_Locations_All%ROWTYPE Y PO Requisition Line Id.

5456: REM Assumptions :
5457: REM
5458: REM Parameter IN/OUT Type Required Description and Purpose
5459: REM ----------------------- ------ ------------------------------ ---------- ------------------------------------
5460: REM prec_po_location IN Po_Line_Locations_All%ROWTYPE Y PO Requisition Line Id.
5461: REM
5462: REM CALLED BY
5463: REM process_req_line_inserting , process_req_line_updating.
5464: REM +================================================================================================+

Line 5468: rec_line_loc PO_LINE_LOCATIONS_ALL%ROWTYPE;

5464: REM +================================================================================================+
5465: */
5466: PROCEDURE cancel_po(pn_po_hdr_id IN NUMBER) IS
5467:
5468: rec_line_loc PO_LINE_LOCATIONS_ALL%ROWTYPE;
5469:
5470: CURSOR cur_line_loc IS
5471: SELECT *
5472: FROM PO_LINE_LOCATIONS_ALL

Line 5472: FROM PO_LINE_LOCATIONS_ALL

5468: rec_line_loc PO_LINE_LOCATIONS_ALL%ROWTYPE;
5469:
5470: CURSOR cur_line_loc IS
5471: SELECT *
5472: FROM PO_LINE_LOCATIONS_ALL
5473: WHERE PO_HEADER_ID = pn_po_hdr_id;
5474:
5475:
5476: l_api_name CONSTANT VARCHAR2(200) := 'cancel_po';

Line 5514: FROM PO_LINE_LOCATIONS_ALL

5510: */
5511: PROCEDURE process_release(pn_po_release_id IN NUMBER, pv_action IN VARCHAR2) IS
5512: CURSOR c_release_line_locs IS
5513: SELECT *
5514: FROM PO_LINE_LOCATIONS_ALL
5515: WHERE po_release_id = pn_po_release_id;
5516:
5517: CURSOR c_jai_loc_exists(cn_line_id IN NUMBER) IS
5518: SELECT 1

Line 5523: rec_line_location PO_LINE_LOCATIONS_ALL%ROWTYPE;

5519: FROM JAI_PO_LINE_LOCATIONS jai
5520: WHERE jai.PO_LINE_ID = cn_line_id
5521: AND jai.line_location_id IS NULL;
5522:
5523: rec_line_location PO_LINE_LOCATIONS_ALL%ROWTYPE;
5524: ln_line_id PO_LINE_LOCATIONS_ALL.PO_LINE_ID%TYPE;
5525: ln_flag NUMBER;
5526: lv_action VARCHAR2(20);
5527: l_api_name CONSTANT VARCHAR2(30) := 'process_release';

Line 5524: ln_line_id PO_LINE_LOCATIONS_ALL.PO_LINE_ID%TYPE;

5520: WHERE jai.PO_LINE_ID = cn_line_id
5521: AND jai.line_location_id IS NULL;
5522:
5523: rec_line_location PO_LINE_LOCATIONS_ALL%ROWTYPE;
5524: ln_line_id PO_LINE_LOCATIONS_ALL.PO_LINE_ID%TYPE;
5525: ln_flag NUMBER;
5526: lv_action VARCHAR2(20);
5527: l_api_name CONSTANT VARCHAR2(30) := 'process_release';
5528: BEGIN

Line 5681: FROM Po_Line_Locations_All

5677:
5678: v_junk_uom MTL_UNITS_OF_MEASURE.unit_of_measure%TYPE;
5679: CURSOR Fetch_Qty_Cur( llid IN NUMBER ) IS
5680: SELECT Quantity, Price_Override, Unit_Meas_Lookup_Code
5681: FROM Po_Line_Locations_All
5682: WHERE Line_Location_Id = llid;
5683:
5684:
5685: CURSOR Fetch_Cum_Qty_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS

Line 5685: CURSOR Fetch_Cum_Qty_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS

5681: FROM Po_Line_Locations_All
5682: WHERE Line_Location_Id = llid;
5683:
5684:
5685: CURSOR Fetch_Cum_Qty_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS
5686: SELECT SUM( Quantity )
5687: FROM Po_Line_Locations_All PLL
5688: WHERE Po_Line_Id = p_line_id
5689:

Line 5687: FROM Po_Line_Locations_All PLL

5683:
5684:
5685: CURSOR Fetch_Cum_Qty_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS
5686: SELECT SUM( Quantity )
5687: FROM Po_Line_Locations_All PLL
5688: WHERE Po_Line_Id = p_line_id
5689:
5690: AND shipment_type <> cp_shipment_type --'PRICE BREAK'
5691: AND ((pQryOn = 'ALL' AND PLL.SHIP_TO_ORGANIZATION_ID = pShipToOrganizationId AND PLL.SHIP_TO_LOCATION_ID = pShipToLocationId )

Line 5697: CURSOR Fetch_Count_Llid_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS

5693: OR (pQryOn = 'NULL' AND PLL.SHIP_TO_ORGANIZATION_ID IS NULL AND PLL.SHIP_TO_LOCATION_ID IS NULL )
5694: );
5695:
5696:
5697: CURSOR Fetch_Count_Llid_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS
5698: SELECT NVL( COUNT( Line_Location_Id ), 0 )
5699: FROM Po_Line_Locations_All PLL
5700: WHERE Po_Line_Id = p_line_id
5701: AND Shipment_Type = cp_shipment_type --'PRICE BREAK'

Line 5699: FROM Po_Line_Locations_All PLL

5695:
5696:
5697: CURSOR Fetch_Count_Llid_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS
5698: SELECT NVL( COUNT( Line_Location_Id ), 0 )
5699: FROM Po_Line_Locations_All PLL
5700: WHERE Po_Line_Id = p_line_id
5701: AND Shipment_Type = cp_shipment_type --'PRICE BREAK'
5702: AND ((pQryOn = 'ALL' AND PLL.SHIP_TO_ORGANIZATION_ID = pShipToOrganizationId AND PLL.SHIP_TO_LOCATION_ID = pShipToLocationId )
5703: OR (pQryOn = 'ORG' AND PLL.SHIP_TO_ORGANIZATION_ID = pShipToOrganizationId AND PLL.SHIP_TO_LOCATION_ID IS NULL )

Line 5709: CURSOR Fetch_Locid_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS

5705: )
5706: AND SYSDATE between nvl(start_date, SYSDATE) and nvl(end_date, SYSDATE);
5707:
5708:
5709: CURSOR Fetch_Locid_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS
5710: SELECT Line_Location_Id, Quantity, Price_Override, Unit_Meas_Lookup_Code
5711: FROM Po_Line_Locations_All PLL
5712: WHERE Po_Header_Id = p_hdr_id
5713: AND Po_Line_Id = p_line_id

Line 5711: FROM Po_Line_Locations_All PLL

5707:
5708:
5709: CURSOR Fetch_Locid_Cur(pQryOn IN VARCHAR2, pShipToOrganizationId IN NUMBER, pShipToLocationId IN NUMBER, cp_shipment_type Po_Line_Locations_All.shipment_type%type) IS
5710: SELECT Line_Location_Id, Quantity, Price_Override, Unit_Meas_Lookup_Code
5711: FROM Po_Line_Locations_All PLL
5712: WHERE Po_Header_Id = p_hdr_id
5713: AND Po_Line_Id = p_line_id
5714: AND Shipment_Type = cp_shipment_type --'PRICE BREAK'
5715:

Line 5726: FROM po_line_locations_all

5722:
5723:
5724: CURSOR cShipmentDetails(pLineLocationId IN NUMBER) IS
5725: SELECT ship_to_organization_id, ship_to_location_id
5726: FROM po_line_locations_all
5727: WHERE line_location_id = pLineLocationId;
5728: vShpDtl cShipmentDetails%ROWTYPE;
5729:
5730:

Line 5733: FROM Po_Line_Locations_All

5729:
5730:
5731: CURSOR Fetch_Price_cur IS
5732: SELECT Price_Override
5733: FROM Po_Line_Locations_All
5734: WHERE po_header_id = p_hdr_id
5735: AND po_line_id = p_line_id
5736: AND line_location_id=p_line_loc_id;
5737:

Line 5818: FROM Po_Line_Locations_All

5814: where po_header_id=p_po_hdr_id;
5815:
5816: CURSOR Fetch_Dtls1_Cur( lineid IN NUMBER, linelocid IN NUMBER ) IS
5817: SELECT Price_Override ,Unit_Meas_Lookup_Code
5818: FROM Po_Line_Locations_All
5819: WHERE Po_Line_Id = lineid
5820: AND Line_Location_Id = linelocid;
5821:
5822: CURSOR Fetch_Org_Id_Cur IS

Line 6494: ,pr_po_line_loc po_line_locations_all%ROWTYPE DEFAULT NULL

6490: FUNCTION rfq_quotation_related
6491: (
6492: pr_po_header po_headers_all%ROWTYPE DEFAULT NULL
6493: ,pr_po_line po_lines_all%ROWTYPE DEFAULT NULL
6494: ,pr_po_line_loc po_line_locations_all%ROWTYPE DEFAULT NULL
6495: ) RETURN BOOLEAN IS
6496: lv_type_lookup_code po_headers_all.type_lookup_code%TYPE;
6497: lv_from_type_lookup_code po_headers_all.from_type_lookup_code%TYPE;
6498: ln_from_line_id po_lines_all.from_line_id%TYPE;

Line 6604: FROM Po_Line_Locations_All

6600: WHERE Unit_Of_Measure = v_uom;
6601:
6602: CURSOR Fetch_Lines_Cur IS
6603: SELECT Line_location_id, Price_Override, Quantity
6604: FROM Po_Line_Locations_All
6605: WHERE Po_Line_Id = v_po_line_id;
6606:
6607: CURSOR c_get_po_line_loc_details IS
6608: SELECT DISTINCT item_id

Line 6613: SELECT * FROM PO_LINE_LOCATIONS_ALL

6609: FROM JAI_PO_LINE_LOCATIONS
6610: WHERE po_line_id = v_po_line_id;
6611:
6612: CURSOR po_line_loc_cur IS
6613: SELECT * FROM PO_LINE_LOCATIONS_ALL
6614: WHERE po_line_id = v_po_line_id
6615: AND shipment_type NOT IN ( 'SCHEDULED', 'BLANKET' );
6616:
6617: r_jai_po_line_loc c_get_po_line_loc_details%ROWTYPE;

Line 6831: PROCEDURE process_quotation_line_loc(po_line_loc_rec PO_LINE_LOCATIONS_ALL%ROWTYPE , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS

6827: app_exception.raise_exception;
6828:
6829: END process_quotation_line;
6830:
6831: PROCEDURE process_quotation_line_loc(po_line_loc_rec PO_LINE_LOCATIONS_ALL%ROWTYPE , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
6832:
6833: v_po_hdr_id NUMBER;
6834: v_po_line_id NUMBER;
6835: v_orig_ship_id NUMBER;

Line 6900: v_hook_value := jai_cmn_hook_pkg.Ja_In_po_line_locations_all(

6896: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
6897: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'pv_action:'||pv_action);
6898: END IF;
6899:
6900: v_hook_value := jai_cmn_hook_pkg.Ja_In_po_line_locations_all(
6901: po_line_loc_rec.LINE_LOCATION_ID ,
6902: po_line_loc_rec.PO_HEADER_ID ,
6903: po_line_loc_rec.PO_LINE_ID ,
6904: po_line_loc_rec.QUANTITY ,

Line 7177: PO_LINE_LOCATIONS_ALL

7173: WHERE Po_Line_Id = lineid;
7174:
7175: CURSOR PO_Line_loc_cur(cn_line_loc_id NUMBER) IS
7176: SELECT * FROM
7177: PO_LINE_LOCATIONS_ALL
7178: WHERE Line_Location_Id = cn_line_loc_id;
7179:
7180: CURSOR c_po_line_dtl(cn_po_line_id NUMBER) IS
7181: SELECT * FROM PO_LINES_ALL

Line 7197: r_po_line_loc PO_LINE_LOCATIONS_ALL%ROWTYPE;

7193: AND vendor_site_id = c_supp_site_id;
7194:
7195:
7196: r_po_line PO_LINES_ALL%ROWTYPE;
7197: r_po_line_loc PO_LINE_LOCATIONS_ALL%ROWTYPE;
7198: ln_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE := prec_po_header.po_header_id;
7199: v_po_line_id PO_LINE_LOCATIONS_ALL.PO_LINE_ID%TYPE;
7200: v_line_loc_id PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID%TYPE;
7201:

Line 7199: v_po_line_id PO_LINE_LOCATIONS_ALL.PO_LINE_ID%TYPE;

7195:
7196: r_po_line PO_LINES_ALL%ROWTYPE;
7197: r_po_line_loc PO_LINE_LOCATIONS_ALL%ROWTYPE;
7198: ln_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE := prec_po_header.po_header_id;
7199: v_po_line_id PO_LINE_LOCATIONS_ALL.PO_LINE_ID%TYPE;
7200: v_line_loc_id PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID%TYPE;
7201:
7202:
7203: v_override_flag VARCHAR2(1);

Line 7200: v_line_loc_id PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID%TYPE;

7196: r_po_line PO_LINES_ALL%ROWTYPE;
7197: r_po_line_loc PO_LINE_LOCATIONS_ALL%ROWTYPE;
7198: ln_po_header_id PO_HEADERS_ALL.PO_HEADER_ID%TYPE := prec_po_header.po_header_id;
7199: v_po_line_id PO_LINE_LOCATIONS_ALL.PO_LINE_ID%TYPE;
7200: v_line_loc_id PO_LINE_LOCATIONS_ALL.LINE_LOCATION_ID%TYPE;
7201:
7202:
7203: v_override_flag VARCHAR2(1);
7204: v_line_exists_flag NUMBER;

Line 7334: -- Cursor definition for picking line_location_id from po_line_locations_all

7330: ,p_item_id NUMBER
7331: ,p_ship_num NUMBER
7332: ) RETURN NUMBER IS
7333: PRAGMA AUTONOMOUS_TRANSACTION;
7334: -- Cursor definition for picking line_location_id from po_line_locations_all
7335: CURSOR fetch_line_loc_id_cur IS
7336: SELECT jpll.line_location_id
7337: FROM po_line_locations_all plla, jai_po_line_locations jpll,
7338: po_lines_all pla, po_headers_all pha

Line 7337: FROM po_line_locations_all plla, jai_po_line_locations jpll,

7333: PRAGMA AUTONOMOUS_TRANSACTION;
7334: -- Cursor definition for picking line_location_id from po_line_locations_all
7335: CURSOR fetch_line_loc_id_cur IS
7336: SELECT jpll.line_location_id
7337: FROM po_line_locations_all plla, jai_po_line_locations jpll,
7338: po_lines_all pla, po_headers_all pha
7339: WHERE pha.po_header_id = pla.po_header_id AND
7340: jpll.line_location_id = plla.line_location_id AND
7341: pha.po_header_id = plla.po_header_id AND

Line 7438: FROM Po_Line_Locations_All

7434: Qty_tab v_Qty_Tab;
7435:
7436: CURSOR Fetch_Qty_Cur IS
7437: SELECT Quantity, Line_Location_Id
7438: FROM Po_Line_Locations_All
7439: WHERE Po_Header_Id = p_header_id
7440: AND Po_Line_Id = v_po_line_id
7441: and SYSDATE between nvl(start_date, SYSDATE) and nvl(end_date, SYSDATE) -- cbabu for Bug# 2740918
7442: ORDER BY Quantity;

Line 7457: FROM Po_Line_Locations_All

7453: WHERE Po_Line_Id = p_line_id;
7454:
7455: CURSOR Fetch_Cum_Qty_Cur IS
7456: SELECT SUM( Quantity )
7457: FROM Po_Line_Locations_All
7458: WHERE Po_Line_Id = v_po_line_id;
7459:
7460: CURSOR Chk_Line_Loc_Cur IS
7461: SELECT COUNT( * )

Line 7462: FROM Po_Line_Locations_All

7458: WHERE Po_Line_Id = v_po_line_id;
7459:
7460: CURSOR Chk_Line_Loc_Cur IS
7461: SELECT COUNT( * )
7462: FROM Po_Line_Locations_All
7463: WHERE Po_Line_Id = v_po_line_id;
7464:
7465: lv_object_name CONSTANT VARCHAR2 (61) := 'jai_po_proc_pkg.locate_source_line';
7466:

Line 7544: PROCEDURE cancel_po_shipment_line(pr_po_line_loc po_line_locations_all%ROWTYPE) IS

7540: FND_MESSAGE.SET_TOKEN ('JAI_PROCESS_MSG',lv_object_name ||'.Err:'||sqlerrm);
7541: app_exception.raise_exception;
7542: END locate_source_line;
7543:
7544: PROCEDURE cancel_po_shipment_line(pr_po_line_loc po_line_locations_all%ROWTYPE) IS
7545:
7546: v_quantity_cancelled po_line_locations_all.QUANTITY_CANCELLED%TYPE;
7547: v_qty po_line_locations_all.QUANTITY%TYPE;
7548: v_quantity_received po_line_locations_all.QUANTITY_RECEIVED%TYPE;

Line 7546: v_quantity_cancelled po_line_locations_all.QUANTITY_CANCELLED%TYPE;

7542: END locate_source_line;
7543:
7544: PROCEDURE cancel_po_shipment_line(pr_po_line_loc po_line_locations_all%ROWTYPE) IS
7545:
7546: v_quantity_cancelled po_line_locations_all.QUANTITY_CANCELLED%TYPE;
7547: v_qty po_line_locations_all.QUANTITY%TYPE;
7548: v_quantity_received po_line_locations_all.QUANTITY_RECEIVED%TYPE;
7549: v_po_line_id po_line_locations_all.PO_LINE_ID%TYPE;
7550: v_line_loc_id po_line_locations_all.LINE_LOCATION_ID%TYPE;

Line 7547: v_qty po_line_locations_all.QUANTITY%TYPE;

7543:
7544: PROCEDURE cancel_po_shipment_line(pr_po_line_loc po_line_locations_all%ROWTYPE) IS
7545:
7546: v_quantity_cancelled po_line_locations_all.QUANTITY_CANCELLED%TYPE;
7547: v_qty po_line_locations_all.QUANTITY%TYPE;
7548: v_quantity_received po_line_locations_all.QUANTITY_RECEIVED%TYPE;
7549: v_po_line_id po_line_locations_all.PO_LINE_ID%TYPE;
7550: v_line_loc_id po_line_locations_all.LINE_LOCATION_ID%TYPE;
7551: v_price po_line_locations_all.price_override%TYPE;

Line 7548: v_quantity_received po_line_locations_all.QUANTITY_RECEIVED%TYPE;

7544: PROCEDURE cancel_po_shipment_line(pr_po_line_loc po_line_locations_all%ROWTYPE) IS
7545:
7546: v_quantity_cancelled po_line_locations_all.QUANTITY_CANCELLED%TYPE;
7547: v_qty po_line_locations_all.QUANTITY%TYPE;
7548: v_quantity_received po_line_locations_all.QUANTITY_RECEIVED%TYPE;
7549: v_po_line_id po_line_locations_all.PO_LINE_ID%TYPE;
7550: v_line_loc_id po_line_locations_all.LINE_LOCATION_ID%TYPE;
7551: v_price po_line_locations_all.price_override%TYPE;
7552: v_po_hdr_id po_line_locations_all.po_header_id%TYPE;

Line 7549: v_po_line_id po_line_locations_all.PO_LINE_ID%TYPE;

7545:
7546: v_quantity_cancelled po_line_locations_all.QUANTITY_CANCELLED%TYPE;
7547: v_qty po_line_locations_all.QUANTITY%TYPE;
7548: v_quantity_received po_line_locations_all.QUANTITY_RECEIVED%TYPE;
7549: v_po_line_id po_line_locations_all.PO_LINE_ID%TYPE;
7550: v_line_loc_id po_line_locations_all.LINE_LOCATION_ID%TYPE;
7551: v_price po_line_locations_all.price_override%TYPE;
7552: v_po_hdr_id po_line_locations_all.po_header_id%TYPE;
7553: l_total_tax_amount JAI_PO_LINE_LOCATIONS.TAX_AMOUNT%TYPE;

Line 7550: v_line_loc_id po_line_locations_all.LINE_LOCATION_ID%TYPE;

7546: v_quantity_cancelled po_line_locations_all.QUANTITY_CANCELLED%TYPE;
7547: v_qty po_line_locations_all.QUANTITY%TYPE;
7548: v_quantity_received po_line_locations_all.QUANTITY_RECEIVED%TYPE;
7549: v_po_line_id po_line_locations_all.PO_LINE_ID%TYPE;
7550: v_line_loc_id po_line_locations_all.LINE_LOCATION_ID%TYPE;
7551: v_price po_line_locations_all.price_override%TYPE;
7552: v_po_hdr_id po_line_locations_all.po_header_id%TYPE;
7553: l_total_tax_amount JAI_PO_LINE_LOCATIONS.TAX_AMOUNT%TYPE;
7554: CURSOR rec_get_tax_amount

Line 7551: v_price po_line_locations_all.price_override%TYPE;

7547: v_qty po_line_locations_all.QUANTITY%TYPE;
7548: v_quantity_received po_line_locations_all.QUANTITY_RECEIVED%TYPE;
7549: v_po_line_id po_line_locations_all.PO_LINE_ID%TYPE;
7550: v_line_loc_id po_line_locations_all.LINE_LOCATION_ID%TYPE;
7551: v_price po_line_locations_all.price_override%TYPE;
7552: v_po_hdr_id po_line_locations_all.po_header_id%TYPE;
7553: l_total_tax_amount JAI_PO_LINE_LOCATIONS.TAX_AMOUNT%TYPE;
7554: CURSOR rec_get_tax_amount
7555: IS

Line 7552: v_po_hdr_id po_line_locations_all.po_header_id%TYPE;

7548: v_quantity_received po_line_locations_all.QUANTITY_RECEIVED%TYPE;
7549: v_po_line_id po_line_locations_all.PO_LINE_ID%TYPE;
7550: v_line_loc_id po_line_locations_all.LINE_LOCATION_ID%TYPE;
7551: v_price po_line_locations_all.price_override%TYPE;
7552: v_po_hdr_id po_line_locations_all.po_header_id%TYPE;
7553: l_total_tax_amount JAI_PO_LINE_LOCATIONS.TAX_AMOUNT%TYPE;
7554: CURSOR rec_get_tax_amount
7555: IS
7556: SELECT

Line 7607: In such a case the cancelled quantity would be lesser than the quantity in table po_line_locations_all.

7603: delete_jai_po_lines(pn_line_loc_id => v_line_loc_id);
7604: ELSIF nvl(v_quantity_cancelled,-9999) < nvl(v_qty,0) THEN
7605: /*
7606: Indicating that a partial receipt has been made for the line and then the line has been cancelled.
7607: In such a case the cancelled quantity would be lesser than the quantity in table po_line_locations_all.
7608: Now in this scenario update the line and the associated apportioned taxes in the table JAI_PO_LINE_LOCATIONS
7609: and JAI_PO_TAXES
7610: */
7611:

Line 7817: PROCEDURE process_po_line_loc(po_line_loc_rec PO_LINE_LOCATIONS_ALL%ROWTYPE

7813:
7814: END process_distribution_line;
7815:
7816: /*Only used for trigger replacement and copy from process_po_shipment_line and remove the calls to process_dist and copy_req_to_po*/
7817: PROCEDURE process_po_line_loc(po_line_loc_rec PO_LINE_LOCATIONS_ALL%ROWTYPE
7818: ,old_line_loc_rec PO_LINE_LOCATIONS_ALL%ROWTYPE
7819: , pv_action varchar2
7820: , pv_return_code out nocopy varchar2
7821: , pv_return_message out nocopy varchar2 ) IS

Line 7818: ,old_line_loc_rec PO_LINE_LOCATIONS_ALL%ROWTYPE

7814: END process_distribution_line;
7815:
7816: /*Only used for trigger replacement and copy from process_po_shipment_line and remove the calls to process_dist and copy_req_to_po*/
7817: PROCEDURE process_po_line_loc(po_line_loc_rec PO_LINE_LOCATIONS_ALL%ROWTYPE
7818: ,old_line_loc_rec PO_LINE_LOCATIONS_ALL%ROWTYPE
7819: , pv_action varchar2
7820: , pv_return_code out nocopy varchar2
7821: , pv_return_message out nocopy varchar2 ) IS
7822:

Line 7899: v_hook_value := jai_cmn_hook_pkg.Ja_In_po_line_locations_all(

7895: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name||'.BEGIN',G_PKG_NAME||': '||l_api_name||'()+');
7896: FND_LOG.STRING(G_LEVEL_PROCEDURE,G_MODULE_NAME||l_api_name,'pv_action:'||pv_action);
7897: END IF;
7898:
7899: v_hook_value := jai_cmn_hook_pkg.Ja_In_po_line_locations_all(
7900: po_line_loc_rec.LINE_LOCATION_ID ,
7901: po_line_loc_rec.PO_HEADER_ID ,
7902: po_line_loc_rec.PO_LINE_ID ,
7903: po_line_loc_rec.QUANTITY ,

Line 8288: v_price_override PO_LINE_LOCATIONS_ALL.price_override%TYPE;

8284: v_inventory_org_id HR_LOCATIONS.Inventory_Organization_Id%TYPE;
8285: v_line_loc_cnt NUMBER;
8286: v_ship_to_organization_id NUMBER;
8287: v_ship_to_location_id NUMBER;
8288: v_price_override PO_LINE_LOCATIONS_ALL.price_override%TYPE;
8289: v_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;
8290: v_line_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE;
8291: v_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
8292: v_quot_class_code PO_HEADERS_ALL.quotation_class_code%TYPE;

Line 8289: v_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;

8285: v_line_loc_cnt NUMBER;
8286: v_ship_to_organization_id NUMBER;
8287: v_ship_to_location_id NUMBER;
8288: v_price_override PO_LINE_LOCATIONS_ALL.price_override%TYPE;
8289: v_unit_meas_lookup_code PO_LINE_LOCATIONS_ALL.unit_meas_lookup_code%TYPE;
8290: v_line_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE;
8291: v_type_lookup_code PO_HEADERS_ALL.type_lookup_code%TYPE;
8292: v_quot_class_code PO_HEADERS_ALL.quotation_class_code%TYPE;
8293:

Line 8413: Po_Line_Locations_All

8409: lv_tax_modified_flag VARCHAR2(1) ;
8410:
8411: CURSOR c_get_po_line_loc IS
8412: SELECT * FROM
8413: Po_Line_Locations_All
8414: WHERE LINE_LOCATION_ID = prec_po_req_line.Line_Location_Id;
8415:
8416: prec_po_location Po_Line_Locations_All%ROWTYPE;
8417: tax_cnt NUMBER;

Line 8416: prec_po_location Po_Line_Locations_All%ROWTYPE;

8412: SELECT * FROM
8413: Po_Line_Locations_All
8414: WHERE LINE_LOCATION_ID = prec_po_req_line.Line_Location_Id;
8415:
8416: prec_po_location Po_Line_Locations_All%ROWTYPE;
8417: tax_cnt NUMBER;
8418: l_api_name CONSTANT VARCHAR2(200) := 'copy_req_tax_to_po';
8419: BEGIN
8420: