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.GR_FIELD_NAME_MASKS_TL_PKG dependencies on GR_ITEM_FIELD_NAME_MASKS_TL

Line 114: INSERT INTO gr_item_field_name_masks_tl

110: IF FND_API.To_Boolean(l_key_exists) THEN
111: RAISE Item_Exists_Error;
112: END IF;
113:
114: INSERT INTO gr_item_field_name_masks_tl
115: (item_code,
116: disclosure_code,
117: label_code,
118: language,

Line 316: UPDATE gr_item_field_name_masks_tl

312:
313: IF l_return_status <> 'S' THEN
314: RAISE Foreign_Key_Error;
315: ELSE
316: UPDATE gr_item_field_name_masks_tl
317: SET item_code = p_item_code,
318: disclosure_code = p_disclosure_code,
319: label_code = p_label_code,
320: language = p_language,

Line 457: FROM gr_item_field_name_masks_tl eit

453: eit.creation_date,
454: eit.last_updated_by,
455: eit.last_update_date,
456: eit.last_update_login
457: FROM gr_item_field_name_masks_tl eit
458: WHERE eit.item_code = p_item_code
459: AND eit.disclosure_code = p_disclosure_code
460: AND eit.label_code = p_label_code
461: AND eit.language = l_language;

Line 483: delete from GR_ITEM_FIELD_NAME_MASKS_TL T

479: l_msg_token := p_item_code || ' ' || p_disclosure_code || ' ' || p_label_code || ' ' || p_language;
480:
481: /* Remove translations with no base row */
482:
483: delete from GR_ITEM_FIELD_NAME_MASKS_TL T
484: where not exists
485: (select NULL
486: from GR_ITEM_FIELD_NAME_MASKS_B B
487: where B.ITEM_CODE = T.ITEM_CODE

Line 494: Update gr_item_field_name_masks_tl t set (

490: );
491:
492: /* Redefault translations from the source language */
493:
494: Update gr_item_field_name_masks_tl t set (
495: field_name_mask ) =
496: ( select
497: b.field_name_mask
498: from gr_item_field_name_masks_tl b

Line 498: from gr_item_field_name_masks_tl b

494: Update gr_item_field_name_masks_tl t set (
495: field_name_mask ) =
496: ( select
497: b.field_name_mask
498: from gr_item_field_name_masks_tl b
499: where b.item_code = t.item_code
500: and b.disclosure_code = t.disclosure_code
501: and b.label_code = t.label_code
502: and b.language = t.source_lang)

Line 513: from gr_item_field_name_masks_tl subb, gr_item_field_name_masks_tl subt

509: subt.item_code,
510: subt.disclosure_code,
511: subt.label_code,
512: subt.language
513: from gr_item_field_name_masks_tl subb, gr_item_field_name_masks_tl subt
514: where subb.item_code = subt.item_code
515: and subb.disclosure_code = subt.disclosure_code
516: and subb.label_code = subt.label_code
517: and subb.language = subt.source_lang

Line 555: INSERT INTO gr_item_field_name_masks_tl

551: OPEN c_get_descs;
552: FETCH c_get_descs INTO TypeDesc;
553: IF c_get_descs%NOTFOUND THEN
554: CLOSE c_get_descs;
555: INSERT INTO gr_item_field_name_masks_tl
556: (item_code,
557: disclosure_code,
558: label_code,
559: language,

Line 697: FROM gr_item_field_name_masks_tl

693:
694: CURSOR c_lock_ein_number
695: IS
696: SELECT last_update_date
697: FROM gr_item_field_name_masks_tl
698: WHERE rowid = p_rowid
699: FOR UPDATE NOWAIT;
700: LockEinRcd c_lock_ein_number%ROWTYPE;
701: BEGIN

Line 841: DELETE FROM gr_item_field_name_masks_tl

837: x_oracle_error := 0;
838: x_msg_data := NULL;
839: l_msg_token := p_item_code || ' ' || p_disclosure_code || ' ' || p_label_code || ' '|| p_language;
840:
841: DELETE FROM gr_item_field_name_masks_tl
842: WHERE rowid = p_rowid;
843:
844: /* Check the commit flag and if set, then commit the work. */
845:

Line 938: DELETE FROM gr_item_field_name_masks_tl

934: x_oracle_error := 0;
935: x_msg_data := NULL;
936: l_msg_token := p_item_code;
937:
938: DELETE FROM gr_item_field_name_masks_tl
939: WHERE item_code = p_item_code;
940:
941: IF FND_API.To_Boolean(p_commit) THEN
942: COMMIT WORK;

Line 1120: FROM gr_item_field_name_masks_tl ein

1116:
1117: CURSOR c_get_ein_rowid
1118: IS
1119: SELECT ein.rowid
1120: FROM gr_item_field_name_masks_tl ein
1121: WHERE ein.item_code = p_item_code
1122: AND ein.disclosure_code = p_disclosure_code
1123: AND ein.label_code = p_label_code
1124: AND ein.language = p_language;

Line 1183: UPDATE GR_ITEM_FIELD_NAME_MASKS_TL SET

1179: ,X_FIELD_NAME_MASK IN VARCHAR2
1180: ,X_SOURCE_LANG IN VARCHAR2
1181: ) IS
1182: BEGIN
1183: UPDATE GR_ITEM_FIELD_NAME_MASKS_TL SET
1184: FIELD_NAME_MASK = X_FIELD_NAME_MASK,
1185: SOURCE_LANG = USERENV('LANG'),
1186: LAST_UPDATE_DATE = sysdate,
1187: LAST_UPDATED_BY = 0,

Line 1224: FROM GR_ITEM_FIELD_NAME_MASKS_TL

1220: ,X_SOURCE_LANG IN VARCHAR2
1221: ) IS
1222: CURSOR Cur_rowid IS
1223: SELECT rowid
1224: FROM GR_ITEM_FIELD_NAME_MASKS_TL
1225: WHERE (ITEM_CODE = X_ITEM_CODE)
1226: AND (DISCLOSURE_CODE = X_DISCLOSURE_CODE)
1227: AND (LABEL_CODE = X_LABEL_CODE)
1228: AND (LANGUAGE = X_LANGUAGE);

Line 1295: DELETE FROM GR_ITEM_FIELD_NAME_MASKS_TL T

1291: ===================================================================== */
1292: PROCEDURE NEW_LANGUAGE
1293: is
1294: begin
1295: DELETE FROM GR_ITEM_FIELD_NAME_MASKS_TL T
1296: WHERE not exists
1297: (SELECT NULL
1298: FROM GR_ITEM_FIELD_NAME_MASKS_B B
1299: WHERE B.ITEM_CODE = T.ITEM_CODE

Line 1304: UPDATE GR_ITEM_FIELD_NAME_MASKS_TL T SET (

1300: AND B.DISCLOSURE_CODE = T.DISCLOSURE_CODE
1301: AND B.LABEL_CODE = T.LABEL_CODE
1302: );
1303:
1304: UPDATE GR_ITEM_FIELD_NAME_MASKS_TL T SET (
1305: FIELD_NAME_MASK
1306: ) = (SELECT
1307: B.FIELD_NAME_MASK
1308: FROM GR_ITEM_FIELD_NAME_MASKS_TL B

Line 1308: FROM GR_ITEM_FIELD_NAME_MASKS_TL B

1304: UPDATE GR_ITEM_FIELD_NAME_MASKS_TL T SET (
1305: FIELD_NAME_MASK
1306: ) = (SELECT
1307: B.FIELD_NAME_MASK
1308: FROM GR_ITEM_FIELD_NAME_MASKS_TL B
1309: WHERE B.ITEM_CODE = T.ITEM_CODE
1310: AND B.LANGUAGE = T.SOURCE_LANG
1311: AND B.DISCLOSURE_CODE = T.DISCLOSURE_CODE
1312: AND B.LABEL_CODE = T.LABEL_CODE)

Line 1323: FROM GR_ITEM_FIELD_NAME_MASKS_TL SUBB, GR_ITEM_FIELD_NAME_MASKS_TL SUBT

1319: SUBT.ITEM_CODE,
1320: SUBT.LANGUAGE,
1321: SUBT.DISCLOSURE_CODE,
1322: SUBT.LABEL_CODE
1323: FROM GR_ITEM_FIELD_NAME_MASKS_TL SUBB, GR_ITEM_FIELD_NAME_MASKS_TL SUBT
1324: WHERE SUBB.ITEM_CODE = SUBT.ITEM_CODE
1325: AND SUBB.LANGUAGE = SUBT.SOURCE_LANG
1326: AND SUBB.DISCLOSURE_CODE = SUBT.DISCLOSURE_CODE
1327: AND SUBB.LABEL_CODE = SUBT.LABEL_CODE

Line 1331: INSERT into GR_ITEM_FIELD_NAME_MASKS_TL (

1327: AND SUBB.LABEL_CODE = SUBT.LABEL_CODE
1328: AND (SUBB.FIELD_NAME_MASK <> SUBT.FIELD_NAME_MASK
1329: ));
1330:
1331: INSERT into GR_ITEM_FIELD_NAME_MASKS_TL (
1332: ITEM_CODE,
1333: DISCLOSURE_CODE,
1334: LABEL_CODE,
1335: FIELD_NAME_MASK,

Line 1355: FROM GR_ITEM_FIELD_NAME_MASKS_TL B, FND_LANGUAGES L

1351: B.LAST_UPDATE_DATE,
1352: B.LAST_UPDATE_LOGIN,
1353: L.LANGUAGE_CODE,
1354: B.SOURCE_LANG
1355: FROM GR_ITEM_FIELD_NAME_MASKS_TL B, FND_LANGUAGES L
1356: WHERE L.INSTALLED_FLAG in ('I', 'B')
1357: AND B.LANGUAGE = userenv('LANG')
1358: AND not exists
1359: (SELECT NULL

Line 1360: FROM GR_ITEM_FIELD_NAME_MASKS_TL T

1356: WHERE L.INSTALLED_FLAG in ('I', 'B')
1357: AND B.LANGUAGE = userenv('LANG')
1358: AND not exists
1359: (SELECT NULL
1360: FROM GR_ITEM_FIELD_NAME_MASKS_TL T
1361: WHERE T.ITEM_CODE = B.ITEM_CODE
1362: AND T.DISCLOSURE_CODE = B.DISCLOSURE_CODE
1363: AND T.LABEL_CODE = B.LABEL_CODE
1364: AND T.LANGUAGE = L.LANGUAGE_CODE);