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_OM_WDD_TRIGGER_PKG dependencies on JAI_OM_WSH_LINE_TAXES

Line 91: DELETE JAI_OM_WSH_LINE_TAXES

87: Else
88: DELETE JAI_OM_WSH_LINES_ALL
89: WHERE delivery_detail_id = v_DELIVERY_DETAIL_ID;
90:
91: DELETE JAI_OM_WSH_LINE_TAXES
92: WHERE delivery_detail_id = v_DELIVERY_DETAIL_ID;
93: End If;
94:
95: END ARD_T1 ;

Line 1255: FROM JAI_OM_WSH_LINE_TAXES

1251: AND A.Tax_Id = b.Tax_Id
1252: ORDER BY A.Tax_Line_No;
1253: CURSOR Pick_Tax_Line_Count_Cur(P_Tax_Id NUMBER) IS
1254: SELECT COUNT(*)
1255: FROM JAI_OM_WSH_LINE_TAXES
1256: WHERE Delivery_Detail_Id = v_delivery_detail_id
1257: AND Tax_Id = P_Tax_Id;
1258: CURSOR Get_Tot_Tax_Amount_Cur IS
1259: SELECT SUM(A.Tax_Amount)

Line 1260: FROM JAI_OM_WSH_LINE_TAXES A,

1256: WHERE Delivery_Detail_Id = v_delivery_detail_id
1257: AND Tax_Id = P_Tax_Id;
1258: CURSOR Get_Tot_Tax_Amount_Cur IS
1259: SELECT SUM(A.Tax_Amount)
1260: FROM JAI_OM_WSH_LINE_TAXES A,
1261: JAI_CMN_TAXES_ALL b
1262: WHERE A.Delivery_Detail_Id = v_delivery_detail_id
1263: AND b.Tax_Id = A.Tax_Id
1264: AND b.Tax_Type <> 'TDS';

Line 1487: FROM JAI_OM_WSH_LINE_TAXES jsptl ,

