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_CMN_MTAX_PKG dependencies on JAI_PO_TAXES

Line 392: FROM JAI_PO_TAXES

388: ORDER BY a.line_no;
389:
390: CURSOR c_manual_taxes_up(p_line_location_id IN NUMBER, p_line_focus_id IN NUMBER) IS
391: SELECT rowid, tax_line_no
392: FROM JAI_PO_TAXES
393: WHERE line_focus_id = p_line_focus_id
394: AND tax_category_id IS NULL
395: ORDER BY tax_line_no;
396:

Line 1528: insert into JAI_PO_TAXES

1524:
1525: -- The adhoc data is preserved to capture the tax_amount later.
1526: -- added by Harshita for Bug #3765133
1527:
1528: insert into JAI_PO_TAXES
1529: (tax_line_no,po_line_id,po_header_id,
1530: line_focus_id,tax_id, tax_amount,
1531: creation_date,created_by,
1532: last_update_date, last_updated_by,last_update_login)

Line 1539: JAI_PO_TAXES A,

1535: -A.line_focus_id,A.tax_id, A.tax_amount,
1536: A.creation_date,A.created_by,
1537: A.last_update_date, A.last_updated_by,A.last_update_login
1538: FROM
1539: JAI_PO_TAXES A,
1540: JAI_CMN_TAXES_ALL B
1541: WHERE
1542: A.tax_id = B.tax_id AND
1543: line_focus_id = shipment_rec.line_focus_id AND

Line 1549: DELETE FROM JAI_PO_TAXES

1545:
1546: -- end, Harshita for Bug #3765133
1547:
1548: IF p_override_manual_taxes = 'Y' THEN
1549: DELETE FROM JAI_PO_TAXES
1550: WHERE line_focus_id = shipment_rec.line_focus_id;
1551:
1552: v_success := 5; -- means the override manual taxes is selected by user and all the attached taxes with the shipment are removed to default the new taxes
1553: ELSE

