APPS.GMD_RECIPE_GENERATE dependencies on GMD_API_GRP

Line 120: l_default_status gmd_api_grp.status_rec_type;

116:
117: l_recipe_id NUMBER(15);
118: x_recipe_id NUMBER(15);
119:
120: l_default_status gmd_api_grp.status_rec_type;
121: l_default_recipe_status gmd_api_grp.status_rec_type;
122: l_default_vr_status gmd_api_grp.status_rec_type;
123: l_formula_status VARCHAR2(30);
124: l_end_status VARCHAR2(30);

Line 121: l_default_recipe_status gmd_api_grp.status_rec_type;

117: l_recipe_id NUMBER(15);
118: x_recipe_id NUMBER(15);
119:
120: l_default_status gmd_api_grp.status_rec_type;
121: l_default_recipe_status gmd_api_grp.status_rec_type;
122: l_default_vr_status gmd_api_grp.status_rec_type;
123: l_formula_status VARCHAR2(30);
124: l_end_status VARCHAR2(30);
125: l_recipe_status VARCHAR2(30);

Line 122: l_default_vr_status gmd_api_grp.status_rec_type;

118: x_recipe_id NUMBER(15);
119:
120: l_default_status gmd_api_grp.status_rec_type;
121: l_default_recipe_status gmd_api_grp.status_rec_type;
122: l_default_vr_status gmd_api_grp.status_rec_type;
123: l_formula_status VARCHAR2(30);
124: l_end_status VARCHAR2(30);
125: l_recipe_status VARCHAR2(30);
126: l_creation_type NUMBER;

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

137: OPEN c_get_formula_status;
138: FETCH c_get_formula_status INTO l_formula_status;
139: CLOSE c_get_formula_status;
140:
141: gmd_api_grp.get_status_details (V_entity_type => 'FORMULA',
142: V_orgn_id => p_orgn_id,
143: X_entity_status => l_default_status);
144:
145: IF l_default_status.entity_status <> l_formula_status THEN

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

165: IF X_return_status <> FND_API.g_ret_sts_success THEN
166: RAISE Create_Recipe_Err;
167: END IF;
168:
169: gmd_api_grp.get_status_details (V_entity_type => 'RECIPE',
170: V_orgn_id => p_orgn_id,
171: X_entity_status => l_default_recipe_status);
172:
173: IF (l_end_status = l_default_recipe_status.entity_status) THEN

Line 356: l_default_vr_status gmd_api_grp.status_rec_type;

352: WHERE recipe_validity_rule_id = V_validity_rule_id;
353:
354:
355: l_vr_id NUMBER;
356: l_default_vr_status gmd_api_grp.status_rec_type;
357: l_return_status VARCHAR2(1);
358: x_msg_count NUMBER;
359: x_msg_data VARCHAR2(2000);
360:

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

360:
361: BEGIN
362: x_return_status := FND_API.G_RET_STS_SUCCESS;
363:
364: GMD_API_GRP.retrieve_vr(p_formula_id => p_formula_id,
365: l_recipe_vr_tbl => l_recipe_vr_tbl,
366: l_vr_flex => l_vr_flex,
367: x_return_status => x_return_status,
368: p_recipe_use => p_recipe_use);

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

401: COMMIT WORK;
402: END IF;
403: END IF;
404:
405: GMD_API_GRP.get_status_details (V_entity_type => 'VALIDITY',
406: V_orgn_id => p_orgn_id,
407: X_entity_status => l_default_vr_status);
408:
409: IF (l_default_vr_status.entity_status <> 100) THEN

Line 493: l_routing_status gmd_api_grp.status_rec_type;

489: CURSOR Cur_get_routing_status(V_routing_id NUMBER) IS
490: SELECT ROUTING_STATUS
491: FROM GMD_ROUTINGS_B
492: WHERE routing_id = V_routing_id;
493: l_routing_status gmd_api_grp.status_rec_type;
494:
495: CURSOR Cur_get_routing_details(V_routing_id NUMBER) IS
496: SELECT ROUTING_NO, ROUTING_VERS
497: FROM GMD_ROUTINGS_B

Line 503: l_default_recipe_status gmd_api_grp.status_rec_type;

499: l_routing_no VARCHAR2(32);
500: l_routing_vers NUMBER;
501:
502: -- Local Variables
503: l_default_recipe_status gmd_api_grp.status_rec_type;
504: l_return_status VARCHAR2(1);
505: x_msg_count NUMBER;
506: x_msg_data VARCHAR2(2000);
507:

Line 517: GMD_API_GRP.retrieve_recipe(p_formula_id,

513: x_return_status := FND_API.G_RET_STS_SUCCESS;
514:
515: -- Kapil LCF-GMO ME : Bug#5458666
516: -- Pass the routing_id to retrieve the recipe details.
517: GMD_API_GRP.retrieve_recipe(p_formula_id,
518: p_routing_id,
519: l_recipe_tbl,
520: l_recipe_flex,
521: x_return_status);

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

558: END IF;
559: END IF;
560:
561:
562: gmd_api_grp.get_status_details (V_entity_type => 'RECIPE',
563: V_orgn_id => p_orgn_id,
564: X_entity_status => l_default_recipe_status);
565:
566: -- Kapil LCF-GMO ME : Bug#5458666