258: IS
259: --Cursor define here
260: CURSOR chk_org_cur IS
261: SELECT COUNT(organization_id)
262: FROM org_organization_definitions
263: WHERE operating_unit = pn_chk_org_id;
264:
265: CURSOR chk_organization_cur IS
266: SELECT COUNT(organization_id)
263: WHERE operating_unit = pn_chk_org_id;
264:
265: CURSOR chk_organization_cur IS
266: SELECT COUNT(organization_id)
267: FROM org_organization_definitions
268: WHERE operating_unit = pn_chk_org_id
269: AND organization_id = pn_chk_organization_id;
270:
271: CURSOR chk_loc_cur IS
276:
277: CURSOR chk_combination_cur IS
278: SELECT COUNT(b.organization_id)
279: FROM jai_cmn_inventory_orgs a
280: , org_organization_definitions b
281: WHERE b.operating_unit = pn_chk_org_id
282: AND a.organization_id = pn_chk_organization_id
283: AND a.location_id = pn_chk_location_id
284: AND a.organization_id = b.organization_id;