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_REQ_LINE_TAXES

Line 406: FROM JAI_PO_REQ_LINE_TAXES

402: ORDER BY tax_line_no;
403:
404: CURSOR c_manual_reqn_taxes_up(p_requisition_line_id IN NUMBER) IS
405: SELECT rowid, tax_line_no
406: FROM JAI_PO_REQ_LINE_TAXES
407: WHERE requisition_line_id = p_requisition_line_id
408: AND tax_category_id IS NULL
409: ORDER BY tax_line_no;
410:

Line 2660: insert into JAI_PO_REQ_LINE_TAXES

2656: -- The adhoc data is preserved to capture the tax_amount later.
2657: -- added by Harshita for Bug #3765133
2658:
2659:
2660: insert into JAI_PO_REQ_LINE_TAXES
2661: (requisition_line_id,tax_line_no,
2662: tax_id, tax_amount,
2663: creation_date,created_by,
2664: last_update_date, last_updated_by,last_update_login)

Line 2671: JAI_PO_REQ_LINE_TAXES A,

2667: A.tax_id, A.tax_amount,
2668: A.creation_date,A.created_by,
2669: A.last_update_date, A.last_updated_by,A.last_update_login
2670: FROM
2671: JAI_PO_REQ_LINE_TAXES A,
2672: JAI_CMN_TAXES_ALL B
2673: WHERE
2674: A.tax_id = B.tax_id AND
2675: requisition_line_id = reqn_rec.requisition_line_id AND

Line 2681: DELETE FROM JAI_PO_REQ_LINE_TAXES

2677:
2678: -- end, Harshita for Bug #3765133
2679:
2680: IF p_override_manual_taxes = 'Y' THEN
2681: DELETE FROM JAI_PO_REQ_LINE_TAXES
2682: WHERE requisition_line_id = reqn_rec.requisition_line_id;
2683:
2684: 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
2685: ELSE

Line 2746: INSERT INTO JAI_PO_REQ_LINE_TAXES(

2742: ||', tax_rec.p_8 -> '||tax_rec.p_8||', tax_rec.p_9 -> '||tax_rec.p_9
2743: ||', tax_rec.p_10 -> '||tax_rec.p_10 );
2744: END IF;
2745:
2746: INSERT INTO JAI_PO_REQ_LINE_TAXES(
2747: requisition_line_id, requisition_header_id, tax_line_no,
2748: precedence_1,
2749: precedence_2,
2750: precedence_3,

Line 2780: JAI_PO_REQ_LINE_TAXES a

2776: /* Harshita - Update the tax_amount in the latest records
2777: to the previous tax amounts for all adhoc tax types. -- Bug #3765133*/
2778:
2779: UPDATE
2780: JAI_PO_REQ_LINE_TAXES a
2781: SET
2782: tax_amount = (SELECT tax_amount
2783: FROM JAI_PO_REQ_LINE_TAXES
2784: where tax_id = a.tax_id

Line 2783: FROM JAI_PO_REQ_LINE_TAXES

2779: UPDATE
2780: JAI_PO_REQ_LINE_TAXES a
2781: SET
2782: tax_amount = (SELECT tax_amount
2783: FROM JAI_PO_REQ_LINE_TAXES
2784: where tax_id = a.tax_id
2785: and requisition_line_id = -reqn_rec.requisition_line_id)
2786: WHERE
2787: requisition_line_id = reqn_rec.requisition_line_id

Line 2789: FROM JAI_PO_REQ_LINE_TAXES

2785: and requisition_line_id = -reqn_rec.requisition_line_id)
2786: WHERE
2787: requisition_line_id = reqn_rec.requisition_line_id
2788: and tax_id in (SELECT tax_id
2789: FROM JAI_PO_REQ_LINE_TAXES
2790: WHERE requisition_line_id = -reqn_rec.requisition_line_id);
2791:
2792: -- ended, Harshita for Bug #3765133
2793:

Line 2801: UPDATE JAI_PO_REQ_LINE_TAXES SET tax_line_no = j

2797: IF p_override_manual_taxes <> 'Y' THEN
2798: --* modifying the tax line number of the manual taxes starting from 1..n manual taxes *
2799: FOR tax_rec IN c_manual_reqn_taxes_up(reqn_rec.requisition_line_id) LOOP
2800: j := j + 1;
2801: UPDATE JAI_PO_REQ_LINE_TAXES SET tax_line_no = j
2802: WHERE rowid = tax_rec.rowid;
2803: END LOOP;
2804: END IF;
2805:

Line 2907: DELETE FROM JAI_PO_REQ_LINE_TAXES

2903: END IF;
2904:
2905: -- added, Harshita for Bug #3765133
2906: /* Temporary data stored previously will be flushed using following DELETE */
2907: DELETE FROM JAI_PO_REQ_LINE_TAXES
2908: WHERE requisition_line_id = -reqn_rec.requisition_line_id;
2909: -- ended, Harshita for Bug #3765133
2910:
2911: ELSE

Line 3273: FROM JAI_PO_REQ_LINE_TAXES

3269: and line_id = -so_rec.line_id)
3270: WHERE
3271: line_id = so_rec.line_id
3272: and tax_id in (SELECT tax_id
3273: FROM JAI_PO_REQ_LINE_TAXES
3274: WHERE line_id = -so_rec.line_id);
3275:
3276:
3277: -- ended, Harshita for Bug #3765133

Line 3673: FROM JAI_PO_REQ_LINE_TAXES

3669: nvl(precedence_8, -1) p_8,
3670: nvl(precedence_9, -1) p_9,
3671: nvl(precedence_10, -1) p_10,
3672: tax_id, tax_category_id
3673: FROM JAI_PO_REQ_LINE_TAXES
3674: WHERE requisition_line_id = p_requisition_line_id;
3675:
3676: j NUMBER(4) := 0;
3677: v_manual VARCHAR2(1); -- := 'N'; --Ramananda for File.Sql.35

Line 3904: DELETE FROM JAI_PO_REQ_LINE_TAXES

3900: DELETE FROM JAI_OM_OE_SO_TAXES
3901: WHERE line_id = p_line_id AND tax_category_id IS NOT NULL;
3902: p_message := 'No Manual taxes are attached to the SO line, so no problem is deleting the line taxes';
3903: ELSIF p_document_type = 'REQUISITION' THEN
3904: DELETE FROM JAI_PO_REQ_LINE_TAXES
3905: WHERE requisition_line_id = p_line_id AND tax_category_id IS NOT NULL;
3906: p_message := 'No Manual taxes are attached to requisition line, so no problem is deleting the line taxes';
3907: END IF;
3908:

Line 3931: DELETE FROM JAI_PO_REQ_LINE_TAXES

3927:
3928: p_message := 'No Manual taxes are attached to the SO line, so no problem is deleting the line taxes';
3929:
3930: ELSIF p_document_type = 'REQUISITION' THEN
3931: DELETE FROM JAI_PO_REQ_LINE_TAXES
3932: WHERE requisition_line_id = p_line_id
3933: AND tax_category_id IS NOT NULL;
3934:
3935: p_message := 'No Manual taxes are attached to requisition line, so no problem is deleting the line taxes';