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 3484: CURSOR fm_text_tbl_cursor (p_text_code fm_text_tbl.text_code%TYPE)

3480: l_text_table gme_common_pvt.text_tab;
3481: l_api_name CONSTANT VARCHAR2 (30) := 'copy and create text';
3482: unexpected_error EXCEPTION;
3483:
3484: CURSOR fm_text_tbl_cursor (p_text_code fm_text_tbl.text_code%TYPE)
3485: IS
3486: SELECT *
3487: FROM fm_text_tbl
3488: WHERE text_code = p_text_code

Line 3487: FROM fm_text_tbl

3483:
3484: CURSOR fm_text_tbl_cursor (p_text_code fm_text_tbl.text_code%TYPE)
3485: IS
3486: SELECT *
3487: FROM fm_text_tbl
3488: WHERE text_code = p_text_code
3489: ORDER BY line_no;
3490: BEGIN
3491: IF g_debug <= gme_debug.g_log_procedure THEN

Line 3511: FOR l_fm_text_tbl_row IN fm_text_tbl_cursor (p_gmd_text_code) LOOP

3507: IF (l_return) THEN
3508: x_gme_text_code := l_text_header.text_code;
3509:
3510: -- This fetches using the fm text data based on the fm text code.
3511: FOR l_fm_text_tbl_row IN fm_text_tbl_cursor (p_gmd_text_code) LOOP
3512: l_number_of_text_lines := l_number_of_text_lines + 1;
3513: l_text_table (l_number_of_text_lines).text_code :=
3514: x_gme_text_code;
3515: l_text_table (l_number_of_text_lines).line_no :=

Line 3516: l_fm_text_tbl_row.line_no;

3512: l_number_of_text_lines := l_number_of_text_lines + 1;
3513: l_text_table (l_number_of_text_lines).text_code :=
3514: x_gme_text_code;
3515: l_text_table (l_number_of_text_lines).line_no :=
3516: l_fm_text_tbl_row.line_no;
3517: l_text_table (l_number_of_text_lines).lang_code :=
3518: l_fm_text_tbl_row.lang_code;
3519: l_text_table (l_number_of_text_lines).paragraph_code :=
3520: l_fm_text_tbl_row.paragraph_code;

Line 3518: l_fm_text_tbl_row.lang_code;

3514: x_gme_text_code;
3515: l_text_table (l_number_of_text_lines).line_no :=
3516: l_fm_text_tbl_row.line_no;
3517: l_text_table (l_number_of_text_lines).lang_code :=
3518: l_fm_text_tbl_row.lang_code;
3519: l_text_table (l_number_of_text_lines).paragraph_code :=
3520: l_fm_text_tbl_row.paragraph_code;
3521: l_text_table (l_number_of_text_lines).sub_paracode :=
3522: l_fm_text_tbl_row.sub_paracode;

Line 3520: l_fm_text_tbl_row.paragraph_code;

3516: l_fm_text_tbl_row.line_no;
3517: l_text_table (l_number_of_text_lines).lang_code :=
3518: l_fm_text_tbl_row.lang_code;
3519: l_text_table (l_number_of_text_lines).paragraph_code :=
3520: l_fm_text_tbl_row.paragraph_code;
3521: l_text_table (l_number_of_text_lines).sub_paracode :=
3522: l_fm_text_tbl_row.sub_paracode;
3523:
3524: IF (l_fm_text_tbl_row.line_no = -1) THEN

Line 3522: l_fm_text_tbl_row.sub_paracode;

3518: l_fm_text_tbl_row.lang_code;
3519: l_text_table (l_number_of_text_lines).paragraph_code :=
3520: l_fm_text_tbl_row.paragraph_code;
3521: l_text_table (l_number_of_text_lines).sub_paracode :=
3522: l_fm_text_tbl_row.sub_paracode;
3523:
3524: IF (l_fm_text_tbl_row.line_no = -1) THEN
3525: l_text_table (l_number_of_text_lines).text := p_text_string;
3526: ELSE

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

3520: l_fm_text_tbl_row.paragraph_code;
3521: l_text_table (l_number_of_text_lines).sub_paracode :=
3522: l_fm_text_tbl_row.sub_paracode;
3523:
3524: IF (l_fm_text_tbl_row.line_no = -1) THEN
3525: l_text_table (l_number_of_text_lines).text := p_text_string;
3526: ELSE
3527: l_text_table (l_number_of_text_lines).text :=
3528: l_fm_text_tbl_row.text;

Line 3528: l_fm_text_tbl_row.text;

3524: IF (l_fm_text_tbl_row.line_no = -1) THEN
3525: l_text_table (l_number_of_text_lines).text := p_text_string;
3526: ELSE
3527: l_text_table (l_number_of_text_lines).text :=
3528: l_fm_text_tbl_row.text;
3529:
3530: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3531: gme_debug.put_line
3532: ( 'text for line no '

Line 3533: || l_fm_text_tbl_row.line_no

3529:
3530: IF (NVL (g_debug, -1) = gme_debug.g_log_statement) THEN
3531: gme_debug.put_line
3532: ( 'text for line no '
3533: || l_fm_text_tbl_row.line_no
3534: || ' is '
3535: || l_text_table (l_number_of_text_lines).text);
3536: END IF;
3537: END IF;

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

3535: || l_text_table (l_number_of_text_lines).text);
3536: END IF;
3537: END IF;
3538: END LOOP;
3539: /* FOR l_fm_text_tbl_row in fm_text_tbl_cursor(l_text_code) LOOP */
3540: ELSE
3541: -- We could not insert the text header. Error message pushed on stack in dbl code.
3542: RAISE unexpected_error;
3543: END IF;