[Home] [Help]
214: AND vr.recipe_validity_rule_id = vVR_id;
215:
216: -- Recipe being changed to ON-HOLD - check for less than ON-HOLD and FROZEN
217: Cursor check_val_rules_800(vEntity_id NUMBER) IS
218: SELECT 1 from sys.dual
219: WHERE EXISTS (
220: SELECT recipe_validity_rule_id
221: FROM gmd_status s, gmd_recipe_validity_rules v
222: WHERE recipe_id = vEntity_id
225: OR s.status_type = '900') );
226:
227: -- Recipe being FROZEN - check for less than ON-HOLD (as on-hold stays on-hold )
228: Cursor check_val_rules_900(vEntity_id NUMBER) IS
229: SELECT 1 from sys.dual
230: WHERE EXISTS (
231: SELECT recipe_validity_rule_id
232: FROM gmd_status s, gmd_recipe_validity_rules v
233: WHERE recipe_id = vEntity_id
235: AND to_number(s.status_type) < to_number('800') );
236:
237: -- Recipe being OBSOLETED - thus check for less than obsolete
238: Cursor check_val_rules_1000(vEntity_id NUMBER) IS
239: SELECT 1 from sys.dual
240: WHERE EXISTS (
241: SELECT recipe_validity_rule_id
242: FROM gmd_status s, gmd_recipe_validity_rules v
243: WHERE recipe_id = vEntity_id
630: 'RECIPE','GMD_RECIPE_BTCH_DEP',
631: 'OPERATION','GMD_OPERATION_INUSE',
632: 'ROUTING','GMD_ROUTING_INUSE',
633: 'VALIDITY','GMD_VR_BTCH_DEP') INTO l_mesg_text
634: FROM sys.dual;
635:
636: IF l_entity_name IN ('FORMULA','OPERATION','ROUTING') THEN
637: FND_MESSAGE.SET_NAME('GMD',l_mesg_text);
638: FND_MSG_PUB.ADD;
660: 'RECIPE',3,
661: 'OPERATION',2,
662: 'ROUTING',4,
663: 'VALIDITY',5) INTO l_entity_value
664: FROM sys.dual;
665:
666: IF NOT ( GMD_STATUS_CODE.CHECK_DEPENDENT_STATUS
667: (l_entity_value,
668: l_entity_id,
945: 'RECIPE','GMD_RECIPES_B',
946: 'OPERATION','GMD_OPERATIONS_B',
947: 'ROUTING','GMD_ROUTINGS_B',
948: 'VALIDITY','GMD_RECIPE_VALIDITY_RULES') INTO l_table_name
949: FROM sys.dual;
950: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
951: 'TABLE_NAME',l_table_name,
952: 'KEY',NVL(p_entity_id, l_entity_id)
953: );