1483: v_lou_flag Varchar2(1);
1484:
1485: CURSOR c_cess_amount (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS
1486: SELECT nvl(sum(jsptl.func_tax_amount),0) tax_amount
1487: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
1488: JAI_CMN_TAXES_ALL jtc
1489: WHERE jtc.tax_id = jsptl.tax_id
1490: AND delivery_detail_id in
1491: (SELECT delivery_detail_id

Line 1505: FROM JAI_OM_WSH_LINE_TAXES jsptl ,

1501: /* Cursor is responsible to get secondary and higher cess */
1502:
1503: CURSOR c_sh_cess_amount (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS
1504: SELECT nvl(sum(jsptl.func_tax_amount),0) tax_amount
1505: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
1506: JAI_CMN_TAXES_ALL jtc
1507: WHERE jtc.tax_id = jsptl.tax_id
1508: AND delivery_detail_id in
1509: (SELECT delivery_detail_id

Line 1534: FROM JAI_OM_WSH_LINE_TAXES jsptl,

1530:
1531: CURSOR cur_chk_vat_exists (cp_del_det_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE)
1532: IS
1533: SELECT 1
1534: FROM JAI_OM_WSH_LINE_TAXES jsptl,
1535: JAI_CMN_TAXES_ALL jtc
1536: , jai_regime_tax_types_v tax_types
1537: WHERE jsptl.delivery_detail_id = cp_del_det_id
1538: AND jtc.tax_id = jsptl.tax_id

Line 1565: || Check if only 'VAT REVERSAL' tax type is present in JAI_OM_WSH_LINE_TAXES

1561: -- End of Bug#4215808
1562:
1563: /*
1564: || Added by csahoo for bug#5680459
1565: || Check if only 'VAT REVERSAL' tax type is present in JAI_OM_WSH_LINE_TAXES
1566: */
1567: CURSOR c_chk_vat_reversal (cp_del_det_id JAI_OM_WSH_LINES_ALL.delivery_detail_id%TYPE,
1568: cp_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE )
1569: IS

Line 1571: FROM JAI_OM_WSH_LINE_TAXES jsptl,

1567: CURSOR c_chk_vat_reversal (cp_del_det_id JAI_OM_WSH_LINES_ALL.delivery_detail_id%TYPE,
1568: cp_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE )
1569: IS
1570: SELECT 1
1571: FROM JAI_OM_WSH_LINE_TAXES jsptl,
1572: JAI_CMN_TAXES_ALL jtc
1573: WHERE jsptl.delivery_detail_id = cp_del_det_id
1574: AND jtc.tax_id = jsptl.tax_id
1575: AND jtc.tax_type = cp_tax_type ;

Line 1603: , CP_DELIVERY_DETAIL_ID JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE

1599: WHERE REGIME_CODE = CP_REGIME_CODE;
1600:
1601: /** Check if taxes with taxType as defined in the regime setup exists for given regime code */
1602: CURSOR C_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
1603: , CP_DELIVERY_DETAIL_ID JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE
1604: )
1605: IS
1606: SELECT COUNT(1)
1607: FROM JAI_REGIME_TAX_TYPES_V JRTTV

Line 1608: , JAI_OM_WSH_LINE_TAXES JSPT

1604: )
1605: IS
1606: SELECT COUNT(1)
1607: FROM JAI_REGIME_TAX_TYPES_V JRTTV
1608: , JAI_OM_WSH_LINE_TAXES JSPT
1609: , JAI_CMN_TAXES_ALL JTC
1610: WHERE JTC.TAX_ID = JSPT.TAX_ID
1611: AND JTC.TAX_TYPE = JRTTV.TAX_TYPE
1612: AND REGIME_CODE = CP_REGIME_CODE

Line 1706: JAI_OM_WSH_LINE_TAXES.

1702: Initial code used to check that if the organization is a Trading organization,item is tradable and excisable
1703: then used to assume that a match receipt has been done and get the sum (tax_amount), sum(base_tax_amount),
1704: sum(func_tax_amount) for a delivery_detail_id and tax_id from the JAI_CMN_MATCH_TAXES table and
1705: populate this into the tax_amount, base_tax_amount and func_tax_amount columns of the table
1706: JAI_OM_WSH_LINE_TAXES.
1707:
1708: This approach used to fail, as many a times a record never used to exists in the JAI_CMN_MATCH_TAXES table
1709: for the delivery_detail_id and tax_id even though the organization is declared as a trading organization,
1710: Item is tradable and excisable.

Line 2233: Before this fix, Null value used to get inserted into taxes in table JAI_OM_WSH_LINE_TAXES for Bond register with

2229: to the other three checks (of organization being a trading organization, Item being tradable and excisable ):-
2230: The order attached to the bond register is one of 'Trading Domestic With Excise' or 'Export With Excise'
2231: hence applying the check that
2232: v_trad_register_code IN ( '23D_DOMESTIC_EXCISE','23D_EXPORT_EXCISE') .
2233: Before this fix, Null value used to get inserted into taxes in table JAI_OM_WSH_LINE_TAXES for Bond register with
2234: 'Trading Domestic Without Excise' and 'Export Without Excise' ( problem stated in the bug )
2235: */
2236: IF NVL(v_trading_flag,'N') = 'Y' AND
2237: NVL(v_item_trading_flag,'N') = 'Y' AND

Line 2329: -- Check for the existence of Tax Lines in JAI_OM_WSH_LINE_TAXES

2325: ||', v_add_excise_duty_amount -> '|| v_add_excise_duty_amount
2326: ||', v_oth_excise_duty_amount -> '|| v_oth_excise_duty_amount
2327: );
2328: END IF; --3
2329: -- Check for the existence of Tax Lines in JAI_OM_WSH_LINE_TAXES
2330: OPEN Pick_Tax_Line_Count_Cur(rec.tax_id);
2331: FETCH Pick_Tax_Line_Count_Cur INTO v_picking_tax_lines_count;
2332: CLOSE Pick_Tax_Line_Count_Cur;
2333: IF v_picking_tax_lines_count = 0 THEN --4

Line 2334: INSERT INTO JAI_OM_WSH_LINE_TAXES(Delivery_Detail_Id,

2330: OPEN Pick_Tax_Line_Count_Cur(rec.tax_id);
2331: FETCH Pick_Tax_Line_Count_Cur INTO v_picking_tax_lines_count;
2332: CLOSE Pick_Tax_Line_Count_Cur;
2333: IF v_picking_tax_lines_count = 0 THEN --4
2334: INSERT INTO JAI_OM_WSH_LINE_TAXES(Delivery_Detail_Id,
2335: Tax_Line_No,
2336: Precedence_1,
2337: Precedence_2,
2338: Precedence_3,

Line 2385: UPDATE JAI_OM_WSH_LINE_TAXES

2381: v_last_updated_by,
2382: v_last_update_login
2383: );
2384: ELSE --4
2385: UPDATE JAI_OM_WSH_LINE_TAXES
2386: SET Tax_Amount = v_tax_amount,
2387: Last_Update_Date = v_last_update_date,
2388: Last_Updated_By = v_last_updated_by,
2389: Last_Update_Login = v_last_update_login

Line 2478: from JAI_OM_WSH_LINE_TAXES

2474:
2475: /* Get line number after which threshold taxes needs to be defaulted */
2476: select max(tax_line_no)
2477: into ln_last_line_no
2478: from JAI_OM_WSH_LINE_TAXES
2479: where delivery_detail_id = v_delivery_detail_id;
2480:
2481: /* Get line number of the base tax (tax_type=TCS) for calculating the surcharge basically to set a precedence */
2482: select max(tax_line_no)

Line 2484: from JAI_OM_WSH_LINE_TAXES jsptl

2480:
2481: /* Get line number of the base tax (tax_type=TCS) for calculating the surcharge basically to set a precedence */
2482: select max(tax_line_no)
2483: into ln_base_line_no
2484: from JAI_OM_WSH_LINE_TAXES jsptl
2485: , JAI_CMN_TAXES_ALL jtc
2486: where jsptl.delivery_detail_id = v_delivery_detail_id
2487: and jsptl.tax_id = jtc.tax_id
2488: and jtc.tax_type = jai_constants.tax_type_tcs;

Line 2493: || into the JAI_OM_WSH_LINE_TAXES table

2489:
2490: /*
2491: ||Call the helper method to default surcharge taxes on top of the SO taxes using the tax category
2492: || The api jai_rgm_thhold_proc_pkg.default_thhold_taxes inserts lines as per the same specified in the TCS tax category
2493: || into the JAI_OM_WSH_LINE_TAXES table
2494: */
2495:
2496: /* jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Calling JAI_RGM_THHOLD_PROC_PKG.DEFAULT_THHOLD_TAXES');*/ --commented by bgowrava for bug#5631784
2497:

Line 2746: || Check if only 'VAT REVERSAL' tax type is present in JAI_OM_WSH_LINE_TAXES

2742:
2743:
2744: /*
2745: || Added by csahoo for bug#5680459
2746: || Check if only 'VAT REVERSAL' tax type is present in JAI_OM_WSH_LINE_TAXES
2747: */
2748: IF nvl(ln_vat_cnt,0) = 0 THEN /* If taxes of type 'VAT' are not present */
2749: lv_vat_reversal := 'VAT REVERSAL' ;
2750: OPEN c_chk_vat_reversal(cp_del_det_id => v_delivery_detail_id,