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_VERSION_CONTROL dependencies on FM_TEXT_TBL_TL

Line 34: FROM FM_TEXT_TBL_TL

30: x_row NUMBER := 0;
31: l_rowid VARCHAR2(100);
32: CURSOR Cur_edit_text(p_text_code number) IS
33: SELECT *
34: FROM FM_TEXT_TBL_TL
35: WHERE text_code = p_text_code;
36: l_insert varchar2(1);
37: BEGIN
38:

Line 57: DELETE FROM FM_TEXT_TBL_TL

53: ELSIF flag = 2 THEN
54: l_insert := 'F';
55: FOR i IN 1..edit_text_tbl.count LOOP
56: IF edit_text_tbl(i).text_code = p_text_code THEN
57: DELETE FROM FM_TEXT_TBL_TL
58: WHERE text_code = p_text_code;
59: l_insert := 'T';
60: EXIT;
61: END IF;

Line 67: INSERT INTO FM_TEXT_TBL_TL(

63:
64: IF l_insert = 'T' THEN
65: FOR i IN 1..edit_text_tbl.count LOOP
66: IF edit_text_tbl(i).text_code = p_text_code THEN
67: INSERT INTO FM_TEXT_TBL_TL(
68: TEXT_CODE,
69: LANG_CODE,
70: PARAGRAPH_CODE,
71: SUB_PARACODE,

Line 113: DELETE FROM FM_TEXT_TBL_TL

109:
110: ELSIF flag = 4 THEN
111: FOR i IN 1..edit_text_tbl.count LOOP
112: IF edit_text_tbl(i).text_code IS NOT NULL THEN
113: DELETE FROM FM_TEXT_TBL_TL
114: WHERE TEXT_CODE = edit_text_tbl(i).text_code;
115: END IF;
116: END LOOP;
117: FOR i IN 1..edit_text_tbl.count LOOP

Line 119: INSERT INTO FM_TEXT_TBL_TL(

115: END IF;
116: END LOOP;
117: FOR i IN 1..edit_text_tbl.count LOOP
118: IF edit_text_tbl(i).text_code IS NOT NULL THEN
119: INSERT INTO FM_TEXT_TBL_TL(
120: TEXT_CODE,
121: LANG_CODE,
122: PARAGRAPH_CODE,
123: SUB_PARACODE,

Line 245: 'FM_TEXT_TBL_TL',

241:
242:
243: IF X_hdr_rec.TEXT_CODE IS NOT NULL THEN
244: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_hdr_rec.TEXT_CODE,
245: 'FM_TEXT_TBL_TL',
246: 'FM_TEXT_TBL_TL');
247: populate_temp_text(X_hdr_rec.TEXT_CODE,2);--BUG#3258592
248: ELSE
249: l_text_code := NULL;

Line 246: 'FM_TEXT_TBL_TL');

242:
243: IF X_hdr_rec.TEXT_CODE IS NOT NULL THEN
244: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_hdr_rec.TEXT_CODE,
245: 'FM_TEXT_TBL_TL',
246: 'FM_TEXT_TBL_TL');
247: populate_temp_text(X_hdr_rec.TEXT_CODE,2);--BUG#3258592
248: ELSE
249: l_text_code := NULL;
250: END IF;

Line 317: 'FM_TEXT_TBL_TL',

313: /* Insert detail records */
314: FOR i IN 1..X_dtl_tbl.count LOOP
315: IF X_dtl_tbl(i).text_code IS NOT NULL THEN
316: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_dtl_tbl(i).text_code,
317: 'FM_TEXT_TBL_TL',
318: 'FM_TEXT_TBL_TL');
319: populate_temp_text(X_dtl_tbl(i).text_code,2);--BUG#3258592
320: ELSE
321: l_text_code := NULL;

Line 318: 'FM_TEXT_TBL_TL');

314: FOR i IN 1..X_dtl_tbl.count LOOP
315: IF X_dtl_tbl(i).text_code IS NOT NULL THEN
316: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_dtl_tbl(i).text_code,
317: 'FM_TEXT_TBL_TL',
318: 'FM_TEXT_TBL_TL');
319: populate_temp_text(X_dtl_tbl(i).text_code,2);--BUG#3258592
320: ELSE
321: l_text_code := NULL;
322: END IF;

Line 508: 'FM_TEXT_TBL_TL',

504:
505:
506: IF X_hdr_rec.TEXT_CODE IS NOT NULL THEN
507: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_hdr_rec.TEXT_CODE,
508: 'FM_TEXT_TBL_TL',
509: 'FM_TEXT_TBL_TL');
510: populate_temp_text(X_hdr_rec.TEXT_CODE,2);--BUG#3258592
511: ELSE
512: l_text_code := NULL;

