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.GME_CREATE_STEP_PVT dependencies on FM_TEXT_TBL

Line 2983: CURSOR fm_text_tbl_cursor (p_text_code fm_text_tbl.text_code%TYPE)

2979: l_text_table gme_common_pvt.text_tab;
2980: l_api_name CONSTANT VARCHAR2 (30) := 'copy and create text';
2981: unexpected_error EXCEPTION;
2982:
2983: CURSOR fm_text_tbl_cursor (p_text_code fm_text_tbl.text_code%TYPE)
2984: IS
2985: SELECT *
2986: FROM fm_text_tbl
2987: WHERE text_code = p_text_code

Line 2986: FROM fm_text_tbl

2982:
2983: CURSOR fm_text_tbl_cursor (p_text_code fm_text_tbl.text_code%TYPE)
2984: IS
2985: SELECT *
2986: FROM fm_text_tbl
2987: WHERE text_code = p_text_code
2988: ORDER BY line_no;
2989: BEGIN
2990: IF g_debug <= gme_debug.g_log_procedure THEN

Line 3010: FOR l_fm_text_tbl_row IN fm_text_tbl_cursor (p_gmd_text_code) LOOP

3006: IF (l_return) THEN
3007: x_gme_text_code := l_text_header.text_code;
3008:
3009: -- This fetches using the fm text data based on the fm text code.
3010: FOR l_fm_text_tbl_row IN fm_text_tbl_cursor (p_gmd_text_code) LOOP
3011: l_number_of_text_lines := l_number_of_text_lines + 1;
3012: l_text_table (l_number_of_text_lines).text_code :=
3013: x_gme_text_code;
3014: l_text_table (l_number_of_text_lines).line_no :=

Line 3015: l_fm_text_tbl_row.line_no;

3011: l_number_of_text_lines := l_number_of_text_lines + 1;
3012: l_text_table (l_number_of_text_lines).text_code :=
3013: x_gme_text_code;
3014: l_text_table (l_number_of_text_lines).line_no :=
3015: l_fm_text_tbl_row.line_no;
3016: l_text_table (l_number_of_text_lines).lang_code :=
3017: l_fm_text_tbl_row.lang_code;
3018: l_text_table (l_number_of_text_lines).paragraph_code :=
3019: l_fm_text_tbl_row.paragraph_code;

Line 3017: l_fm_text_tbl_row.lang_code;

3013: x_gme_text_code;
3014: l_text_table (l_number_of_text_lines).line_no :=
3015: l_fm_text_tbl_row.line_no;
3016: l_text_table (l_number_of_text_lines).lang_code :=
3017: l_fm_text_tbl_row.lang_code;
3018: l_text_table (l_number_of_text_lines).paragraph_code :=
3019: l_fm_text_tbl_row.paragraph_code;
3020: l_text_table (l_number_of_text_lines).sub_paracode :=
3021: l_fm_text_tbl_row.sub_paracode;

Line 3019: l_fm_text_tbl_row.paragraph_code;

3015: l_fm_text_tbl_row.line_no;
3016: l_text_table (l_number_of_text_lines).lang_code :=
3017: l_fm_text_tbl_row.lang_code;
3018: l_text_table (l_number_of_text_lines).paragraph_code :=
3019: l_fm_text_tbl_row.paragraph_code;
3020: l_text_table (l_number_of_text_lines).sub_paracode :=
3021: l_fm_text_tbl_row.sub_paracode;
3022:
3023: IF (l_fm_text_tbl_row.line_no = -1) THEN

Line 3021: l_fm_text_tbl_row.sub_paracode;

3017: l_fm_text_tbl_row.lang_code;
3018: l_text_table (l_number_of_text_lines).paragraph_code :=
3019: l_fm_text_tbl_row.paragraph_code;
3020: l_text_table (l_number_of_text_lines).sub_paracode :=
3021: l_fm_text_tbl_row.sub_paracode;
3022:
3023: IF (l_fm_text_tbl_row.line_no = -1) THEN
3024: l_text_table (l_number_of_text_lines).text := p_text_string;
3025: ELSE

Line 3023: IF (l_fm_text_tbl_row.line_no = -1) THEN

3019: l_fm_text_tbl_row.paragraph_code;
3020: l_text_table (l_number_of_text_lines).sub_paracode :=
3021: l_fm_text_tbl_row.sub_paracode;
3022:
3023: IF (l_fm_text_tbl_row.line_no = -1) THEN
3024: l_text_table (l_number_of_text_lines).text := p_text_string;
3025: ELSE
3026: l_text_table (l_number_of_text_lines).text :=
3027: l_fm_text_tbl_row.text;

Line 3027: l_fm_text_tbl_row.text;

3023: IF (l_fm_text_tbl_row.line_no = -1) THEN
3024: l_text_table (l_number_of_text_lines).text := p_text_string;
3025: ELSE
3026: l_text_table (l_number_of_text_lines).text :=
3027: l_fm_text_tbl_row.text;
3028:
3029: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3030: gme_debug.put_line
3031: ( 'text for line no '

Line 3032: || l_fm_text_tbl_row.line_no

3028:
3029: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3030: gme_debug.put_line
3031: ( 'text for line no '
3032: || l_fm_text_tbl_row.line_no
3033: || ' is '
3034: || l_text_table (l_number_of_text_lines).text);
3035: END IF;
3036: END IF;

Line 3038: /* FOR l_fm_text_tbl_row in fm_text_tbl_cursor(l_text_code) LOOP */

3034: || l_text_table (l_number_of_text_lines).text);
3035: END IF;
3036: END IF;
3037: END LOOP;
3038: /* FOR l_fm_text_tbl_row in fm_text_tbl_cursor(l_text_code) LOOP */
3039: ELSE
3040: -- We could not insert the text header. Error message pushed on stack in dbl code.
3041: RAISE unexpected_error;
3042: END IF;