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 481: FROM JAI_PO_TAXES

477: ORDER BY a.line_no;
478:
479: CURSOR c_manual_taxes_up(p_line_location_id IN NUMBER, p_line_focus_id IN NUMBER) IS
480: SELECT rowid, tax_line_no
481: FROM JAI_PO_TAXES
482: WHERE line_focus_id = p_line_focus_id
483: AND tax_category_id IS NULL
484: ORDER BY tax_line_no;
485:

Line 1931: insert into JAI_PO_TAXES

1927:
1928: -- The adhoc data is preserved to capture the tax_amount later.
1929: -- added by Harshita for Bug #3765133
1930:
1931: insert into JAI_PO_TAXES
1932: (tax_line_no,po_line_id,po_header_id,
1933: line_focus_id,tax_id, tax_amount,
1934: creation_date,created_by,
1935: last_update_date, last_updated_by,last_update_login)

Line 1942: JAI_PO_TAXES A,

1938: -A.line_focus_id,A.tax_id, A.tax_amount,
1939: A.creation_date,A.created_by,
1940: A.last_update_date, A.last_updated_by,A.last_update_login
1941: FROM
1942: JAI_PO_TAXES A,
1943: JAI_CMN_TAXES_ALL B
1944: WHERE
1945: A.tax_id = B.tax_id AND
1946: line_focus_id = shipment_rec.line_focus_id AND

Line 1952: DELETE FROM JAI_PO_TAXES

1948:
1949: -- end, Harshita for Bug #3765133
1950:
1951: IF p_override_manual_taxes = 'Y' THEN
1952: DELETE FROM JAI_PO_TAXES
1953: WHERE line_focus_id = shipment_rec.line_focus_id;
1954:
1955: 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
1956: ELSE

