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_LINES_ALL

Line 537: REM prec_po_line IN PO_LINES_ALL%ROWTYPE N PO Line info.

533: REM Assumptions :
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

Line 545: ,prec_po_line IN PO_LINES_ALL%ROWTYPE DEFAULT NULL

541: REM process_po, process_po_line, process_po_shipment_line
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

Line 552: v_po_hdr_id PO_LINES_ALL.po_header_id%type;

548: )
549: IS
550: l_api_name CONSTANT VARCHAR2(30) := 'process_po_tax_wrapper';
551:
552: v_po_hdr_id PO_LINES_ALL.po_header_id%type;
553: v_po_line_id PO_LINES_ALL.po_line_id%type;
554: v_item_id PO_LINES_ALL.item_id%type;
555: v_from_line_id PO_LINES_ALL.from_line_id%type;
556: v_uom_measure PO_LINES_ALL.Unit_Meas_Lookup_Code%type;

Line 553: v_po_line_id PO_LINES_ALL.po_line_id%type;

549: IS
550: l_api_name CONSTANT VARCHAR2(30) := 'process_po_tax_wrapper';
551:
552: v_po_hdr_id PO_LINES_ALL.po_header_id%type;
553: v_po_line_id PO_LINES_ALL.po_line_id%type;
554: v_item_id PO_LINES_ALL.item_id%type;
555: v_from_line_id PO_LINES_ALL.from_line_id%type;
556: v_uom_measure PO_LINES_ALL.Unit_Meas_Lookup_Code%type;
557: v_cre_dt PO_LINES_ALL.Creation_Date%type;

Line 554: v_item_id PO_LINES_ALL.item_id%type;

550: l_api_name CONSTANT VARCHAR2(30) := 'process_po_tax_wrapper';
551:
552: v_po_hdr_id PO_LINES_ALL.po_header_id%type;
553: v_po_line_id PO_LINES_ALL.po_line_id%type;
554: v_item_id PO_LINES_ALL.item_id%type;
555: v_from_line_id PO_LINES_ALL.from_line_id%type;
556: v_uom_measure PO_LINES_ALL.Unit_Meas_Lookup_Code%type;
557: v_cre_dt PO_LINES_ALL.Creation_Date%type;
558: v_cre_by PO_LINES_ALL.Created_By%type;

Line 555: v_from_line_id PO_LINES_ALL.from_line_id%type;

551:
552: v_po_hdr_id PO_LINES_ALL.po_header_id%type;
553: v_po_line_id PO_LINES_ALL.po_line_id%type;
554: v_item_id PO_LINES_ALL.item_id%type;
555: v_from_line_id PO_LINES_ALL.from_line_id%type;
556: v_uom_measure PO_LINES_ALL.Unit_Meas_Lookup_Code%type;
557: v_cre_dt PO_LINES_ALL.Creation_Date%type;
558: v_cre_by PO_LINES_ALL.Created_By%type;
559: v_last_upd_dt PO_LINES_ALL.Last_Update_Date%type;

Line 556: v_uom_measure PO_LINES_ALL.Unit_Meas_Lookup_Code%type;

552: v_po_hdr_id PO_LINES_ALL.po_header_id%type;
553: v_po_line_id PO_LINES_ALL.po_line_id%type;
554: v_item_id PO_LINES_ALL.item_id%type;
555: v_from_line_id PO_LINES_ALL.from_line_id%type;
556: v_uom_measure PO_LINES_ALL.Unit_Meas_Lookup_Code%type;
557: v_cre_dt PO_LINES_ALL.Creation_Date%type;
558: v_cre_by PO_LINES_ALL.Created_By%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;

Line 557: v_cre_dt PO_LINES_ALL.Creation_Date%type;

553: v_po_line_id PO_LINES_ALL.po_line_id%type;
554: v_item_id PO_LINES_ALL.item_id%type;
555: v_from_line_id PO_LINES_ALL.from_line_id%type;
556: v_uom_measure PO_LINES_ALL.Unit_Meas_Lookup_Code%type;
557: v_cre_dt PO_LINES_ALL.Creation_Date%type;
558: v_cre_by PO_LINES_ALL.Created_By%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;

