eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_RECIPE_DESIGNER_PKG dependencies on FM_TEXT_TBL

Line 46: | Create a row in FM_TEXT_TBL

Line 109: INSERT INTO fm_text_tbl_vl ( text_code

105: p_user_id,
106: sysdate);
107: END IF;
108:
109: INSERT INTO fm_text_tbl_vl ( text_code
110: ,lang_code
111: ,paragraph_code
112: ,sub_paracode
113: ,line_no

Line 134: GMA_FM_TEXT_TBL_PKG.INSERT_ROW(

130: sysdate);
131:
132: END IF;
133:
134: GMA_FM_TEXT_TBL_PKG.INSERT_ROW(
135: X_ROWID => x_row_id,
136: X_TEXT_CODE => p_text_code,
137: X_PARAGRAPH_CODE => p_paragraph_code,
138: X_SUB_PARACODE => p_sub_paracode,

Line 164: | Update a row in FM_TEXT_TBL

Line 203: GMA_FM_TEXT_TBL_PKG.UPDATE_ROW(

199:
200: x_return_code := 'S';
201: x_error_msg := '';
202:
203: GMA_FM_TEXT_TBL_PKG.UPDATE_ROW(
204: X_ROW_ID => p_row_id,
205: X_TEXT_CODE => p_text_code,
206: X_LANG_CODE => p_lang_code,
207: X_PARAGRAPH_CODE => p_paragraph_code,

Line 231: | Delete a row in FM_TEXT_TBL

Line 266: GMA_FM_TEXT_TBL_PKG.DELETE_ROW(

262:
263: x_return_code := 'S';
264: x_error_msg := '';
265:
266: GMA_FM_TEXT_TBL_PKG.DELETE_ROW(
267: X_TEXT_CODE => p_text_code,
268: X_LANG_CODE => p_lang_code,
269: X_PARAGRAPH_CODE => p_paragraph_code,
270: X_SUB_PARACODE => p_sub_paracode,

Line 3290: FROM fm_text_tbl

3286: WHERE routing_id = p_copy_from_routing_id;
3287:
3288: CURSOR Get_Text (p_text_code NUMBER) IS
3289: SELECT *
3290: FROM fm_text_tbl
3291: WHERE text_code = p_text_code AND
3292: line_no <> -1;
3293:
3294: CURSOR Get_text_code IS

Line 3748: DELETE fm_text_tbl WHERE text_code = l_text_code;

3744: FETCH Get_Text_Code INTO l_text_code;
3745: CLOSE Get_Text_Code;
3746: ELSE
3747: l_text_code := l_frm_hdr_rec.text_code;
3748: DELETE fm_text_tbl WHERE text_code = l_text_code;
3749: END IF;
3750:
3751: l_txt_ind := 0;
3752:

Line 3874: DELETE fm_text_tbl WHERE text_code = l_text_code;

3870: FETCH Get_Text_Code INTO l_text_code;
3871: CLOSE Get_Text_Code;
3872: ELSE
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;

Line 3973: DELETE fm_text_tbl WHERE text_code = l_text_code;

3969: FETCH Get_Text_Code INTO l_text_code;
3970: CLOSE Get_Text_Code;
3971: ELSE
3972: l_text_code := l_rtg_hdr_rec.text_code;
3973: DELETE fm_text_tbl WHERE text_code = l_text_code;
3974: END IF;
3975:
3976: l_txt_ind := 0;
3977:

Line 4145: DELETE fm_text_tbl WHERE text_code = l_text_code;

4141: FETCH Get_Text_Code INTO l_text_code;
4142: CLOSE Get_Text_Code;
4143: ELSE
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;

Line 4266: DELETE fm_text_tbl WHERE text_code = l_text_code;

4262: FETCH Get_Text_Code INTO l_text_code;
4263: CLOSE Get_Text_Code;
4264: ELSE
4265: l_text_code := l_rcp_hdr_rec.text_code;
4266: DELETE fm_text_tbl WHERE text_code = l_text_code;
4267: END IF;
4268:
4269: l_txt_ind := 0;
4270:

Line 4407: DELETE fm_text_tbl WHERE text_code = l_text_code;

4403: FETCH Get_Text_Code INTO l_text_code;
4404: CLOSE Get_Text_Code;
4405: ELSE
4406: l_text_code := l_rcp_stp_tbl(i).text_code;
4407: DELETE fm_text_tbl WHERE text_code = l_text_code;
4408: END IF;
4409:
4410: l_table_lnk := 'gmd_recipe_routing_steps' || '|' || x_recipe_id ||
4411: '|' || l_rcp_stp_tbl(i).routingstep_id;

Line 4560: DELETE fm_text_tbl WHERE text_code = l_text_code;

4556: FETCH Get_Text_Code INTO l_text_code;
4557: CLOSE Get_Text_Code;
4558: ELSE
4559: l_text_code := l_stp_mtl_tbl(i).text_code;
4560: DELETE fm_text_tbl WHERE text_code = l_text_code;
4561: END IF;
4562:
4563: l_table_lnk := 'gmd_recipe_step_materials' || '|' ||
4564: l_stp_mtl_tbl(i).formulaline_id ||

Line 4638: DELETE fm_text_tbl WHERE text_code = l_text_code;

4634: FETCH Get_Text_Code INTO l_text_code;
4635: CLOSE Get_Text_Code;
4636: ELSE
4637: l_text_code := l_rcp_cust_tbl(i).text_code;
4638: DELETE fm_text_tbl WHERE text_code = l_text_code;
4639: END IF;
4640:
4641: l_table_lnk := 'gmd_recipe_customers' || '|' ||
4642: x_recipe_id ||

Line 4728: DELETE fm_text_tbl WHERE text_code = l_text_code;

4724: FETCH Get_Text_Code INTO l_text_code;
4725: CLOSE Get_Text_Code;
4726: ELSE
4727: l_text_code := l_rcp_loss_tbl(i).text_code;
4728: DELETE fm_text_tbl WHERE text_code = l_text_code;
4729: END IF;
4730:
4731: l_table_lnk := 'gmd_recipe_process_loss' || '|' ||
4732: x_recipe_id ||