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.

[Home] [Help]

APPS.JAI_MTL_TRXS_PKG dependencies on JAI_CMN_RG_I_TRXS

Line 391: l_range JAI_CMN_RG_I_TRXS.range_no%TYPE;

387: r_rcpts_match c_rcpts_match%rowtype;
388:
389: l_trading JAI_CMN_INVENTORY_ORGS.trading%TYPE;
390: l_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%TYPE;
391: l_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
392: l_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
393: l_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
394: l_register_id_ii JAI_CMN_RG_I_TRXS.register_id_part_ii%TYPE;
395: l_slno JAI_CMN_RG_I_TRXS.slno%TYPE;

Line 392: l_division JAI_CMN_RG_I_TRXS.division_no%TYPE;

388:
389: l_trading JAI_CMN_INVENTORY_ORGS.trading%TYPE;
390: l_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%TYPE;
391: l_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
392: l_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
393: l_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
394: l_register_id_ii JAI_CMN_RG_I_TRXS.register_id_part_ii%TYPE;
395: l_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
396: l_fin_year JAI_CMN_FIN_YEARS.fin_year%TYPE;

Line 393: l_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;

389: l_trading JAI_CMN_INVENTORY_ORGS.trading%TYPE;
390: l_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%TYPE;
391: l_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
392: l_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
393: l_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
394: l_register_id_ii JAI_CMN_RG_I_TRXS.register_id_part_ii%TYPE;
395: l_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
396: l_fin_year JAI_CMN_FIN_YEARS.fin_year%TYPE;
397: l_register_type VARCHAR2(3);

Line 394: l_register_id_ii JAI_CMN_RG_I_TRXS.register_id_part_ii%TYPE;

390: l_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing%TYPE;
391: l_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
392: l_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
393: l_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
394: l_register_id_ii JAI_CMN_RG_I_TRXS.register_id_part_ii%TYPE;
395: l_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
396: l_fin_year JAI_CMN_FIN_YEARS.fin_year%TYPE;
397: l_register_type VARCHAR2(3);
398: l_excise_duty NUMBER;

Line 395: l_slno JAI_CMN_RG_I_TRXS.slno%TYPE;

391: l_range JAI_CMN_RG_I_TRXS.range_no%TYPE;
392: l_division JAI_CMN_RG_I_TRXS.division_no%TYPE;
393: l_register_id JAI_CMN_RG_I_TRXS.register_id%TYPE;
394: l_register_id_ii JAI_CMN_RG_I_TRXS.register_id_part_ii%TYPE;
395: l_slno JAI_CMN_RG_I_TRXS.slno%TYPE;
396: l_fin_year JAI_CMN_FIN_YEARS.fin_year%TYPE;
397: l_register_type VARCHAR2(3);
398: l_excise_duty NUMBER;
399: l_additional_ed NUMBER;

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

464:
465: IF l_manufacturing = 'Y' THEN
466: IF main_rec.excise_flag = 'Y' AND main_rec.bonded = 'Y' AND
467: main_rec.item_class IN ('FGIN','FGEX','CCEX','CCIN') THEN
468: stmt_name := 'Calling JAI_CMN_RG_I_TRXS_pkg.create_rg1_entry';
469: JAI_CMN_RG_I_TRXS_pkg.create_rg1_entry(
470: P_REGISTER_ID => l_register_id,
471: P_REGISTER_ID_PART_II => null,
472: P_FIN_YEAR => l_fin_year,

Line 469: JAI_CMN_RG_I_TRXS_pkg.create_rg1_entry(

465: IF l_manufacturing = 'Y' THEN
466: IF main_rec.excise_flag = 'Y' AND main_rec.bonded = 'Y' AND
467: main_rec.item_class IN ('FGIN','FGEX','CCEX','CCIN') THEN
468: stmt_name := 'Calling JAI_CMN_RG_I_TRXS_pkg.create_rg1_entry';
469: JAI_CMN_RG_I_TRXS_pkg.create_rg1_entry(
470: P_REGISTER_ID => l_register_id,
471: P_REGISTER_ID_PART_II => null,
472: P_FIN_YEAR => l_fin_year,
473: P_SLNO => l_slno,

Line 736: UPDATE JAI_CMN_RG_I_TRXS

732: P_PROCESS_STATUS => l_process_status,
733: P_PROCESS_MESSAGE => l_process_message
734: );
735: IF processed_flag = 'RG1' THEN
736: UPDATE JAI_CMN_RG_I_TRXS
737: SET register_id_part_ii = l_register_id_ii,cess_amt = ln_Cess_amount
738: WHERE register_id = l_register_id;
739: ELSE
740: UPDATE JAI_CMN_RG_23AC_I_TRXS SET register_id_part_ii = l_register_id_ii WHERE register_id = l_register_id;