Line 1611: INSERT INTO JAI_PO_TAXES(

1607: ||', tax_rec.p_10 -> '||tax_rec.p_10 );
1608: END IF;
1609:
1610:
1611: INSERT INTO JAI_PO_TAXES(
1612: line_location_id, tax_line_no, po_line_id, po_header_id,
1613: precedence_1,
1614: precedence_2,
1615: precedence_3,

Line 1654: JAI_PO_TAXES a

1650: /* Harshita - Update the tax_amount in the latest records
1651: to the previous tax amounts for all adhoc tax types. -- Bug #3765133*/
1652:
1653: UPDATE
1654: JAI_PO_TAXES a
1655: SET
1656: tax_amount = (SELECT tax_amount
1657: FROM JAI_PO_TAXES
1658: where tax_id = a.tax_id

Line 1657: FROM JAI_PO_TAXES

1653: UPDATE
1654: JAI_PO_TAXES a
1655: SET
1656: tax_amount = (SELECT tax_amount
1657: FROM JAI_PO_TAXES
1658: where tax_id = a.tax_id
1659: and line_focus_id = -shipment_rec.line_focus_id)
1660: WHERE
1661: line_focus_id = shipment_rec.line_focus_id

Line 1663: FROM JAI_PO_TAXES

1659: and line_focus_id = -shipment_rec.line_focus_id)
1660: WHERE
1661: line_focus_id = shipment_rec.line_focus_id
1662: and tax_id in (SELECT tax_id
1663: FROM JAI_PO_TAXES
1664: where line_focus_id = -shipment_rec.line_focus_id);
1665:
1666: -- ended, Harshita for Bug #3765133
1667:

Line 1676: UPDATE JAI_PO_TAXES SET tax_line_no = j

1672: IF p_override_manual_taxes <> 'Y' THEN
1673: --* modifying the tax line number of the manual taxes starting from 1..n manual taxes *
1674: FOR tax_rec IN c_manual_taxes_up(v_line_location_id, shipment_rec.line_focus_id) LOOP
1675: j := j + 1;
1676: UPDATE JAI_PO_TAXES SET tax_line_no = j
1677: WHERE rowid = tax_rec.rowid;
1678: END LOOP;
1679: END IF;
1680:

Line 1787: DELETE FROM JAI_PO_TAXES

1783: END IF;
1784:
1785: --added, Harshita for Bug#3765133
1786: /* Temporary data stored previously will be flushed using following DELETE */
1787: DELETE FROM JAI_PO_TAXES
1788: WHERE line_focus_id = -shipment_rec.line_focus_id;
1789: --ended, Harshita for Bug#3765133
1790:
1791: ELSE -- IF v_dflt_tax_category_id IS NOT NULL THEN

Line 2092: insert into JAI_PO_TAXES

2088:
2089: -- The adhoc data is preserved to capture the tax_amount later.
2090: -- added by Harshita for Bug #3765133
2091:
2092: insert into JAI_PO_TAXES
2093: (tax_line_no,po_line_id,po_header_id,
2094: line_focus_id,tax_id, tax_amount,
2095: creation_date,created_by,
2096: last_update_date, last_updated_by,last_update_login)

Line 2103: JAI_PO_TAXES A,

2099: -A.line_focus_id,A.tax_id, A.tax_amount,
2100: A.creation_date,A.created_by,
2101: A.last_update_date, A.last_updated_by,A.last_update_login
2102: FROM
2103: JAI_PO_TAXES A,
2104: JAI_CMN_TAXES_ALL B
2105: WHERE
2106: A.tax_id = B.tax_id AND
2107: line_focus_id = releases_rec.line_focus_id AND

Line 2112: DELETE FROM JAI_PO_TAXES

2108: NVL(adhoc_flag,'N') = 'Y';
2109: -- end, Harshita for Bug #3765133
2110:
2111: IF p_override_manual_taxes = 'Y' THEN
2112: DELETE FROM JAI_PO_TAXES
2113: WHERE line_focus_id = releases_rec.line_focus_id;
2114:
2115: v_success := 5; -- means the override manual taxes is selected by user and all the attached taxes with the shipment are removed to default the new taxes
2116: ELSE

Line 2174: INSERT INTO JAI_PO_TAXES(

2170: ||', tax_rec.p_8 -> '||tax_rec.p_8||', tax_rec.p_9 -> '||tax_rec.p_9
2171: ||', tax_rec.p_10 -> '||tax_rec.p_10 );
2172: END IF;
2173:
2174: INSERT INTO JAI_PO_TAXES(
2175: line_location_id, tax_line_no, po_line_id, po_header_id,
2176: precedence_1,
2177: precedence_2,
2178: precedence_3,

Line 2219: JAI_PO_TAXES a

2215: /* Harshita - Update the tax_amount in the latest records
2216: to the previous tax amounts for all adhoc tax types. -- Bug #3765133*/
2217:
2218: UPDATE
2219: JAI_PO_TAXES a
2220: SET
2221: tax_amount = (SELECT tax_amount
2222: FROM JAI_PO_TAXES
2223: where tax_id = a.tax_id

Line 2222: FROM JAI_PO_TAXES

2218: UPDATE
2219: JAI_PO_TAXES a
2220: SET
2221: tax_amount = (SELECT tax_amount
2222: FROM JAI_PO_TAXES
2223: where tax_id = a.tax_id
2224: and line_focus_id = -releases_rec.line_focus_id)
2225: WHERE
2226: line_focus_id = releases_rec.line_focus_id

Line 2228: FROM JAI_PO_TAXES

2224: and line_focus_id = -releases_rec.line_focus_id)
2225: WHERE
2226: line_focus_id = releases_rec.line_focus_id
2227: and tax_id in (SELECT tax_id
2228: FROM JAI_PO_TAXES
2229: WHERE line_focus_id = -releases_rec.line_focus_id);
2230:
2231: -- ended, Harshita for Bug #3765133
2232:

Line 2240: UPDATE JAI_PO_TAXES SET tax_line_no = j

2236: IF p_override_manual_taxes <> 'Y' THEN
2237: -- modifying the tax line number of the manual taxes starting from 1..n manual taxes *
2238: FOR tax_rec IN c_manual_taxes_up(releases_rec.line_location_id, releases_rec.line_focus_id) LOOP
2239: j := j + 1;
2240: UPDATE JAI_PO_TAXES SET tax_line_no = j
2241: WHERE rowid = tax_rec.rowid;
2242: END LOOP;
2243: END IF;
2244:

Line 2349: DELETE FROM JAI_PO_TAXES

2345: END IF;
2346:
2347: -- added, Harshita for Bug #3765133
2348: /* Temporary data stored previously will be flushed using following DELETE */
2349: DELETE FROM JAI_PO_TAXES
2350: WHERE line_focus_id = -releases_rec.line_focus_id;
2351: -- ended, Harshita for Bug #3765133
2352:
2353: ELSE -- IF v_dflt_tax_category_id IS NOT NULL

Line 3640: FROM JAI_PO_TAXES

3636: nvl(precedence_9, -1) p_9,
3637: nvl(precedence_10, -1) p_10,
3638: tax_id,
3639: tax_category_id
3640: FROM JAI_PO_TAXES
3641: WHERE line_focus_id = p_line_focus_id;
3642:
3643: CURSOR c_so_line_taxes(p_line_id NUMBER) IS
3644: SELECT tax_line_no,

Line 3896: DELETE FROM JAI_PO_TAXES

3892: END LOOP;
3893:
3894: IF v_manual = 'N' AND p_success > 0 THEN
3895: IF p_document_type = 'PO' THEN
3896: DELETE FROM JAI_PO_TAXES
3897: WHERE line_focus_id = p_line_focus_id AND tax_category_id IS NOT NULL;
3898: p_message := 'No Manual taxes are attached to the shipment, so no problem is deleting the shipment taxes';
3899: ELSIF p_document_type = 'SO' THEN
3900: DELETE FROM JAI_OM_OE_SO_TAXES

Line 3917: DELETE FROM JAI_PO_TAXES

3913: RETURN;
3914: ELSIF v_manual = 'Y' AND p_success > 0 THEN
3915:
3916: IF p_document_type = 'PO' THEN
3917: DELETE FROM JAI_PO_TAXES
3918: WHERE line_focus_id = p_line_focus_id
3919: AND tax_category_id IS NOT NULL;
3920:
3921: p_message := 'No Manual taxes are attached to the shipment, so no problem is deleting the shipment taxes';