APPS.JAI_CMN_RG_OTHERS_PKG dependencies on JAI_CMN_INVENTORY_ORGS

Line 126: procedure check_balances(p_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE ,

122: p_process_msg := 'Error Occured in jai_cmn_rg_others_pkg.insert_row - ' || substr(sqlerrm,1,900);
123: END insert_row;
124:
125:
126: procedure check_balances(p_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE ,
127: p_location_id HR_LOCATIONS.LOCATION_ID%TYPE ,
128: p_register_type JAI_CMN_RG_OTH_BALANCES.REGISTER_TYPE%TYPE ,
129: p_trx_amount NUMBER ,
130: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 137: FROM JAI_CMN_INVENTORY_ORGS

133: IS
134:
135: CURSOR c_org_unit_id IS
136: SELECT org_unit_id
137: FROM JAI_CMN_INVENTORY_ORGS
138: WHERE organization_id = p_organization_id
139: AND location_id = p_location_id ;
140:
141: CURSOR c_balance_cur(cp_org_unit_id JAI_CMN_INVENTORY_ORGS.ORG_UNIT_ID%TYPE) IS

Line 141: CURSOR c_balance_cur(cp_org_unit_id JAI_CMN_INVENTORY_ORGS.ORG_UNIT_ID%TYPE) IS

137: FROM JAI_CMN_INVENTORY_ORGS
138: WHERE organization_id = p_organization_id
139: AND location_id = p_location_id ;
140:
141: CURSOR c_balance_cur(cp_org_unit_id JAI_CMN_INVENTORY_ORGS.ORG_UNIT_ID%TYPE) IS
142: SELECT NVL(SUM(balance),0)
143: FROM JAI_CMN_RG_OTH_BALANCES
144: WHERE org_unit_id = cp_org_unit_id
145: and register_type = p_register_type

Line 202: procedure check_sh_balances(p_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE ,

198: END;
199:
200: /*Procedure check_sh_balances is added to check balances for secondary and higher education cess */
201: -- start 5989740
202: procedure check_sh_balances(p_organization_id JAI_CMN_INVENTORY_ORGS.ORGANIZATION_ID%TYPE ,
203: p_location_id HR_LOCATIONS.LOCATION_ID%TYPE ,
204: p_register_type JAI_CMN_RG_OTH_BALANCES.REGISTER_TYPE%TYPE ,
205: p_trx_amount NUMBER ,
206: p_process_flag OUT NOCOPY VARCHAR2 ,

Line 213: FROM JAI_CMN_INVENTORY_ORGS

209: IS
210:
211: CURSOR c_org_unit_id IS
212: SELECT org_unit_id
213: FROM JAI_CMN_INVENTORY_ORGS
214: WHERE organization_id = p_organization_id
215: AND location_id = p_location_id ;
216:
217:

Line 218: CURSOR c_balance_cur(cp_org_unit_id JAI_CMN_INVENTORY_ORGS.ORG_UNIT_ID%TYPE) IS

214: WHERE organization_id = p_organization_id
215: AND location_id = p_location_id ;
216:
217:
218: CURSOR c_balance_cur(cp_org_unit_id JAI_CMN_INVENTORY_ORGS.ORG_UNIT_ID%TYPE) IS
219: SELECT NVL(SUM(balance),0)
220: FROM JAI_CMN_RG_OTH_BALANCES
221: WHERE org_unit_id = cp_org_unit_id
222: and register_type = p_register_type