APPS.GMD_API_GRP dependencies on GMD_RECIPES

Line 615: FROM gmd_recipes_b a, mtl_parameters b

611:
612: ELSIF (Entity = 'RECIPE') THEN
613: SELECT b.organization_code, b.organization_id
614: INTO l_owner_orgn_code, l_orgn_id
615: FROM gmd_recipes_b a, mtl_parameters b
616: WHERE recipe_id = Entity_id
617: AND a.owner_organization_id = b.organization_id;
618:
619: /* Check if user has access to this Recipe orgn */

Line 631: FROM gmd_recipes a , gmd_recipe_validity_rules b , mtl_parameters c

627:
628: ELSIF (Entity = 'VALIDITY') THEN
629: SELECT c.organization_code , a.owner_organization_id
630: INTO l_owner_orgn_code, l_orgn_id
631: FROM gmd_recipes a , gmd_recipe_validity_rules b , mtl_parameters c
632: WHERE b.recipe_validity_rule_id = Entity_id
633: AND a.recipe_id = b.recipe_id
634: AND a.owner_organization_id = c.organization_id ;
635:

Line 780: FROM gmd_recipes_b r,gmd_Status_b s

776: f.formula_status = s.status_code;
777:
778: CURSOR Cur_get_rsttyp(pobject_id NUMBER) IS
779: SELECT s.status_type
780: FROM gmd_recipes_b r,gmd_Status_b s
781: WHERE r.recipe_id = pobject_id AND
782: r.recipe_status = s.status_code;
783:
784: CURSOR Cur_get_osttyp(pobject_id NUMBER) IS

Line 845: FROM gmd_recipes

841: X_parent_check OUT NOCOPY BOOLEAN) IS
842: X_status VARCHAR2(5);
843: CURSOR Cur_get_recp_sts(entity_id NUMBER) IS
844: SELECT recipe_status
845: FROM gmd_recipes
846: WHERE recipe_id = entity_id
847: AND ((recipe_status between 700 and 799
848: OR recipe_status between 400 and 499));
849:

Line 979: FROM gmd_recipes_b

975: WHere oprn_id = vEntity_id;
976: ELSIF (vEntity = 'RECIPE') THEN
977: Select recipe_no, recipe_version, recipe_no||' - '||recipe_version
978: INTO l_object_name, l_object_version, l_object_name_and_version
979: FROM gmd_recipes_b
980: WHere recipe_id = vEntity_id;
981: ELSIF (vEntity = 'VALIDITY') THEN
982: Select r.recipe_no, r.recipe_version, r.recipe_no||' - '||r.recipe_version
983: INTO l_object_name, l_object_version, l_object_name_and_version

Line 984: FROM gmd_recipes_b r, gmd_recipe_validity_rules v

980: WHere recipe_id = vEntity_id;
981: ELSIF (vEntity = 'VALIDITY') THEN
982: Select r.recipe_no, r.recipe_version, r.recipe_no||' - '||r.recipe_version
983: INTO l_object_name, l_object_version, l_object_name_and_version
984: FROM gmd_recipes_b r, gmd_recipe_validity_rules v
985: WHere v.recipe_id = vEntity_id
986: AND v.recipe_id = r.recipe_id;
987: END IF;
988: END IF;

Line 1702: FROM gmd_recipes_b

1698: LocalInfoRecord c_get_recipe_info%ROWTYPE;
1699:
1700: CURSOR c_get_version(l_recipe_no VARCHAR2) IS
1701: SELECT max(recipe_version)
1702: FROM gmd_recipes_b
1703: WHERE recipe_no = l_recipe_no;
1704: LocalVersRecord c_get_version%ROWTYPE;
1705:
1706: CURSOR c_check_recipe(l_recipe_no VARCHAR2) IS

Line 1708: FROM gmd_recipes_b

1704: LocalVersRecord c_get_version%ROWTYPE;
1705:
1706: CURSOR c_check_recipe(l_recipe_no VARCHAR2) IS
1707: SELECT *
1708: FROM gmd_recipes_b
1709: WHERE recipe_no = l_recipe_no;
1710: LocalCheckRecord c_check_recipe%ROWTYPE;
1711:
1712: CURSOR c_get_item(l_item_id NUMBER) IS

Line 1736: l_recipe_description GMD_RECIPES_TL.RECIPE_DESCRIPTION%TYPE; -- bug14480509

1732: l_login_id NUMBER;
1733: l_recipe_no VARCHAR2(32);
1734: l_orgn_ID NUMBER;
1735: l_item_id NUMBER;
1736: l_recipe_description GMD_RECIPES_TL.RECIPE_DESCRIPTION%TYPE; -- bug14480509
1737: l_default_recipe_status gmd_api_grp.status_rec_type;
1738:
1739: l_routing_no VARCHAR2(32) := NULL;
1740: l_routing_vers NUMBER := NULL;