APPS.GMD_RECIPE_DESIGNER_PKG dependencies on FM_ROUT_DEP

Line 3285: FROM fm_rout_dep

3281: WHERE routing_id = p_copy_from_routing_id;
3282:
3283: CURSOR Cur_get_step_dep IS
3284: SELECT *
3285: FROM fm_rout_dep
3286: WHERE routing_id = p_copy_from_routing_id;
3287:
3288: CURSOR Get_Text (p_text_code NUMBER) IS
3289: SELECT *

Line 4070: DELETE fm_rout_dep WHERE routing_id = x_routing_id;

4066: ---
4067: l_txt_ind := 1;
4068:
4069: IF NOT l_copy_routing THEN
4070: DELETE fm_rout_dep WHERE routing_id = x_routing_id;
4071: DELETE fm_rout_dtl WHERE routing_id = x_routing_id;
4072: END IF;
4073:
4074: FOR i IN 1..l_rtg_dtl_tbl.COUNT LOOP

Line 4200: INSERT INTO fm_rout_dep

4196: --- Insert routing step dependencies records
4197: ---
4198: FOR i IN 1..l_step_dep_tbl.COUNT LOOP
4199:
4200: INSERT INTO fm_rout_dep
4201: (ROUTINGSTEP_NO,
4202: DEP_ROUTINGSTEP_NO,
4203: ROUTING_ID,
4204: DEP_TYPE,