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 390: l_owner_org GMD_RECIPES_B.owner_orgn_code%TYPE;

386: l_oprn_id GMD_OPERATIONS_B.oprn_id%TYPE;
387: l_oprn_line_id GMD_OPERATION_ACTIVITIES.oprn_line_id%TYPE;
388:
389:
390: l_owner_org GMD_RECIPES_B.owner_orgn_code%TYPE;
391: l_organization_id GMD_RECIPES_B.owner_organization_id%TYPE;
392: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE;
393: l_recipe_type GMD_RECIPES_B.recipe_type%TYPE;
394:

Line 391: l_organization_id GMD_RECIPES_B.owner_organization_id%TYPE;

387: l_oprn_line_id GMD_OPERATION_ACTIVITIES.oprn_line_id%TYPE;
388:
389:
390: l_owner_org GMD_RECIPES_B.owner_orgn_code%TYPE;
391: l_organization_id GMD_RECIPES_B.owner_organization_id%TYPE;
392: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE;
393: l_recipe_type GMD_RECIPES_B.recipe_type%TYPE;
394:
395: l_user_id NUMBER := FND_GLOBAL.USER_ID;

Line 392: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE;

388:
389:
390: l_owner_org GMD_RECIPES_B.owner_orgn_code%TYPE;
391: l_organization_id GMD_RECIPES_B.owner_organization_id%TYPE;
392: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE;
393: l_recipe_type GMD_RECIPES_B.recipe_type%TYPE;
394:
395: l_user_id NUMBER := FND_GLOBAL.USER_ID;
396:

Line 393: l_recipe_type GMD_RECIPES_B.recipe_type%TYPE;

389:
390: l_owner_org GMD_RECIPES_B.owner_orgn_code%TYPE;
391: l_organization_id GMD_RECIPES_B.owner_organization_id%TYPE;
392: l_recipe_id GMD_RECIPES_B.recipe_id%TYPE;
393: l_recipe_type GMD_RECIPES_B.recipe_type%TYPE;
394:
395: l_user_id NUMBER := FND_GLOBAL.USER_ID;
396:
397: l_dummy_cnt NUMBER;

Line 465: FROM gmd_recipes_b

461:
462: -- Cursor to get formula_id when recipe_id is passed
463: CURSOR get_formula_id(v_recp_id NUMBER) IS
464: SELECT formula_id
465: FROM gmd_recipes_b
466: WHERE recipe_id = v_recp_id;
467:
468: -- Cursor to get formula_id when Validity Rule Id is passed
469: CURSOR get_recp_formula_id(v_vr_id NUMBER) IS

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

504: /* END Declaration KSHUKLA bug 5198213 */
505:
506: CURSOR Cur_get_recipe_org (V_recipe_id NUMBER) IS
507: SELECT owner_organization_id
508: FROM gmd_recipes_b
509: WHERE recipe_id = V_recipe_id;
510:
511: -- Bug 5531717 Added
512: CURSOR Cur_get_recipe_override_org (V_recipe_id NUMBER) IS

Line 1003: FROM gmd_recipes_b rcp

999: ELSIF (get_object_rec.object_type = 'RECIPE') THEN
1000: -- Get the action flag to decide on update or insert(version control)
1001: SELECT rcp.owner_organization_id
1002: INTO l_orgn_id
1003: FROM gmd_recipes_b rcp
1004: WHERE rcp.recipe_id = get_object_rec.object_id;
1005:
1006: -- Get the Recipe version control for the entity orgn.
1007: GMD_API_GRP.FETCH_PARM_VALUES(P_orgn_id => l_orgn_id,

Line 1175: FROM gmd_recipes_b

1171: RAISE No_Update_Exception;
1172: ELSE
1173: SELECT recipe_version
1174: INTO l_object_version
1175: FROM gmd_recipes_b
1176: WHERE recipe_id = l_recipe_id;
1177:
1178: -- Setup message to indicate that a new version
1179: -- has been created

Line 1220: UPDATE gmd_recipes_b

1216: END IF;
1217:
1218: ELSIF (l_action_flag IN ('U')) THEN
1219: -- Perform updates
1220: UPDATE gmd_recipes_b
1221: SET formula_id = DECODE(get_object_rec.replace_type,'FORMULA_ID'
1222: ,get_object_rec.new_name
1223: ,formula_id),
1224: routing_id = DECODE(get_object_rec.replace_type,'ROUTING_ID'

Line 2145: 'RECIPE','GMD_RECIPES_B',

2141: AND Concurrent_id IS NULL;
2142:
2143: SELECT DECODE(pObject_type,
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,

Line 2268: FROM GMD_RECIPES_B

2264: fnd_dsql.add_bind(pOld_name);
2265: fnd_dsql.add_text(' ))');
2266: ELSIF ((pObject_type = 'RECIPE') AND (pReplace_type = 'OWNER_ORGANIZATION_ID'))THEN
2267: fnd_dsql.add_text(' SELECT RECIPE_ID
2268: FROM GMD_RECIPES_B
2269: WHERE OWNER_ORGANIZATION_ID = ');
2270: fnd_dsql.add_bind(pOld_name);
2271: fnd_dsql.add_text(' ))');
2272: ELSIF ((pObject_type = 'VALIDITY') AND (pReplace_type = 'ORGANIZATION_ID'))THEN