DBA Data[Home] [Help]

APPS.GMD_RECIPE_DESIGNER_PKG dependencies on GMD_RECIPE_HEADER

Line 1794: l_recipe_tbl GMD_RECIPE_HEADER.recipe_hdr;

1790: recipe_id = p_recipe_id AND
1791: last_update_date = p_last_update_date_origin;
1792:
1793: l_recipe_rec GMD_RECIPES%ROWTYPE;
1794: l_recipe_tbl GMD_RECIPE_HEADER.recipe_hdr;
1795: l_recipe_update_flex GMD_RECIPE_HEADER.update_flex;
1796:
1797: l_return_status VARCHAR2(2);
1798: l_msg_count NUMBER(10);

Line 1795: l_recipe_update_flex GMD_RECIPE_HEADER.update_flex;

1791: last_update_date = p_last_update_date_origin;
1792:
1793: l_recipe_rec GMD_RECIPES%ROWTYPE;
1794: l_recipe_tbl GMD_RECIPE_HEADER.recipe_hdr;
1795: l_recipe_update_flex GMD_RECIPE_HEADER.update_flex;
1796:
1797: l_return_status VARCHAR2(2);
1798: l_msg_count NUMBER(10);
1799: l_message_count NUMBER;

Line 1914: GMD_RECIPE_HEADER_PVT.Update_Recipe_Header

1910: l_recipe_update_flex.ATTRIBUTE28 := l_recipe_rec.attribute28;
1911: l_recipe_update_flex.ATTRIBUTE29 := l_recipe_rec.attribute29;
1912: l_recipe_update_flex.ATTRIBUTE30 := l_recipe_rec.attribute30;
1913:
1914: GMD_RECIPE_HEADER_PVT.Update_Recipe_Header
1915: ( p_recipe_header_rec => l_recipe_tbl
1916: ,p_flex_header_rec => l_recipe_update_flex
1917: ,x_return_status => l_return_status);
1918:

Line 2749: l_recipe_hdr GMD_RECIPE_HEADER.recipe_hdr;

2745: WHERE
2746: recipe_id = p_recipe_id AND
2747: last_update_date = p_last_update_date_orig;
2748:
2749: l_recipe_hdr GMD_RECIPE_HEADER.recipe_hdr;
2750: l_recipe_flex GMD_RECIPE_HEADER.update_flex;
2751: l_recipe_rec GMD_RECIPES%ROWTYPE;
2752:
2753: l_status VARCHAR2(30);

Line 2750: l_recipe_flex GMD_RECIPE_HEADER.update_flex;

2746: recipe_id = p_recipe_id AND
2747: last_update_date = p_last_update_date_orig;
2748:
2749: l_recipe_hdr GMD_RECIPE_HEADER.recipe_hdr;
2750: l_recipe_flex GMD_RECIPE_HEADER.update_flex;
2751: l_recipe_rec GMD_RECIPES%ROWTYPE;
2752:
2753: l_status VARCHAR2(30);
2754: l_msg_cnt NUMBER;

Line 2830: GMD_RECIPE_HEADER_PVT.Delete_Recipe_Header

2826: l_recipe_flex.ATTRIBUTE27 := l_recipe_rec.attribute27;
2827: l_recipe_flex.ATTRIBUTE28 := l_recipe_rec.attribute28;
2828: l_recipe_flex.ATTRIBUTE29 := l_recipe_rec.attribute29;
2829:
2830: GMD_RECIPE_HEADER_PVT.Delete_Recipe_Header
2831: ( p_recipe_header_rec => l_recipe_hdr
2832: ,p_flex_header_rec => l_recipe_flex
2833: ,x_return_status => l_status);
2834:

Line 2898: l_recipe_hdr GMD_RECIPE_HEADER.recipe_hdr;

2894: WHERE
2895: recipe_id = p_recipe_id AND
2896: last_update_date = p_last_update_date_orig;
2897:
2898: l_recipe_hdr GMD_RECIPE_HEADER.recipe_hdr;
2899: l_recipe_flex GMD_RECIPE_HEADER.update_flex;
2900: l_recipe_rec GMD_RECIPES%ROWTYPE;
2901: l_status VARCHAR2(30);
2902: l_msg_cnt NUMBER;

Line 2899: l_recipe_flex GMD_RECIPE_HEADER.update_flex;

2895: recipe_id = p_recipe_id AND
2896: last_update_date = p_last_update_date_orig;
2897:
2898: l_recipe_hdr GMD_RECIPE_HEADER.recipe_hdr;
2899: l_recipe_flex GMD_RECIPE_HEADER.update_flex;
2900: l_recipe_rec GMD_RECIPES%ROWTYPE;
2901: l_status VARCHAR2(30);
2902: l_msg_cnt NUMBER;
2903: l_msg_dat VARCHAR2(30);

Line 2978: GMD_RECIPE_HEADER_PVT.Delete_Recipe_Header

2974: l_recipe_flex.ATTRIBUTE27 := l_recipe_rec.attribute27;
2975: l_recipe_flex.ATTRIBUTE28 := l_recipe_rec.attribute28;
2976: l_recipe_flex.ATTRIBUTE29 := l_recipe_rec.attribute29;
2977:
2978: GMD_RECIPE_HEADER_PVT.Delete_Recipe_Header
2979: ( p_recipe_header_rec => l_recipe_hdr
2980: ,p_flex_header_rec => l_recipe_flex
2981: ,x_return_status => l_status);
2982:

Line 3374: l_recipe_tbl GMD_RECIPE_HEADER.recipe_hdr;

3370: l_copy_routing BOOLEAN;
3371: l_routing_update_allowed BOOLEAN;
3372: l_new_routing BOOLEAN;
3373: l_rtg_upd_tbl GMD_ROUTINGS_PUB.update_tbl_type;
3374: l_recipe_tbl GMD_RECIPE_HEADER.recipe_hdr;
3375: l_recipe_update_flex GMD_RECIPE_HEADER.flex;
3376: COPY_RECIPE_EXCEPTION EXCEPTION;
3377: COPY_ROUTING_EXCEPTION EXCEPTION;
3378: COPY_FORMULA_EXCEPTION EXCEPTION;

Line 3375: l_recipe_update_flex GMD_RECIPE_HEADER.flex;

3371: l_routing_update_allowed BOOLEAN;
3372: l_new_routing BOOLEAN;
3373: l_rtg_upd_tbl GMD_ROUTINGS_PUB.update_tbl_type;
3374: l_recipe_tbl GMD_RECIPE_HEADER.recipe_hdr;
3375: l_recipe_update_flex GMD_RECIPE_HEADER.flex;
3376: COPY_RECIPE_EXCEPTION EXCEPTION;
3377: COPY_ROUTING_EXCEPTION EXCEPTION;
3378: COPY_FORMULA_EXCEPTION EXCEPTION;
3379: COPY_FORM_DTL_EXCEPTION EXCEPTION;

Line 4379: GMD_RECIPE_HEADER_PVT.Create_Recipe_Header

4375: l_recipe_update_flex.ATTRIBUTE28 := l_rcp_hdr_rec.attribute28;
4376: l_recipe_update_flex.ATTRIBUTE29 := l_rcp_hdr_rec.attribute29;
4377: l_recipe_update_flex.ATTRIBUTE30 := l_rcp_hdr_rec.attribute30;
4378:
4379: GMD_RECIPE_HEADER_PVT.Create_Recipe_Header
4380: ( p_recipe_header_rec => l_recipe_tbl
4381: ,p_recipe_hdr_flex_rec => l_recipe_update_flex
4382: ,x_return_status => l_return_code);
4383: