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

Line 596: FROM JAI_OM_WSH_LINE_TAXES

592: ORDER BY A.Tax_Line_No;
593:
594: CURSOR Pick_Tax_Line_Count_Cur(P_Tax_Id NUMBER) IS
595: SELECT COUNT(*)
596: FROM JAI_OM_WSH_LINE_TAXES
597: WHERE Delivery_Detail_Id = v_delivery_detail_id
598: AND Tax_Id = P_Tax_Id;
599:
600: CURSOR Get_Tot_Tax_Amount_Cur IS

Line 602: FROM JAI_OM_WSH_LINE_TAXES A,

598: AND Tax_Id = P_Tax_Id;
599:
600: CURSOR Get_Tot_Tax_Amount_Cur IS
601: SELECT SUM(A.Tax_Amount)
602: FROM JAI_OM_WSH_LINE_TAXES A,
603: JAI_CMN_TAXES_ALL b
604: WHERE A.Delivery_Detail_Id = v_delivery_detail_id
605: AND b.Tax_Id = A.Tax_Id
606: AND b.Tax_Type <> 'TDS';

Line 773: FROM JAI_OM_WSH_LINE_TAXES jsptl ,

769: v_lou_flag Varchar2(1);
770:
771: CURSOR c_cess_amount (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS
772: SELECT nvl(sum(jsptl.func_tax_amount),0) tax_amount
773: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
774: JAI_CMN_TAXES_ALL jtc
775: WHERE jtc.tax_id = jsptl.tax_id
776: AND delivery_detail_id in
777: (SELECT delivery_detail_id

Line 787: FROM JAI_OM_WSH_LINE_TAXES jsptl ,

783: ln_sh_cess_amount JAI_CMN_RG_OTHERS.DEBIT%TYPE;
784:
785: CURSOR c_sh_cess_amount (cp_delivery_id JAI_OM_WSH_LINES_ALL.DELIVERY_ID%TYPE) IS
786: SELECT nvl(sum(jsptl.func_tax_amount),0) tax_amount
787: FROM JAI_OM_WSH_LINE_TAXES jsptl ,
788: JAI_CMN_TAXES_ALL jtc
789: WHERE jtc.tax_id = jsptl.tax_id
790: AND delivery_detail_id in
791: (SELECT delivery_detail_id

Line 811: FROM JAI_OM_WSH_LINE_TAXES jsptl,

807:
808: CURSOR cur_chk_vat_exists (cp_del_det_id JAI_OM_WSH_LINES_ALL.DELIVERY_DETAIL_ID%TYPE)
809: IS
810: SELECT 1
811: FROM JAI_OM_WSH_LINE_TAXES jsptl,
812: JAI_CMN_TAXES_ALL jtc
813: , jai_regime_tax_types_v tax_types
814: WHERE jsptl.delivery_detail_id = cp_del_det_id
815: AND jtc.tax_id = jsptl.tax_id

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

835: FROM JAI_RGM_INVOICE_GEN_T
836: WHERE delivery_id = cp_delivery_id;
837:
838: /*
839: || Check if only 'VAT REVERSAL' tax type is present in JAI_OM_WSH_LINE_TAXES
840: */
841: CURSOR c_chk_vat_reversal (cp_del_det_id JAI_OM_WSH_LINES_ALL.delivery_detail_id%TYPE,
842: cp_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE )
843: IS

Line 845: FROM JAI_OM_WSH_LINE_TAXES jsptl,

841: CURSOR c_chk_vat_reversal (cp_del_det_id JAI_OM_WSH_LINES_ALL.delivery_detail_id%TYPE,
842: cp_tax_type JAI_CMN_TAXES_ALL.tax_type%TYPE )
843: IS
844: SELECT 1
845: FROM JAI_OM_WSH_LINE_TAXES jsptl,
846: JAI_CMN_TAXES_ALL jtc
847: WHERE jsptl.delivery_detail_id = cp_del_det_id
848: AND jtc.tax_id = jsptl.tax_id
849: AND jtc.tax_type = cp_tax_type ;

Line 870: , CP_DELIVERY_DETAIL_ID JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE)

866: WHERE REGIME_CODE = CP_REGIME_CODE;
867:
868: /** Check if taxes with taxType as defined in the regime setup exists for given regime code */
869: CURSOR C_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
870: , CP_DELIVERY_DETAIL_ID JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE)
871: IS
872: SELECT COUNT(1)
873: FROM JAI_REGIME_TAX_TYPES_V JRTTV
874: , JAI_OM_WSH_LINE_TAXES JSPT

Line 874: , JAI_OM_WSH_LINE_TAXES JSPT

870: , CP_DELIVERY_DETAIL_ID JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE)
871: IS
872: SELECT COUNT(1)
873: FROM JAI_REGIME_TAX_TYPES_V JRTTV
874: , JAI_OM_WSH_LINE_TAXES JSPT
875: , JAI_CMN_TAXES_ALL JTC
876: WHERE JTC.TAX_ID = JSPT.TAX_ID
877: AND JTC.TAX_TYPE = JRTTV.TAX_TYPE
878: AND REGIME_CODE = CP_REGIME_CODE

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

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

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

1178: ', v_add_excise_duty_amount -> '|| v_add_excise_duty_amount ||
1179: ', v_oth_excise_duty_amount -> '|| v_oth_excise_duty_amount);
1180: END IF;
1181:
1182: -- Check for the existence of Tax Lines in JAI_OM_WSH_LINE_TAXES
1183: OPEN Pick_Tax_Line_Count_Cur(rec.tax_id);
1184: FETCH Pick_Tax_Line_Count_Cur INTO v_picking_tax_lines_count;
1185: CLOSE Pick_Tax_Line_Count_Cur;
1186: IF v_picking_tax_lines_count = 0 THEN

