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 288: CURSOR fm_text_tbl_cursor (v_text_code NUMBER)

284: FROM fm_matl_dtl a, gmd_recipes_b b
285: WHERE a.formula_id = b.formula_id AND b.recipe_id = v_recipe_id
286: ORDER BY line_no;
287:
288: CURSOR fm_text_tbl_cursor (v_text_code NUMBER)
289: IS
290: SELECT *
291: FROM fm_text_tbl
292: WHERE text_code = NVL (v_text_code, -1)

Line 291: FROM fm_text_tbl

287:
288: CURSOR fm_text_tbl_cursor (v_text_code NUMBER)
289: IS
290: SELECT *
291: FROM fm_text_tbl
292: WHERE text_code = NVL (v_text_code, -1)
293: ORDER BY line_no;
294: -- pawan kumar changed this cursor for bug 4917631
295: CURSOR item_master_cursor (v_inventory_item_id NUMBER, v_org_id NUMBER)

Line 1463: FOR l_fm_text_tbl_row IN

1459: IF (g_debug = gme_debug.g_log_statement) THEN
1460: gme_debug.put_line ('x_batch_header_rec.text_code = '||x_batch_header_rec.text_code);
1461: gme_debug.put_line ('Inserting formula header text in batch header edit text');
1462: END IF;
1463: FOR l_fm_text_tbl_row IN
1464: fm_text_tbl_cursor (l_formula_master.text_code) LOOP
1465: l_number_of_text_lines := l_number_of_text_lines + 1;
1466: l_text_table (l_number_of_text_lines).text_code :=
1467: x_batch_header_rec.text_code;

Line 1464: fm_text_tbl_cursor (l_formula_master.text_code) LOOP

1460: gme_debug.put_line ('x_batch_header_rec.text_code = '||x_batch_header_rec.text_code);
1461: gme_debug.put_line ('Inserting formula header text in batch header edit text');
1462: END IF;
1463: FOR l_fm_text_tbl_row IN
1464: fm_text_tbl_cursor (l_formula_master.text_code) LOOP
1465: l_number_of_text_lines := l_number_of_text_lines + 1;
1466: l_text_table (l_number_of_text_lines).text_code :=
1467: x_batch_header_rec.text_code;
1468: l_text_table (l_number_of_text_lines).line_no :=

Line 1469: l_fm_text_tbl_row.line_no;

1465: l_number_of_text_lines := l_number_of_text_lines + 1;
1466: l_text_table (l_number_of_text_lines).text_code :=
1467: x_batch_header_rec.text_code;
1468: l_text_table (l_number_of_text_lines).line_no :=
1469: l_fm_text_tbl_row.line_no;
1470: l_text_table (l_number_of_text_lines).lang_code :=
1471: l_fm_text_tbl_row.lang_code;
1472: l_text_table (l_number_of_text_lines).paragraph_code :=
1473: l_fm_text_tbl_row.paragraph_code;

Line 1471: l_fm_text_tbl_row.lang_code;

1467: x_batch_header_rec.text_code;
1468: l_text_table (l_number_of_text_lines).line_no :=
1469: l_fm_text_tbl_row.line_no;
1470: l_text_table (l_number_of_text_lines).lang_code :=
1471: l_fm_text_tbl_row.lang_code;
1472: l_text_table (l_number_of_text_lines).paragraph_code :=
1473: l_fm_text_tbl_row.paragraph_code;
1474: l_text_table (l_number_of_text_lines).sub_paracode :=
1475: l_fm_text_tbl_row.sub_paracode;

Line 1473: l_fm_text_tbl_row.paragraph_code;

1469: l_fm_text_tbl_row.line_no;
1470: l_text_table (l_number_of_text_lines).lang_code :=
1471: l_fm_text_tbl_row.lang_code;
1472: l_text_table (l_number_of_text_lines).paragraph_code :=
1473: l_fm_text_tbl_row.paragraph_code;
1474: l_text_table (l_number_of_text_lines).sub_paracode :=
1475: l_fm_text_tbl_row.sub_paracode;
1476:
1477: IF l_fm_text_tbl_row.line_no = -1 THEN

Line 1475: l_fm_text_tbl_row.sub_paracode;

1471: l_fm_text_tbl_row.lang_code;
1472: l_text_table (l_number_of_text_lines).paragraph_code :=
1473: l_fm_text_tbl_row.paragraph_code;
1474: l_text_table (l_number_of_text_lines).sub_paracode :=
1475: l_fm_text_tbl_row.sub_paracode;
1476:
1477: IF l_fm_text_tbl_row.line_no = -1 THEN
1478: -- Start constructing key field for text code.
1479: l_text_table (l_number_of_text_lines).text :=

Line 1477: IF l_fm_text_tbl_row.line_no = -1 THEN

1473: l_fm_text_tbl_row.paragraph_code;
1474: l_text_table (l_number_of_text_lines).sub_paracode :=
1475: l_fm_text_tbl_row.sub_paracode;
1476:
1477: IF l_fm_text_tbl_row.line_no = -1 THEN
1478: -- Start constructing key field for text code.
1479: l_text_table (l_number_of_text_lines).text :=
1480: 'gme_batch_header'
1481: || '|'

Line 1486: l_fm_text_tbl_row.text;

1482: || TO_CHAR (x_batch_header_rec.batch_id)
1483: || '|';
1484: ELSE
1485: l_text_table (l_number_of_text_lines).text :=
1486: l_fm_text_tbl_row.text;
1487: END IF;
1488: END LOOP;
1489: END IF;
1490:

Line 1513: FOR l_fm_text_tbl_row IN fm_text_tbl_cursor (l_text_code) LOOP

1509: l_material_details (l_row_count).text_code :=
1510: l_text_header.text_code;
1511:
1512: -- This fetches using the fm text data based on the fm text code.
1513: FOR l_fm_text_tbl_row IN fm_text_tbl_cursor (l_text_code) LOOP
1514: l_number_of_text_lines := l_number_of_text_lines + 1;
1515: l_text_table (l_number_of_text_lines).text_code :=
1516: l_text_header.text_code;
1517: l_text_table (l_number_of_text_lines).line_no :=

Line 1518: l_fm_text_tbl_row.line_no;

1514: l_number_of_text_lines := l_number_of_text_lines + 1;
1515: l_text_table (l_number_of_text_lines).text_code :=
1516: l_text_header.text_code;
1517: l_text_table (l_number_of_text_lines).line_no :=
1518: l_fm_text_tbl_row.line_no;
1519: l_text_table (l_number_of_text_lines).lang_code :=
1520: l_fm_text_tbl_row.lang_code;
1521: l_text_table (l_number_of_text_lines).paragraph_code :=
1522: l_fm_text_tbl_row.paragraph_code;

Line 1520: l_fm_text_tbl_row.lang_code;

1516: l_text_header.text_code;
1517: l_text_table (l_number_of_text_lines).line_no :=
1518: l_fm_text_tbl_row.line_no;
1519: l_text_table (l_number_of_text_lines).lang_code :=
1520: l_fm_text_tbl_row.lang_code;
1521: l_text_table (l_number_of_text_lines).paragraph_code :=
1522: l_fm_text_tbl_row.paragraph_code;
1523: l_text_table (l_number_of_text_lines).sub_paracode :=
1524: l_fm_text_tbl_row.sub_paracode;

Line 1522: l_fm_text_tbl_row.paragraph_code;

1518: l_fm_text_tbl_row.line_no;
1519: l_text_table (l_number_of_text_lines).lang_code :=
1520: l_fm_text_tbl_row.lang_code;
1521: l_text_table (l_number_of_text_lines).paragraph_code :=
1522: l_fm_text_tbl_row.paragraph_code;
1523: l_text_table (l_number_of_text_lines).sub_paracode :=
1524: l_fm_text_tbl_row.sub_paracode;
1525:
1526: IF l_fm_text_tbl_row.line_no = -1 THEN

Line 1524: l_fm_text_tbl_row.sub_paracode;

1520: l_fm_text_tbl_row.lang_code;
1521: l_text_table (l_number_of_text_lines).paragraph_code :=
1522: l_fm_text_tbl_row.paragraph_code;
1523: l_text_table (l_number_of_text_lines).sub_paracode :=
1524: l_fm_text_tbl_row.sub_paracode;
1525:
1526: IF l_fm_text_tbl_row.line_no = -1 THEN
1527: -- Start constructing key field for text code.
1528: l_text_string :=

Line 1526: IF l_fm_text_tbl_row.line_no = -1 THEN

1522: l_fm_text_tbl_row.paragraph_code;
1523: l_text_table (l_number_of_text_lines).sub_paracode :=
1524: l_fm_text_tbl_row.sub_paracode;
1525:
1526: IF l_fm_text_tbl_row.line_no = -1 THEN
1527: -- Start constructing key field for text code.
1528: l_text_string :=
1529: 'gme_material_details'
1530: || '|'

Line 1545: l_fm_text_tbl_row.text;

1541: l_text_table (l_number_of_text_lines).text :=
1542: l_text_string;
1543: ELSE
1544: l_text_table (l_number_of_text_lines).text :=
1545: l_fm_text_tbl_row.text;
1546: END IF;
1547: END LOOP; -- text lines loop.
1548: ELSE
1549: -- We could not insert the text header. Panic