[Home] [Help]
24: l_recipe_description GMD_RECIPES.RECIPE_DESCRIPTION%TYPE;
25: l_owner_id GMD_RECIPES.OWNER_ID%TYPE;
26: l_creation_orgn_code ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE%TYPE;
27: l_creation_orgn_id GMD_RECIPES.creation_organization_id%TYPE;
28: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
29: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
30: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
31: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
32: /* Mercy Thomas Bug 3173515 End of the changes */
25: l_owner_id GMD_RECIPES.OWNER_ID%TYPE;
26: l_creation_orgn_code ORG_ORGANIZATION_DEFINITIONS.ORGANIZATION_CODE%TYPE;
27: l_creation_orgn_id GMD_RECIPES.creation_organization_id%TYPE;
28: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
29: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
30: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
31: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
32: /* Mercy Thomas Bug 3173515 End of the changes */
33:
96:
97: /* Mercy Thomas Bug 3173515 Added the following variables for the NPD workflow changes */
98: SELECT A.RECIPE_DESCRIPTION, A.OWNER_ID, A.CREATION_ORGANIZATION_ID, C.FORMULA_NO, C.FORMULA_VERS, B.ROUTING_NO, B.ROUTING_VERS
99: INTO l_recipe_description, l_owner_id, l_creation_orgn_id, l_formula_no, l_formula_vers, l_routing_no, l_routing_vers
100: FROM GMD_RECIPES A, GMD_ROUTINGS B, FM_FORM_MST C
101: WHERE A.RECIPE_ID = P_RECIPE_ID
102: AND A.ROUTING_ID = B.ROUTING_ID (+)
103: AND A.FORMULA_ID = C.FORMULA_ID;
104:
282: l_recipe_use VARCHAR2(1);
283:
284: CURSOR c_get_details IS
285: SELECT r.owner_organization_id, r.formula_id, r.recipe_no, r.recipe_version, f.formula_status
286: FROM gmd_recipes_b r, fm_form_mst_b f
287: WHERE r.recipe_id = l_recipe_id
288: AND r.formula_id = f.formula_id;
289: LocalDetailsRecord c_get_details%ROWTYPE;
290: