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_EXCISE_SCRIPTS_PKG dependencies on JAI_CMN_RG_SLNOS

Line 284: UPDATE JAI_CMN_RG_SLNOS

280: AND register_type = p_register_type
281: AND fin_year = p_fin_year
282: AND slno > p_slno;
283:
284: UPDATE JAI_CMN_RG_SLNOS
285: SET slno = slno + p_dup_cnt - 1
286: WHERE organization_id = p_organization_id
287: AND location_id = p_location_id
288: AND register_type = p_register_type

Line 319: UPDATE JAI_CMN_RG_SLNOS

315: AND location_id = p_location_id
316: AND fin_year = p_fin_year
317: AND slno > p_slno;
318:
319: UPDATE JAI_CMN_RG_SLNOS
320: SET slno = slno + p_dup_cnt - 1
321: WHERE organization_id = p_organization_id
322: AND location_id = p_location_id
323: AND register_type = p_register_type

Line 785: UPDATE JAI_CMN_RG_SLNOS

781:
782: END IF;
783:
784:
785: UPDATE JAI_CMN_RG_SLNOS
786: SET balance = p_closing_balance
787: WHERE organization_id = p_organization_id
788: AND location_id = p_location_id
789: AND register_type = p_register_type

Line 817: UPDATE JAI_CMN_RG_SLNOS

813: p_slno NUMBER)
814: IS
815: BEGIN
816:
817: UPDATE JAI_CMN_RG_SLNOS
818: SET slno = p_slno
819: WHERE organization_id = p_organization_id
820: AND location_id = p_location_id
821: AND register_type = p_register_type

Line 1393: UPDATE JAI_CMN_RG_SLNOS

1389: last_updated_by = p_last_updated_by
1390: WHERE organization_id = p_organization_id
1391: AND location_id = p_location_id ;
1392:
1393: UPDATE JAI_CMN_RG_SLNOS
1394: SET balance = ln_prev_balance
1395: WHERE organization_id = p_organization_id
1396: AND location_id = p_location_id
1397: AND register_type = 'A' ;

Line 1406: UPDATE JAI_CMN_RG_SLNOS

1402: SET rg23c_balance = ln_prev_balance
1403: WHERE organization_id = p_organization_id
1404: AND location_id = p_location_id ;
1405:
1406: UPDATE JAI_CMN_RG_SLNOS
1407: SET balance = ln_prev_balance
1408: WHERE organization_id = p_organization_id
1409: AND location_id = p_location_id
1410: AND register_type = 'C' ;

Line 1438: UPDATE JAI_CMN_RG_SLNOS

1434: last_updated_by = p_last_updated_by
1435: WHERE organization_id = p_organization_id
1436: AND location_id = p_location_id ;
1437:
1438: UPDATE JAI_CMN_RG_SLNOS
1439: SET balance = ln_prev_balance
1440: WHERE organization_id = p_organization_id
1441: AND location_id = p_location_id
1442: AND register_type = 'PLA' ;

Line 2239: from JAI_CMN_RG_SLNOS

2235: cp_register_type varchar2
2236: )
2237: is
2238: select balance , slno
2239: from JAI_CMN_RG_SLNOS
2240: where organization_id = cp_organization_id
2241: and location_id = cp_location_id
2242: and register_type = cp_register_type;
2243:

Line 2310: from JAI_CMN_RG_SLNOS

2306: cp_register_type JAI_CMN_RG_23AC_II_TRXS.REGISTER_TYPE%TYPE
2307: )
2308: is
2309: select balance
2310: from JAI_CMN_RG_SLNOS
2311: where
2312: organization_id = cp_organization_id AND
2313: location_id = cp_location_id AND
2314: register_type = cp_register_type ;

Line 2561: proceed with the fix : JAI_CMN_RG_23AC_II_TRXS,JAI_CMN_RG_PLA_TRXS ,JAI_CMN_RG_BALANCES ,JAI_CMN_RG_SLNOS ,JAI_CMN_RG_OTHERS ,JAI_CMN_RG_OTH_BALANCES ,JAI_CMN_RG_PERIOD_BALS' ) ;

2557: gn_exists := null ;
2558:
2559: if p_action = 3 and nvl(p_backup,'N') = 'N' then
2560: raise_application_error(-20054, ' Pls take a backup of the following tables from JA before you
2561: proceed with the fix : JAI_CMN_RG_23AC_II_TRXS,JAI_CMN_RG_PLA_TRXS ,JAI_CMN_RG_BALANCES ,JAI_CMN_RG_SLNOS ,JAI_CMN_RG_OTHERS ,JAI_CMN_RG_OTH_BALANCES ,JAI_CMN_RG_PERIOD_BALS' ) ;
2562: end if ;
2563:
2564: open c_check_addl_cvd ;
2565: fetch c_check_addl_cvd into gn_exists ;

Line 2657: -- Code to Validate balance in JAI_CMN_RG_SLNOS

2653: p_year => null
2654: ) ;
2655: end if ;
2656:
2657: -- Code to Validate balance in JAI_CMN_RG_SLNOS
2658: ln_rg_slno_balance := null ;
2659: ln_rg_slno := null ;
2660: open c_rg_slno_balance(rg23_bal_rec.organization_id,rg23_bal_rec.location_id, rg23_bal_rec.register_type) ;
2661: fetch c_rg_slno_balance into ln_rg_slno_balance, ln_rg_slno;

Line 2771: -- Code to Validate balance in JAI_CMN_RG_SLNOS

2767: p_year => null
2768: ) ;
2769: end if ;
2770:
2771: -- Code to Validate balance in JAI_CMN_RG_SLNOS
2772: ln_rg_slno_balance := null ;
2773: ln_rg_slno := null ;
2774: open c_rg_slno_balance(pla_bal_rec.organization_id,pla_bal_rec.location_id, 'PLA') ;
2775: fetch c_rg_slno_balance into ln_rg_slno_balance, ln_rg_slno;

Line 3629: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E11 : RG23 Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;

3625: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E09 : RG23 Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;
3626:
3627: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E10 : PLA Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;
3628:
3629: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E11 : RG23 Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;
3630:
3631: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E12 : PLA Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;
3632:
3633: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E13 : RG23 Last record Balance does not match with the balance in JAI_CMN_RG_BALANCES ' ) ;

Line 3631: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E12 : PLA Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;

3627: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E10 : PLA Other Tax Credit/Debit is not equal to the sum of credit/debit in JAI_CMN_RG_OTHERS ' ) ;
3628:
3629: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E11 : RG23 Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;
3630:
3631: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E12 : PLA Balance, Slno do not match with JAI_CMN_RG_SLNOS Balance,Slno ' ) ;
3632:
3633: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E13 : RG23 Last record Balance does not match with the balance in JAI_CMN_RG_BALANCES ' ) ;
3634:
3635: FND_FILE.PUT_LINE(FND_FILE.LOG, 'E14 : PLA Last record Balance does not match with the balance in JAI_CMN_RG_BALANCES ' ) ;