APPS.GMD_RECIPE_DESIGNER_PKG dependencies on FM_ROUT_DTL

Line 765: FM_ROUT_DTL

761: SELECT
762: ROUTINGSTEP_ID,
763: ROUTINGSTEP_NO
764: FROM
765: FM_ROUT_DTL
766: WHERE
767: routing_id = p_routing_id;
768:
769: BEGIN

Line 1311: fm_rout_dtl

1307: CURSOR Get_Step_Id (c_routing_id NUMBER, c_routingstep_no NUMBER) IS
1308: SELECT
1309: routingstep_id
1310: FROM
1311: fm_rout_dtl
1312: WHERE
1313: routing_id = c_routing_id AND
1314: routingstep_no = c_routingstep_no;
1315:

Line 1806: FROM gmd_recipe_step_materials a, fm_rout_dtl b

1802: l_dummy NUMBER;
1803:
1804: CURSOR Get_Old_Stp_Mat IS
1805: SELECT a.routingstep_id
1806: FROM gmd_recipe_step_materials a, fm_rout_dtl b
1807: WHERE a.recipe_id = p_recipe_id
1808: AND a.routingstep_id = b.routingstep_id
1809: AND b.routing_id = l_recipe_rec.routing_id;
1810:

Line 1813: FROM gmd_recipe_routing_steps a, fm_rout_dtl b

1809: AND b.routing_id = l_recipe_rec.routing_id;
1810:
1811: CURSOR Get_Old_Stp IS
1812: SELECT a.routingstep_id
1813: FROM gmd_recipe_routing_steps a, fm_rout_dtl b
1814: WHERE a.recipe_id = p_recipe_id
1815: AND a.routingstep_id = b.routingstep_id
1816: AND b.routing_id = l_recipe_rec.routing_id;
1817:

Line 3280: FROM fm_rout_dtl

3276: WHERE routing_id = p_copy_from_routing_id;
3277:
3278: CURSOR Cur_get_rtg_dtl IS
3279: SELECT *
3280: FROM fm_rout_dtl
3281: WHERE routing_id = p_copy_from_routing_id;
3282:
3283: CURSOR Cur_get_step_dep IS
3284: SELECT *

Line 4071: DELETE fm_rout_dtl WHERE routing_id = x_routing_id;

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
4075: l_text_code := NULL;

Line 4148: l_table_lnk := 'fm_rout_dtl' || '|' || x_routing_id || '|' ||

4144: l_text_code := l_rtg_dtl_tbl(i).text_code;
4145: DELETE fm_text_tbl WHERE text_code = l_text_code;
4146: END IF;
4147:
4148: l_table_lnk := 'fm_rout_dtl' || '|' || x_routing_id || '|' ||
4149: l_routingstep_id;
4150:
4151: WHILE (l_txt_ind <= l_rtg_dtl_text_tbl.COUNT AND
4152: l_rtg_dtl_text_tbl(l_txt_ind).text_code =