APPS.GMD_RECIPE_DESIGNER_PKG dependencies on GMD_RECIPES_B

Line 736: FROM gmd_recipes_b

732: x_error_msg OUT NOCOPY VARCHAR2) IS
733:
734: CURSOR Get_RoutingId IS
735: SELECT routing_id, planned_process_loss, owner_organization_id
736: FROM gmd_recipes_b
737: WHERE recipe_id = p_recipe_id;
738:
739: l_routing_id NUMBER(10) := 0;
740: l_charge_tbl GMD_COMMON_VAL.charge_tbl;

Line 1935: GMD_RECIPES_B

1931: IF l_recipe_rec.recipe_no <> p_recipe_no OR
1932: l_recipe_rec.recipe_version <> p_recipe_version THEN
1933:
1934: UPDATE
1935: GMD_RECIPES_B
1936: SET
1937: recipe_no = p_recipe_no,
1938: recipe_version = p_recipe_version
1939: WHERE

Line 4305: DELETE gmd_recipes_b WHERE recipe_id = p_copy_from_recipe_id;

4301: --- Create recipe header record
4302: ---
4303:
4304: IF NOT l_copy_recipe THEN
4305: DELETE gmd_recipes_b WHERE recipe_id = p_copy_from_recipe_id;
4306: END IF;
4307:
4308: IF x_routing_id <= 0 THEN
4309: l_recipe_tbl.ROUTING_ID := NULL;

Line 5450: FROM gmd_recipes_b

5446: x_return_code OUT NOCOPY VARCHAR2) IS
5447:
5448: CURSOR Cur_get_recp_orgn IS
5449: SELECT owner_organization_id
5450: FROM gmd_recipes_b
5451: WHERE recipe_id = p_recipe_id;
5452:
5453: l_orgn_id NUMBER;
5454: l_return_status VARCHAR2(10);

Line 5483: FROM gmd_recipes_b

5479: x_return_code OUT NOCOPY VARCHAR2) IS
5480:
5481: CURSOR get_recipe_details (l_recipe_id NUMBER) IS
5482: SELECT formula_id, owner_organization_id
5483: FROM gmd_recipes_b
5484: WHERE recipe_id = l_recipe_id;
5485:
5486: l_orgn_id NUMBER;
5487: l_formula_id NUMBER;

Line 5546: FROM gmd_recipes_b

5542: WHERE formula_id = vFormula_id;
5543:
5544: CURSOR get_recipe_details(vRecipe_id NUMBER) IS
5545: SELECT owner_organization_id
5546: FROM gmd_recipes_b
5547: WHERE recipe_id = vRecipe_id;
5548:
5549: CURSOR get_routing_details(vRouting_id NUMBER) IS
5550: SELECT owner_organization_id