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_WSH_PKG dependencies on JAI_CONSTANTS

Line 250: AND b.tax_type = jai_constants.tax_type_modvat_recovery ; /* --'Modvat Recovery'; Ramananda for removal of SQL LITERALs */

246: SELECT A.tax_rate, b.rounding_factor
247: FROM JAI_OM_WSH_LINE_TAXES A, JAI_CMN_TAXES_ALL b
248: WHERE A.tax_id = b.tax_id
249: AND A.delivery_detail_id = p_delivery_detail_id
250: AND b.tax_type = jai_constants.tax_type_modvat_recovery ; /* --'Modvat Recovery'; Ramananda for removal of SQL LITERALs */
251:
252: CURSOR for_modvat_percentage(p_organization_id NUMBER, p_location_id NUMBER) IS
253: SELECT MODVAT_REVERSE_PERCENT
254: FROM JAI_CMN_INVENTORY_ORGS

Line 540: AND upper(jtc.tax_type) in (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess); /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

536: (SELECT delivery_detail_id
537: FROM JAI_OM_WSH_LINES_ALL
538: WHERE delivery_id = cp_delivery_id
539: )
540: AND upper(jtc.tax_type) in (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess); /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
541: -- AND upper(jtc.tax_type) in ('CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS');
542:
543: /*Cursor added by ssawant for bug 5989740 */
544: CURSOR c_sh_cess_amount (cp_Delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type) is

Line 554: AND upper(jtc.tax_type) in (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess);

550: (SELECT delivery_detail_id
551: FROM JAI_OM_WSH_LINES_ALL
552: WHERE delivery_id = cp_delivery_id
553: )
554: AND upper(jtc.tax_type) in (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess);
555:
556: ln_cess_amount number;
557: ln_sh_cess_amount number; /* added by ssawant for bug 5989740 */
558: lv_process_flag varchar2(5);

Line 582: upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess) AND

578: jai_cmn_taxes_all jtc
579: WHERE
580: jspl.delivery_detail_id = jsptl.delivery_detail_id AND
581: jsptl.tax_id = jtc.tax_id AND
582: upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess) AND
583: jspl.delivery_detail_id = cp_delivery_detail_id;
584:
585: ln_del_det_totcess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE;
586: /* End of bug 4566054 */

Line 600: upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,

596: JAI_CMN_TAXES_ALL jtc
597: WHERE
598: jspl.delivery_detail_id = jsptl.delivery_detail_id AND
599: jsptl.tax_id = jtc.tax_id AND
600: upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,
601: jai_constants.tax_type_sh_exc_edu_cess)
602: AND
603: jspl.delivery_detail_id = cp_delivery_detail_id;
604:

Line 601: jai_constants.tax_type_sh_exc_edu_cess)

597: WHERE
598: jspl.delivery_detail_id = jsptl.delivery_detail_id AND
599: jsptl.tax_id = jtc.tax_id AND
600: upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,
601: jai_constants.tax_type_sh_exc_edu_cess)
602: AND
603: jspl.delivery_detail_id = cp_delivery_detail_id;
604:
605: ln_del_det_totshcess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE;

Line 1062: Added the new cess types jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess

1058: Higher Secondary Education Cess from 11.5( bug no 5907436) to R12 (bug no 5989740).
1059:
1060: 53. 18/Apr/2007 Bgowrava for forward porting bug#5989740, 11i BUG#5907436 File Version 120.9
1061: ENH: Handling Secondary and Higher Education Cess
1062: Added the new cess types jai_constants.tax_type_sh_exc_edu_cess, jai_constants.tax_type_sh_cvd_edu_cess
1063:
1064: 54. 28/05/2007 CSahoo for bug#6077065, File version 120.10
1065: Issue: The excise invoice num and excise_invoice_date was not getting updated in the JAI_OM_WSH_LINES_ALL table.
1066: Fix:added the following line in the code lv_exc_inv_gen_for_dlry_flag := 'Y'.

Line 1183: lv_debug := jai_constants.yes ;

