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_TAXES

Line 126: DELETE FROM JAI_PO_TAXES

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;
128: END ARD_T1 ;
129:
130: /*

Line 248: FROM JAI_PO_TAXES a

244: CURSOR tax_cur IS
245: SELECT a.Po_Line_Id, a.tax_line_no lno, a.tax_id,
246: a.precedence_1 p_1, a.precedence_2 p_2, a.precedence_3 p_3, a.precedence_4 p_4, a.precedence_5 p_5,
247: a.currency, a.tax_rate, a.qty_rate, a.uom, a.tax_amount, a.tax_type, a.vendor_id, a.modvat_flag
248: FROM JAI_PO_TAXES a
249: WHERE NVL( a.line_location_id, -999 ) = DECODE( v_quot_line_loc_id, -999, -999, v_quot_line_loc_id )
250: AND Po_Line_Id = v_from_line_id
251: ORDER BY a.tax_line_no;
252:

Line 279: FROM JAI_PO_TAXES

275:
276: /*Bug 8586635 - Start*/
277: CURSOR c_get_po_taxes (p_line_location_id IN NUMBER) IS
278: SELECT *
279: FROM JAI_PO_TAXES
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 *

Line 371: Fix: Tax Lines are inserted into jai_po_taxes on a prorated basis

367: Added the parameter pr_new.quantity to the call to jai_po_tax_pkg.Ja_In_Po_Case1 procedure
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

Line 619: from jai_po_taxes

615:
616: END LOOP;
617:
618: select sum(tax_amount) into l_tax_amount
619: from jai_po_taxes
620: where line_location_id = v_line_loc_id;
621:
622: l_ship_line_amount := v_qty * v_price;
623:

Line 957: JAI_PO_TAXES a ,

953: SELECT
954: nvl(a.tax_amount,0) tax_amount,
955: nvl(b.adhoc_flag, 'N') adhoc_flag
956: FROM
957: JAI_PO_TAXES a ,
958: JAI_CMN_TAXES_ALL b
959: WHERE
960: a.tax_id = b.tax_id AND
961: a.po_line_id = v_po_line_id AND

Line 968: FROM JAI_PO_TAXES

964:
965: CURSOR rec_calc_total_tax
966: IS
967: SELECT sum(tax_amount )
968: FROM JAI_PO_TAXES
969: WHERE
970: po_line_id = v_po_line_id AND
971: po_header_id = v_po_hdr_id AND
972: line_location_id = v_line_loc_id AND

Line 1034: JAI_PO_TAXES

1030: IS
1031: SELECT
1032: SUM( NVL( Tax_Amount, 0 ) )
1033: FROM
1034: JAI_PO_TAXES
1035: WHERE
1036: po_line_id = v_po_line_id AND
1037: line_location_id = v_line_loc_id AND
1038: tax_type <> jai_constants.tax_type_tds ; /*'TDS';Ramananda for removal of SQL LITERALs */

Line 1045: JAI_PO_TAXES

1041: IS
1042: SELECT
1043: sum( nvl( tax_amount, 0 ) )
1044: FROM
1045: JAI_PO_TAXES
1046: WHERE
1047: po_line_id = v_po_line_id AND
1048: line_location_id is null AND
1049: tax_type <> jai_constants.tax_type_tds ; /*'TDS';Ramananda for removal of SQL LITERALs */

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 1139: in table JAI_PO_TAXES.

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

Line 1141: in the table JAI_PO_TAXES for that line_locations_id excluding 'TDS'

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)
1145: +

Line 1146: sum of all taxes from JAI_PO_TAXES for that line_location_id .

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:
1148: 2 15/10/2003 Vijay Shankar for Bug #3184673, File version 618.1
1149: Adhoc taxes are not apportioned when quantity is changed which is handled with this bug.
1150: Code is added to update JAI_PO_TAXES tables based on old and new quantity for adhoc taxes

Line 1150: Code is added to update JAI_PO_TAXES tables based on old and new quantity for adhoc taxes

1146: sum of all taxes from JAI_PO_TAXES for that line_location_id .
1147:
1148: 2 15/10/2003 Vijay Shankar for Bug #3184673, File version 618.1
1149: Adhoc taxes are not apportioned when quantity is changed which is handled with this bug.
1150: Code is added to update JAI_PO_TAXES tables based on old and new quantity for adhoc taxes
1151:
1152: 3 29-Nov-2004 Sanjikum for 4035297. Version 115.1
1153: Changed the 'INR' check. Added the call to jai_cmn_utils_pkg.check_jai_exists
1154:

Line 1468: and JAI_PO_TAXES and return .

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
1472: WHERE

Line 1471: JAI_PO_TAXES

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
1472: WHERE
1473: line_location_id = v_line_loc_id AND
1474: po_line_id = v_po_line_id AND
1475: po_header_id = v_po_hdr_id;

Line 1489: and JAI_PO_TAXES

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: /*
1493: Update the JAI_PO_TAXES with the apportioned tax_amount

Line 1493: Update the JAI_PO_TAXES with the apportioned tax_amount

1489: and JAI_PO_TAXES
1490: */
1491:
1492: /*
1493: Update the JAI_PO_TAXES with the apportioned tax_amount
1494: The tax amounts are apportioned in a ratio of the (quantity_received\quantity)
1495: Only the taxes which have a adhoc flag set to 'N' can be apportioned.
1496: Taxes which have adhoc flag set to 'Y' would remain unaffected .
1497:

Line 1506: JAI_PO_TAXES

1502: -- following IF commented by Vijay Shankar for Bug #3184673
1503: -- IF cur_rec_get_tax_amount.adhoc_flag = 'N' THEN
1504:
1505: UPDATE
1506: JAI_PO_TAXES
1507: SET
1508: tax_amount = (nvl(v_quantity_received,0) / nvl(v_qty,1)) * nvl(cur_rec_get_tax_amount.tax_amount,0)
1509: WHERE
1510: CURRENT OF rec_get_tax_amount;

Line 1516: The record in ja_in_po_line_location has to be updated with the total of all taxes from JAI_PO_TAXES

1512: -- END IF;
1513: END LOOP;
1514:
1515: /*
1516: The record in ja_in_po_line_location has to be updated with the total of all taxes from JAI_PO_TAXES
1517: excluding the TDS type of taxes. The total_amount should be calculated as (quantity_received * price_override) + total of tax amount
1518: */
1519:
1520: OPEN rec_calc_total_tax ;

Line 1759: UPDATE JAI_PO_TAXES a

1755: IF v_old_qty IS NULL OR v_old_qty = 0 THEN
1756: v_old_qty := 1;
1757: END IF;
1758:
1759: UPDATE JAI_PO_TAXES a
1760: SET tax_amount = (tax_amount * pr_new.quantity/ v_old_qty ),
1761: tax_target_amount = (tax_target_amount * pr_new.quantity/ v_old_qty)
1762: WHERE line_location_id = v_line_loc_id
1763: AND EXISTS (select 1 from JAI_CMN_TAXES_ALL b where b.tax_id = a.tax_id and b.adhoc_flag = 'Y');

Line 1815: DELETE FROM JAI_PO_TAXES

1811:
1812:
1813: IF v_flag = 'N' OR retcode = FALSE THEN
1814:
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