Line 509: 'FM_TEXT_TBL_TL');

505:
506: IF X_hdr_rec.TEXT_CODE IS NOT NULL THEN
507: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_hdr_rec.TEXT_CODE,
508: 'FM_TEXT_TBL_TL',
509: 'FM_TEXT_TBL_TL');
510: populate_temp_text(X_hdr_rec.TEXT_CODE,2);--BUG#3258592
511: ELSE
512: l_text_code := NULL;
513: END IF;

Line 577: 'FM_TEXT_TBL_TL',

573: FOR i IN 1..X_actv_tbl.count LOOP
574: -- Regulating the text code here
575: IF X_actv_tbl(i).text_code IS NOT NULL THEN
576: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_actv_tbl(i).text_code,
577: 'FM_TEXT_TBL_TL',
578: 'FM_TEXT_TBL_TL');
579: populate_temp_text(X_actv_tbl(i).text_code,2);--BUG#3258592
580: ELSE
581: l_text_code := NULL;

Line 578: 'FM_TEXT_TBL_TL');

574: -- Regulating the text code here
575: IF X_actv_tbl(i).text_code IS NOT NULL THEN
576: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_actv_tbl(i).text_code,
577: 'FM_TEXT_TBL_TL',
578: 'FM_TEXT_TBL_TL');
579: populate_temp_text(X_actv_tbl(i).text_code,2);--BUG#3258592
580: ELSE
581: l_text_code := NULL;
582: END IF;

Line 631: 'FM_TEXT_TBL_TL',

627: END IF;
628: IF (X_actv_tbl(i).oprn_line_id = X_rsrc_tbl(X_rsrc_cnt).oprn_line_id) THEN
629: IF X_rsrc_tbl(X_rsrc_cnt).text_code IS NOT NULL THEN
630: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_rsrc_tbl(X_rsrc_cnt).text_code,
631: 'FM_TEXT_TBL_TL',
632: 'FM_TEXT_TBL_TL');
633: populate_temp_text(X_rsrc_tbl(X_rsrc_cnt).text_code,2);--BUG#3258592
634: ELSE
635: l_text_code := NULL;

Line 632: 'FM_TEXT_TBL_TL');

628: IF (X_actv_tbl(i).oprn_line_id = X_rsrc_tbl(X_rsrc_cnt).oprn_line_id) THEN
629: IF X_rsrc_tbl(X_rsrc_cnt).text_code IS NOT NULL THEN
630: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_rsrc_tbl(X_rsrc_cnt).text_code,
631: 'FM_TEXT_TBL_TL',
632: 'FM_TEXT_TBL_TL');
633: populate_temp_text(X_rsrc_tbl(X_rsrc_cnt).text_code,2);--BUG#3258592
634: ELSE
635: l_text_code := NULL;
636: END IF;

Line 938: 'FM_TEXT_TBL_TL',

934: FETCH Cur_recipe_id INTO x_recipe_id;
935: CLOSE Cur_recipe_id;
936: IF X_hdr_rec.TEXT_CODE IS NOT NULL THEN
937: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_hdr_rec.TEXT_CODE,
938: 'FM_TEXT_TBL_TL',
939: 'FM_TEXT_TBL_TL');
940: populate_temp_text(X_hdr_rec.TEXT_CODE,2);--BUG#3258592
941: ELSE
942: l_text_code := NULL;

Line 939: 'FM_TEXT_TBL_TL');

935: CLOSE Cur_recipe_id;
936: IF X_hdr_rec.TEXT_CODE IS NOT NULL THEN
937: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_hdr_rec.TEXT_CODE,
938: 'FM_TEXT_TBL_TL',
939: 'FM_TEXT_TBL_TL');
940: populate_temp_text(X_hdr_rec.TEXT_CODE,2);--BUG#3258592
941: ELSE
942: l_text_code := NULL;
943: END IF;

Line 1008: 'FM_TEXT_TBL_TL',

1004: );
1005: FOR i IN 1..X_proc_loss_tbl.count LOOP
1006: IF X_proc_loss_tbl(i).text_code IS NOT NULL THEN
1007: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_proc_loss_tbl(i).text_code,
1008: 'FM_TEXT_TBL_TL',
1009: 'FM_TEXT_TBL_TL');
1010: populate_temp_text(X_proc_loss_tbl(i).text_code,2);--BUG#3258592
1011: ELSE
1012: l_text_code := NULL;

Line 1009: 'FM_TEXT_TBL_TL');

1005: FOR i IN 1..X_proc_loss_tbl.count LOOP
1006: IF X_proc_loss_tbl(i).text_code IS NOT NULL THEN
1007: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_proc_loss_tbl(i).text_code,
1008: 'FM_TEXT_TBL_TL',
1009: 'FM_TEXT_TBL_TL');
1010: populate_temp_text(X_proc_loss_tbl(i).text_code,2);--BUG#3258592
1011: ELSE
1012: l_text_code := NULL;
1013: END IF;

Line 1031: 'FM_TEXT_TBL_TL',

1027: END LOOP;
1028: FOR i IN 1..X_cust_tbl.count LOOP
1029: IF X_cust_tbl(i).text_code IS NOT NULL THEN
1030: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_cust_tbl(i).text_code,
1031: 'FM_TEXT_TBL_TL',
1032: 'FM_TEXT_TBL_TL');
1033: populate_temp_text(X_cust_tbl(i).text_code,2);--BUG#3258592
1034: ELSE
1035: l_text_code := NULL;

Line 1032: 'FM_TEXT_TBL_TL');

1028: FOR i IN 1..X_cust_tbl.count LOOP
1029: IF X_cust_tbl(i).text_code IS NOT NULL THEN
1030: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_cust_tbl(i).text_code,
1031: 'FM_TEXT_TBL_TL',
1032: 'FM_TEXT_TBL_TL');
1033: populate_temp_text(X_cust_tbl(i).text_code,2);--BUG#3258592
1034: ELSE
1035: l_text_code := NULL;
1036: END IF;

Line 1049: 'FM_TEXT_TBL_TL',

1045: END LOOP;
1046: FOR i IN 1..X_step_tbl.count LOOP
1047: IF X_step_tbl(i).text_code IS NOT NULL THEN
1048: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_step_tbl(i).text_code,
1049: 'FM_TEXT_TBL_TL',
1050: 'FM_TEXT_TBL_TL');
1051: populate_temp_text(X_step_tbl(i).text_code,2);--BUG#3258592
1052: ELSE
1053: l_text_code := NULL;

Line 1050: 'FM_TEXT_TBL_TL');

1046: FOR i IN 1..X_step_tbl.count LOOP
1047: IF X_step_tbl(i).text_code IS NOT NULL THEN
1048: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_step_tbl(i).text_code,
1049: 'FM_TEXT_TBL_TL',
1050: 'FM_TEXT_TBL_TL');
1051: populate_temp_text(X_step_tbl(i).text_code,2);--BUG#3258592
1052: ELSE
1053: l_text_code := NULL;
1054: END IF;

Line 1094: 'FM_TEXT_TBL_TL',

1090: END LOOP;
1091: FOR i IN 1..X_vr_tbl.count LOOP
1092: IF X_vr_tbl(i).text_code IS NOT NULL THEN
1093: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_vr_tbl(i).text_code,
1094: 'FM_TEXT_TBL_TL',
1095: 'FM_TEXT_TBL_TL');
1096: populate_temp_text(X_vr_tbl(i).text_code,2);--BUG#3258592
1097: ELSE
1098: l_text_code := NULL;

Line 1095: 'FM_TEXT_TBL_TL');

1091: FOR i IN 1..X_vr_tbl.count LOOP
1092: IF X_vr_tbl(i).text_code IS NOT NULL THEN
1093: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_vr_tbl(i).text_code,
1094: 'FM_TEXT_TBL_TL',
1095: 'FM_TEXT_TBL_TL');
1096: populate_temp_text(X_vr_tbl(i).text_code,2);--BUG#3258592
1097: ELSE
1098: l_text_code := NULL;
1099: END IF;

Line 1145: 'FM_TEXT_TBL_TL',

1141: END LOOP;
1142: FOR i IN 1..X_actv_tbl.count LOOP
1143: IF X_actv_tbl(i).text_code IS NOT NULL THEN
1144: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_actv_tbl(i).text_code,
1145: 'FM_TEXT_TBL_TL',
1146: 'FM_TEXT_TBL_TL');
1147: populate_temp_text(X_actv_tbl(i).text_code,2);--BUG#3258592
1148: ELSE
1149: l_text_code := NULL;

Line 1146: 'FM_TEXT_TBL_TL');

1142: FOR i IN 1..X_actv_tbl.count LOOP
1143: IF X_actv_tbl(i).text_code IS NOT NULL THEN
1144: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_actv_tbl(i).text_code,
1145: 'FM_TEXT_TBL_TL',
1146: 'FM_TEXT_TBL_TL');
1147: populate_temp_text(X_actv_tbl(i).text_code,2);--BUG#3258592
1148: ELSE
1149: l_text_code := NULL;
1150: END IF;

Line 1189: 'FM_TEXT_TBL_TL',

1185: END LOOP;
1186: FOR i IN 1..X_rsrc_tbl.count LOOP
1187: IF X_rsrc_tbl(i).text_code IS NOT NULL THEN
1188: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_rsrc_tbl(i).text_code,
1189: 'FM_TEXT_TBL_TL',
1190: 'FM_TEXT_TBL_TL');
1191: populate_temp_text(X_rsrc_tbl(i).text_code,2);--BUG#3258592
1192: ELSE
1193: l_text_code := NULL;

Line 1190: 'FM_TEXT_TBL_TL');

1186: FOR i IN 1..X_rsrc_tbl.count LOOP
1187: IF X_rsrc_tbl(i).text_code IS NOT NULL THEN
1188: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_rsrc_tbl(i).text_code,
1189: 'FM_TEXT_TBL_TL',
1190: 'FM_TEXT_TBL_TL');
1191: populate_temp_text(X_rsrc_tbl(i).text_code,2);--BUG#3258592
1192: ELSE
1193: l_text_code := NULL;
1194: END IF;

Line 1244: 'FM_TEXT_TBL_TL',

1240: END LOOP;
1241: FOR i IN 1..X_stepmtl_tbl.count LOOP
1242: IF X_stepmtl_tbl(i).text_code IS NOT NULL THEN
1243: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_stepmtl_tbl(i).text_code,
1244: 'FM_TEXT_TBL_TL',
1245: 'FM_TEXT_TBL_TL');
1246: populate_temp_text(X_stepmtl_tbl(i).text_code,2);--BUG#3258592
1247: ELSE
1248: l_text_code := NULL;

Line 1245: 'FM_TEXT_TBL_TL');

1241: FOR i IN 1..X_stepmtl_tbl.count LOOP
1242: IF X_stepmtl_tbl(i).text_code IS NOT NULL THEN
1243: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_stepmtl_tbl(i).text_code,
1244: 'FM_TEXT_TBL_TL',
1245: 'FM_TEXT_TBL_TL');
1246: populate_temp_text(X_stepmtl_tbl(i).text_code,2);--BUG#3258592
1247: ELSE
1248: l_text_code := NULL;
1249: END IF;

Line 1425: 'FM_TEXT_TBL_TL',

1421: FETCH Cur_formula_id INTO x_formula_id;
1422: CLOSE Cur_formula_id;
1423: IF X_hdr_rec.TEXT_CODE IS NOT NULL THEN
1424: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_hdr_rec.TEXT_CODE,
1425: 'FM_TEXT_TBL_TL',
1426: 'FM_TEXT_TBL_TL');
1427: populate_temp_text(X_hdr_rec.TEXT_CODE,2);--BUG#3258592
1428: ELSE
1429: l_text_code := NULL;

Line 1426: 'FM_TEXT_TBL_TL');

1422: CLOSE Cur_formula_id;
1423: IF X_hdr_rec.TEXT_CODE IS NOT NULL THEN
1424: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_hdr_rec.TEXT_CODE,
1425: 'FM_TEXT_TBL_TL',
1426: 'FM_TEXT_TBL_TL');
1427: populate_temp_text(X_hdr_rec.TEXT_CODE,2);--BUG#3258592
1428: ELSE
1429: l_text_code := NULL;
1430: END IF;

Line 1523: 'FM_TEXT_TBL_TL',

1519:
1520: FOR i IN 1..X_dtl_tbl.count LOOP
1521: IF X_dtl_tbl(i).text_code IS NOT NULL THEN
1522: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_dtl_tbl(i).text_code,
1523: 'FM_TEXT_TBL_TL',
1524: 'FM_TEXT_TBL_TL');
1525: populate_temp_text(X_dtl_tbl(i).text_code,2);--BUG#3258592
1526: ELSE
1527: l_text_code := NULL;

Line 1524: 'FM_TEXT_TBL_TL');

1520: FOR i IN 1..X_dtl_tbl.count LOOP
1521: IF X_dtl_tbl(i).text_code IS NOT NULL THEN
1522: l_text_code := GMA_EDITTEXT_PKG.Copy_Text(X_dtl_tbl(i).text_code,
1523: 'FM_TEXT_TBL_TL',
1524: 'FM_TEXT_TBL_TL');
1525: populate_temp_text(X_dtl_tbl(i).text_code,2);--BUG#3258592
1526: ELSE
1527: l_text_code := NULL;
1528: END IF;