[Home] [Help]
40: * (select oprn_id from fm_rout_dtl where routing_id is current routing)
41: * IF any operation_status returned by select is On-hold, Obsolete or less than
42: * the TO_STATUS of the routing, set the boolean to FALSE.
43: * IF the entity is Recipes THEN
44: * select formula_status from fm_form_mst where formula_id is in
45: * (select formula_id from gmd_recipes where recipe_id is current recipe)
46: * select routing_status from fm_rout_hdr where routing_id is in
47: * (select routing_id from gmd_recipes where recipe_id is current recipe)
48: * IF either formula or routing status returned by select is on-hold, obsolete
112: ELSIF P_entity_type = 3 THEN
113: /* if entity is recipe, check formula and routing */
114: OPEN Formula_Status_cur FOR
115: Select f.formula_status, g.routing_id
116: From fm_form_mst f, gmd_recipes g
117: Where g.formula_id = f.formula_id
118: and g.recipe_id = P_Entity_id;
119: FETCH Formula_Status_cur into l_cur_dependent_status, l_routing_defined;
120: IF (l_cur_dependent_status between 800 and 899)