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 663: GMD_RECIPE_VAL.recipe_name

659: /* ================================ */
660: /* Check if recipe id exists */
661: /* ================================= */
662: IF (p_recipe_vr_rec.recipe_id IS NULL) THEN
663: GMD_RECIPE_VAL.recipe_name
664: ( p_api_version => 1.0,
665: p_init_msg_list => FND_API.G_FALSE,
666: p_commit => FND_API.G_FALSE,
667: p_recipe_no => p_recipe_vr_rec.recipe_no,

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

750: CLOSE get_primary_um;
751:
752: /* Call Recipe val pkg for getting the inv min and max qty */
753: IF ((p_recipe_vr_rec.inv_min_qty IS NULL OR p_recipe_vr_rec.inv_min_qty IS NULL)) THEN
754: GMD_RECIPE_VAL.calc_inv_qtys (P_inv_item_um => l_prim_item_um,
755: P_item_um => p_recipe_vr_rec.detail_uom,
756: P_item_id => p_recipe_vr_rec.inventory_item_id,
757: P_min_qty => p_recipe_vr_rec.min_qty,
758: P_max_qty => p_recipe_vr_rec.max_qty,

Line 772: GMD_RECIPE_VAL.validate_start_date

768:
769: /* Validate start and end dates for VR with Routiing start and end dates */
770: FOR get_routing_rec in Get_Routing_Details(p_recipe_vr_rec.recipe_id) LOOP
771: -- Get the routing start date if applicable
772: GMD_RECIPE_VAL.validate_start_date
773: (P_disp_start_date => p_recipe_vr_rec.start_date,
774: P_routing_start_date => get_routing_rec.effective_start_date,
775: x_return_status => x_return_status);
776: IF (x_return_status <> 'S') THEN

Line 780: GMD_RECIPE_VAL.validate_end_date

776: IF (x_return_status <> 'S') THEN
777: RAISE Recipe_VR_insert_failure;
778: END IF;
779:
780: GMD_RECIPE_VAL.validate_end_date
781: (P_end_date => p_recipe_vr_rec.end_date,
782: P_routing_end_date => get_routing_rec.effective_end_date,
783: x_return_status => x_return_status);
784:

Line 1013: GMD_RECIPE_VAL.recipe_name

1009: /* ================================ */
1010: /* Check if recipe id exists */
1011: /* ================================= */
1012: IF (p_recipe_mtl_rec.recipe_id IS NULL) THEN
1013: GMD_RECIPE_VAL.recipe_name
1014: ( p_api_version => 1.0,
1015: p_init_msg_list => FND_API.G_FALSE,
1016: p_commit => FND_API.G_FALSE,
1017: p_recipe_no => p_recipe_mtl_rec.recipe_no,

Line 1510: GMD_RECIPE_VAL.recipe_name

1506: /* ================================ */
1507: /* Check if recipe id exists */
1508: /* ================================= */
1509: IF (p_recipe_detail_rec.recipe_id IS NULL) THEN
1510: GMD_RECIPE_VAL.recipe_name
1511: ( p_api_version => 1.0,
1512: p_init_msg_list => FND_API.G_FALSE,
1513: p_commit => FND_API.G_FALSE,
1514: p_recipe_no => p_recipe_detail_rec.recipe_no,

Line 1685: FROM gmd_recipe_validity_rules

1681: attribute11, attribute12, attribute13, attribute14, attribute15,
1682: attribute16, attribute17, attribute18, attribute19, attribute20,
1683: attribute21, attribute22, attribute23, attribute24,attribute25,
1684: attribute26, attribute27, attribute28, attribute29, attribute30
1685: FROM gmd_recipe_validity_rules
1686: WHERE Recipe_Validity_Rule_id = NVL(vRecipe_VR_id,-1);
1687:
1688:
1689: /* Define a cursor for dealing with updates */

Line 1692: FROM gmd_recipe_validity_rules

1688:
1689: /* Define a cursor for dealing with updates */
1690: CURSOR update_vr_cur(vRecipe_VR_id NUMBER) IS
1691: SELECT recipe_id, orgn_code, end_date, planned_process_loss
1692: FROM gmd_recipe_validity_rules
1693: WHERE Recipe_Validity_Rule_id = NVL(vRecipe_VR_id,-1);
1694:
1695: /* Cursor to get the item id when item no is passed */
1696: CURSOR get_item_id(pItem_no VARCHAR2) IS

Line 2236: GMD_RECIPE_VAL.recipe_exists

2232:
2233: /* ========================== */
2234: /* Check if recipe id exists */
2235: /* ========================== */
2236: GMD_RECIPE_VAL.recipe_exists
2237: ( p_api_version => 1.0,
2238: p_init_msg_list => FND_API.G_FALSE,
2239: p_commit => FND_API.G_FALSE,
2240: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

Line 2696: GMD_RECIPE_VAL.recipe_name

2692: /* ========================== */
2693: /* Check if recipe id exists */
2694: /* ========================== */
2695: IF (p_recipe_detail_rec.recipe_id IS NULL) THEN
2696: GMD_RECIPE_VAL.recipe_name
2697: ( p_api_version => 1.0,
2698: p_init_msg_list => FND_API.G_FALSE,
2699: p_commit => FND_API.G_FALSE,
2700: p_recipe_no => p_recipe_detail_rec.recipe_no,

Line 3168: GMD_RECIPE_VAL.recipe_name

3164: /* ========================== */
3165: /* Check if recipe id exists */
3166: /* ========================== */
3167: IF (p_recipe_detail_rec.recipe_id IS NULL) THEN
3168: GMD_RECIPE_VAL.recipe_name
3169: ( p_api_version => 1.0,
3170: p_init_msg_list => FND_API.G_FALSE,
3171: p_commit => FND_API.G_FALSE,
3172: p_recipe_no => p_recipe_detail_rec.recipe_no,