[Home] [Help]
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
49: * or less than the TO_STATUS of the recipe, 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
49: * or less than the TO_STATUS of the recipe, set the boolean to FALSE.
50: * IF the entity is Validity Rules THEN
51: * select recipe_status from gmd_recipes where recipe_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
49: * or less than the TO_STATUS of the recipe, set the boolean to FALSE.
50: * IF the entity is Validity Rules THEN
51: * select recipe_status from gmd_recipes where recipe_id is in
52: * (select recipe_id from gmd_recipe_validity_rules where
53: * recipe_validity_rule_id is current recipe_validity_rule_id)
54: * IF recipe_status returned by select is on-hold, obsolete or
55: * less than the TO_STATUS of the validity_rule, set the boolean to FALSE.
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)
148: ELSIF P_entity_type = 5 THEN
149: /* if entity is validity_rule, check recipe */
150: OPEN Recipe_Status_cur FOR
151: Select g.recipe_status
152: From gmd_recipe_validity_rules vr, gmd_recipes g
153: Where vr.recipe_id = g.recipe_id
154: and vr.recipe_validity_rule_id = P_Entity_id;
155: FETCH Recipe_Status_cur into l_cur_dependent_status;
156: IF (l_cur_dependent_status between 800 and 899)
168: --KKILLAMS, Bug# 3283888: Validating the rule status aganist recipe status if recipe status is 'NEW'
169: --Set FALSE to "dependent_status_ok" variable if recipe status is NEW and validate rule status is FROZEN.
170: IF (p_entity_type =5) THEN
171: OPEN Recipe_Status_cur FOR
172: SELECT g.recipe_status FROM gmd_recipe_validity_rules vr, gmd_recipes_b g
173: WHERE vr.recipe_id = g.recipe_id
174: AND vr.recipe_validity_rule_id = p_Entity_id;
175: FETCH recipe_status_cur INTO l_cur_dependent_status;
176: CLOSE recipe_status_cur;
196: FUNCTION Check_parent_status (pentity_name VARCHAR2,pentity_id NUMBER) RETURN BOOLEAN IS
197:
198: CURSOR Cur_Check_Sts(l_recipe_id NUMBER) IS
199: SELECT COUNT(*)
200: FROM gmd_recipes r,gmd_recipe_validity_rules v
201: WHERE r.recipe_id = l_recipe_id
202: AND r.recipe_id = v.recipe_id
203: AND (r.recipe_status BETWEEN 700 AND 799
204: OR r.recipe_Status BETWEEN 400 AND 499
209: AND recipe_validity_rule_id = v.recipe_validity_rule_id);
210:
211: CURSOR Cur_Check_routing_recipe(l_routing_id NUMBER) IS
212: SELECT Count(*)
213: FROM gmd_recipes
214: WHERE routing_id = l_routing_id
215: AND (recipe_status between 700 and 799
216: OR recipe_status between 400 and 499
217: OR recipe_status between 900 and 999) ;
237:
238:
239: CURSOR Cur_check_form_recipe(l_formula_id NUMBER) IS
240: SELECT count(*)
241: FROM gmd_recipes
242: WHERE formula_id = l_formula_id
243: AND (recipe_status between 700 and 799
244: OR recipe_status between 400 and 499
245: OR recipe_status between 900 and 999);