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_LABELS_TL_PKG dependencies on GR_LABELS_TL

Line 1: PACKAGE BODY GR_LABELS_TL_PKG AS

1: PACKAGE BODY GR_LABELS_TL_PKG AS
2: /*$Header: GRHILATB.pls 120.1 2006/06/16 21:39:22 pbamb noship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 76: INSERT INTO gr_labels_tl

72: IF FND_API.To_Boolean(l_key_exists) THEN
73: RAISE Item_Exists_Error;
74: END IF;
75:
76: INSERT INTO gr_labels_tl
77: (label_code,
78: language,
79: label_description,
80: source_lang,

Line 243: UPDATE gr_labels_tl

239:
240: IF l_return_status <> 'S' THEN
241: RAISE Foreign_Key_Error;
242: ELSE
243: UPDATE gr_labels_tl
244: SET label_code = p_label_code,
245: language = p_language,
246: label_description = p_label_description,
247: source_lang = p_source_lang,

Line 357: FROM gr_labels_tl lat

353: lat.creation_date,
354: lat.last_updated_by,
355: lat.last_update_date,
356: lat.last_update_login
357: FROM gr_labels_tl lat
358: WHERE lat.label_code = p_label_code
359: AND lat.language = l_language;
360: LabelDesc c_get_descs%ROWTYPE;
361:

Line 382: delete from GR_LABELS_TL T

378: l_msg_token := p_label_code || ' ' || p_language;
379:
380: /* Remove translations with no base row */
381:
382: delete from GR_LABELS_TL T
383: where not exists
384: (select NULL
385: from GR_LABELS_B B
386: where B.LABEL_CODE = T.LABEL_CODE

Line 391: update gr_labels_tl t set (

387: );
388:
389: /* Redefault translations from the source language */
390:
391: update gr_labels_tl t set (
392: label_description ) =
393: ( select
394: B.LABEL_DESCRIPTION
395: from GR_LABELS_TL B

Line 395: from GR_LABELS_TL B

391: update gr_labels_tl t set (
392: label_description ) =
393: ( select
394: B.LABEL_DESCRIPTION
395: from GR_LABELS_TL B
396: where B.LABEL_CODE = T.LABEL_CODE
397: and B.LANGUAGE = T.SOURCE_LANG)
398: where (
399: T.LABEL_CODE,

Line 404: from GR_LABELS_TL SUBB, GR_LABELS_TL SUBT

400: T.LANGUAGE
401: ) in (select
402: SUBT.LABEL_CODE,
403: SUBT.LANGUAGE
404: from GR_LABELS_TL SUBB, GR_LABELS_TL SUBT
405: where SUBB.LABEL_CODE = SUBT.LABEL_CODE
406: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
407: and (SUBB.LABEL_DESCRIPTION <> SUBT.LABEL_DESCRIPTION
408: or (SUBB.LABEL_DESCRIPTION is null and SUBT.LABEL_DESCRIPTION is not null)

Line 447: INSERT INTO gr_labels_tl

443: OPEN c_get_descs;
444: FETCH c_get_descs INTO LabelDesc;
445: IF c_get_descs%NOTFOUND THEN
446: CLOSE c_get_descs;
447: INSERT INTO gr_labels_tl
448: (label_code,
449: language,
450: label_description,
451: source_lang,

Line 554: FROM gr_labels_tl

550:
551: CURSOR c_lock_labels_tl
552: IS
553: SELECT *
554: FROM gr_labels_tl
555: WHERE rowid = p_rowid
556: FOR UPDATE NOWAIT;
557: LockLabelRcd c_lock_labels_tl%ROWTYPE;
558:

Line 693: DELETE FROM gr_labels_tl

689: IF l_return_status <> 'S' THEN
690: RAISE Check_Integrity_Error;
691: END IF;
692:
693: DELETE FROM gr_labels_tl
694: WHERE rowid = p_rowid;
695:
696: /* Check the commit flag and if set, then commit the work. */
697:

Line 778: DELETE FROM gr_labels_tl

774: x_oracle_error := 0;
775: x_msg_data := NULL;
776: l_msg_token := p_label_code;
777:
778: DELETE FROM gr_labels_tl
779: WHERE label_code = p_label_code;
780:
781: IF FND_API.To_Boolean(p_commit) THEN
782: COMMIT WORK;

Line 1011: FROM gr_labels_tl lat

1007:
1008: CURSOR c_get_labels_tl_rowid
1009: IS
1010: SELECT lat.rowid
1011: FROM gr_labels_tl lat
1012: WHERE lat.label_code = p_label_code
1013: AND lat.language = p_language;
1014: LabelTLRecord c_get_labels_tl_rowid%ROWTYPE;
1015:

Line 1053: UPDATE GR_LABELS_TL SET

1049: ,X_LABEL_DESCRIPTION IN VARCHAR2
1050: ,X_SOURCE_LANG IN VARCHAR2
1051: ) IS
1052: BEGIN
1053: UPDATE GR_LABELS_TL SET
1054: LABEL_DESCRIPTION = X_LABEL_DESCRIPTION,
1055: SOURCE_LANG = USERENV('LANG'),
1056: LAST_UPDATE_DATE = sysdate,
1057: LAST_UPDATED_BY = 0,

Line 1070: UPDATE GR_LABELS_TL SET

1066: ,X_LABEL_DESCRIPTION IN VARCHAR2
1067: ,X_OWNER IN VARCHAR2
1068: ) IS
1069: BEGIN
1070: UPDATE GR_LABELS_TL SET
1071: LABEL_DESCRIPTION = X_LABEL_DESCRIPTION,
1072: SOURCE_LANG = USERENV('LANG'),
1073: LAST_UPDATE_DATE = sysdate,
1074: LAST_UPDATED_BY = Decode(X_OWNER, 'SEED', 1, 0),

Line 1089: FROM GR_LABELS_TL

1085: ,X_SOURCE_LANG IN VARCHAR2
1086: ) IS
1087: CURSOR Cur_rowid IS
1088: SELECT rowid
1089: FROM GR_LABELS_TL
1090: WHERE (LABEL_CODE = X_LABEL_CODE)
1091: AND (LANGUAGE = X_LANGUAGE);
1092: l_user_id NUMBER DEFAULT 1;
1093: l_row_id VARCHAR2(64);

Line 1101: GR_LABELS_TL_PKG.UPDATE_ROW(

1097: BEGIN
1098: OPEN Cur_rowid;
1099: FETCH Cur_rowid INTO l_row_id;
1100: IF Cur_rowid%FOUND THEN
1101: GR_LABELS_TL_PKG.UPDATE_ROW(
1102: P_COMMIT => 'T'
1103: ,P_CALLED_BY_FORM => 'F'
1104: ,P_ROWID => l_row_id
1105: ,P_LABEL_CODE => X_LABEL_CODE

Line 1118: GR_LABELS_TL_PKG.INSERT_ROW(

1114: ,X_RETURN_STATUS => l_return_status
1115: ,X_ORACLE_ERROR => l_oracle_error
1116: ,X_MSG_DATA => l_msg_data);
1117: ELSE
1118: GR_LABELS_TL_PKG.INSERT_ROW(
1119: P_COMMIT => 'T'
1120: ,P_CALLED_BY_FORM => 'F'
1121: ,P_LABEL_CODE => X_LABEL_CODE
1122: ,P_LANGUAGE => X_LANGUAGE

Line 1146: FROM GR_LABELS_TL

1142: ,X_OWNER IN VARCHAR2
1143: ) IS
1144: CURSOR Cur_rowid IS
1145: SELECT rowid
1146: FROM GR_LABELS_TL
1147: WHERE (LABEL_CODE = X_LABEL_CODE)
1148: AND USERENV('LANG') in (LANGUAGE,SOURCE_LANG);
1149:
1150: l_user_id NUMBER DEFAULT 0;

Line 1166: UPDATE GR_LABELS_TL SET

1162:
1163: OPEN Cur_rowid;
1164: FETCH Cur_rowid INTO l_row_id;
1165: IF Cur_rowid%FOUND THEN
1166: UPDATE GR_LABELS_TL SET
1167: LABEL_DESCRIPTION = X_LABEL_DESCRIPTION,
1168: LAST_UPDATE_DATE = l_sysdate,
1169: LAST_UPDATED_BY = l_user_id,
1170: LAST_UPDATE_LOGIN = 0,

Line 1176: insert into GR_LABELS_TL (

1172: WHERE (LABEL_CODE = X_LABEL_CODE)
1173: AND userenv('LANG') in (LANGUAGE,SOURCE_LANG);
1174:
1175: ELSE
1176: insert into GR_LABELS_TL (
1177: LABEL_CODE,
1178: LABEL_DESCRIPTION,
1179: CREATED_BY,
1180: CREATION_DATE,

Line 1200: from GR_LABELS_TL T

1196: from FND_LANGUAGES L
1197: where L.INSTALLED_FLAG in ('I', 'B')
1198: and not exists
1199: (select NULL
1200: from GR_LABELS_TL T
1201: where T.LABEL_CODE = X_LABEL_CODE
1202: and T.LANGUAGE = L.LANGUAGE_CODE);
1203: END IF;
1204: CLOSE Cur_rowid;

Line 1216: delete from GR_LABELS_TL T

1212: */
1213: procedure NEW_LANGUAGE
1214: is
1215: begin
1216: delete from GR_LABELS_TL T
1217: where not exists
1218: (select NULL
1219: from GR_LABELS_B B
1220: where B.LABEL_CODE = T.LABEL_CODE

Line 1223: update GR_LABELS_TL T set (

1219: from GR_LABELS_B B
1220: where B.LABEL_CODE = T.LABEL_CODE
1221: );
1222:
1223: update GR_LABELS_TL T set (
1224: LABEL_DESCRIPTION
1225: ) = (select
1226: B.LABEL_DESCRIPTION
1227: from GR_LABELS_TL B

Line 1227: from GR_LABELS_TL B

1223: update GR_LABELS_TL T set (
1224: LABEL_DESCRIPTION
1225: ) = (select
1226: B.LABEL_DESCRIPTION
1227: from GR_LABELS_TL B
1228: where B.LABEL_CODE = T.LABEL_CODE
1229: and B.LANGUAGE = T.SOURCE_LANG)
1230: where (
1231: T.LABEL_CODE,

Line 1236: from GR_LABELS_TL SUBB, GR_LABELS_TL SUBT

1232: T.LANGUAGE
1233: ) in (select
1234: SUBT.LABEL_CODE,
1235: SUBT.LANGUAGE
1236: from GR_LABELS_TL SUBB, GR_LABELS_TL SUBT
1237: where SUBB.LABEL_CODE = SUBT.LABEL_CODE
1238: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1239: and (SUBB.LABEL_DESCRIPTION <> SUBT.LABEL_DESCRIPTION
1240: ));

Line 1242: insert into GR_LABELS_TL (

1238: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1239: and (SUBB.LABEL_DESCRIPTION <> SUBT.LABEL_DESCRIPTION
1240: ));
1241:
1242: insert into GR_LABELS_TL (
1243: LABEL_CODE,
1244: LABEL_DESCRIPTION,
1245: CREATED_BY,
1246: CREATION_DATE,

Line 1262: from GR_LABELS_TL B, FND_LANGUAGES L

1258: B.LAST_UPDATE_DATE,
1259: B.LAST_UPDATE_LOGIN,
1260: L.LANGUAGE_CODE,
1261: B.SOURCE_LANG
1262: from GR_LABELS_TL B, FND_LANGUAGES L
1263: where L.INSTALLED_FLAG in ('I', 'B')
1264: and B.LANGUAGE = userenv('LANG')
1265: and not exists
1266: (select NULL

Line 1267: from GR_LABELS_TL T

1263: where L.INSTALLED_FLAG in ('I', 'B')
1264: and B.LANGUAGE = userenv('LANG')
1265: and not exists
1266: (select NULL
1267: from GR_LABELS_TL T
1268: where T.LABEL_CODE = B.LABEL_CODE
1269: and T.LANGUAGE = L.LANGUAGE_CODE);
1270:
1271: end NEW_LANGUAGE;

Line 1275: END GR_LABELS_TL_PKG;

1271: end NEW_LANGUAGE;
1272:
1273:
1274:
1275: END GR_LABELS_TL_PKG;