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 245: AND b.tax_type = jai_constants.tax_type_modvat_recovery ; /* --'Modvat Recovery'; Ramananda for removal of SQL LITERALs */

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

Line 512: 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*/

508: (SELECT delivery_detail_id
509: FROM JAI_OM_WSH_LINES_ALL
510: WHERE delivery_id = cp_delivery_id
511: )
512: 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*/
513: -- AND upper(jtc.tax_type) in ('CVD_EDUCATION_CESS','EXCISE_EDUCATION_CESS');
514:
515: /*Cursor added by ssawant for bug 5989740 */
516: CURSOR c_sh_cess_amount (cp_Delivery_id JAI_OM_WSH_LINES_ALL.delivery_id%type) is

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

522: (SELECT delivery_detail_id
523: FROM JAI_OM_WSH_LINES_ALL
524: WHERE delivery_id = cp_delivery_id
525: )
526: AND upper(jtc.tax_type) in (jai_constants.tax_type_sh_cvd_edu_cess,jai_constants.tax_type_sh_exc_edu_cess);
527:
528: ln_cess_amount number;
529: ln_sh_cess_amount number; /* added by ssawant for bug 5989740 */
530: lv_process_flag varchar2(5);

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

550: jai_cmn_taxes_all jtc
551: WHERE
552: jspl.delivery_detail_id = jsptl.delivery_detail_id AND
553: jsptl.tax_id = jtc.tax_id AND
554: upper(jtc.tax_type) IN (jai_constants.tax_type_cvd_edu_cess,jai_constants.tax_type_exc_edu_cess) AND
555: jspl.delivery_detail_id = cp_delivery_detail_id;
556:
557: ln_del_det_totcess_amt JAI_CMN_RG_I_TRXS.CESS_AMT%TYPE;
558: /* End of bug 4566054 */

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

568: JAI_CMN_TAXES_ALL jtc
569: WHERE
570: jspl.delivery_detail_id = jsptl.delivery_detail_id AND
571: jsptl.tax_id = jtc.tax_id AND
572: upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,
573: jai_constants.tax_type_sh_exc_edu_cess)
574: AND
575: jspl.delivery_detail_id = cp_delivery_detail_id;
576:

Line 573: jai_constants.tax_type_sh_exc_edu_cess)

569: WHERE
570: jspl.delivery_detail_id = jsptl.delivery_detail_id AND
571: jsptl.tax_id = jtc.tax_id AND
572: upper(jtc.tax_type) IN (jai_constants.tax_type_sh_cvd_edu_cess,
573: jai_constants.tax_type_sh_exc_edu_cess)
574: AND
575: jspl.delivery_detail_id = cp_delivery_detail_id;
576:
577: ln_del_det_totshcess_amt JAI_CMN_RG_I_TRXS.SH_CESS_AMT%TYPE;

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

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

Line 1103: lv_debug := jai_constants.yes ;

1099: jai_om_rg.plb 120.4
1100:
1101: ------------------------------------------------------------------------------------------------------------------------------------------------*/
1102: /* Ramananda for File.Sql.35 */
1103: lv_debug := jai_constants.yes ;
1104: lv_procedure_name := 'process_delivery';
1105: v_creation_date := SYSDATE;
1106: v_source_name := 'Register India' ;
1107: v_category_name := 'Register India' ;

Line 1848: jai_constants.source_wsh

1844: v_last_update_login ,
1845: v_assessable_value ,
1846: ln_del_det_totcess_amt , /*Parameters p_cess_amt and p_source added by aiyer for the bug 4566054 */
1847: ln_del_det_totshcess_amt , --Bgowrava for forward porting bug#5989740
1848: jai_constants.source_wsh
1849: );
1850:
1851: lv_statement_no := '31';
1852: SELECT JAI_CMN_RG_I_TRXS_S.CURRVAL INTO v_part_i_register_id FROM dual;

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

2527: v_oth_excise_duty_amount := p_oth_excise_duty_amount;
2528: v_export_oriented_unit := p_export_oriented_unit;
2529: v_register_code := p_register_code;
2530:
2531: v_debug_flag := jai_constants.no; --Ramananda for File.Sql.35
2532:
2533: If v_debug_flag = 'Y' THEN
2534: --For Fetching UTIL File.......
2535: BEGIN

Line 2588: if lv_process_flag <> jai_constants.successful then

2584: p_process_flag => lv_process_flag ,
2585: p_process_message => lv_process_message
2586: );
2587:
2588: if lv_process_flag <> jai_constants.successful then
2589: lv_rg23a_cess_avlbl := 'FALSE';
2590: else
2591: lv_rg23a_cess_avlbl := 'TRUE';
2592: end if;

Line 2603: if lv_process_flag <> jai_constants.successful then

2599: p_process_flag => lv_process_flag ,
2600: p_process_message => lv_process_message
2601: );
2602:
2603: if lv_process_flag <> jai_constants.successful then
2604: lv_rg23a_sh_cess_avlbl := 'FALSE';
2605: else
2606: lv_rg23a_sh_cess_avlbl := 'TRUE';
2607: end if;

Line 2620: if lv_process_flag <> jai_constants.successful then

2616: p_process_flag => lv_process_flag ,
2617: p_process_message => lv_process_message
2618: );
2619:
2620: if lv_process_flag <> jai_constants.successful then
2621: lv_rg23c_cess_avlbl := 'FALSE';
2622: else
2623: lv_rg23c_cess_avlbl := 'TRUE';
2624: end if;

Line 2636: if lv_process_flag <> jai_constants.successful then

2632: p_process_flag => lv_process_flag ,
2633: p_process_message => lv_process_message
2634: );
2635:
2636: if lv_process_flag <> jai_constants.successful then
2637: lv_rg23a_sh_cess_avlbl := 'FALSE';
2638: else
2639: lv_rg23a_sh_cess_avlbl := 'TRUE';
2640: end if;

Line 2653: if lv_process_flag <> jai_constants.successful then

2649: p_process_flag => lv_process_flag ,
2650: p_process_message => lv_process_message
2651: );
2652:
2653: if lv_process_flag <> jai_constants.successful then
2654: lv_pla_cess_avlbl := 'FALSE';
2655: else
2656: lv_pla_cess_avlbl := 'TRUE';
2657: end if;

Line 2668: if lv_process_flag <> jai_constants.successful then

2664: p_process_flag => lv_process_flag ,
2665: p_process_message => lv_process_message
2666: );
2667:
2668: if lv_process_flag <> jai_constants.successful then
2669: lv_rg23a_sh_cess_avlbl := 'FALSE';
2670: else
2671: lv_rg23a_sh_cess_avlbl := 'TRUE';
2672: end if;