APPS.GMD_RECIPE_DESIGNER_PKG dependencies on FM_MATL_DTL

Line 3270: FROM fm_matl_dtl

3266: WHERE formula_id = p_copy_from_formula_id;
3267:
3268: CURSOR Cur_get_frm_dtl IS
3269: SELECT *
3270: FROM fm_matl_dtl
3271: WHERE formula_id = p_copy_from_formula_id;
3272:
3273: CURSOR Cur_get_rtg_hdr IS
3274: SELECT *

Line 3840: DELETE fm_matl_dtl WHERE formula_id = x_formula_id;

3836: ---
3837: l_txt_ind := 1;
3838:
3839: IF NOT l_copy_formula THEN
3840: DELETE fm_matl_dtl WHERE formula_id = x_formula_id;
3841: END IF;
3842:
3843: FOR i IN 1..l_frm_dtl_tbl.count LOOP
3844: l_text_code := NULL;

Line 3877: l_table_lnk := 'fm_matl_dtl' || '|' || x_formula_id || '|' ||

3873: l_text_code := l_frm_dtl_tbl(i).text_code;
3874: DELETE fm_text_tbl WHERE text_code = l_text_code;
3875: END IF;
3876:
3877: l_table_lnk := 'fm_matl_dtl' || '|' || x_formula_id || '|' ||
3878: l_formulaline_id;
3879:
3880: WHILE (l_txt_ind <= l_frm_dtl_text_tbl.COUNT AND
3881: l_frm_dtl_text_tbl(l_txt_ind).text_code =