Line 558: v_cre_by PO_LINES_ALL.Created_By%type;

554: v_item_id PO_LINES_ALL.item_id%type;
555: v_from_line_id PO_LINES_ALL.from_line_id%type;
556: v_uom_measure PO_LINES_ALL.Unit_Meas_Lookup_Code%type;
557: v_cre_dt PO_LINES_ALL.Creation_Date%type;
558: v_cre_by PO_LINES_ALL.Created_By%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:

Line 559: v_last_upd_dt PO_LINES_ALL.Last_Update_Date%type;

555: v_from_line_id PO_LINES_ALL.from_line_id%type;
556: v_uom_measure PO_LINES_ALL.Unit_Meas_Lookup_Code%type;
557: v_cre_dt PO_LINES_ALL.Creation_Date%type;
558: v_cre_by PO_LINES_ALL.Created_By%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;

Line 560: v_last_upd_by PO_LINES_ALL.Last_Updated_By%type;

556: v_uom_measure PO_LINES_ALL.Unit_Meas_Lookup_Code%type;
557: v_cre_dt PO_LINES_ALL.Creation_Date%type;
558: v_cre_by PO_LINES_ALL.Created_By%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;

Line 561: v_last_upd_login PO_LINES_ALL.Last_Update_Login%type;

557: v_cre_dt PO_LINES_ALL.Creation_Date%type;
558: v_cre_by PO_LINES_ALL.Created_By%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;

Line 618: FROM PO_LINES_ALL

614: WHERE line_location_id = c_line_loc_id;
615:
616: CURSOR c_line_info (cn_po_line_id NUMBER)IS
617: SELECT item_id
618: FROM PO_LINES_ALL
619: WHERE po_line_id = cn_po_line_id;
620:
621: CURSOR c_old_qty(c_line_loc_id NUMBER) IS
622: SELECT quantity

Line 1029: po_lines_all pla, po_headers_all pha

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
1033: AND pla.po_line_id = plla.po_line_id

Line 1040: -- Cursor definition for picking po_line_id from po_lines_all

1036: AND pla.item_id = p_item_id
1037: AND plla.shipment_num = p_ship_num;*/
1038:
1039: /* move to function get_line_id since mutating error.
1040: -- Cursor definition for picking po_line_id from po_lines_all
1041: CURSOR fetch_line_id_cur IS
1042: SELECT pla.Po_Line_Id
1043: FROM po_lines_all pla, po_headers_all pha
1044: WHERE pha.Po_Header_Id = p_from_hdr_id

Line 1043: FROM po_lines_all pla, po_headers_all pha

1039: /* move to function get_line_id since mutating error.
1040: -- Cursor definition for picking po_line_id from po_lines_all
1041: CURSOR fetch_line_id_cur IS
1042: SELECT pla.Po_Line_Id
1043: FROM po_lines_all pla, po_headers_all pha
1044: WHERE pha.Po_Header_Id = p_from_hdr_id
1045: AND pla.line_num = p_line_num
1046: AND pha.po_header_id =pla.po_header_id;*/
1047:

Line 1367: v_item_id po_lines_all.item_id%TYPE;

1363:
1364: v_vendor_id po_headers_all.vendor_id%TYPE;
1365: v_vendor_site_id po_headers_all.vendor_site_id%TYPE;
1366: v_currency po_headers_all.currency_code%TYPE;
1367: v_item_id po_lines_all.item_id%TYPE;
1368: v_assessable_value NUMBER;
1369: v_vat_assess_value NUMBER;
1370: v_tax_category_id_holder JAI_PO_LINE_LOCATIONS.tax_category_id%TYPE;
1371:

Line 1422: FROM po_lines_all

1418: /* Replace it with separate function since trigger mutating
1419: CURSOR cur_item
1420: IS
1421: SELECT ITEM_ID
1422: FROM po_lines_all
1423: WHERE po_line_id = p_po_line_id;*/
1424:
1425: v_check_adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type;
1426: v_tax_amount NUMBER;

