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_PA_BILLING_PKG dependencies on JAI_CMN_RG_BALANCES

Line 1411: cursor c_jai_cmn_rg_balances(cpn_organization_id number, cpn_location_id number) is

1407: or
1408: (cpn_location_id is null and (location_id is null or location_id = 0) )
1409: );
1410:
1411: cursor c_jai_cmn_rg_balances(cpn_organization_id number, cpn_location_id number) is
1412: select nvl(rg23a_balance,0) rg23a_balance
1413: ,nvl(rg23c_balance,0) rg23c_balance
1414: ,nvl(pla_balance,0) pla_balance
1415: ,nvl(basic_pla_balance,0) basic_pla_balance

Line 1418: from jai_cmn_rg_balances

1414: ,nvl(pla_balance,0) pla_balance
1415: ,nvl(basic_pla_balance,0) basic_pla_balance
1416: ,nvl(additional_pla_balance,0) additional_pla_balance
1417: ,nvl(other_pla_balance,0) other_pla_balance
1418: from jai_cmn_rg_balances
1419: where organization_id = cpn_organization_id
1420: and location_id = cpn_location_id;
1421:
1422: r_jai_cmn_inventory_orgs c_jai_cmn_inventory_orgs%rowtype;

Line 1424: r_jai_cmn_rg_balances c_jai_cmn_rg_balances%rowtype;

1420: and location_id = cpn_location_id;
1421:
1422: r_jai_cmn_inventory_orgs c_jai_cmn_inventory_orgs%rowtype;
1423: r_jai_cmn_inventory_orgs1 c_jai_cmn_inventory_orgs%rowtype;
1424: r_jai_cmn_rg_balances c_jai_cmn_rg_balances%rowtype;
1425:
1426: ln_pref_rg23a jai_cmn_inventory_orgs.pref_rg23a%type;
1427: ln_pref_rg23c jai_cmn_inventory_orgs.pref_rg23c%type;
1428: ln_pref_pla jai_cmn_inventory_orgs.pref_pla%type;

Line 1481: open c_jai_cmn_rg_balances(pn_organization_id, pn_location_id);

