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_BATCH_PVT dependencies on FM_TEXT_TBL

Line 368: CURSOR fm_text_tbl_cursor (v_text_code NUMBER)

364: FROM fm_matl_dtl a, gmd_recipes_b b
365: WHERE a.formula_id = b.formula_id AND b.recipe_id = v_recipe_id
366: ORDER BY line_no;
367:
368: CURSOR fm_text_tbl_cursor (v_text_code NUMBER)
369: IS
370: SELECT *
371: FROM fm_text_tbl
372: WHERE text_code = NVL (v_text_code, -1)

Line 371: FROM fm_text_tbl

367:
368: CURSOR fm_text_tbl_cursor (v_text_code NUMBER)
369: IS
370: SELECT *
371: FROM fm_text_tbl
372: WHERE text_code = NVL (v_text_code, -1)
373: ORDER BY line_no;
374:
375: -- pawan kumar changed this cursor for bug 4917631

Line 1692: FOR l_fm_text_tbl_row IN

1688: IF (g_debug = gme_debug.g_log_statement) THEN
1689: gme_debug.put_line ('x_batch_header_rec.text_code = '||x_batch_header_rec.text_code);
1690: gme_debug.put_line ('Inserting formula header text in batch header edit text');
1691: END IF;
1692: FOR l_fm_text_tbl_row IN
1693: fm_text_tbl_cursor (l_formula_master.text_code) LOOP
1694: l_number_of_text_lines := l_number_of_text_lines + 1;
1695: l_text_table (l_number_of_text_lines).text_code :=
1696: x_batch_header_rec.text_code;

Line 1693: fm_text_tbl_cursor (l_formula_master.text_code) LOOP

1689: gme_debug.put_line ('x_batch_header_rec.text_code = '||x_batch_header_rec.text_code);
1690: gme_debug.put_line ('Inserting formula header text in batch header edit text');
1691: END IF;
1692: FOR l_fm_text_tbl_row IN
1693: fm_text_tbl_cursor (l_formula_master.text_code) LOOP
1694: l_number_of_text_lines := l_number_of_text_lines + 1;
1695: l_text_table (l_number_of_text_lines).text_code :=
1696: x_batch_header_rec.text_code;
1697: l_text_table (l_number_of_text_lines).line_no :=

Line 1698: l_fm_text_tbl_row.line_no;

1694: l_number_of_text_lines := l_number_of_text_lines + 1;
1695: l_text_table (l_number_of_text_lines).text_code :=
1696: x_batch_header_rec.text_code;
1697: l_text_table (l_number_of_text_lines).line_no :=
1698: l_fm_text_tbl_row.line_no;
1699: l_text_table (l_number_of_text_lines).lang_code :=
1700: l_fm_text_tbl_row.lang_code;
1701: l_text_table (l_number_of_text_lines).paragraph_code :=
1702: l_fm_text_tbl_row.paragraph_code;

Line 1700: l_fm_text_tbl_row.lang_code;

1696: x_batch_header_rec.text_code;
1697: l_text_table (l_number_of_text_lines).line_no :=
1698: l_fm_text_tbl_row.line_no;
1699: l_text_table (l_number_of_text_lines).lang_code :=
1700: l_fm_text_tbl_row.lang_code;
1701: l_text_table (l_number_of_text_lines).paragraph_code :=
1702: l_fm_text_tbl_row.paragraph_code;
1703: l_text_table (l_number_of_text_lines).sub_paracode :=
1704: l_fm_text_tbl_row.sub_paracode;

Line 1702: l_fm_text_tbl_row.paragraph_code;

1698: l_fm_text_tbl_row.line_no;
1699: l_text_table (l_number_of_text_lines).lang_code :=
1700: l_fm_text_tbl_row.lang_code;
1701: l_text_table (l_number_of_text_lines).paragraph_code :=
1702: l_fm_text_tbl_row.paragraph_code;
1703: l_text_table (l_number_of_text_lines).sub_paracode :=
1704: l_fm_text_tbl_row.sub_paracode;
1705:
1706: IF l_fm_text_tbl_row.line_no = -1 THEN

Line 1704: l_fm_text_tbl_row.sub_paracode;

1700: l_fm_text_tbl_row.lang_code;
1701: l_text_table (l_number_of_text_lines).paragraph_code :=
1702: l_fm_text_tbl_row.paragraph_code;
1703: l_text_table (l_number_of_text_lines).sub_paracode :=
1704: l_fm_text_tbl_row.sub_paracode;
1705:
1706: IF l_fm_text_tbl_row.line_no = -1 THEN
1707: -- Start constructing key field for text code.
1708: l_text_table (l_number_of_text_lines).text :=

