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 1375: cursor c_jai_cmn_rg_balances(cpn_organization_id number, cpn_location_id number) is

1371: or
1372: (cpn_location_id is null and (location_id is null or location_id = 0) )
1373: );
1374:
1375: cursor c_jai_cmn_rg_balances(cpn_organization_id number, cpn_location_id number) is
1376: select nvl(rg23a_balance,0) rg23a_balance
1377: ,nvl(rg23c_balance,0) rg23c_balance
1378: ,nvl(pla_balance,0) pla_balance
1379: ,nvl(basic_pla_balance,0) basic_pla_balance

Line 1382: from jai_cmn_rg_balances

1378: ,nvl(pla_balance,0) pla_balance
1379: ,nvl(basic_pla_balance,0) basic_pla_balance
1380: ,nvl(additional_pla_balance,0) additional_pla_balance
1381: ,nvl(other_pla_balance,0) other_pla_balance
1382: from jai_cmn_rg_balances
1383: where organization_id = cpn_organization_id
1384: and location_id = cpn_location_id;
1385:
1386: r_jai_cmn_inventory_orgs c_jai_cmn_inventory_orgs%rowtype;

Line 1388: r_jai_cmn_rg_balances c_jai_cmn_rg_balances%rowtype;

1384: and location_id = cpn_location_id;
1385:
1386: r_jai_cmn_inventory_orgs c_jai_cmn_inventory_orgs%rowtype;
1387: r_jai_cmn_inventory_orgs1 c_jai_cmn_inventory_orgs%rowtype;
1388: r_jai_cmn_rg_balances c_jai_cmn_rg_balances%rowtype;
1389:
1390: ln_pref_rg23a jai_cmn_inventory_orgs.pref_rg23a%type;
1391: ln_pref_rg23c jai_cmn_inventory_orgs.pref_rg23c%type;
1392: ln_pref_pla jai_cmn_inventory_orgs.pref_pla%type;

Line 1445: open c_jai_cmn_rg_balances(pn_organization_id, pn_location_id);