Line 1625: SELECT * FROM PO_LINES_ALL

1621: REM +================================================================================================+
1622: */
1623: PROCEDURE process_po (pn_header_id IN Number, pv_action IN VARCHAR2) IS
1624: CURSOR c_po_line IS
1625: SELECT * FROM PO_LINES_ALL
1626: WHERE Po_Header_Id = pn_header_id;
1627:
1628: CURSOR c_po_header IS
1629: SELECT * FROM PO_HEADERS_ALL

Line 1645: r_po_line PO_LINES_ALL%ROWTYPE;

1641: WHERE Po_Line_Id = line_id;
1642:
1643: l_api_name CONSTANT VARCHAR2(30) := 'process_po';
1644: lv_action VARCHAR2(10);
1645: r_po_line PO_LINES_ALL%ROWTYPE;
1646: r_po_header PO_HEADERS_ALL%ROWTYPE;
1647:
1648: v_old_currency PO_HEADERS_ALL.currency_code%TYPE;
1649: v_old_vendor_id PO_HEADERS_ALL.vendor_id%TYPE;

Line 1894: SELECT * FROM PO_LINES_ALL

1890: v_Last_Upd_Login Number;
1891: v_src_line_id NUMBER;
1892:
1893: CURSOR c_po_line IS
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

Line 1928: -- Cursor definition for picking po_line_id from po_lines_all

1924: FROM PO_HEADERS_ALL
1925: WHERE po_header_id = cn_po_hdr_id;
1926:
1927:
1928: -- Cursor definition for picking po_line_id from po_lines_all
1929: CURSOR fetch_line_id_cur(p_from_hdr_id NUMBER, p_line_num NUMBER) IS
1930: SELECT pla.Po_Line_Id
1931: FROM po_lines_all pla, po_headers_all pha
1932: WHERE pha.Po_Header_Id = p_from_hdr_id

Line 1931: FROM po_lines_all pla, po_headers_all pha

1927:
1928: -- Cursor definition for picking po_line_id from po_lines_all
1929: CURSOR fetch_line_id_cur(p_from_hdr_id NUMBER, p_line_num NUMBER) IS
1930: SELECT pla.Po_Line_Id
1931: FROM po_lines_all pla, po_headers_all pha
1932: WHERE pha.Po_Header_Id = p_from_hdr_id
1933: AND pla.line_num = p_line_num
1934: AND pha.po_header_id =pla.po_header_id;
1935:

Line 1937: r_po_line PO_LINES_ALL%ROWTYPE;

1933: AND pla.line_num = p_line_num
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

