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_RISK_PHRASES_TL_PKG dependencies on GR_RISK_PHRASES_TL

Line 1: PACKAGE BODY GR_RISK_PHRASES_TL_PKG AS

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

Line 76: INSERT INTO gr_risk_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_risk_phrases_tl
77: (risk_phrase_code,
78: language,
79: source_lang,
80: risk_description,

Line 243: UPDATE gr_risk_phrases_tl

239:
240: IF l_return_status <> 'S' THEN
241: RAISE Foreign_Key_Error;
242: ELSE
243: UPDATE gr_risk_phrases_tl
244: SET risk_phrase_code = p_risk_phrase_code,
245: language = p_language,
246: source_lang = p_source_language,
247: risk_description = p_risk_description,

Line 357: FROM gr_risk_phrases_tl rpt

353: rpt.creation_date,
354: rpt.last_updated_by,
355: rpt.last_update_date,
356: rpt.last_update_login
357: FROM gr_risk_phrases_tl rpt
358: WHERE rpt.risk_phrase_code = p_risk_phrase_code
359: AND rpt.language = l_language;
360: PhraseDesc c_get_descs%ROWTYPE;
361:

Line 382: delete from GR_RISK_PHRASES_TL T

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

Line 391: update gr_risk_phrases_tl t set (

387: );
388:
389: /* Redefault translations from the source language */
390:
391: update gr_risk_phrases_tl t set (
392: risk_description ) =
393: ( select
394: B.RISK_DESCRIPTION
395: from GR_RISK_PHRASES_TL B

Line 395: from GR_RISK_PHRASES_TL B

391: update gr_risk_phrases_tl t set (
392: risk_description ) =
393: ( select
394: B.RISK_DESCRIPTION
395: from GR_RISK_PHRASES_TL B
396: where B.RISK_PHRASE_CODE = T.RISK_PHRASE_CODE
397: and B.LANGUAGE = T.SOURCE_LANG)
398: where (
399: T.RISK_PHRASE_CODE,

Line 404: from GR_RISK_PHRASES_TL SUBB, GR_RISK_PHRASES_TL SUBT

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

Line 446: INSERT INTO gr_risk_phrases_tl

442: OPEN c_get_descs;
443: FETCH c_get_descs INTO PhraseDesc;
444: IF c_get_descs%NOTFOUND THEN
445: CLOSE c_get_descs;
446: INSERT INTO gr_risk_phrases_tl
447: (risk_phrase_code,
448: language,
449: source_lang,
450: risk_description,

Line 553: FROM gr_risk_phrases_tl

549:
550: CURSOR c_lock_risk_tl
551: IS
552: SELECT last_update_date
553: FROM gr_risk_phrases_tl
554: WHERE rowid = p_rowid
555: FOR UPDATE NOWAIT;
556: LockRiskRcd c_lock_risk_tl%ROWTYPE;
557: BEGIN

Line 704: DELETE FROM gr_risk_phrases_tl

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

Line 788: DELETE FROM gr_risk_phrases_tl

784: x_oracle_error := 0;
785: x_msg_data := NULL;
786: l_msg_token := p_risk_phrase_code;
787:
788: DELETE FROM gr_risk_phrases_tl
789: WHERE risk_phrase_code = p_risk_phrase_code;
790:
791: IF FND_API.To_Boolean(p_commit) THEN
792: COMMIT WORK;

Line 1011: FROM gr_risk_phrases_tl rpt

1007:
1008: CURSOR c_get_risk_tl_rowid
1009: IS
1010: SELECT rpt.rowid
1011: FROM gr_risk_phrases_tl rpt
1012: WHERE rpt.risk_phrase_code = p_risk_phrase_code
1013: AND rpt.language = p_language;
1014: RiskTLRecord c_get_risk_tl_rowid%ROWTYPE;
1015:

Line 1053: UPDATE GR_RISK_PHRASES_TL SET

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

Line 1069: UPDATE GR_RISK_PHRASES_TL SET

1065: ,X_RISK_DESCRIPTION IN VARCHAR2
1066: ,X_OWNER IN VARCHAR2
1067: ) IS
1068: BEGIN
1069: UPDATE GR_RISK_PHRASES_TL SET
1070: RISK_DESCRIPTION = X_RISK_DESCRIPTION,
1071: SOURCE_LANG = USERENV('LANG'),
1072: LAST_UPDATE_DATE = sysdate,
1073: LAST_UPDATED_BY = Decode(X_OWNER, 'SEED', 1, 0),

Line 1088: FROM GR_RISK_PHRASES_TL

1084: ,X_RISK_DESCRIPTION IN VARCHAR2
1085: ) IS
1086: CURSOR Cur_rowid IS
1087: SELECT rowid
1088: FROM GR_RISK_PHRASES_TL
1089: WHERE (RISK_PHRASE_CODE = X_RISK_PHRASE_CODE)
1090: AND (LANGUAGE = X_LANGUAGE);
1091: l_user_id NUMBER DEFAULT 1;
1092: l_row_id VARCHAR2(64);

Line 1100: GR_RISK_PHRASES_TL_PKG.UPDATE_ROW(

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

Line 1117: GR_RISK_PHRASES_TL_PKG.INSERT_ROW(

1113: ,X_RETURN_STATUS => l_return_status
1114: ,X_ORACLE_ERROR => l_oracle_error
1115: ,X_MSG_DATA => l_msg_data);
1116: ELSE
1117: GR_RISK_PHRASES_TL_PKG.INSERT_ROW(
1118: P_COMMIT => 'T'
1119: ,P_CALLED_BY_FORM => 'F'
1120: ,P_RISK_PHRASE_CODE => X_RISK_PHRASE_CODE
1121: ,P_LANGUAGE => X_LANGUAGE

Line 1144: FROM GR_RISK_PHRASES_TL

1140: ,X_OWNER IN VARCHAR2
1141: ) IS
1142: CURSOR Cur_rowid IS
1143: SELECT rowid
1144: FROM GR_RISK_PHRASES_TL
1145: WHERE (RISK_PHRASE_CODE = X_RISK_PHRASE_CODE)
1146: AND USERENV('LANG') in (LANGUAGE,SOURCE_LANG);
1147: l_user_id NUMBER DEFAULT 0;
1148: l_row_id VARCHAR2(64);

Line 1163: UPDATE GR_RISK_PHRASES_TL SET

1159:
1160: OPEN Cur_rowid;
1161: FETCH Cur_rowid INTO l_row_id;
1162: IF Cur_rowid%FOUND THEN
1163: UPDATE GR_RISK_PHRASES_TL SET
1164: RISK_DESCRIPTION = X_RISK_DESCRIPTION,
1165: SOURCE_LANG = USERENV('LANG'),
1166: LAST_UPDATE_DATE = l_sysdate,
1167: LAST_UPDATED_BY = l_user_id,

Line 1172: insert into GR_RISK_PHRASES_TL (

1168: LAST_UPDATE_LOGIN = 0
1169: WHERE (RISK_PHRASE_CODE = X_RISK_PHRASE_CODE)
1170: AND (USERENV('LANG') IN (LANGUAGE, SOURCE_LANG));
1171: ELSE
1172: insert into GR_RISK_PHRASES_TL (
1173: RISK_PHRASE_CODE,
1174: RISK_DESCRIPTION,
1175: CREATED_BY,
1176: CREATION_DATE,

Line 1196: from GR_RISK_PHRASES_TL T

1192: from FND_LANGUAGES L
1193: where L.INSTALLED_FLAG in ('I', 'B')
1194: and not exists
1195: (select NULL
1196: from GR_RISK_PHRASES_TL T
1197: where T.RISK_PHRASE_CODE = X_RISK_PHRASE_CODE
1198: and T.LANGUAGE = L.LANGUAGE_CODE);
1199: END IF;
1200: CLOSE Cur_rowid;

Line 1210: delete from GR_RISK_PHRASES_TL T

1206: */
1207: procedure NEW_LANGUAGE
1208: is
1209: begin
1210: delete from GR_RISK_PHRASES_TL T
1211: where not exists
1212: (select NULL
1213: from GR_RISK_PHRASES_B B
1214: where B.RISK_PHRASE_CODE = T.RISK_PHRASE_CODE

Line 1217: update GR_RISK_PHRASES_TL T set (

1213: from GR_RISK_PHRASES_B B
1214: where B.RISK_PHRASE_CODE = T.RISK_PHRASE_CODE
1215: );
1216:
1217: update GR_RISK_PHRASES_TL T set (
1218: RISK_DESCRIPTION
1219: ) = (select
1220: B.RISK_DESCRIPTION
1221: from GR_RISK_PHRASES_TL B

Line 1221: from GR_RISK_PHRASES_TL B

1217: update GR_RISK_PHRASES_TL T set (
1218: RISK_DESCRIPTION
1219: ) = (select
1220: B.RISK_DESCRIPTION
1221: from GR_RISK_PHRASES_TL B
1222: where B.RISK_PHRASE_CODE = T.RISK_PHRASE_CODE
1223: and B.LANGUAGE = T.SOURCE_LANG)
1224: where (
1225: T.RISK_PHRASE_CODE,

Line 1230: from GR_RISK_PHRASES_TL SUBB, GR_RISK_PHRASES_TL SUBT

1226: T.LANGUAGE
1227: ) in (select
1228: SUBT.RISK_PHRASE_CODE,
1229: SUBT.LANGUAGE
1230: from GR_RISK_PHRASES_TL SUBB, GR_RISK_PHRASES_TL SUBT
1231: where SUBB.RISK_PHRASE_CODE = SUBT.RISK_PHRASE_CODE
1232: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1233: and (SUBB.RISK_DESCRIPTION <> SUBT.RISK_DESCRIPTION
1234: ));

Line 1236: insert into GR_RISK_PHRASES_TL (

1232: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
1233: and (SUBB.RISK_DESCRIPTION <> SUBT.RISK_DESCRIPTION
1234: ));
1235:
1236: insert into GR_RISK_PHRASES_TL (
1237: RISK_PHRASE_CODE,
1238: RISK_DESCRIPTION,
1239: CREATED_BY,
1240: CREATION_DATE,

Line 1256: from GR_RISK_PHRASES_TL B, FND_LANGUAGES L

1252: B.LAST_UPDATE_DATE,
1253: B.LAST_UPDATE_LOGIN,
1254: L.LANGUAGE_CODE,
1255: B.SOURCE_LANG
1256: from GR_RISK_PHRASES_TL B, FND_LANGUAGES L
1257: where L.INSTALLED_FLAG in ('I', 'B')
1258: and B.LANGUAGE = userenv('LANG')
1259: and not exists
1260: (select NULL

Line 1261: from GR_RISK_PHRASES_TL T

1257: where L.INSTALLED_FLAG in ('I', 'B')
1258: and B.LANGUAGE = userenv('LANG')
1259: and not exists
1260: (select NULL
1261: from GR_RISK_PHRASES_TL T
1262: where T.RISK_PHRASE_CODE = B.RISK_PHRASE_CODE
1263: and T.LANGUAGE = L.LANGUAGE_CODE);
1264:
1265: end NEW_LANGUAGE;

Line 1269: END GR_RISK_PHRASES_TL_PKG;

1265: end NEW_LANGUAGE;
1266:
1267:
1268:
1269: END GR_RISK_PHRASES_TL_PKG;