APPS.GMD_RECIPE_DETAIL dependencies on GMD_RECIPE_VAL

Line 113: GMD_RECIPE_VAL.recipe_name

109: /* Either recipe_id or recipe_no/vers */
110: /* has to be provided */
111: /* ================================== */
112: IF (p_recipe_detail_rec.recipe_id IS NULL) THEN
113: GMD_RECIPE_VAL.recipe_name
114: ( p_api_version => 1.0,
115: p_init_msg_list => FND_API.G_FALSE,
116: p_commit => FND_API.G_FALSE,
117: p_recipe_no => p_recipe_detail_rec.recipe_no,

Line 327: GMD_RECIPE_VAL.recipe_name

323: /* ================================ */
324: /* Check if recipe id exists */
325: /* ================================= */
326: IF (p_recipe_detail_rec.recipe_id IS NULL) THEN
327: GMD_RECIPE_VAL.recipe_name
328: ( p_api_version => 1.0,
329: p_init_msg_list => FND_API.G_FALSE,
330: p_commit => FND_API.G_FALSE,
331: p_recipe_no => p_recipe_detail_rec.recipe_no,

Line 655: GMD_RECIPE_VAL.recipe_name

651: /* ================================ */
652: /* Check if recipe id exists */
653: /* ================================= */
654: IF (p_recipe_vr_rec.recipe_id IS NULL) THEN
655: GMD_RECIPE_VAL.recipe_name
656: ( p_api_version => 1.0,
657: p_init_msg_list => FND_API.G_FALSE,
658: p_commit => FND_API.G_FALSE,
659: p_recipe_no => p_recipe_vr_rec.recipe_no,

Line 732: GMD_RECIPE_VAL.calc_inv_qtys (P_inv_item_um => l_prim_item_um,

728: CLOSE get_primary_um;
729:
730: /* Call Recipe val pkg for getting the inv min and max qty */
731: IF ((p_recipe_vr_rec.inv_min_qty IS NULL OR p_recipe_vr_rec.inv_min_qty IS NULL)) THEN
732: GMD_RECIPE_VAL.calc_inv_qtys (P_inv_item_um => l_prim_item_um,
733: P_item_um => p_recipe_vr_rec.detail_uom,
734: P_item_id => p_recipe_vr_rec.inventory_item_id,
735: P_min_qty => p_recipe_vr_rec.min_qty,
736: P_max_qty => p_recipe_vr_rec.max_qty,

Line 750: GMD_RECIPE_VAL.validate_start_date

746:
747: /* Validate start and end dates for VR with Routiing start and end dates */
748: FOR get_routing_rec in Get_Routing_Details(p_recipe_vr_rec.recipe_id) LOOP
749: -- Get the routing start date if applicable
750: GMD_RECIPE_VAL.validate_start_date
751: (P_disp_start_date => p_recipe_vr_rec.start_date,
752: P_routing_start_date => get_routing_rec.effective_start_date,
753: x_return_status => x_return_status);
754: IF (x_return_status <> 'S') THEN

Line 758: GMD_RECIPE_VAL.validate_end_date

754: IF (x_return_status <> 'S') THEN
755: RAISE Recipe_VR_insert_failure;
756: END IF;
757:
758: GMD_RECIPE_VAL.validate_end_date
759: (P_end_date => p_recipe_vr_rec.end_date,
760: P_routing_end_date => get_routing_rec.effective_end_date,
761: x_return_status => x_return_status);
762:

Line 970: GMD_RECIPE_VAL.recipe_name

966: /* ================================ */
967: /* Check if recipe id exists */
968: /* ================================= */
969: IF (p_recipe_mtl_rec.recipe_id IS NULL) THEN
970: GMD_RECIPE_VAL.recipe_name
971: ( p_api_version => 1.0,
972: p_init_msg_list => FND_API.G_FALSE,
973: p_commit => FND_API.G_FALSE,
974: p_recipe_no => p_recipe_mtl_rec.recipe_no,

Line 1411: GMD_RECIPE_VAL.recipe_name

1407: /* ================================ */
1408: /* Check if recipe id exists */
1409: /* ================================= */
1410: IF (p_recipe_detail_rec.recipe_id IS NULL) THEN
1411: GMD_RECIPE_VAL.recipe_name
1412: ( p_api_version => 1.0,
1413: p_init_msg_list => FND_API.G_FALSE,
1414: p_commit => FND_API.G_FALSE,
1415: p_recipe_no => p_recipe_detail_rec.recipe_no,

Line 1586: FROM gmd_recipe_validity_rules

1582: attribute11, attribute12, attribute13, attribute14, attribute15,
1583: attribute16, attribute17, attribute18, attribute19, attribute20,
1584: attribute21, attribute22, attribute23, attribute24,attribute25,
1585: attribute26, attribute27, attribute28, attribute29, attribute30
1586: FROM gmd_recipe_validity_rules
1587: WHERE Recipe_Validity_Rule_id = NVL(vRecipe_VR_id,-1);
1588:
1589:
1590: /* Define a cursor for dealing with updates */

Line 1593: FROM gmd_recipe_validity_rules

1589:
1590: /* Define a cursor for dealing with updates */
1591: CURSOR update_vr_cur(vRecipe_VR_id NUMBER) IS
1592: SELECT recipe_id, orgn_code, end_date, planned_process_loss
1593: FROM gmd_recipe_validity_rules
1594: WHERE Recipe_Validity_Rule_id = NVL(vRecipe_VR_id,-1);
1595:
1596: /* Cursor to get the item id when item no is passed */
1597: CURSOR get_item_id(pItem_no VARCHAR2) IS

Line 2109: GMD_RECIPE_VAL.recipe_exists

2105:
2106: /* ========================== */
2107: /* Check if recipe id exists */
2108: /* ========================== */
2109: GMD_RECIPE_VAL.recipe_exists
2110: ( p_api_version => 1.0,
2111: p_init_msg_list => FND_API.G_FALSE,
2112: p_commit => FND_API.G_FALSE,
2113: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

Line 2569: GMD_RECIPE_VAL.recipe_name

2565: /* ========================== */
2566: /* Check if recipe id exists */
2567: /* ========================== */
2568: IF (p_recipe_detail_rec.recipe_id IS NULL) THEN
2569: GMD_RECIPE_VAL.recipe_name
2570: ( p_api_version => 1.0,
2571: p_init_msg_list => FND_API.G_FALSE,
2572: p_commit => FND_API.G_FALSE,
2573: p_recipe_no => p_recipe_detail_rec.recipe_no,

Line 3026: GMD_RECIPE_VAL.recipe_name

3022: /* ========================== */
3023: /* Check if recipe id exists */
3024: /* ========================== */
3025: IF (p_recipe_detail_rec.recipe_id IS NULL) THEN
3026: GMD_RECIPE_VAL.recipe_name
3027: ( p_api_version => 1.0,
3028: p_init_msg_list => FND_API.G_FALSE,
3029: p_commit => FND_API.G_FALSE,
3030: p_recipe_no => p_recipe_detail_rec.recipe_no,