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_SAFETY_PHRASES_TL_PKG dependencies on GR_SAFETY_PHRASES_TL

Line 1: PACKAGE BODY GR_SAFETY_PHRASES_TL_PKG AS

1: PACKAGE BODY GR_SAFETY_PHRASES_TL_PKG AS
2: /*$Header: GRHISPTB.pls 120.1 2006/06/16 21:41:50 pbamb noship $*/
3: PROCEDURE Insert_Row
4: (p_commit IN VARCHAR2,
5: p_called_by_form IN VARCHAR2,

Line 76: INSERT INTO gr_safety_phrases_tl

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

Line 243: UPDATE gr_safety_phrases_tl

239:
240: IF l_return_status <> 'S' THEN
241: RAISE Foreign_Key_Error;
242: ELSE
243: UPDATE gr_safety_phrases_tl
244: SET safety_phrase_code = p_safety_phrase_code,
245: language = p_language,
246: source_lang = p_source_language,
247: safety_phrase_description = p_safety_phrase_description,

Line 357: FROM gr_safety_phrases_tl spt

353: spt.creation_date,
354: spt.last_updated_by,
355: spt.last_update_date,
356: spt.last_update_login
357: FROM gr_safety_phrases_tl spt
358: WHERE spt.safety_phrase_code = p_safety_phrase_code
359: AND spt.language = l_language;
360: PhraseDesc c_get_descs%ROWTYPE;
361:

Line 382: delete from GR_SAFETY_PHRASES_TL T

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

Line 391: update gr_safety_phrases_tl t set (

387: );
388:
389: /* Redefault translations from the source language */
390:
391: update gr_safety_phrases_tl t set (
392: safety_phrase_description ) =
393: ( select
394: B.SAFETY_PHRASE_DESCRIPTION
395: from GR_SAFETY_PHRASES_TL B

Line 395: from GR_SAFETY_PHRASES_TL B

391: update gr_safety_phrases_tl t set (
392: safety_phrase_description ) =
393: ( select
394: B.SAFETY_PHRASE_DESCRIPTION
395: from GR_SAFETY_PHRASES_TL B
396: where B.SAFETY_PHRASE_CODE = T.SAFETY_PHRASE_CODE
397: and B.LANGUAGE = T.SOURCE_LANG)
398: where (
399: T.SAFETY_PHRASE_CODE,

Line 404: from GR_SAFETY_PHRASES_TL SUBB, GR_SAFETY_PHRASES_TL SUBT

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

Line 448: INSERT INTO gr_safety_phrases_tl

444: OPEN c_get_descs;
445: FETCH c_get_descs INTO PhraseDesc;
446: IF c_get_descs%NOTFOUND THEN
447: CLOSE c_get_descs;
448: INSERT INTO gr_safety_phrases_tl
449: (safety_phrase_code,
450: language,
451: source_lang,
452: safety_phrase_description,

Line 554: FROM gr_safety_phrases_tl

550:
551: CURSOR c_lock_safety_tl
552: IS
553: SELECT last_update_date
554: FROM gr_safety_phrases_tl
555: WHERE rowid = p_rowid
556: FOR UPDATE NOWAIT;
557: LockSafetyRcd c_lock_safety_tl%ROWTYPE;
558: BEGIN

Line 705: DELETE FROM gr_safety_phrases_tl

701: IF l_return_status <> 'S' THEN
702: RAISE Check_Integrity_Error;
703: END IF;
704:
705: DELETE FROM gr_safety_phrases_tl
706: WHERE rowid = p_rowid;
707:
708: /* Check the commit flag and if set, then commit the work. */
709:

Line 791: DELETE FROM gr_safety_phrases_tl

787: x_oracle_error := 0;
788: x_msg_data := NULL;
789: l_msg_token := p_safety_phrase_code;
790:
791: DELETE FROM gr_safety_phrases_tl
792: WHERE safety_phrase_code = p_safety_phrase_code;
793:
794: IF FND_API.To_Boolean(p_commit) THEN
795: COMMIT WORK;

Line 1023: FROM gr_safety_phrases_tl spt

1019:
1020: CURSOR c_get_safety_tl_rowid
1021: IS
1022: SELECT spt.rowid
1023: FROM gr_safety_phrases_tl spt
1024: WHERE spt.safety_phrase_code = p_safety_phrase_code
1025: AND spt.language = p_language;
1026: SafetyTLRecord c_get_safety_tl_rowid%ROWTYPE;
1027:

Line 1065: UPDATE GR_SAFETY_PHRASES_TL SET

1061: ,X_SOURCE_LANG IN VARCHAR2
1062: ,X_SAFETY_PHRASE_DESCRIPTION IN VARCHAR2
1063: ) IS
1064: BEGIN
1065: UPDATE GR_SAFETY_PHRASES_TL SET
1066: SAFETY_PHRASE_DESCRIPTION = X_SAFETY_PHRASE_DESCRIPTION,
1067: SOURCE_LANG = USERENV('LANG'),
1068: LAST_UPDATE_DATE = sysdate,
1069: LAST_UPDATED_BY = 0,

Line 1082: UPDATE GR_SAFETY_PHRASES_TL SET

1078: ,X_SAFETY_PHRASE_DESCRIPTION IN VARCHAR2
1079: ,X_OWNER IN VARCHAR2
1080: ) IS
1081: BEGIN
1082: UPDATE GR_SAFETY_PHRASES_TL SET
1083: SAFETY_PHRASE_DESCRIPTION = X_SAFETY_PHRASE_DESCRIPTION,
1084: SOURCE_LANG = USERENV('LANG'),
1085: LAST_UPDATE_DATE = sysdate,
1086: LAST_UPDATED_BY = Decode(X_OWNER, 'SEED', 1, 0),

Line 1100: FROM GR_SAFETY_PHRASES_TL

1096: ,X_SAFETY_PHRASE_DESCRIPTION IN VARCHAR2
1097: ) IS
1098: CURSOR Cur_rowid IS
1099: SELECT rowid
1100: FROM GR_SAFETY_PHRASES_TL
1101: WHERE (SAFETY_PHRASE_CODE = X_SAFETY_PHRASE_CODE)
1102: AND (LANGUAGE = X_LANGUAGE);
1103: l_user_id NUMBER DEFAULT 1;
1104: l_row_id VARCHAR2(64);

Line 1112: GR_SAFETY_PHRASES_TL_PKG.UPDATE_ROW(

1108: BEGIN
1109: OPEN Cur_rowid;
1110: FETCH Cur_rowid INTO l_row_id;
1111: IF Cur_rowid%FOUND THEN
1112: GR_SAFETY_PHRASES_TL_PKG.UPDATE_ROW(
1113: P_COMMIT => 'T'
1114: ,P_CALLED_BY_FORM => 'F'
1115: ,P_ROWID => l_row_id
1116: ,P_SAFETY_PHRASE_CODE => X_SAFETY_PHRASE_CODE

Line 1129: GR_SAFETY_PHRASES_TL_PKG.INSERT_ROW(

1125: ,X_RETURN_STATUS => l_return_status
1126: ,X_ORACLE_ERROR => l_oracle_error
1127: ,X_MSG_DATA => l_msg_data);
1128: ELSE
1129: GR_SAFETY_PHRASES_TL_PKG.INSERT_ROW(
1130: P_COMMIT => 'T'
1131: ,P_CALLED_BY_FORM => 'F'
1132: ,P_SAFETY_PHRASE_CODE => X_SAFETY_PHRASE_CODE
1133: ,P_LANGUAGE => X_LANGUAGE

Line 1157: FROM GR_SAFETY_PHRASES_TL

1153: ,X_OWNER IN VARCHAR2
1154: ) IS
1155: CURSOR Cur_rowid IS
1156: SELECT rowid
1157: FROM GR_SAFETY_PHRASES_TL
1158: WHERE (SAFETY_PHRASE_CODE = X_SAFETY_PHRASE_CODE)
1159: AND USERENV('LANG') in (LANGUAGE,SOURCE_LANG);
1160: l_user_id NUMBER DEFAULT 0;
1161: l_row_id VARCHAR2(64);

Line 1176: UPDATE GR_SAFETY_PHRASES_TL SET

1172:
1173: OPEN Cur_rowid;
1174: FETCH Cur_rowid INTO l_row_id;
1175: IF Cur_rowid%FOUND THEN
1176: UPDATE GR_SAFETY_PHRASES_TL SET
1177: SAFETY_PHRASE_DESCRIPTION = X_SAFETY_PHRASE_DESCRIPTION,
1178: LAST_UPDATE_DATE = l_sysdate,
1179: LAST_UPDATED_BY = l_user_id,
1180: LAST_UPDATE_LOGIN = 0,

Line 1185: insert into GR_SAFETY_PHRASES_TL (

1181: SOURCE_LANG = userenv('LANG')
1182: WHERE (SAFETY_PHRASE_CODE = X_SAFETY_PHRASE_CODE)
1183: AND userenv('LANG') in (LANGUAGE,SOURCE_LANG);
1184: ELSE
1185: insert into GR_SAFETY_PHRASES_TL (
1186: SAFETY_PHRASE_CODE,
1187: SAFETY_PHRASE_DESCRIPTION,
1188: CREATED_BY,
1189: CREATION_DATE,

Line 1209: from GR_SAFETY_PHRASES_TL T

1205: from FND_LANGUAGES L
1206: where L.INSTALLED_FLAG in ('I', 'B')
1207: and not exists
1208: (select NULL
1209: from GR_SAFETY_PHRASES_TL T
1210: where T.SAFETY_PHRASE_CODE = X_SAFETY_PHRASE_CODE
1211: and T.LANGUAGE = L.LANGUAGE_CODE);
1212: END IF;
1213: CLOSE Cur_rowid;

Line 1223: delete from GR_SAFETY_PHRASES_TL T

1219: */
1220: procedure NEW_LANGUAGE
1221: is
1222: begin
1223: delete from GR_SAFETY_PHRASES_TL T
1224: where not exists
1225: (select NULL
1226: from GR_SAFETY_PHRASES_B B
1227: where B.SAFETY_PHRASE_CODE = T.SAFETY_PHRASE_CODE

Line 1230: update GR_SAFETY_PHRASES_TL T set (

1226: from GR_SAFETY_PHRASES_B B
1227: where B.SAFETY_PHRASE_CODE = T.SAFETY_PHRASE_CODE
1228: );
1229:
1230: update GR_SAFETY_PHRASES_TL T set (
1231: SAFETY_PHRASE_DESCRIPTION
1232: ) = (select
1233: B.SAFETY_PHRASE_DESCRIPTION
1234: from GR_SAFETY_PHRASES_TL B

Line 1234: from GR_SAFETY_PHRASES_TL B

1230: update GR_SAFETY_PHRASES_TL T set (
1231: SAFETY_PHRASE_DESCRIPTION
1232: ) = (select
1233: B.SAFETY_PHRASE_DESCRIPTION
1234: from GR_SAFETY_PHRASES_TL B
1235: where B.SAFETY_PHRASE_CODE = T.SAFETY_PHRASE_CODE
1236: and B.LANGUAGE = T.SOURCE_LANG)
1237: where (
1238: T.SAFETY_PHRASE_CODE,

Line 1243: from GR_SAFETY_PHRASES_TL SUBB, GR_SAFETY_PHRASES_TL SUBT

1239: T.LANGUAGE
1240: ) in (select
1241: SUBT.SAFETY_PHRASE_CODE,
1242: SUBT.LANGUAGE
1243: from GR_SAFETY_PHRASES_TL SUBB, GR_SAFETY_PHRASES_TL SUBT
1244: where SUBB.SAFETY_PHRASE_CODE = SUBT.SAFETY_PHRASE_CODE
1245: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1246: and (SUBB.SAFETY_PHRASE_DESCRIPTION <> SUBT.SAFETY_PHRASE_DESCRIPTION
1247: ));

Line 1249: insert into GR_SAFETY_PHRASES_TL (

1245: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1246: and (SUBB.SAFETY_PHRASE_DESCRIPTION <> SUBT.SAFETY_PHRASE_DESCRIPTION
1247: ));
1248:
1249: insert into GR_SAFETY_PHRASES_TL (
1250: SAFETY_PHRASE_CODE,
1251: SAFETY_PHRASE_DESCRIPTION,
1252: CREATED_BY,
1253: CREATION_DATE,

Line 1269: from GR_SAFETY_PHRASES_TL B, FND_LANGUAGES L

1265: B.LAST_UPDATE_DATE,
1266: B.LAST_UPDATE_LOGIN,
1267: L.LANGUAGE_CODE,
1268: B.SOURCE_LANG
1269: from GR_SAFETY_PHRASES_TL B, FND_LANGUAGES L
1270: where L.INSTALLED_FLAG in ('I', 'B')
1271: and B.LANGUAGE = userenv('LANG')
1272: and not exists
1273: (select NULL

Line 1274: from GR_SAFETY_PHRASES_TL T

1270: where L.INSTALLED_FLAG in ('I', 'B')
1271: and B.LANGUAGE = userenv('LANG')
1272: and not exists
1273: (select NULL
1274: from GR_SAFETY_PHRASES_TL T
1275: where T.SAFETY_PHRASE_CODE = B.SAFETY_PHRASE_CODE
1276: and T.LANGUAGE = L.LANGUAGE_CODE);
1277:
1278: end NEW_LANGUAGE;

Line 1281: END GR_SAFETY_PHRASES_TL_PKG;

1277:
1278: end NEW_LANGUAGE;
1279:
1280:
1281: END GR_SAFETY_PHRASES_TL_PKG;