1477: end if;
1478:
1479: ln_tot_excise_amt := nvl(pn_basic_excise_amt,0) + nvl(pn_additional_excise_amt,0) + nvl(pn_other_excise_amt,0);
1480:
1481: open c_jai_cmn_rg_balances(pn_organization_id, pn_location_id);
1482: fetch c_jai_cmn_rg_balances into r_jai_cmn_rg_balances;
1483: close c_jai_cmn_rg_balances;
1484:
1485: pv_register := jai_om_wsh_processing_pkg.excise_balance_check (

Line 1482: fetch c_jai_cmn_rg_balances into r_jai_cmn_rg_balances;

1478:
1479: ln_tot_excise_amt := nvl(pn_basic_excise_amt,0) + nvl(pn_additional_excise_amt,0) + nvl(pn_other_excise_amt,0);
1480:
1481: open c_jai_cmn_rg_balances(pn_organization_id, pn_location_id);
1482: fetch c_jai_cmn_rg_balances into r_jai_cmn_rg_balances;
1483: close c_jai_cmn_rg_balances;
1484:
1485: pv_register := jai_om_wsh_processing_pkg.excise_balance_check (
1486: p_pref_rg23a => ln_pref_rg23a ,

Line 1483: close c_jai_cmn_rg_balances;

1479: ln_tot_excise_amt := nvl(pn_basic_excise_amt,0) + nvl(pn_additional_excise_amt,0) + nvl(pn_other_excise_amt,0);
1480:
1481: open c_jai_cmn_rg_balances(pn_organization_id, pn_location_id);
1482: fetch c_jai_cmn_rg_balances into r_jai_cmn_rg_balances;
1483: close c_jai_cmn_rg_balances;
1484:
1485: pv_register := jai_om_wsh_processing_pkg.excise_balance_check (
1486: p_pref_rg23a => ln_pref_rg23a ,
1487: p_pref_rg23c => ln_pref_rg23c ,

Line 1491: p_rg23a_balance => r_jai_cmn_rg_balances.rg23a_balance ,

1487: p_pref_rg23c => ln_pref_rg23c ,
1488: p_pref_pla => ln_pref_pla ,
1489: p_ssi_unit_flag => lv_ssi_unit_flag ,
1490: p_tot_excise_amt => ln_tot_excise_amt ,
1491: p_rg23a_balance => r_jai_cmn_rg_balances.rg23a_balance ,
1492: p_rg23c_balance => r_jai_cmn_rg_balances.rg23c_balance ,
1493: p_pla_balance => r_jai_cmn_rg_balances.pla_balance ,
1494: p_basic_pla_balance => r_jai_cmn_rg_balances.basic_pla_balance ,
1495: p_additional_pla_balance => r_jai_cmn_rg_balances.additional_pla_balance ,

Line 1492: p_rg23c_balance => r_jai_cmn_rg_balances.rg23c_balance ,

1488: p_pref_pla => ln_pref_pla ,
1489: p_ssi_unit_flag => lv_ssi_unit_flag ,
1490: p_tot_excise_amt => ln_tot_excise_amt ,
1491: p_rg23a_balance => r_jai_cmn_rg_balances.rg23a_balance ,
1492: p_rg23c_balance => r_jai_cmn_rg_balances.rg23c_balance ,
1493: p_pla_balance => r_jai_cmn_rg_balances.pla_balance ,
1494: p_basic_pla_balance => r_jai_cmn_rg_balances.basic_pla_balance ,
1495: p_additional_pla_balance => r_jai_cmn_rg_balances.additional_pla_balance ,
1496: p_other_pla_balance => r_jai_cmn_rg_balances.other_pla_balance ,

Line 1493: p_pla_balance => r_jai_cmn_rg_balances.pla_balance ,

1489: p_ssi_unit_flag => lv_ssi_unit_flag ,
1490: p_tot_excise_amt => ln_tot_excise_amt ,
1491: p_rg23a_balance => r_jai_cmn_rg_balances.rg23a_balance ,
1492: p_rg23c_balance => r_jai_cmn_rg_balances.rg23c_balance ,
1493: p_pla_balance => r_jai_cmn_rg_balances.pla_balance ,
1494: p_basic_pla_balance => r_jai_cmn_rg_balances.basic_pla_balance ,
1495: p_additional_pla_balance => r_jai_cmn_rg_balances.additional_pla_balance ,
1496: p_other_pla_balance => r_jai_cmn_rg_balances.other_pla_balance ,
1497: p_basic_excise_duty_amount => pn_basic_excise_amt ,

Line 1494: p_basic_pla_balance => r_jai_cmn_rg_balances.basic_pla_balance ,

1490: p_tot_excise_amt => ln_tot_excise_amt ,
1491: p_rg23a_balance => r_jai_cmn_rg_balances.rg23a_balance ,
1492: p_rg23c_balance => r_jai_cmn_rg_balances.rg23c_balance ,
1493: p_pla_balance => r_jai_cmn_rg_balances.pla_balance ,
1494: p_basic_pla_balance => r_jai_cmn_rg_balances.basic_pla_balance ,
1495: p_additional_pla_balance => r_jai_cmn_rg_balances.additional_pla_balance ,
1496: p_other_pla_balance => r_jai_cmn_rg_balances.other_pla_balance ,
1497: p_basic_excise_duty_amount => pn_basic_excise_amt ,
1498: p_add_excise_duty_amount => pn_additional_excise_amt ,

Line 1495: p_additional_pla_balance => r_jai_cmn_rg_balances.additional_pla_balance ,

1491: p_rg23a_balance => r_jai_cmn_rg_balances.rg23a_balance ,
1492: p_rg23c_balance => r_jai_cmn_rg_balances.rg23c_balance ,
1493: p_pla_balance => r_jai_cmn_rg_balances.pla_balance ,
1494: p_basic_pla_balance => r_jai_cmn_rg_balances.basic_pla_balance ,
1495: p_additional_pla_balance => r_jai_cmn_rg_balances.additional_pla_balance ,
1496: p_other_pla_balance => r_jai_cmn_rg_balances.other_pla_balance ,
1497: p_basic_excise_duty_amount => pn_basic_excise_amt ,
1498: p_add_excise_duty_amount => pn_additional_excise_amt ,
1499: p_oth_excise_duty_amount => pn_other_excise_amt ,

Line 1496: p_other_pla_balance => r_jai_cmn_rg_balances.other_pla_balance ,

1492: p_rg23c_balance => r_jai_cmn_rg_balances.rg23c_balance ,
1493: p_pla_balance => r_jai_cmn_rg_balances.pla_balance ,
1494: p_basic_pla_balance => r_jai_cmn_rg_balances.basic_pla_balance ,
1495: p_additional_pla_balance => r_jai_cmn_rg_balances.additional_pla_balance ,
1496: p_other_pla_balance => r_jai_cmn_rg_balances.other_pla_balance ,
1497: p_basic_excise_duty_amount => pn_basic_excise_amt ,
1498: p_add_excise_duty_amount => pn_additional_excise_amt ,
1499: p_oth_excise_duty_amount => pn_other_excise_amt ,
1500: p_export_oriented_unit => lv_export_oriented_unit ,