Line 1187: INSERT INTO JAI_OM_WSH_LINE_TAXES(Delivery_Detail_Id,

1183: OPEN Pick_Tax_Line_Count_Cur(rec.tax_id);
1184: FETCH Pick_Tax_Line_Count_Cur INTO v_picking_tax_lines_count;
1185: CLOSE Pick_Tax_Line_Count_Cur;
1186: IF v_picking_tax_lines_count = 0 THEN
1187: INSERT INTO JAI_OM_WSH_LINE_TAXES(Delivery_Detail_Id,
1188: Tax_Line_No,
1189: Precedence_1,
1190: Precedence_2,
1191: Precedence_3,

Line 1238: UPDATE JAI_OM_WSH_LINE_TAXES

1234: v_last_updated_by,
1235: v_last_update_login
1236: );
1237: ELSE
1238: UPDATE JAI_OM_WSH_LINE_TAXES
1239: SET Tax_Amount = v_tax_amount,
1240: base_tax_amount = v_base_tax_amount,
1241: func_tax_amount = v_func_tax_amount,
1242: Last_Update_Date = v_last_update_date,

Line 1337: from JAI_OM_WSH_LINE_TAXES

1333:
1334: /* Get line number after which threshold taxes needs to be defaulted */
1335: select max(tax_line_no)
1336: into ln_last_line_no
1337: from JAI_OM_WSH_LINE_TAXES
1338: where delivery_detail_id = v_delivery_detail_id;
1339:
1340: /* Get line number of the base tax (tax_type=TCS) for calculating the surcharge basically to set a precedence */
1341: select max(tax_line_no)

Line 1343: from JAI_OM_WSH_LINE_TAXES jsptl

1339:
1340: /* Get line number of the base tax (tax_type=TCS) for calculating the surcharge basically to set a precedence */
1341: select max(tax_line_no)
1342: into ln_base_line_no
1343: from JAI_OM_WSH_LINE_TAXES jsptl
1344: , JAI_CMN_TAXES_ALL jtc
1345: where jsptl.delivery_detail_id = v_delivery_detail_id
1346: and jsptl.tax_id = jtc.tax_id
1347: and jtc.tax_type = jai_constants.tax_type_tcs;

Line 1352: || into the JAI_OM_WSH_LINE_TAXES table

1348:
1349: /*
1350: ||Call the helper method to default surcharge taxes on top of the SO taxes using the tax category
1351: || The api jai_rgm_thhold_proc_pkg.default_thhold_taxes inserts lines as per the same specified in the TCS tax category
1352: || into the JAI_OM_WSH_LINE_TAXES table
1353: */
1354:
1355: ln_vat_assessable_value := nvl(ln_vat_assessable_value * v_shipped_quantity / v_quantity, 0);
1356:

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

1579: CLOSE cur_chk_vat_proc_entry;
1580:
1581:
1582: /*
1583: || Check if only 'VAT REVERSAL' tax type is present in JAI_OM_WSH_LINE_TAXES
1584: */
1585: IF nvl(ln_vat_cnt,0) = 0 THEN
1586: lv_vat_reversal := 'VAT REVERSAL' ;
1587: OPEN c_chk_vat_reversal(cp_del_det_id => v_delivery_detail_id,

Line 2078: FROM jai_om_wsh_line_taxes a, jai_cmn_taxes_all b

2074: WHERE currency_code = cp_curr_code;
2075:
2076: CURSOR c_inclusive_flag(CP_DDID IN NUMBER) IS
2077: SELECT count(*)
2078: FROM jai_om_wsh_line_taxes a, jai_cmn_taxes_all b
2079: where a.delivery_Detail_id = cp_ddid
2080: and a.tax_id = b.tax_id
2081: and upper(b.tax_type) like '%EXCISE%'
2082: AND B.INCLUSIVE_TAX_FLAG = 'Y';

Line 3030: , CP_DELIVERY_DETAIL_ID JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE)

3026: lv_process_message VARCHAR2(1996);
3027:
3028: /** Check if taxes with taxType as defined in the regime setup exists for given regime code */
3029: CURSOR C_CHK_RGM_TAX_EXISTS ( CP_REGIME_CODE JAI_RGM_DEFINITIONS.REGIME_CODE%TYPE
3030: , CP_DELIVERY_DETAIL_ID JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE)
3031: IS
3032: SELECT COUNT(1)
3033: FROM JAI_REGIME_TAX_TYPES_V JRTTV
3034: , JAI_OM_WSH_LINE_TAXES JSPT

Line 3034: , JAI_OM_WSH_LINE_TAXES JSPT

3030: , CP_DELIVERY_DETAIL_ID JAI_OM_WSH_LINE_TAXES.DELIVERY_DETAIL_ID%TYPE)
3031: IS
3032: SELECT COUNT(1)
3033: FROM JAI_REGIME_TAX_TYPES_V JRTTV
3034: , JAI_OM_WSH_LINE_TAXES JSPT
3035: , JAI_CMN_TAXES_ALL JTC
3036: WHERE JTC.TAX_ID = JSPT.TAX_ID
3037: AND JTC.TAX_TYPE = JRTTV.TAX_TYPE
3038: AND REGIME_CODE = CP_REGIME_CODE

Line 3186: JAI_OM_WSH_LINE_TAXES jsptl,

3182: jrttv.regime_id,
3183: jtc.tax_type
3184: FROM
3185: JAI_OM_WSH_LINES_ALL jspl ,
3186: JAI_OM_WSH_LINE_TAXES jsptl,
3187: JAI_CMN_TAXES_ALL jtc ,
3188: jai_regime_tax_types_v jrttv
3189: WHERE
3190: jspl.delivery_detail_id = jsptl.delivery_detail_id