APPS.GMD_RECIPE_HEADER dependencies on GMD_RECIPES

Line 217: --Add this code after the call to gmd_recipes_mls.insert_row.

213: --Getting the default status for the owner orgn code or null orgn of recipe from parameters table
214: gmd_api_grp.get_status_details (V_entity_type => 'RECIPE',
215: V_orgn_id => p_recipe_header_rec.owner_organization_id, --w.r.t. bug 4004501 INVCONV kkillams
216: X_entity_status => l_entity_status);
217: --Add this code after the call to gmd_recipes_mls.insert_row.
218: IF (l_entity_status.entity_status <> 100) THEN
219: Gmd_status_pub.modify_status ( p_api_version => 1
220: , p_init_msg_list => TRUE
221: , p_entity_name => 'RECIPE'

Line 320: l_recipe_header_rec GMD_RECIPES%ROWTYPE;

316: /* Record types for data manipulation */
317: p_recipe_header_rec recipe_hdr;
318:
319: p_flex_header_rec update_flex;
320: l_recipe_header_rec GMD_RECIPES%ROWTYPE;
321:
322: /* Define a cursor for dealing with updates */
323: CURSOR Recipe_cur(pRecipe_id GMD_RECIPES.recipe_id%TYPE) IS
324: Select *

Line 323: CURSOR Recipe_cur(pRecipe_id GMD_RECIPES.recipe_id%TYPE) IS

319: p_flex_header_rec update_flex;
320: l_recipe_header_rec GMD_RECIPES%ROWTYPE;
321:
322: /* Define a cursor for dealing with updates */
323: CURSOR Recipe_cur(pRecipe_id GMD_RECIPES.recipe_id%TYPE) IS
324: Select *
325: From GMD_RECIPES
326: Where Recipe_id = pRecipe_id;
327:

Line 325: From GMD_RECIPES

321:
322: /* Define a cursor for dealing with updates */
323: CURSOR Recipe_cur(pRecipe_id GMD_RECIPES.recipe_id%TYPE) IS
324: Select *
325: From GMD_RECIPES
326: Where Recipe_id = pRecipe_id;
327:
328: update_recipe_err EXCEPTION;
329: setup_failure EXCEPTION;

Line 390: /* To be derived from gmd_recipes */

386: FND_MSG_PUB.ADD;
387: RAISE FND_API.G_EXC_ERROR;
388: END IF;
389:
390: /* To be derived from gmd_recipes */
391: OPEN Recipe_cur(l_recipe_id);
392: FETCH Recipe_cur INTO l_recipe_header_rec;
393: CLOSE Recipe_cur;
394: