APPS.GMD_RECIPE_HEADER_PVT dependencies on GMD_RECIPES

Line 58: l_surrogate gmd_recipes.recipe_id%TYPE := 0;

54:
55: /* Defining all local variables */
56: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECIPE_HEADER';
57: l_user_id fnd_user.user_id%TYPE := 0;
58: l_surrogate gmd_recipes.recipe_id%TYPE := 0;
59:
60:
61: /* Recipe variables */
62: l_recipe_id gmd_recipes.recipe_id%TYPE := 0;

Line 62: l_recipe_id gmd_recipes.recipe_id%TYPE := 0;

58: l_surrogate gmd_recipes.recipe_id%TYPE := 0;
59:
60:
61: /* Recipe variables */
62: l_recipe_id gmd_recipes.recipe_id%TYPE := 0;
63:
64: /* Formula variables */
65: l_formula_id fm_form_mst.formula_id%TYPE := 0;
66: l_formula_no fm_form_mst.formula_no%TYPE;

Line 241: GMD_RECIPES_MLS.INSERT_ROW(

237: /* on-insert pkg to insert into */
238: /* and table */
239: /* Text Code is handled by another package. */
240:
241: GMD_RECIPES_MLS.INSERT_ROW(
242: X_ROWID => l_rowid,
243: X_RECIPE_ID => l_recipe_id,
244: X_RECIPE_NO => p_recipe_header_rec.recipe_no,
245: X_RECIPE_VERSION => p_recipe_header_rec.recipe_version,

Line 358: l_surrogate gmd_recipes.recipe_id%TYPE := 0;

354: /* Defining all local variables */
355: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_HEADER';
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:

Line 388: CURSOR cur_getrcprout(pRecipe_id GMD_RECIPES.recipe_id%TYPE) IS

384: l_msg_count NUMBER;
385: l_msg_data VARCHAR2(2000);
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

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 541: GMD_RECIPES_MLS.UPDATE_ROW(

537: /* on-insert pkg to insert into */
538: /* and table */
539: /* Text Code is handled by another package. */
540: IF (x_return_status = 'S') THEN
541: GMD_RECIPES_MLS.UPDATE_ROW(
542: X_RECIPE_ID => p_recipe_header_rec.recipe_id,
543: X_OWNER_ID => p_recipe_header_rec.owner_id,
544: X_OWNER_LAB_TYPE => p_recipe_header_rec.owner_lab_type,
545: X_DELETE_MARK => p_recipe_header_rec.delete_mark,

Line 720: ( p_old_recipe_id IN GMD_RECIPES_B.recipe_id%TYPE ,

716: /* End of comments */
717: /* ===================================================*/
718:
719: PROCEDURE COPY_RECIPE_HEADER
720: ( p_old_recipe_id IN GMD_RECIPES_B.recipe_id%TYPE ,
721: p_recipe_header_rec IN GMD_RECIPE_HEADER.recipe_hdr ,
722: p_recipe_hdr_flex_rec IN GMD_RECIPE_HEADER.flex ,
723: x_return_status OUT NOCOPY VARCHAR2
724: ) IS

Line 726: CURSOR get_old_recipe_record(vRecipe_id GMD_RECIPES_B.recipe_id%TYPE) IS

722: p_recipe_hdr_flex_rec IN GMD_RECIPE_HEADER.flex ,
723: x_return_status OUT NOCOPY VARCHAR2
724: ) IS
725:
726: CURSOR get_old_recipe_record(vRecipe_id GMD_RECIPES_B.recipe_id%TYPE) IS
727: SELECT *
728: FROM gmd_recipes
729: WHERE recipe_id = vRecipe_id;
730:

Line 728: FROM gmd_recipes

724: ) IS
725:
726: CURSOR get_old_recipe_record(vRecipe_id GMD_RECIPES_B.recipe_id%TYPE) IS
727: SELECT *
728: FROM gmd_recipes
729: WHERE recipe_id = vRecipe_id;
730:
731: CURSOR get_next_recipe_version (vRecipe_no GMD_RECIPES_B.recipe_no%TYPE) IS
732: SELECT max(Recipe_version) + 1

Line 731: CURSOR get_next_recipe_version (vRecipe_no GMD_RECIPES_B.recipe_no%TYPE) IS

727: SELECT *
728: FROM gmd_recipes
729: WHERE recipe_id = vRecipe_id;
730:
731: CURSOR get_next_recipe_version (vRecipe_no GMD_RECIPES_B.recipe_no%TYPE) IS
732: SELECT max(Recipe_version) + 1
733: FROM gmd_recipes_b
734: WHERE Recipe_no = vRecipe_no;
735:

Line 733: FROM gmd_recipes_b

729: WHERE recipe_id = vRecipe_id;
730:
731: CURSOR get_next_recipe_version (vRecipe_no GMD_RECIPES_B.recipe_no%TYPE) IS
732: SELECT max(Recipe_version) + 1
733: FROM gmd_recipes_b
734: WHERE Recipe_no = vRecipe_no;
735:
736: CURSOR get_formula_no_and_vers(vFormula_id FM_FORM_MST_B.formula_id%TYPE) IS
737: SELECT formula_no, formula_vers