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_LLA_TRIGGER_PKG dependencies on JAI_PO_LINE_LOCATIONS

Line 123: DELETE FROM JAI_PO_LINE_LOCATIONS

119: -- p_set_of_books_id => v_gl_set_of_bks_id) = FALSE THEN
120: -- RETURN;
121: -- END IF;
122:
123: DELETE FROM JAI_PO_LINE_LOCATIONS
124: WHERE Line_Location_Id = v_po_line_loc_id;
125:
126: DELETE FROM JAI_PO_TAXES
127: WHERE Line_Location_Id = v_po_line_loc_id;

Line 255: FROM JAI_PO_LINE_LOCATIONS

251: ORDER BY a.tax_line_no;
252:
253: CURSOR Fetch_Line_Focus_Id_Cur IS
254: SELECT Line_Focus_Id
255: FROM JAI_PO_LINE_LOCATIONS
256: WHERE Po_Line_Id = v_po_line_id
257: AND Line_Location_Id = v_line_loc_id;
258:
259: CURSOR Fetch_UOMCode_Cur( v_temp_uom IN VARCHAR2 ) IS

Line 266: FROM JAI_PO_LINE_LOCATIONS

262: WHERE Unit_Of_Measure = v_temp_uom;
263:
264: CURSOR Fetch_Count_Cur IS
265: SELECT COUNT(Line_Location_Id)
266: FROM JAI_PO_LINE_LOCATIONS
267: WHERE Po_Header_Id = v_quot_from_hdr_id;
268:
269: -- Vijay Shankar for Bug# 3184418
270: v_tax_modified_flag CHAR(1);

Line 273: FROM JAI_PO_LINE_LOCATIONS

269: -- Vijay Shankar for Bug# 3184418
270: v_tax_modified_flag CHAR(1);
271: CURSOR c_tax_modified_flag(p_line_location_id IN NUMBER) IS
272: SELECT tax_modified_flag
273: FROM JAI_PO_LINE_LOCATIONS
274: WHERE line_location_id = p_line_location_id;
275:
276: /*Bug 8586635 - Start*/
277: CURSOR c_get_po_taxes (p_line_location_id IN NUMBER) IS

Line 284: FROM JAI_PO_LINE_LOCATIONS

280: WHERE line_location_id = p_line_location_id;
281:
282: CURSOR c_get_po_line_loc_details (p_line_location_id IN NUMBER) IS
283: SELECT *
284: FROM JAI_PO_LINE_LOCATIONS
285: WHERE line_location_id = p_line_location_id;
286:
287: r_get_po_taxes c_get_po_taxes%ROWTYPE;
288: r_get_po_line_loc_details c_get_po_line_loc_details%ROWTYPE;

Line 372: and the tax amounts are updated in JAI_PO_LINE_LOCATIONS

368:
369: 14. 08-Jul-2009 Bug 8586635
370: Description: When the Shipment Lines are split in iSupplier, the appropriate Taxes are not updated
371: Fix: Tax Lines are inserted into jai_po_taxes on a prorated basis
372: and the tax amounts are updated in JAI_PO_LINE_LOCATIONS
373:
374: 15. 14-Aug-2009 Jia for bug#8745089 and bug#8765528.
375: Issue: Create a new quotations or a BPA Release with incorrect price list successfully
376: Fix: Add Item_UOM validation that is advanced pricing enhancement for quotation and Blanket.

Line 579: /Insert into JAI_PO_LINE_LOCATIONS/

575: AND r_get_po_line_loc_details.po_line_id = v_po_line_id THEN
576:
577: /*Get the Quantity of the parent Line in an Autonomous Transaction*/
578: ja_in_po_get_lineloc_p (v_orig_ship_id, l_prev_quantity);
579: /*Insert into JAI_PO_LINE_LOCATIONS*/
580: jai_po_cmn_pkg.insert_line
581: ( v_type_lookup_code,
582: v_line_loc_id,
583: r_get_po_line_loc_details.po_header_id,

Line 594: from JAI_PO_LINE_LOCATIONS

590: 'I'
591: );
592:
593: select line_focus_id into l_line_focus_id
594: from JAI_PO_LINE_LOCATIONS
595: where line_location_id = v_line_loc_id;
596: /*Insert Taxes of the parent line in to the split line after adjusting the Tax Amount and Tax Target Amount*/
597: for r_get_po_taxes in c_get_po_taxes(v_orig_ship_id) loop
598:

Line 624: UPDATE JAI_PO_LINE_LOCATIONS

620: where line_location_id = v_line_loc_id;
621:
622: l_ship_line_amount := v_qty * v_price;
623:
624: UPDATE JAI_PO_LINE_LOCATIONS
625: SET tax_modified_flag = 'N',
626: tax_amount = l_tax_amount,
627: total_amount = l_ship_line_amount + l_tax_amount,
628: tax_category_id = r_get_po_taxes.tax_category_id

Line 976: l_total_tax_amount JAI_PO_LINE_LOCATIONS.TAX_AMOUNT%TYPE;

972: line_location_id = v_line_loc_id AND
973: tax_type <> jai_constants.tax_type_tds ; /*'TDS';Ramananda for removal of SQL LITERALs */
974:
975: cur_rec_get_total REC_CALC_TOTAL_TAX%ROWTYPE;
976: l_total_tax_amount JAI_PO_LINE_LOCATIONS.TAX_AMOUNT%TYPE;
977:
978: -- END of bug 3037284
979:
980: CURSOR check_rfq_quot_cur

Line 1023: JAI_PO_LINE_LOCATIONS

1019: IS
1020: SELECT
1021: NVL( Tax_Modified_Flag, 'N' )
1022: FROM
1023: JAI_PO_LINE_LOCATIONS
1024: WHERE
1025: Po_Line_Id = v_po_line_id AND
1026: Line_Location_Id = v_line_loc_id;
1027:

Line 1057: JAI_PO_LINE_LOCATIONS

1053: IS
1054: SELECT
1055: nvl(1,0)
1056: FROM
1057: JAI_PO_LINE_LOCATIONS
1058: WHERE
1059: po_line_id = v_po_line_id AND
1060: Line_Location_Id = v_line_loc_id;
1061:

Line 1136: the lines from JAI_PO_TAXES and JAI_PO_LINE_LOCATIONS are deleted.

1132: ------------------------------------------------------------------------------------------
1133: 1. 14/08/2003 Aiyer , Bug #3037284 ,File version 616.1
1134: Changed the triggering condition to fire when cancel_flag is 'Y'.
1135: In case of full cancellation of a Purchase order line (no receipt done),
1136: the lines from JAI_PO_TAXES and JAI_PO_LINE_LOCATIONS are deleted.
1137: In case of partial cancellation of purchase order line, apportion the tax amount
1138: in the ratio of quantity_received to original line quantity i.e quantity_received/quantity
1139: in table JAI_PO_TAXES.
1140: Calculate the tax_amount in the table JAI_PO_LINE_LOCATIONS as a sum of all records

Line 1140: Calculate the tax_amount in the table JAI_PO_LINE_LOCATIONS as a sum of all records

1136: the lines from JAI_PO_TAXES and JAI_PO_LINE_LOCATIONS are deleted.
1137: In case of partial cancellation of purchase order line, apportion the tax amount
1138: in the ratio of quantity_received to original line quantity i.e quantity_received/quantity
1139: in table JAI_PO_TAXES.
1140: Calculate the tax_amount in the table JAI_PO_LINE_LOCATIONS as a sum of all records
1141: in the table JAI_PO_TAXES for that line_locations_id excluding 'TDS'
1142: type of taxes.
1143: The total amount in JAI_PO_LINE_LOCATIONS is calculated as
1144: (po_line_locations_all.quantity_received * po_line_locations_all.price_override)

