APPS.JAI_EXCISE_SCRIPTS_PKG dependencies on JAI_CMN_RG_PERIOD_BALS

Line 361: DELETE JAI_CMN_RG_PERIOD_BALS

357: p_ret_code OUT NOCOPY NUMBER)
358: IS
359: BEGIN
360:
361: DELETE JAI_CMN_RG_PERIOD_BALS
362: WHERE organization_id = p_organization_id
363: AND location_id = p_location_id
364: AND register_type = decode(p_register_type,'A','RG23A','C','RG23C')
365: AND start_date >= p_start_date;

Line 374: jai_cmn_rg_period_bals_pkg.consolidate_balances( p_err_msg,

370: AND location_id = p_location_id
371: AND register_type = p_register_type
372: AND trunc(creation_date) >= p_start_date;
373:
374: jai_cmn_rg_period_bals_pkg.consolidate_balances( p_err_msg,
375: p_ret_code ,
376: NULL,
377: p_register_type,
378: trunc(last_day(add_months(sysdate,-1))));

Line 403: FROM JAI_CMN_RG_PERIOD_BALS

399: AND inventory_item_id <> 0;
400:
401: CURSOR cur_get_period_balance( cp_start_date DATE,cp_end_date DATE ) IS
402: SELECT closing_balance - opening_balance
403: FROM JAI_CMN_RG_PERIOD_BALS
404: WHERE organization_id = p_organization_id
405: AND location_id = p_location_id
406: AND register_type = decode(p_register_type,'A','RG23A','C','RG23C')
407: AND start_date = cp_start_date

Line 428: FROM JAI_CMN_RG_PERIOD_BALS

424: SELECT exc_edu_cess_cl_bal,
425: cvd_edu_cess_cl_bal,
426: sh_exc_edu_cess_cl_bal,
427: sh_cvd_edu_cess_cl_bal
428: FROM JAI_CMN_RG_PERIOD_BALS
429: WHERE organization_id = p_organization_id
430: AND location_id = p_location_id
431: AND register_type = decode(p_register_type,'A','RG23A','C','RG23C')
432: AND start_date = cp_start_date

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 ;