1441: end if;
1442:
1443: ln_tot_excise_amt := nvl(pn_basic_excise_amt,0) + nvl(pn_additional_excise_amt,0) + nvl(pn_other_excise_amt,0);
1444:
1445: open c_jai_cmn_rg_balances(pn_organization_id, pn_location_id);
1446: fetch c_jai_cmn_rg_balances into r_jai_cmn_rg_balances;
1447: close c_jai_cmn_rg_balances;
1448:
1449: pv_register := jai_om_wsh_processing_pkg.excise_balance_check (

Line 1446: fetch c_jai_cmn_rg_balances into r_jai_cmn_rg_balances;

1442:
1443: ln_tot_excise_amt := nvl(pn_basic_excise_amt,0) + nvl(pn_additional_excise_amt,0) + nvl(pn_other_excise_amt,0);
1444:
1445: open c_jai_cmn_rg_balances(pn_organization_id, pn_location_id);
1446: fetch c_jai_cmn_rg_balances into r_jai_cmn_rg_balances;
1447: close c_jai_cmn_rg_balances;
1448:
1449: pv_register := jai_om_wsh_processing_pkg.excise_balance_check (
1450: p_pref_rg23a => ln_pref_rg23a ,

Line 1447: close c_jai_cmn_rg_balances;

1443: ln_tot_excise_amt := nvl(pn_basic_excise_amt,0) + nvl(pn_additional_excise_amt,0) + nvl(pn_other_excise_amt,0);
1444:
1445: open c_jai_cmn_rg_balances(pn_organization_id, pn_location_id);
1446: fetch c_jai_cmn_rg_balances into r_jai_cmn_rg_balances;
1447: close c_jai_cmn_rg_balances;
1448:
1449: pv_register := jai_om_wsh_processing_pkg.excise_balance_check (
1450: p_pref_rg23a => ln_pref_rg23a ,
1451: p_pref_rg23c => ln_pref_rg23c ,

Line 1455: p_rg23a_balance => r_jai_cmn_rg_balances.rg23a_balance ,

1451: p_pref_rg23c => ln_pref_rg23c ,
1452: p_pref_pla => ln_pref_pla ,
1453: p_ssi_unit_flag => lv_ssi_unit_flag ,
1454: p_tot_excise_amt => ln_tot_excise_amt ,
1455: p_rg23a_balance => r_jai_cmn_rg_balances.rg23a_balance ,
1456: p_rg23c_balance => r_jai_cmn_rg_balances.rg23c_balance ,
1457: p_pla_balance => r_jai_cmn_rg_balances.pla_balance ,
1458: p_basic_pla_balance => r_jai_cmn_rg_balances.basic_pla_balance ,
1459: p_additional_pla_balance => r_jai_cmn_rg_balances.additional_pla_balance ,

Line 1456: p_rg23c_balance => r_jai_cmn_rg_balances.rg23c_balance ,

1452: p_pref_pla => ln_pref_pla ,
1453: p_ssi_unit_flag => lv_ssi_unit_flag ,
1454: p_tot_excise_amt => ln_tot_excise_amt ,
1455: p_rg23a_balance => r_jai_cmn_rg_balances.rg23a_balance ,
1456: p_rg23c_balance => r_jai_cmn_rg_balances.rg23c_balance ,
1457: p_pla_balance => r_jai_cmn_rg_balances.pla_balance ,
1458: p_basic_pla_balance => r_jai_cmn_rg_balances.basic_pla_balance ,
1459: p_additional_pla_balance => r_jai_cmn_rg_balances.additional_pla_balance ,
1460: p_other_pla_balance => r_jai_cmn_rg_balances.other_pla_balance ,

Line 1457: p_pla_balance => r_jai_cmn_rg_balances.pla_balance ,

1453: p_ssi_unit_flag => lv_ssi_unit_flag ,
1454: p_tot_excise_amt => ln_tot_excise_amt ,
1455: p_rg23a_balance => r_jai_cmn_rg_balances.rg23a_balance ,
1456: p_rg23c_balance => r_jai_cmn_rg_balances.rg23c_balance ,
1457: p_pla_balance => r_jai_cmn_rg_balances.pla_balance ,
1458: p_basic_pla_balance => r_jai_cmn_rg_balances.basic_pla_balance ,
1459: p_additional_pla_balance => r_jai_cmn_rg_balances.additional_pla_balance ,
1460: p_other_pla_balance => r_jai_cmn_rg_balances.other_pla_balance ,
1461: p_basic_excise_duty_amount => pn_basic_excise_amt ,

Line 1458: p_basic_pla_balance => r_jai_cmn_rg_balances.basic_pla_balance ,

1454: p_tot_excise_amt => ln_tot_excise_amt ,
1455: p_rg23a_balance => r_jai_cmn_rg_balances.rg23a_balance ,
1456: p_rg23c_balance => r_jai_cmn_rg_balances.rg23c_balance ,
1457: p_pla_balance => r_jai_cmn_rg_balances.pla_balance ,
1458: p_basic_pla_balance => r_jai_cmn_rg_balances.basic_pla_balance ,
1459: p_additional_pla_balance => r_jai_cmn_rg_balances.additional_pla_balance ,
1460: p_other_pla_balance => r_jai_cmn_rg_balances.other_pla_balance ,
1461: p_basic_excise_duty_amount => pn_basic_excise_amt ,
1462: p_add_excise_duty_amount => pn_additional_excise_amt ,

Line 1459: p_additional_pla_balance => r_jai_cmn_rg_balances.additional_pla_balance ,

1455: p_rg23a_balance => r_jai_cmn_rg_balances.rg23a_balance ,
1456: p_rg23c_balance => r_jai_cmn_rg_balances.rg23c_balance ,
1457: p_pla_balance => r_jai_cmn_rg_balances.pla_balance ,
1458: p_basic_pla_balance => r_jai_cmn_rg_balances.basic_pla_balance ,
1459: p_additional_pla_balance => r_jai_cmn_rg_balances.additional_pla_balance ,
1460: p_other_pla_balance => r_jai_cmn_rg_balances.other_pla_balance ,
1461: p_basic_excise_duty_amount => pn_basic_excise_amt ,
1462: p_add_excise_duty_amount => pn_additional_excise_amt ,
1463: p_oth_excise_duty_amount => pn_other_excise_amt ,

Line 1460: p_other_pla_balance => r_jai_cmn_rg_balances.other_pla_balance ,

1456: p_rg23c_balance => r_jai_cmn_rg_balances.rg23c_balance ,
1457: p_pla_balance => r_jai_cmn_rg_balances.pla_balance ,
1458: p_basic_pla_balance => r_jai_cmn_rg_balances.basic_pla_balance ,
1459: p_additional_pla_balance => r_jai_cmn_rg_balances.additional_pla_balance ,
1460: p_other_pla_balance => r_jai_cmn_rg_balances.other_pla_balance ,
1461: p_basic_excise_duty_amount => pn_basic_excise_amt ,
1462: p_add_excise_duty_amount => pn_additional_excise_amt ,
1463: p_oth_excise_duty_amount => pn_other_excise_amt ,
1464: p_export_oriented_unit => lv_export_oriented_unit ,