APPS.JAI_RCV_TAX_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 59: v_loc_quantity po_line_locations_all.quantity % TYPE;

55: lv_object_name CONSTANT VARCHAR2(61) := 'jai_rcv_tax_pkg.default_taxes_onto_line';
56:
57: -- LAST MODIFIED BY SRIHARI on 25-JUN-2000
58: v_receipt_num rcv_shipment_headers.receipt_num % TYPE;
59: v_loc_quantity po_line_locations_all.quantity % TYPE;
60: v_cor_amount JAI_PO_LINE_LOCATIONS.tax_amount % TYPE;
61: -- v_form_id VARCHAR2(30); --File.Sql.35 Cbabu := 'JAINPORE';
62: v_chk_form VARCHAR2(30);
63: -- v_rowid JAI_CMN_LOCATORS_T.row_id % TYPE;

Line 988: of PO_LINES_ALL instead of PO_LINE_LOCATIONS_ALL. Code is modified to calculate

984: When a Receipt is made against a SCHEDULED Release (partial quantity) of
985: PLANNED PO, then taxes are calculated for whole of the PLANNED PO line quantity
986: instead of SCHEDULED Release quantity.
987: The issue is occuring because, precedence_0 is calculated as unit_price * quantity
988: of PO_LINES_ALL instead of PO_LINE_LOCATIONS_ALL. Code is modified to calculate
989: precedence_0 as PRICE_OVERRIDE * QUANTITY of PO_LINE_LOCATIONS_ALL instead of using
990: PO_LINES_ALL
991:
992: 16. 06/06/2003 Nagaraj.s for Bug #2991872. Version : 616.1

Line 989: precedence_0 as PRICE_OVERRIDE * QUANTITY of PO_LINE_LOCATIONS_ALL instead of using

985: PLANNED PO, then taxes are calculated for whole of the PLANNED PO line quantity
986: instead of SCHEDULED Release quantity.
987: The issue is occuring because, precedence_0 is calculated as unit_price * quantity
988: of PO_LINES_ALL instead of PO_LINE_LOCATIONS_ALL. Code is modified to calculate
989: precedence_0 as PRICE_OVERRIDE * QUANTITY of PO_LINE_LOCATIONS_ALL instead of using
990: PO_LINES_ALL
991:
992: 16. 06/06/2003 Nagaraj.s for Bug #2991872. Version : 616.1
993: Code is added to ensure that if Assessable price is defined for Excise Taxes, then

Line 994: the Assessable Price is picked up instead of the unit price from po_line_locations_all

990: PO_LINES_ALL
991:
992: 16. 06/06/2003 Nagaraj.s for Bug #2991872. Version : 616.1
993: Code is added to ensure that if Assessable price is defined for Excise Taxes, then
994: the Assessable Price is picked up instead of the unit price from po_line_locations_all
995: table.
996:
997: 17. 21/07/2003 Vijay Shankar for Bug# 3028040, Version : 616.2
998: Code is added to check for EXPRESS transaction and then stop 'For Passing' to fire for every RECEIVE transaction

Line 1612: FROM po_line_locations_all plla,

1608: IF p_source_document_code = 'PO' THEN
1609: --Changed by Nagaraj.s for Bug2531667
1610: FOR ll_rec IN (SELECT plla.unit_meas_lookup_code ll_uom,
1611: pla.unit_meas_lookup_code l_uom
1612: FROM po_line_locations_all plla,
1613: po_lines_all pla
1614: WHERE plla.line_location_id = p_line_location_id
1615: AND pla.po_header_id = plla.po_header_id
1616: AND pla.po_line_id = p_po_line_id)

Line 1796: FROM po_line_locations_all

1792:
1793: -------------------------- To retrieve po quantity -------------------------------------
1794:
1795: FOR qty_rec IN (SELECT quantity
1796: FROM po_line_locations_all
1797: WHERE line_location_id = p_line_location_id)
1798: LOOP
1799: v_loc_quantity := qty_rec.quantity;
1800: END LOOP;

Line 2233: FROM po_line_locations_all

2229: IF p_source_document_code = 'PO' AND lv_asbn_type <> 'TRUE'
2230: THEN
2231: SELECT price_override , quantity
2232: INTO v_price_override,v_po_quantity
2233: FROM po_line_locations_all
2234: WHERE line_location_id = p_line_location_id;
2235: ELSIF p_source_document_code = 'PO' AND lv_asbn_type = 'TRUE'
2236: THEN
2237: v_po_quantity := r_jai_cmn_lines.quantity;