Line 1706: IF l_fm_text_tbl_row.line_no = -1 THEN

1702: l_fm_text_tbl_row.paragraph_code;
1703: l_text_table (l_number_of_text_lines).sub_paracode :=
1704: l_fm_text_tbl_row.sub_paracode;
1705:
1706: IF l_fm_text_tbl_row.line_no = -1 THEN
1707: -- Start constructing key field for text code.
1708: l_text_table (l_number_of_text_lines).text :=
1709: 'gme_batch_header'
1710: || '|'

Line 1715: l_fm_text_tbl_row.text;

1711: || TO_CHAR (x_batch_header_rec.batch_id)
1712: || '|';
1713: ELSE
1714: l_text_table (l_number_of_text_lines).text :=
1715: l_fm_text_tbl_row.text;
1716: END IF;
1717: END LOOP;
1718: END IF;
1719:

Line 1742: FOR l_fm_text_tbl_row IN fm_text_tbl_cursor (l_text_code) LOOP

1738: l_material_details (l_row_count).text_code :=
1739: l_text_header.text_code;
1740:
1741: -- This fetches using the fm text data based on the fm text code.
1742: FOR l_fm_text_tbl_row IN fm_text_tbl_cursor (l_text_code) LOOP
1743: l_number_of_text_lines := l_number_of_text_lines + 1;
1744: l_text_table (l_number_of_text_lines).text_code :=
1745: l_text_header.text_code;
1746: l_text_table (l_number_of_text_lines).line_no :=

Line 1747: l_fm_text_tbl_row.line_no;

1743: l_number_of_text_lines := l_number_of_text_lines + 1;
1744: l_text_table (l_number_of_text_lines).text_code :=
1745: l_text_header.text_code;
1746: l_text_table (l_number_of_text_lines).line_no :=
1747: l_fm_text_tbl_row.line_no;
1748: l_text_table (l_number_of_text_lines).lang_code :=
1749: l_fm_text_tbl_row.lang_code;
1750: l_text_table (l_number_of_text_lines).paragraph_code :=
1751: l_fm_text_tbl_row.paragraph_code;

Line 1749: l_fm_text_tbl_row.lang_code;

1745: l_text_header.text_code;
1746: l_text_table (l_number_of_text_lines).line_no :=
1747: l_fm_text_tbl_row.line_no;
1748: l_text_table (l_number_of_text_lines).lang_code :=
1749: l_fm_text_tbl_row.lang_code;
1750: l_text_table (l_number_of_text_lines).paragraph_code :=
1751: l_fm_text_tbl_row.paragraph_code;
1752: l_text_table (l_number_of_text_lines).sub_paracode :=
1753: l_fm_text_tbl_row.sub_paracode;

Line 1751: l_fm_text_tbl_row.paragraph_code;

1747: l_fm_text_tbl_row.line_no;
1748: l_text_table (l_number_of_text_lines).lang_code :=
1749: l_fm_text_tbl_row.lang_code;
1750: l_text_table (l_number_of_text_lines).paragraph_code :=
1751: l_fm_text_tbl_row.paragraph_code;
1752: l_text_table (l_number_of_text_lines).sub_paracode :=
1753: l_fm_text_tbl_row.sub_paracode;
1754:
1755: IF l_fm_text_tbl_row.line_no = -1 THEN

Line 1753: l_fm_text_tbl_row.sub_paracode;

1749: l_fm_text_tbl_row.lang_code;
1750: l_text_table (l_number_of_text_lines).paragraph_code :=
1751: l_fm_text_tbl_row.paragraph_code;
1752: l_text_table (l_number_of_text_lines).sub_paracode :=
1753: l_fm_text_tbl_row.sub_paracode;
1754:
1755: IF l_fm_text_tbl_row.line_no = -1 THEN
1756: -- Start constructing key field for text code.
1757: l_text_string :=

Line 1755: IF l_fm_text_tbl_row.line_no = -1 THEN

1751: l_fm_text_tbl_row.paragraph_code;
1752: l_text_table (l_number_of_text_lines).sub_paracode :=
1753: l_fm_text_tbl_row.sub_paracode;
1754:
1755: IF l_fm_text_tbl_row.line_no = -1 THEN
1756: -- Start constructing key field for text code.
1757: l_text_string :=
1758: 'gme_material_details'
1759: || '|'

Line 1774: l_fm_text_tbl_row.text;

1770: l_text_table (l_number_of_text_lines).text :=
1771: l_text_string;
1772: ELSE
1773: l_text_table (l_number_of_text_lines).text :=
1774: l_fm_text_tbl_row.text;
1775: END IF;
1776: END LOOP; -- text lines loop.
1777: ELSE
1778: -- We could not insert the text header. Panic