APPS.GMD_RECIPE_GENERATE dependencies on GMD_API_GRP

Line 62: l_default_status gmd_api_grp.status_rec_type;

58:
59: l_recipe_id NUMBER(15);
60: x_recipe_id NUMBER(15);
61:
62: l_default_status gmd_api_grp.status_rec_type;
63: l_default_recipe_status gmd_api_grp.status_rec_type;
64: l_default_vr_status gmd_api_grp.status_rec_type;
65: l_formula_status VARCHAR2(30);
66: l_end_status VARCHAR2(30);

Line 63: l_default_recipe_status gmd_api_grp.status_rec_type;

59: l_recipe_id NUMBER(15);
60: x_recipe_id NUMBER(15);
61:
62: l_default_status gmd_api_grp.status_rec_type;
63: l_default_recipe_status gmd_api_grp.status_rec_type;
64: l_default_vr_status gmd_api_grp.status_rec_type;
65: l_formula_status VARCHAR2(30);
66: l_end_status VARCHAR2(30);
67: l_recipe_status VARCHAR2(30);

Line 64: l_default_vr_status gmd_api_grp.status_rec_type;

60: x_recipe_id NUMBER(15);
61:
62: l_default_status gmd_api_grp.status_rec_type;
63: l_default_recipe_status gmd_api_grp.status_rec_type;
64: l_default_vr_status gmd_api_grp.status_rec_type;
65: l_formula_status VARCHAR2(30);
66: l_end_status VARCHAR2(30);
67: l_recipe_status VARCHAR2(30);
68: l_creation_type NUMBER;

Line 83: gmd_api_grp.get_status_details (V_entity_type => 'FORMULA',

79: OPEN c_get_formula_status;
80: FETCH c_get_formula_status INTO l_formula_status;
81: CLOSE c_get_formula_status;
82:
83: gmd_api_grp.get_status_details (V_entity_type => 'FORMULA',
84: V_orgn_id => p_orgn_id,
85: X_entity_status => l_default_status);
86:
87: IF l_default_status.entity_status <> l_formula_status THEN

Line 111: gmd_api_grp.get_status_details (V_entity_type => 'RECIPE',

107: IF X_return_status <> FND_API.g_ret_sts_success THEN
108: RAISE Create_Recipe_Err;
109: END IF;
110:
111: gmd_api_grp.get_status_details (V_entity_type => 'RECIPE',
112: V_orgn_id => p_orgn_id,
113: X_entity_status => l_default_recipe_status);
114:
115: IF (l_end_status = l_default_recipe_status.entity_status) THEN

Line 298: l_default_vr_status gmd_api_grp.status_rec_type;

294: WHERE recipe_validity_rule_id = V_validity_rule_id;
295:
296:
297: l_vr_id NUMBER;
298: l_default_vr_status gmd_api_grp.status_rec_type;
299: l_return_status VARCHAR2(1);
300: x_msg_count NUMBER;
301: x_msg_data VARCHAR2(2000);
302:

Line 306: GMD_API_GRP.retrieve_vr(p_formula_id => p_formula_id,

302:
303: BEGIN
304: x_return_status := FND_API.G_RET_STS_SUCCESS;
305:
306: GMD_API_GRP.retrieve_vr(p_formula_id => p_formula_id,
307: l_recipe_vr_tbl => l_recipe_vr_tbl,
308: l_vr_flex => l_vr_flex,
309: x_return_status => x_return_status,
310: p_recipe_use => p_recipe_use);

Line 343: GMD_API_GRP.get_status_details (V_entity_type => 'VALIDITY',

339: ELSE
340: COMMIT WORK;
341: END IF;
342:
343: GMD_API_GRP.get_status_details (V_entity_type => 'VALIDITY',
344: V_orgn_id => p_orgn_id,
345: X_entity_status => l_default_vr_status);
346:
347: IF (l_default_vr_status.entity_status <> 100) THEN

Line 431: l_routing_status gmd_api_grp.status_rec_type;

427: CURSOR Cur_get_routing_status(V_routing_id NUMBER) IS
428: SELECT ROUTING_STATUS
429: FROM GMD_ROUTINGS_B
430: WHERE routing_id = V_routing_id;
431: l_routing_status gmd_api_grp.status_rec_type;
432:
433: CURSOR Cur_get_routing_details(V_routing_id NUMBER) IS
434: SELECT ROUTING_NO, ROUTING_VERS
435: FROM GMD_ROUTINGS_B

Line 441: l_default_recipe_status gmd_api_grp.status_rec_type;

437: l_routing_no VARCHAR2(32);
438: l_routing_vers NUMBER;
439:
440: -- Local Variables
441: l_default_recipe_status gmd_api_grp.status_rec_type;
442: l_return_status VARCHAR2(1);
443: x_msg_count NUMBER;
444: x_msg_data VARCHAR2(2000);
445:

Line 455: GMD_API_GRP.retrieve_recipe(p_formula_id,

451: x_return_status := FND_API.G_RET_STS_SUCCESS;
452:
453: -- Kapil LCF-GMO ME : Bug#5458666
454: -- Pass the routing_id to retrieve the recipe details.
455: GMD_API_GRP.retrieve_recipe(p_formula_id,
456: p_routing_id,
457: l_recipe_tbl,
458: l_recipe_flex,
459: x_return_status);

Line 498: gmd_api_grp.get_status_details (V_entity_type => 'RECIPE',

494: END IF;
495: END IF;
496:
497:
498: gmd_api_grp.get_status_details (V_entity_type => 'RECIPE',
499: V_orgn_id => p_orgn_id,
500: X_entity_status => l_default_recipe_status);
501:
502: -- Kapil LCF-GMO ME : Bug#5458666