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 318: FROM gmd_recipes_b r, gmd_recipe_validity_rules vr

314:
315: -- Cursor to get formula_id when Validity Rule Id is passed
316: CURSOR get_recp_formula_id(v_vr_id NUMBER) IS
317: SELECT r.formula_id
318: FROM gmd_recipes_b r, gmd_recipe_validity_rules vr
319: WHERE vr.recipe_validity_rule_id = v_vr_id
320: AND r.recipe_id = vr.recipe_id;
321:
322: CURSOR Cur_get_validity (V_rcp_vldty_rule_id NUMBER) IS

Line 324: FROM gmd_recipe_validity_rules

320: AND r.recipe_id = vr.recipe_id;
321:
322: CURSOR Cur_get_validity (V_rcp_vldty_rule_id NUMBER) IS
323: SELECT recipe_id
324: FROM gmd_recipe_validity_rules
325: WHERE recipe_validity_rule_id = V_rcp_vldty_rule_id;
326:
327: CURSOR Cur_check_item (V_form_id NUMBER, V_item_id NUMBER) IS
328: SELECT 1

Line 1962: 'VALIDITY','GMD_RECIPE_VALIDITY_RULES'),

1958: 'FORMULA','FM_FORM_MST_B',
1959: 'RECIPE','GMD_RECIPES_B',
1960: 'OPERATION','GMD_OPERATIONS_B',
1961: 'ROUTING','GMD_ROUTINGS_B',
1962: 'VALIDITY','GMD_RECIPE_VALIDITY_RULES'),
1963: DECODE(pObject_type,
1964: 'FORMULA','FORMULA_ID',
1965: 'RECIPE','RECIPE_ID',
1966: 'OPERATION','OPRN_ID',

Line 2088: FROM GMD_RECIPE_VALIDITY_RULES

2084: fnd_dsql.add_bind(pOld_name);
2085: fnd_dsql.add_text(' ))');
2086: ELSIF ((pObject_type = 'VALIDITY') AND (pReplace_type = 'ORGANIZATION_ID'))THEN
2087: fnd_dsql.add_text(' SELECT recipe_validity_rule_id
2088: FROM GMD_RECIPE_VALIDITY_RULES
2089: WHERE ORGANIZATION_ID = ');
2090: fnd_dsql.add_bind(pOld_name);
2091: fnd_dsql.add_text(' ))');
2092: ELSIF (pReplace_type IN ('START_DATE','END_DATE')) THEN