APPS.GMD_RECIPE_DESIGNER_PKG dependencies on GMD_ROUTINGS

Line 3275: FROM gmd_routings

3271: WHERE formula_id = p_copy_from_formula_id;
3272:
3273: CURSOR Cur_get_rtg_hdr IS
3274: SELECT *
3275: FROM gmd_routings
3276: WHERE routing_id = p_copy_from_routing_id;
3277:
3278: CURSOR Cur_get_rtg_dtl IS
3279: SELECT *

Line 3373: l_rtg_upd_tbl GMD_ROUTINGS_PUB.update_tbl_type;

3369: l_copy_formula BOOLEAN;
3370: l_copy_routing BOOLEAN;
3371: l_routing_update_allowed BOOLEAN;
3372: l_new_routing BOOLEAN;
3373: l_rtg_upd_tbl GMD_ROUTINGS_PUB.update_tbl_type;
3374: l_recipe_tbl GMD_RECIPE_HEADER.recipe_hdr;
3375: l_recipe_update_flex GMD_RECIPE_HEADER.flex;
3376: COPY_RECIPE_EXCEPTION EXCEPTION;
3377: COPY_ROUTING_EXCEPTION EXCEPTION;

Line 3981: l_table_lnk := 'gmd_routings' || '|' || x_routing_id;

3977:
3978: FOR i IN 1..l_rtg_hdr_text_tbl.COUNT LOOP
3979:
3980: l_txt_ind := l_txt_ind + 1;
3981: l_table_lnk := 'gmd_routings' || '|' || x_routing_id;
3982:
3983: ---
3984: --- Create routing header text
3985: ---

Line 4026: GMD_ROUTINGS_PVT.Insert_Routing ( p_routings => l_rtg_hdr_rec

4022: /*Bug 3953359 - Thomas Daniel */
4023: /*Added initializing of the routing status as New */
4024: l_rtg_hdr_rec.routing_status := 100;
4025:
4026: GMD_ROUTINGS_PVT.Insert_Routing ( p_routings => l_rtg_hdr_rec
4027: ,x_message_count => l_message_count
4028: ,x_message_list => l_message_list
4029: ,x_return_status => l_return_code);
4030: IF l_return_code <> 'S' THEN

Line 5551: FROM gmd_routings_b

5547: WHERE recipe_id = vRecipe_id;
5548:
5549: CURSOR get_routing_details(vRouting_id NUMBER) IS
5550: SELECT owner_organization_id
5551: FROM gmd_routings_b
5552: WHERE routing_id = vRouting_id;
5553:
5554: BEGIN
5555: SAVEPOINT default_status_sp;