Line 2014: INSERT INTO JAI_PO_TAXES(

2010: ||', tax_rec.p_10 -> '||tax_rec.p_10 );
2011: END IF;
2012:
2013:
2014: INSERT INTO JAI_PO_TAXES(
2015: line_location_id, tax_line_no, po_line_id, po_header_id,
2016: precedence_1,
2017: precedence_2,
2018: precedence_3,

Line 2057: JAI_PO_TAXES a

2053: /* Harshita - Update the tax_amount in the latest records
2054: to the previous tax amounts for all adhoc tax types. -- Bug #3765133*/
2055:
2056: UPDATE
2057: JAI_PO_TAXES a
2058: SET
2059: tax_amount = (SELECT tax_amount
2060: FROM JAI_PO_TAXES
2061: where tax_id = a.tax_id

Line 2060: FROM JAI_PO_TAXES

2056: UPDATE
2057: JAI_PO_TAXES a
2058: SET
2059: tax_amount = (SELECT tax_amount
2060: FROM JAI_PO_TAXES
2061: where tax_id = a.tax_id
2062: and line_focus_id = -shipment_rec.line_focus_id)
2063: WHERE
2064: line_focus_id = shipment_rec.line_focus_id

Line 2066: FROM JAI_PO_TAXES

2062: and line_focus_id = -shipment_rec.line_focus_id)
2063: WHERE
2064: line_focus_id = shipment_rec.line_focus_id
2065: and tax_id in (SELECT tax_id
2066: FROM JAI_PO_TAXES
2067: where line_focus_id = -shipment_rec.line_focus_id);
2068:
2069: -- ended, Harshita for Bug #3765133
2070:

Line 2079: UPDATE JAI_PO_TAXES SET tax_line_no = j

2075: IF p_override_manual_taxes <> 'Y' THEN
2076: --* modifying the tax line number of the manual taxes starting from 1..n manual taxes *
2077: FOR tax_rec IN c_manual_taxes_up(v_line_location_id, shipment_rec.line_focus_id) LOOP
2078: j := j + 1;
2079: UPDATE JAI_PO_TAXES SET tax_line_no = j
2080: WHERE rowid = tax_rec.rowid;
2081: END LOOP;
2082: END IF;
2083:

Line 2206: DELETE FROM JAI_PO_TAXES

2202: END IF;
2203:
2204: --added, Harshita for Bug#3765133
2205: /* Temporary data stored previously will be flushed using following DELETE */
2206: DELETE FROM JAI_PO_TAXES
2207: WHERE line_focus_id = -shipment_rec.line_focus_id;
2208: --ended, Harshita for Bug#3765133
2209:
2210: ELSE -- IF v_dflt_tax_category_id IS NOT NULL THEN

Line 2520: insert into JAI_PO_TAXES

2516:
2517: -- The adhoc data is preserved to capture the tax_amount later.
2518: -- added by Harshita for Bug #3765133
2519:
2520: insert into JAI_PO_TAXES
2521: (tax_line_no,po_line_id,po_header_id,
2522: line_focus_id,tax_id, tax_amount,
2523: creation_date,created_by,
2524: last_update_date, last_updated_by,last_update_login)

Line 2531: JAI_PO_TAXES A,

2527: -A.line_focus_id,A.tax_id, A.tax_amount,
2528: A.creation_date,A.created_by,
2529: A.last_update_date, A.last_updated_by,A.last_update_login
2530: FROM
2531: JAI_PO_TAXES A,
2532: JAI_CMN_TAXES_ALL B
2533: WHERE
2534: A.tax_id = B.tax_id AND
2535: line_focus_id = releases_rec.line_focus_id AND

Line 2540: DELETE FROM JAI_PO_TAXES

2536: NVL(adhoc_flag,'N') = 'Y';
2537: -- end, Harshita for Bug #3765133
2538:
2539: IF p_override_manual_taxes = 'Y' THEN
2540: DELETE FROM JAI_PO_TAXES
2541: WHERE line_focus_id = releases_rec.line_focus_id;
2542:
2543: 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
2544: ELSE

Line 2602: INSERT INTO JAI_PO_TAXES(

2598: ||', tax_rec.p_8 -> '||tax_rec.p_8||', tax_rec.p_9 -> '||tax_rec.p_9
2599: ||', tax_rec.p_10 -> '||tax_rec.p_10 );
2600: END IF;
2601:
2602: INSERT INTO JAI_PO_TAXES(
2603: line_location_id, tax_line_no, po_line_id, po_header_id,
2604: precedence_1,
2605: precedence_2,
2606: precedence_3,

Line 2647: JAI_PO_TAXES a

2643: /* Harshita - Update the tax_amount in the latest records
2644: to the previous tax amounts for all adhoc tax types. -- Bug #3765133*/
2645:
2646: UPDATE
2647: JAI_PO_TAXES a
2648: SET
2649: tax_amount = (SELECT tax_amount
2650: FROM JAI_PO_TAXES
2651: where tax_id = a.tax_id

Line 2650: FROM JAI_PO_TAXES

2646: UPDATE
2647: JAI_PO_TAXES a
2648: SET
2649: tax_amount = (SELECT tax_amount
2650: FROM JAI_PO_TAXES
2651: where tax_id = a.tax_id
2652: and line_focus_id = -releases_rec.line_focus_id)
2653: WHERE
2654: line_focus_id = releases_rec.line_focus_id

Line 2656: FROM JAI_PO_TAXES

2652: and line_focus_id = -releases_rec.line_focus_id)
2653: WHERE
2654: line_focus_id = releases_rec.line_focus_id
2655: and tax_id in (SELECT tax_id
2656: FROM JAI_PO_TAXES
2657: WHERE line_focus_id = -releases_rec.line_focus_id);
2658:
2659: -- ended, Harshita for Bug #3765133
2660:

Line 2668: UPDATE JAI_PO_TAXES SET tax_line_no = j

2664: IF p_override_manual_taxes <> 'Y' THEN
2665: -- modifying the tax line number of the manual taxes starting from 1..n manual taxes *
2666: FOR tax_rec IN c_manual_taxes_up(releases_rec.line_location_id, releases_rec.line_focus_id) LOOP
2667: j := j + 1;
2668: UPDATE JAI_PO_TAXES SET tax_line_no = j
2669: WHERE rowid = tax_rec.rowid;
2670: END LOOP;
2671: END IF;
2672:

Line 2794: DELETE FROM JAI_PO_TAXES

2790: END IF;
2791:
2792: -- added, Harshita for Bug #3765133
2793: /* Temporary data stored previously will be flushed using following DELETE */
2794: DELETE FROM JAI_PO_TAXES
2795: WHERE line_focus_id = -releases_rec.line_focus_id;
2796: -- ended, Harshita for Bug #3765133
2797:
2798: ELSE -- IF v_dflt_tax_category_id IS NOT NULL

Line 4787: FROM JAI_PO_TAXES

4783: nvl(precedence_9, -1) p_9,
4784: nvl(precedence_10, -1) p_10,
4785: tax_id,
4786: tax_category_id
4787: FROM JAI_PO_TAXES
4788: WHERE line_focus_id = p_line_focus_id;
4789:
4790: CURSOR c_so_line_taxes(p_line_id NUMBER) IS
4791: SELECT tax_line_no,

Line 5111: DELETE FROM JAI_PO_TAXES

5107: END LOOP;
5108:
5109: IF v_manual = 'N' AND p_success > 0 THEN
5110: IF p_document_type = 'PO' THEN
5111: DELETE FROM JAI_PO_TAXES
5112: WHERE line_focus_id = p_line_focus_id AND tax_category_id IS NOT NULL;
5113: p_message := 'No Manual taxes are attached to the shipment, so no problem is deleting the shipment taxes';
5114: ELSIF p_document_type = 'SO' THEN
5115: DELETE FROM JAI_OM_OE_SO_TAXES

Line 5143: DELETE FROM JAI_PO_TAXES

5139: RETURN;
5140: ELSIF v_manual = 'Y' AND p_success > 0 THEN
5141:
5142: IF p_document_type = 'PO' THEN
5143: DELETE FROM JAI_PO_TAXES
5144: WHERE line_focus_id = p_line_focus_id
5145: AND tax_category_id IS NOT NULL;
5146:
5147: p_message := 'No Manual taxes are attached to the shipment, so no problem is deleting the shipment taxes';