1179: jai_om_rg.plb 120.4
1180:
1181: ------------------------------------------------------------------------------------------------------------------------------------------------*/
1182: /* Ramananda for File.Sql.35 */
1183: lv_debug := jai_constants.yes ;
1184: lv_procedure_name := 'process_delivery';
1185: v_creation_date := SYSDATE;
1186: v_source_name := 'Register India' ;
1187: v_category_name := 'Register India' ;

Line 1950: jai_constants.source_wsh

1946: ln_total_of_base_tax , /* multiplied with v_converted_rate for the bug 16014905 */
1947: /* removed the v_converted_rate which is multiplying with ln_total_of_base_tax for bug 16197185 */
1948: ln_del_det_totcess_amt , /*Parameters p_cess_amt and p_source added by aiyer for the bug 4566054 */
1949: ln_del_det_totshcess_amt , --Bgowrava for forward porting bug#5989740
1950: jai_constants.source_wsh
1951: );
1952:
1953: lv_statement_no := '31';
1954: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_part_i_register_id FROM dual;

Line 2660: v_debug_flag := jai_constants.no; --Ramananda for File.Sql.35

2656: v_oth_excise_duty_amount := p_oth_excise_duty_amount;
2657: v_export_oriented_unit := p_export_oriented_unit;
2658: v_register_code := p_register_code;
2659:
2660: v_debug_flag := jai_constants.no; --Ramananda for File.Sql.35
2661:
2662: If v_debug_flag = 'Y' THEN
2663: --For Fetching UTIL File.......
2664: BEGIN

Line 2717: if lv_process_flag <> jai_constants.successful then

2713: p_process_flag => lv_process_flag ,
2714: p_process_message => lv_process_message
2715: );
2716:
2717: if lv_process_flag <> jai_constants.successful then
2718: lv_rg23a_cess_avlbl := 'FALSE';
2719: else
2720: lv_rg23a_cess_avlbl := 'TRUE';
2721: end if;

Line 2732: if lv_process_flag <> jai_constants.successful then

2728: p_process_flag => lv_process_flag ,
2729: p_process_message => lv_process_message
2730: );
2731:
2732: if lv_process_flag <> jai_constants.successful then
2733: lv_rg23a_sh_cess_avlbl := 'FALSE';
2734: else
2735: lv_rg23a_sh_cess_avlbl := 'TRUE';
2736: end if;

Line 2749: if lv_process_flag <> jai_constants.successful then

2745: p_process_flag => lv_process_flag ,
2746: p_process_message => lv_process_message
2747: );
2748:
2749: if lv_process_flag <> jai_constants.successful then
2750: lv_rg23c_cess_avlbl := 'FALSE';
2751: else
2752: lv_rg23c_cess_avlbl := 'TRUE';
2753: end if;

Line 2765: if lv_process_flag <> jai_constants.successful then

2761: p_process_flag => lv_process_flag ,
2762: p_process_message => lv_process_message
2763: );
2764:
2765: if lv_process_flag <> jai_constants.successful then
2766: lv_rg23a_sh_cess_avlbl := 'FALSE';
2767: else
2768: lv_rg23a_sh_cess_avlbl := 'TRUE';
2769: end if;

Line 2782: if lv_process_flag <> jai_constants.successful then

2778: p_process_flag => lv_process_flag ,
2779: p_process_message => lv_process_message
2780: );
2781:
2782: if lv_process_flag <> jai_constants.successful then
2783: lv_pla_cess_avlbl := 'FALSE';
2784: else
2785: lv_pla_cess_avlbl := 'TRUE';
2786: end if;

Line 2797: if lv_process_flag <> jai_constants.successful then

2793: p_process_flag => lv_process_flag ,
2794: p_process_message => lv_process_message
2795: );
2796:
2797: if lv_process_flag <> jai_constants.successful then
2798: lv_rg23a_sh_cess_avlbl := 'FALSE';
2799: else
2800: lv_rg23a_sh_cess_avlbl := 'TRUE';
2801: end if;