Line 1960: v_hook_value := jai_cmn_hook_pkg.Ja_In_po_lines_all(

1956: v_qty := r_po_line.QUANTITY;
1957: v_line_uom := r_po_line.Unit_Meas_Lookup_Code;
1958: v_hook_value := 'TRUE';
1959:
1960: v_hook_value := jai_cmn_hook_pkg.Ja_In_po_lines_all(
1961: r_po_line.PO_LINE_ID ,
1962: r_po_line.PO_HEADER_ID ,
1963: r_po_line.LINE_TYPE_ID ,
1964: r_po_line.LINE_NUM ,

Line 2203: REM pr_po_line IN PO_LINES_ALL%ROWTYPE N PO line info.

2199: REM Parameter IN/OUT Type Required Description and Purpose
2200: REM -------------------- ------ ------------------------ ---------- ------------------------------------
2201: REM pn_line_loc_id IN NUMBER Y Indiate which PO shipment line is processed.
2202: REM pr_po_header IN PO_HEADERS_ALL%ROWTYPE N PO header info.
2203: REM pr_po_line IN PO_LINES_ALL%ROWTYPE N PO line info.
2204: REM pv_action IN VARCHAR2 Y Indiate action is inserting/updating.
2205: REM CALLED BY
2206: REM jai_po_proc_pkg.process_po
2207: REM +=========================================================================================================+

Line 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

2205: REM CALLED BY
2206: REM jai_po_proc_pkg.process_po
2207: REM +=========================================================================================================+
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;

Line 2253: v_line_num PO_LINES_ALL.line_num%TYPE;

2249: v_service_type_code VARCHAR2(30);
2250: v_count NUMBER;
2251:
2252: v_item_id NUMBER;
2253: v_line_num PO_LINES_ALL.line_num%TYPE;
2254: v_style_id NUMBER;
2255:
2256: v_q_line_id NUMBER;
2257: v_hook_value VARCHAR2(10);

Line 2286: FROM PO_LINES_ALL

2282: WHERE po_header_id = cn_po_hdr_id;
2283:
2284: CURSOR c_po_line(cn_po_line_id NUMBER) IS
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

Line 2293: po_lines_all pla, po_headers_all pha

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
2297: AND pla.po_line_id = plla.po_line_id

Line 2304: r_po_line PO_LINES_ALL%ROWTYPE;

2300: AND pla.item_id = p_item_id
2301: AND plla.shipment_num = p_ship_num;
2302:
2303: r_po_header PO_HEADERS_ALL%ROWTYPE;
2304: r_po_line PO_LINES_ALL%ROWTYPE;
2305:
2306: BEGIN
2307:
2308: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 4481: FROM Po_Lines_All

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);
4484:
4485:

Line 4862: v_line_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE;

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:
4866:

Line 4869: FROM Po_Lines_All

4865:
4866:
4867: CURSOR Fetch_Unit_Measure_Cur IS
4868: SELECT Unit_Meas_Lookup_Code
4869: FROM Po_Lines_All
4870: WHERE Po_Line_Id = v_po_line_id;
4871:
4872: CURSOR Fetch_UomCode_Cur(p_uom IN VARCHAR2) IS
4873: SELECT Uom_Code

Line 5740: FROM Po_Lines_All

5736: AND line_location_id=p_line_loc_id;
5737:
5738: CURSOR Fetch_Lineid_Cur IS
5739: SELECT Po_Line_Id, Unit_Price, Unit_Meas_Lookup_Code, Item_Id
5740: FROM Po_Lines_All
5741: WHERE Po_Line_Id = p_line_id;
5742:
5743: CURSOR Fetch_UOMCode_Cur( uom IN VARCHAR2 ) IS
5744: SELECT Uom_Code

Line 5761: FROM Po_Lines_All

5757: WHERE Po_Header_Id = v_po_hdr_id;
5758:
5759: CURSOR Get_Item_Id_Cur IS
5760: SELECT Item_Id
5761: FROM Po_Lines_All
5762: WHERE Po_Line_Id = v_po_line_id;
5763:
5764:
5765: CURSOR c_line_tax_category_id_1(p_po_line_id IN NUMBER) IS

Line 5802: FROM Po_Lines_All

5798:
5799: /* Fetch Cumulative pricing flag */
5800: CURSOR Fetch_Cum_Pr_Cur( line_id IN NUMBER) IS
5801: SELECT Price_Break_Lookup_Code
5802: FROM Po_Lines_All
5803: WHERE Po_Line_Id = line_id;
5804:
5805: CURSOR tax_override_flag_cur(c_vendor_id NUMBER, c_vendor_site_id NUMBER) IS
5806: SELECT override_flag

Line 6493: ,pr_po_line po_lines_all%ROWTYPE DEFAULT NULL

6489:
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;

Line 6498: ln_from_line_id po_lines_all.from_line_id%TYPE;

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;
6499: lb_related BOOLEAN := FALSE;
6500: CURSOR c_po_hdr(c_po_hdr_id NUMBER) IS
6501: SELECT * FROM
6502: PO_HEADERS_ALL

Line 6507: PO_LINES_ALL

6503: WHERE po_header_id = c_po_hdr_id;
6504:
6505: CURSOR c_po_line(c_po_line_id NUMBER) IS
6506: SELECT * FROM
6507: PO_LINES_ALL
6508: WHERE po_line_id = c_po_line_id;
6509:
6510: r_po_hdr po_headers_all%ROWTYPE;
6511: r_po_line po_lines_all%ROWTYPE;

Line 6511: r_po_line po_lines_all%ROWTYPE;

6507: PO_LINES_ALL
6508: WHERE po_line_id = c_po_line_id;
6509:
6510: r_po_hdr po_headers_all%ROWTYPE;
6511: r_po_line po_lines_all%ROWTYPE;
6512: l_api_name CONSTANT VARCHAR2(30) := 'ref_quotation_related';
6513: BEGIN
6514:
6515: IF (g_level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 6566: PROCEDURE process_quotation_line(r_old_po_line po_lines_all%ROWTYPE DEFAULT NULL ,r_po_line PO_LINES_ALL%ROWTYPE , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS

6562: END IF;
6563:
6564: RETURN lb_related;
6565: END rfq_quotation_related;
6566: PROCEDURE process_quotation_line(r_old_po_line po_lines_all%ROWTYPE DEFAULT NULL ,r_po_line PO_LINES_ALL%ROWTYPE , pv_action varchar2 , pv_return_code out nocopy varchar2 , pv_return_message out nocopy varchar2 ) IS
6567: v_po_line_id NUMBER;
6568: v_po_hdr_id NUMBER;
6569: v_frm_hdr_id NUMBER;
6570: v_frm_po_line_id NUMBER;

Line 6637: v_hook_value := jai_cmn_hook_pkg.Ja_In_po_lines_all(

6633: v_qty := r_po_line.QUANTITY;
6634: v_line_uom := r_po_line.Unit_Meas_Lookup_Code;
6635: v_hook_value := 'TRUE';
6636:
6637: v_hook_value := jai_cmn_hook_pkg.Ja_In_po_lines_all(
6638: r_po_line.PO_LINE_ID ,
6639: r_po_line.PO_HEADER_ID ,
6640: r_po_line.LINE_TYPE_ID ,
6641: r_po_line.LINE_NUM ,

Line 6865: v_line_num PO_LINES_ALL.line_num%TYPE;

6861: v_service_type_code VARCHAR2(30);
6862: v_count NUMBER;
6863:
6864: v_item_id NUMBER;
6865: v_line_num PO_LINES_ALL.line_num%TYPE;
6866: v_style_id NUMBER;
6867: v_hook_value VARCHAR2(10);
6868: v_src_loc_id NUMBER;
6869: v_src_line_id NUMBER;

Line 6882: FROM PO_LINES_ALL

6878: WHERE unit_of_measure = v_uom_measure;
6879:
6880: CURSOR c_po_line(cn_po_line_id NUMBER) IS
6881: SELECT *
6882: FROM PO_LINES_ALL
6883: WHERE po_line_id = cn_po_line_id;
6884:
6885: CURSOR Fetch_Count_Cur (cn_po_hdr_id NUMBER)IS
6886: SELECT COUNT(Line_Location_Id)

Line 6891: r_po_line PO_LINES_ALL%ROWTYPE;

6887: FROM JAI_PO_LINE_LOCATIONS
6888: WHERE Po_Header_Id = cn_po_hdr_id ;
6889:
6890: r_po_header PO_HEADERS_ALL%ROWTYPE;
6891: r_po_line PO_LINES_ALL%ROWTYPE;
6892:
6893: l_api_name CONSTANT VARCHAR2(30) := 'process_quotation_line_loc';
6894: BEGIN
6895: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 7181: SELECT * FROM PO_LINES_ALL

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
7182: WHERE PO_LINE_ID = cn_po_line_id;
7183:
7184: CURSOR Fetch_UOMCode_Cur( c_uom IN VARCHAR2 ) IS
7185: SELECT Uom_Code

Line 7196: r_po_line PO_LINES_ALL%ROWTYPE;

7192: WHERE vendor_id = c_supplier_id
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;

Line 7338: po_lines_all pla, po_headers_all pha

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
7342: pla.po_line_id = plla.po_line_id AND pha.po_header_id = p_from_hdr_id AND

Line 7375: FROM po_lines_all pla, po_headers_all pha

7371: ) RETURN NUMBER IS
7372: PRAGMA AUTONOMOUS_TRANSACTION;
7373: CURSOR fetch_line_id_cur IS
7374: SELECT pla.Po_Line_Id
7375: FROM po_lines_all pla, po_headers_all pha
7376: WHERE pha.Po_Header_Id = p_from_hdr_id
7377: AND pla.line_num = p_line_num
7378: AND pha.po_header_id =pla.po_header_id;
7379: l_api_name CONSTANT VARCHAR2(30) := 'get_line_id';

Line 7425: v_cum_flag Po_Lines_All.Price_Break_Lookup_Code % TYPE;

7421: -- there are multiple price break lines for the specified p_line_id or p_line_num of p_header_id
7422:
7423: i NUMBER := 1;
7424: v_po_line_id NUMBER;
7425: v_cum_flag Po_Lines_All.Price_Break_Lookup_Code % TYPE;
7426: v_quantity NUMBER; -- := p_line_quantity; --Ramananda for File.Sql.35
7427: v_qty NUMBER;
7428: v_count NUMBER;
7429:

Line 7446: FROM Po_Lines_All

7442: ORDER BY Quantity;
7443:
7444: CURSOR Fetch_Line_Id_Cur IS
7445: SELECT Po_Line_Id, NVL( Price_Break_Lookup_Code, 'NC' ) Price_Break_Lookup_Code
7446: FROM Po_Lines_All
7447: WHERE Po_Header_Id = p_header_id
7448: AND Line_Num = p_line_num;
7449:
7450: CURSOR Fetch_Line1_Id_Cur IS

Line 7452: FROM Po_Lines_All

7448: AND Line_Num = p_line_num;
7449:
7450: CURSOR Fetch_Line1_Id_Cur IS
7451: SELECT NVL( Price_Break_Lookup_Code, 'NC' ) Price_Break_Lookup_Code
7452: FROM Po_Lines_All
7453: WHERE Po_Line_Id = p_line_id;
7454:
7455: CURSOR Fetch_Cum_Qty_Cur IS
7456: SELECT SUM( Quantity )

Line 7855: v_line_num PO_LINES_ALL.line_num%TYPE;

7851: v_service_type_code VARCHAR2(30);
7852: v_count NUMBER;
7853:
7854: v_item_id NUMBER;
7855: v_line_num PO_LINES_ALL.line_num%TYPE;
7856: v_style_id NUMBER;
7857: v_hook_value VARCHAR2(10);
7858: v_src_loc_id NUMBER;
7859: v_src_line_id NUMBER;

Line 7875: FROM PO_LINES_ALL

7871: WHERE unit_of_measure = v_uom_measure;
7872:
7873: CURSOR c_po_line(cn_po_line_id NUMBER) IS
7874: SELECT *
7875: FROM PO_LINES_ALL
7876: WHERE po_line_id = cn_po_line_id;
7877:
7878: CURSOR Fetch_Count_Cur (cn_po_hdr_id NUMBER)IS
7879: SELECT COUNT(Line_Location_Id)

Line 7890: r_po_line PO_LINES_ALL%ROWTYPE;

7886: WHERE line_location_id = p_line_location_id;
7887:
7888:
7889: r_po_header PO_HEADERS_ALL%ROWTYPE;
7890: r_po_line PO_LINES_ALL%ROWTYPE;
7891: r_get_po_line_loc_details JAI_PO_LINE_LOCATIONS%ROWTYPE;
7892: l_api_name CONSTANT VARCHAR2(30) := 'process_quotation_line_loc';
7893: BEGIN
7894: IF ( G_LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 8290: v_line_uom PO_LINES_ALL.unit_meas_lookup_code%TYPE;

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:
8294:

Line 8297: FROM Po_Lines_All

8293:
8294:
8295: CURSOR Fetch_Unit_Measure_Cur IS
8296: SELECT Unit_Meas_Lookup_Code
8297: FROM Po_Lines_All
8298: WHERE Po_Line_Id = v_po_line_id;
8299:
8300: CURSOR Fetch_UomCode_Cur(p_uom IN VARCHAR2) IS
8301: SELECT Uom_Code