[Home] [Help]
47: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECIPE_PROCESS_LOSS';
48: l_api_version CONSTANT NUMBER := 1.0;
49:
50: l_user_id fnd_user.user_id%TYPE := 0;
51: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
52:
53: /* Variables used for defining status */
54: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
55: l_return_code NUMBER := 0;
261: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECIPE_CUSTOMERS';
262: l_api_version CONSTANT NUMBER := 1.0;
263:
264: l_user_id fnd_user.user_id%TYPE := 0;
265: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
266: l_customer_id NUMBER := 0;
267: l_site_id NUMBER := 0;
268: l_org_id NUMBER := 0;
269:
529: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECIPE_VR';
530: l_api_version CONSTANT NUMBER := 1.0;
531:
532: l_user_id fnd_user.user_id%TYPE := 0;
533: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
534:
535: /* Variables used for defining status */
536: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
537: l_return_code NUMBER := 0;
555: /* Get the matl dtl for the main product */
556: Cursor get_certain_VR_defaults(vRecipe_id NUMBER) IS
557: -- NPD Conv.
558: SELECT inventory_item_id, qty, detail_uom
559: FROM fm_matl_dtl f, gmd_recipes_b r
560: WHERE f.formula_id = r.formula_id
561: AND r.recipe_id = vRecipe_id
562: AND f.line_type = 1
563: AND f.line_no = 1;
564:
565: /* get the matl details for the item passed in */
566: Cursor get_specific_VR_details(vRecipe_id NUMBER, vItem_id NUMBER) IS
567: SELECT qty, detail_uom
568: FROM fm_matl_dtl f, gmd_recipes_b r
569: WHERE f.formula_id = r.formula_id
570: AND r.recipe_id = vRecipe_id
571: AND f.line_type IN (1,2)
572: AND f.inventory_item_id = vItem_id
582: /* Chcek VR dates against Routing dates */
583: CURSOR Get_Routing_Details(vRecipe_id NUMBER) IS
584: SELECT rt.Effective_Start_Date,
585: rt.Effective_End_Date
586: FROM gmd_routings_b rt, gmd_recipes_b rc
587: WHERE rc.routing_id = rt.routing_id AND
588: rc.recipe_id = vRecipe_id AND
589: rt.delete_mark = 0;
590:
591: CURSOR check_fmhdr_fixed_scale(vRecipe_id NUMBER) IS
592: SELECT 1
593: FROM sys.dual
594: WHERE EXISTS (Select h.formula_id
595: From fm_form_mst h, gmd_recipes_b r
596: WHERE r.formula_id = h.formula_id AND
597: r.recipe_id = vRecipe_id AND
598: h.scale_type = 0);
599:
795: SAVEPOINT default_status_sp;
796: gmd_api_grp.get_status_details (V_entity_type => 'VALIDITY',
797: V_orgn_id => p_recipe_vr_rec.organization_id, --w.r.t. bug 4004501 INVCONV kkillams.
798: X_entity_status => l_entity_status);
799: --Add this code after the call to gmd_recipes_mls.insert_row.
800: IF (l_entity_status.entity_status <> 100) THEN
801: Gmd_status_pub.modify_status ( p_api_version => 1
802: , p_init_msg_list => TRUE
803: , p_entity_name => 'VALIDITY'
900: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_RECIPE_MTL';
901: l_api_version CONSTANT NUMBER := 1.0;
902:
903: l_user_id fnd_user.user_id%TYPE := 0;
904: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
905:
906: /* Variables used for defining status */
907: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
908: l_return_code NUMBER := 0;
1114: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_PROCESS_LOSS';
1115: l_api_version CONSTANT NUMBER := 1.0;
1116:
1117: l_user_id fnd_user.user_id%TYPE := 0;
1118: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
1119:
1120: /* Variables used for defining status */
1121: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1122: l_return_code NUMBER := 0;
1336: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_CUSTOMERS';
1337: l_api_version CONSTANT NUMBER := 1.0;
1338:
1339: l_user_id fnd_user.user_id%TYPE := 0;
1340: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
1341: l_customer_id NUMBER := 0;
1342: l_site_id NUMBER := 0;
1343: l_org_id NUMBER := 0;
1344:
1556: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_RECIPE_VR';
1557: l_api_version CONSTANT NUMBER := 2.0;
1558:
1559: l_user_id fnd_user.user_id%TYPE;
1560: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
1561:
1562: /* Variables used for defining status */
1563: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
1564: l_return_code NUMBER := 0;
2017: l_api_name CONSTANT VARCHAR2(30) := 'RECIPE_ROUTING_STEPS';
2018: l_api_version CONSTANT NUMBER := 2.0;
2019:
2020: l_user_id fnd_user.user_id%TYPE := 0;
2021: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
2022:
2023: /* Variables used for defining status */
2024: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
2025: l_return_code NUMBER := 0;
2481: l_api_name CONSTANT VARCHAR2(30) := 'RECIPE_ORGN_OPERATIONS';
2482: l_api_version CONSTANT NUMBER := 2.0;
2483: l_rowid VARCHAR2(32);
2484: l_user_id fnd_user.user_id%TYPE := 0;
2485: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
2486:
2487: /* Variables used for defining status */
2488: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
2489: l_return_code NUMBER := 0;
2927: l_api_name CONSTANT VARCHAR2(30) := 'RECIPE_ORGN_RESOURCES';
2928: l_api_version CONSTANT NUMBER := 2.0;
2929:
2930: l_user_id fnd_user.user_id%TYPE := 0;
2931: l_recipe_id GMD_RECIPES.recipe_id%TYPE := 0;
2932:
2933: /* Variables used for defining status */
2934: l_return_status varchar2(1) := FND_API.G_RET_STS_SUCCESS;
2935: l_return_code NUMBER := 0;