APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_RECIPE_VALIDITY_RULES

Line 37: DELETE FROM gmd_recipe_validity_rules

33: BEGIN
34: IF (update_item = 'FORMULA') THEN
35: /* Bug 3037410 Appended the where clause to check for the
36: validity rule's Product */
37: DELETE FROM gmd_recipe_validity_rules
38: WHERE recipe_id = precipe_id AND
39: inventory_item_id NOT IN (SELECT inventory_item_id FROM fm_matl_dtl
40: WHERE formula_id = (SELECT formula_id FROM gmd_recipes_b
41: WHERE recipe_id = precipe_id)

Line 471: FROM gmd_recipes_b r, gmd_recipe_validity_rules vr

467:
468: -- Cursor to get formula_id when Validity Rule Id is passed
469: CURSOR get_recp_formula_id(v_vr_id NUMBER) IS
470: SELECT r.formula_id
471: FROM gmd_recipes_b r, gmd_recipe_validity_rules vr
472: WHERE vr.recipe_validity_rule_id = v_vr_id
473: AND r.recipe_id = vr.recipe_id;
474:
475: CURSOR Cur_get_validity (V_rcp_vldty_rule_id NUMBER) IS

Line 477: FROM gmd_recipe_validity_rules

473: AND r.recipe_id = vr.recipe_id;
474:
475: CURSOR Cur_get_validity (V_rcp_vldty_rule_id NUMBER) IS
476: SELECT recipe_id
477: FROM gmd_recipe_validity_rules
478: WHERE recipe_validity_rule_id = V_rcp_vldty_rule_id;
479:
480: CURSOR Cur_check_item (V_form_id NUMBER, V_item_id NUMBER) IS
481: SELECT 1

Line 2148: 'VALIDITY','GMD_RECIPE_VALIDITY_RULES'),

2144: 'FORMULA','FM_FORM_MST_B',
2145: 'RECIPE','GMD_RECIPES_B',
2146: 'OPERATION','GMD_OPERATIONS_B',
2147: 'ROUTING','GMD_ROUTINGS_B',
2148: 'VALIDITY','GMD_RECIPE_VALIDITY_RULES'),
2149: DECODE(pObject_type,
2150: 'FORMULA','FORMULA_ID',
2151: 'RECIPE','RECIPE_ID',
2152: 'OPERATION','OPRN_ID',

Line 2274: FROM GMD_RECIPE_VALIDITY_RULES

2270: fnd_dsql.add_bind(pOld_name);
2271: fnd_dsql.add_text(' ))');
2272: ELSIF ((pObject_type = 'VALIDITY') AND (pReplace_type = 'ORGANIZATION_ID'))THEN
2273: fnd_dsql.add_text(' SELECT recipe_validity_rule_id
2274: FROM GMD_RECIPE_VALIDITY_RULES
2275: WHERE ORGANIZATION_ID = ');
2276: fnd_dsql.add_bind(pOld_name);
2277: fnd_dsql.add_text(' ))');
2278: ELSIF (pReplace_type IN ('START_DATE','END_DATE')) THEN