APPS.GMD_CONC_REPLACE_PKG dependencies on GMD_RECIPES_B

Line 40: WHERE formula_id = (SELECT formula_id FROM gmd_recipes_b

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)
42: AND line_type = 1);
43:
44: fnd_message.set_name('GMD', 'GMD_DELETE_RECIPE_FM_DEP');

Line 255: l_owner_org GMD_RECIPES_B.owner_orgn_code%TYPE;

251: l_oprn_id GMD_OPERATIONS_B.oprn_id%TYPE;
252: l_oprn_line_id GMD_OPERATION_ACTIVITIES.oprn_line_id%TYPE;
253:
254:
255: l_owner_org GMD_RECIPES_B.owner_orgn_code%TYPE;
256: l_organization_id GMD_RECIPES_B.owner_organization_id%TYPE;
257: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE;
258: l_recipe_type GMD_RECIPES_B.recipe_type%TYPE;
259:

Line 256: l_organization_id GMD_RECIPES_B.owner_organization_id%TYPE;

252: l_oprn_line_id GMD_OPERATION_ACTIVITIES.oprn_line_id%TYPE;
253:
254:
255: l_owner_org GMD_RECIPES_B.owner_orgn_code%TYPE;
256: l_organization_id GMD_RECIPES_B.owner_organization_id%TYPE;
257: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE;
258: l_recipe_type GMD_RECIPES_B.recipe_type%TYPE;
259:
260: l_user_id NUMBER := FND_GLOBAL.USER_ID;

Line 257: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE;

253:
254:
255: l_owner_org GMD_RECIPES_B.owner_orgn_code%TYPE;
256: l_organization_id GMD_RECIPES_B.owner_organization_id%TYPE;
257: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE;
258: l_recipe_type GMD_RECIPES_B.recipe_type%TYPE;
259:
260: l_user_id NUMBER := FND_GLOBAL.USER_ID;
261:

Line 258: l_recipe_type GMD_RECIPES_B.recipe_type%TYPE;

254:
255: l_owner_org GMD_RECIPES_B.owner_orgn_code%TYPE;
256: l_organization_id GMD_RECIPES_B.owner_organization_id%TYPE;
257: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE;
258: l_recipe_type GMD_RECIPES_B.recipe_type%TYPE;
259:
260: l_user_id NUMBER := FND_GLOBAL.USER_ID;
261:
262: l_dummy_cnt NUMBER;

Line 312: FROM gmd_recipes_b

308:
309: -- Cursor to get formula_id when recipe_id is passed
310: CURSOR get_formula_id(v_recp_id NUMBER) IS
311: SELECT formula_id
312: FROM gmd_recipes_b
313: WHERE recipe_id = v_recp_id;
314:
315: -- Cursor to get formula_id when Validity Rule Id is passed
316: CURSOR get_recp_formula_id(v_vr_id NUMBER) IS

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 355: FROM gmd_recipes_b

351: /* END Declaration KSHUKLA bug 5198213 */
352:
353: CURSOR Cur_get_recipe_org (V_recipe_id NUMBER) IS
354: SELECT owner_organization_id
355: FROM gmd_recipes_b
356: WHERE recipe_id = V_recipe_id;
357:
358: -- Bug 5531717 Added
359: CURSOR Cur_get_recipe_override_org (V_recipe_id NUMBER) IS

Line 850: FROM gmd_recipes_b rcp

846: ELSIF (get_object_rec.object_type = 'RECIPE') THEN
847: -- Get the action flag to decide on update or insert(version control)
848: SELECT rcp.owner_organization_id
849: INTO l_orgn_id
850: FROM gmd_recipes_b rcp
851: WHERE rcp.recipe_id = get_object_rec.object_id;
852:
853: -- Get the Recipe version control for the entity orgn.
854: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,

Line 1022: FROM gmd_recipes_b

1018: RAISE No_Update_Exception;
1019: ELSE
1020: SELECT recipe_version
1021: INTO l_object_version
1022: FROM gmd_recipes_b
1023: WHERE recipe_id = l_recipe_id;
1024:
1025: -- Setup message to indicate that a new version
1026: -- has been created

Line 1067: UPDATE gmd_recipes_b

1063: END IF;
1064:
1065: ELSIF (l_action_flag IN ('U')) THEN
1066: -- Perform updates
1067: UPDATE gmd_recipes_b
1068: SET formula_id = DECODE(get_object_rec.replace_type,'FORMULA_ID'
1069: ,get_object_rec.new_name
1070: ,formula_id),
1071: routing_id = DECODE(get_object_rec.replace_type,'ROUTING_ID'

Line 1959: 'RECIPE','GMD_RECIPES_B',

1955: AND Concurrent_id IS NULL;
1956:
1957: SELECT DECODE(pObject_type,
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,

Line 2082: FROM GMD_RECIPES_B

2078: fnd_dsql.add_bind(pOld_name);
2079: fnd_dsql.add_text(' ))');
2080: ELSIF ((pObject_type = 'RECIPE') AND (pReplace_type = 'OWNER_ORGANIZATION_ID'))THEN
2081: fnd_dsql.add_text(' SELECT RECIPE_ID
2082: FROM GMD_RECIPES_B
2083: WHERE OWNER_ORGANIZATION_ID = ');
2084: fnd_dsql.add_bind(pOld_name);
2085: fnd_dsql.add_text(' ))');
2086: ELSIF ((pObject_type = 'VALIDITY') AND (pReplace_type = 'ORGANIZATION_ID'))THEN