APPS.JAI_CMN_RG_I_TRXS_PKG dependencies on JAI_OM_RG_PKG

Line 159: vBalanceLoose := jai_om_rg_pkg.ja_in_rgi_balance(p_organization_id,p_location_id,p_inventory_item_id,p_fin_year,

155: p_err_buf := 'Enough RG1 balance is not available to Issue the Goods';
156: END IF;
157: */
158: /*Code modified to fetch the Opening Balance when no transactions currently exist in JAI_CMN_RG_I_TRXS*/
159: vBalanceLoose := jai_om_rg_pkg.ja_in_rgi_balance(p_organization_id,p_location_id,p_inventory_item_id,p_fin_year,
160: vMaxSlno,vBalancePacked);
161: /*Bug 9550254 - End*/
162:
163: IF p_transaction_type IN ('I', 'IA', 'IOI', 'PI') THEN

Line 405: vBalanceLoose := jai_om_rg_pkg.ja_in_rgi_balance(p_organization_id,p_location_id,p_inventory_item_id,p_fin_year,

401: AND location_id = p_location_id
402: AND inventory_item_id = p_inventory_item_id
403: AND fin_year = p_fin_year;
404: */
405: vBalanceLoose := jai_om_rg_pkg.ja_in_rgi_balance(p_organization_id,p_location_id,p_inventory_item_id,p_fin_year,
406: vMaxSlno,vBalancePacked);
407:
408: IF vMaxSlno IS NOT NULL THEN
409: SELECT NVL(balance_packed,0), NVL(balance_loose,0) INTO vBalancePacked, vBalanceLoose