[Home] [Help]
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.
56: * END IF;
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