Line 1143: The total amount in JAI_PO_LINE_LOCATIONS is calculated as

1139: in table JAI_PO_TAXES.
1140: Calculate the tax_amount in the table JAI_PO_LINE_LOCATIONS as a sum of all records
1141: in the table JAI_PO_TAXES for that line_locations_id excluding 'TDS'
1142: type of taxes.
1143: The total amount in JAI_PO_LINE_LOCATIONS is calculated as
1144: (po_line_locations_all.quantity_received * po_line_locations_all.price_override)
1145: +
1146: sum of all taxes from JAI_PO_TAXES for that line_location_id .
1147:

Line 1467: then delete the line and associated taxes from JAI_PO_LINE_LOCATIONS

1463: IF nvl(pr_old.cancel_flag,'N') <> 'Y' AND nvl(pr_new.cancel_flag,'N') = 'Y' THEN
1464: IF nvl(v_quantity_cancelled,-9999) = nvl(v_qty,0) THEN
1465: /*
1466: Indicating that the entire line has been cancelled and no receipt has been made for ths line,
1467: then delete the line and associated taxes from JAI_PO_LINE_LOCATIONS
1468: and JAI_PO_TAXES and return .
1469: */
1470: DELETE
1471: JAI_PO_TAXES

Line 1478: JAI_PO_LINE_LOCATIONS

1474: po_line_id = v_po_line_id AND
1475: po_header_id = v_po_hdr_id;
1476:
1477: DELETE
1478: JAI_PO_LINE_LOCATIONS
1479: WHERE
1480: po_line_id = v_po_line_id AND
1481: po_header_id = v_po_hdr_id AND
1482: line_location_id = v_line_loc_id;

Line 1488: Now in this scenario update the line and the associated apportioned taxes in the table JAI_PO_LINE_LOCATIONS

1484: ELSIF nvl(v_quantity_cancelled,-9999) < nvl(v_qty,0) THEN
1485: /*
1486: Indicating that a partial receipt has been made for the line and then the line has been cancelled.
1487: In such a case the cancelled quantity would be lesser than the quantity in table po_line_locations_all.
1488: Now in this scenario update the line and the associated apportioned taxes in the table JAI_PO_LINE_LOCATIONS
1489: and JAI_PO_TAXES
1490: */
1491:
1492: /*

Line 1525: JAI_PO_LINE_LOCATIONS

1521: FETCH rec_calc_total_tax INTO l_total_tax_amount;
1522: CLOSE rec_calc_total_tax;
1523:
1524: UPDATE
1525: JAI_PO_LINE_LOCATIONS
1526: SET
1527: tax_amount = l_total_tax_amount ,
1528: total_amount = nvl(pr_new.quantity_received * pr_new.price_override, 0) + nvl(l_total_tax_amount,0)
1529: WHERE

Line 1819: DELETE FROM JAI_PO_LINE_LOCATIONS

1815: DELETE FROM JAI_PO_TAXES
1816: WHERE Po_Line_Id = v_po_line_id
1817: AND NVL( Line_Location_Id, - 999 ) = NVL( v_line_loc_id, -999 );
1818:
1819: DELETE FROM JAI_PO_LINE_LOCATIONS
1820: WHERE Po_Line_Id = v_po_line_id
1821: AND NVL( Line_Location_Id, - 999 ) = NVL( v_line_loc_id, -999 );
1822:
1823: x := v_line_loc_id;

Line 1937: UPDATE JAI_PO_LINE_LOCATIONS

1933: ELSE
1934: v_tot_amt := v_tax_amt + ( v_qty * v_price );
1935: END IF;
1936:
1937: UPDATE JAI_PO_LINE_LOCATIONS
1938: SET Tax_Amount = v_tax_amt,
1939: Total_Amount = v_tot_amt,
1940: Last_Updated_By = v_last_upd_by,
1941: Last_Update_Date = v_last_upd_dt,