APPS.GMD_RECIPE_HEADER_PVT dependencies on GMD_STATUS

Line 360: l_meaning GMD_STATUS.meaning%TYPE;

356:
357: l_user_id fnd_user.user_id%TYPE := 0;
358: l_surrogate gmd_recipes.recipe_id%TYPE := 0;
359:
360: l_meaning GMD_STATUS.meaning%TYPE;
361: l_description GMD_STATUS.description%TYPE;
362:
363: /* Formula variables */
364: l_formula_id fm_form_mst.formula_id%TYPE := 0;

Line 361: l_description GMD_STATUS.description%TYPE;

357: l_user_id fnd_user.user_id%TYPE := 0;
358: l_surrogate gmd_recipes.recipe_id%TYPE := 0;
359:
360: l_meaning GMD_STATUS.meaning%TYPE;
361: l_description GMD_STATUS.description%TYPE;
362:
363: /* Formula variables */
364: l_formula_id fm_form_mst.formula_id%TYPE := 0;
365: l_formula_no fm_form_mst.formula_no%TYPE;

Line 390: From GMD_RECIPES r,gmd_status b

386:
387:
388: CURSOR cur_getrcprout(pRecipe_id GMD_RECIPES.recipe_id%TYPE) IS
389: Select r.routing_id,b.status_type
390: From GMD_RECIPES r,gmd_status b
391: Where Recipe_id = pRecipe_id
392: And r.Recipe_status = b.Status_code;--BUG#3427313
393:
394: -- Cursor and declaration as per as Bug 5138316 KSHUKLA

Line 424: l_status_type gmd_status.status_type%type;

420: l_delValRule BOOLEAN := FALSE;
421: -- End of declaration as per as 5138316 KSHUKLA
422: l_val_rt_status BOOLEAN;
423: x_routing_id NUMBER;
424: l_status_type gmd_status.status_type%type;
425: BEGIN
426: /* Initialize API return status to success */
427: x_return_status := FND_API.G_RET_STS_SUCCESS;
428: