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_MTL_TRXS_PKG dependencies on JAI_CMN_RG_I_TRXS

Line 514: l_range JAI_CMN_RG_I_TRXS.range_no%TYPE;

510: r_rcpts_match c_rcpts_match%rowtype;
511:
512: l_trading JAI_CMN_INVENTORY_ORGS.trading%TYPE;
513: l_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%TYPE;
514: l_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
515: l_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
516: l_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
517: l_register_id_ii JAI_CMN_RG_I_TRXS.register_id_part_ii%TYPE;
518: l_slno JAI_CMN_RG_I_TRXS.slno%TYPE;

Line 515: l_division JAI_CMN_RG_I_TRXS.division_no%TYPE;

511:
512: l_trading JAI_CMN_INVENTORY_ORGS.trading%TYPE;
513: l_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%TYPE;
514: l_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
515: l_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
516: l_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
517: l_register_id_ii JAI_CMN_RG_I_TRXS.register_id_part_ii%TYPE;
518: l_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
519: l_fin_year JAI_CMN_FIN_YEARS.fin_year%TYPE;

Line 516: l_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;

512: l_trading JAI_CMN_INVENTORY_ORGS.trading%TYPE;
513: l_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%TYPE;
514: l_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
515: l_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
516: l_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
517: l_register_id_ii JAI_CMN_RG_I_TRXS.register_id_part_ii%TYPE;
518: l_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
519: l_fin_year JAI_CMN_FIN_YEARS.fin_year%TYPE;
520: l_register_type VARCHAR2(3);

Line 517: l_register_id_ii JAI_CMN_RG_I_TRXS.register_id_part_ii%TYPE;

513: l_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%TYPE;
514: l_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
515: l_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
516: l_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
517: l_register_id_ii JAI_CMN_RG_I_TRXS.register_id_part_ii%TYPE;
518: l_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
519: l_fin_year JAI_CMN_FIN_YEARS.fin_year%TYPE;
520: l_register_type VARCHAR2(3);
521: l_excise_duty NUMBER;

Line 518: l_slno JAI_CMN_RG_I_TRXS.slno%TYPE;

514: l_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
515: l_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
516: l_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
517: l_register_id_ii JAI_CMN_RG_I_TRXS.register_id_part_ii%TYPE;
518: l_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
519: l_fin_year JAI_CMN_FIN_YEARS.fin_year%TYPE;
520: l_register_type VARCHAR2(3);
521: l_excise_duty NUMBER;
522: l_additional_ed NUMBER;

Line 591: stmt_name := 'Calling JAI_CMN_RG_I_TRXS_pkg.create_rg1_entry';

587:
588: IF l_manufacturing = 'Y' THEN
589: IF main_rec.excise_flag = 'Y' AND main_rec.bonded = 'Y' AND
590: main_rec.item_class IN ('FGIN','FGEX','CCEX','CCIN') THEN
591: stmt_name := 'Calling JAI_CMN_RG_I_TRXS_pkg.create_rg1_entry';
592: JAI_CMN_RG_I_TRXS_pkg.create_rg1_entry(
593: P_REGISTER_ID => l_register_id,
594: P_REGISTER_ID_PART_II => null,
595: P_FIN_YEAR => l_fin_year,

Line 592: JAI_CMN_RG_I_TRXS_pkg.create_rg1_entry(

588: IF l_manufacturing = 'Y' THEN
589: IF main_rec.excise_flag = 'Y' AND main_rec.bonded = 'Y' AND
590: main_rec.item_class IN ('FGIN','FGEX','CCEX','CCIN') THEN
591: stmt_name := 'Calling JAI_CMN_RG_I_TRXS_pkg.create_rg1_entry';
592: JAI_CMN_RG_I_TRXS_pkg.create_rg1_entry(
593: P_REGISTER_ID => l_register_id,
594: P_REGISTER_ID_PART_II => null,
595: P_FIN_YEAR => l_fin_year,
596: P_SLNO => l_slno,

Line 859: UPDATE JAI_CMN_RG_I_TRXS

855: P_PROCESS_STATUS => l_process_status,
856: P_PROCESS_MESSAGE => l_process_message
857: );
858: IF processed_flag = 'RG1' THEN
859: UPDATE JAI_CMN_RG_I_TRXS
860: SET register_id_part_ii = l_register_id_ii,cess_amt = ln_Cess_amount
861: WHERE register_id = l_register_id;
862: ELSE
863: UPDATE JAI_CMN_RG_23AC_I_TRXS SET register_id_part_ii = l_register_id_ii WHERE register_id = l_register_id;