APPS.GMD_STATUS_PUB dependencies on GMD_RECIPE_VALIDITY_RULES

Line 194: FROM gmd_recipe_validity_rules

190: -- Gets the validity rule details and its current status code
191: -- Bug 5347418 added recipe_use
192: CURSOR get_curr_vr_status(vVR_id NUMBER) IS
193: SELECT recipe_validity_rule_id, validity_rule_status, recipe_use
194: FROM gmd_recipe_validity_rules
195: WHERE recipe_validity_rule_id = vVR_id;
196:
197: -- Bug 5394532
198: -- Gets the substitution details and its current status code

Line 212: FROM gmd_recipes r, gmd_recipe_validity_rules vr

208:
209: -- Gets the formula associated with the val rule
210: CURSOR get_vr_dets(vVR_id NUMBER) IS
211: SELECT r.formula_id, vr.organization_id
212: FROM gmd_recipes r, gmd_recipe_validity_rules vr
213: WHERE r.recipe_id = vr.recipe_id
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

Line 221: FROM gmd_status s, gmd_recipe_validity_rules v

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
223: AND v.validity_rule_status = s.status_code
224: AND (to_number(s.status_type) < to_number('800')
225: OR s.status_type = '900') );

Line 232: FROM gmd_status s, gmd_recipe_validity_rules v

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
234: AND v.validity_rule_status = s.status_code
235: AND to_number(s.status_type) < to_number('800') );
236:

Line 242: FROM gmd_status s, gmd_recipe_validity_rules v

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
244: AND v.validity_rule_status = s.status_code
245: AND to_number(s.status_type) < to_number('1000') );
246:

Line 259: FROM mtl_system_items i, gmd_recipe_validity_rules v

255: CURSOR Cur_chk_prod_exec_enabled (V_val_rule_id NUMBER) IS
256: -- Get process ececution enabled setting for the val rule orgn
257: -- (Local val rules)
258: SELECT i.process_execution_enabled_flag
259: FROM mtl_system_items i, gmd_recipe_validity_rules v
260: WHERE v.recipe_validity_rule_id = V_val_rule_id
261: AND i.inventory_item_id = v.inventory_item_id
262: AND i.organization_id = v.organization_id
263: AND v.organization_id IS NOT NULL

Line 268: FROM mtl_system_items i, gmd_recipe_validity_rules v, gmd_recipes_b re

264: UNION
265: -- Get process ececution enabled setting for the recipe owning orgn
266: -- for Global recipes (Global val rules)
267: SELECT i.process_execution_enabled_flag
268: FROM mtl_system_items i, gmd_recipe_validity_rules v, gmd_recipes_b re
269: WHERE v.recipe_validity_rule_id = V_val_rule_id
270: AND i.inventory_item_id = v.inventory_item_id
271: AND v.recipe_id = re.recipe_id
272: AND i.organization_id = re.owner_organization_id

Line 730: UPDATE gmd_recipe_validity_rules

726: IF (p_ignore_flag) THEN
727: -- Now update the VR according to recipe status change
728: IF (to_number(l_to_status_type) = 800) THEN
729: -- Change status to ON-HOLD for less than ON-HOLD
730: UPDATE gmd_recipe_validity_rules
731: SET validity_rule_status = P_to_status
732: WHERE recipe_id = l_entity_id
733: AND (to_number(validity_rule_status) < to_number('800') OR
734: to_number(validity_rule_status) between 900 and 999);

Line 736: UPDATE gmd_recipe_validity_rules

732: WHERE recipe_id = l_entity_id
733: AND (to_number(validity_rule_status) < to_number('800') OR
734: to_number(validity_rule_status) between 900 and 999);
735: ELSIF (to_number(l_to_status_type) = 900) THEN
736: UPDATE gmd_recipe_validity_rules
737: SET validity_rule_status = P_to_status
738: WHERE recipe_id = l_entity_id
739: AND to_number(validity_rule_status) < to_number('800') ;
740: ELSIF (to_number(l_to_status_type) = 1000) THEN

Line 744: UPDATE gmd_recipe_validity_rules

740: ELSIF (to_number(l_to_status_type) = 1000) THEN
741: IF (l_debug = 'Y') THEN
742: gmd_debug.put_line('Ignore flag was true and we are about update VR ');
743: END IF;
744: UPDATE gmd_recipe_validity_rules
745: SET validity_rule_status = P_to_status
746: WHERE recipe_id = l_entity_id
747: AND to_number(validity_rule_status) < to_number('1000') ;
748: END IF;

Line 948: 'VALIDITY','GMD_RECIPE_VALIDITY_RULES') INTO l_table_name

944: 'FORMULA','FM_FORM_MST_B',
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)