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.CLN_NOTIFICATION_CODES_PKG dependencies on CLN_NOTIFICATION_CODES_TL

Line 40: insert into CLN_NOTIFICATION_CODES_TL (

36: X_LAST_UPDATED_BY,
37: X_LAST_UPDATE_LOGIN
38: );
39:
40: insert into CLN_NOTIFICATION_CODES_TL (
41: NOTIFICATION_ID,
42: NOTIFICATION_MESSAGE,
43: CREATION_DATE,
44: CREATED_BY,

Line 64: from CLN_NOTIFICATION_CODES_TL T

60: from FND_LANGUAGES L
61: where L.INSTALLED_FLAG in ('I', 'B')
62: and not exists
63: (select NULL
64: from CLN_NOTIFICATION_CODES_TL T
65: where T.NOTIFICATION_ID = X_NOTIFICATION_ID
66: and T.LANGUAGE = L.LANGUAGE_CODE);
67:
68: open c;

Line 95: from CLN_NOTIFICATION_CODES_TL

91:
92: cursor c1 is select
93: NOTIFICATION_MESSAGE,
94: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
95: from CLN_NOTIFICATION_CODES_TL
96: where NOTIFICATION_ID = X_NOTIFICATION_ID
97: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
98: for update of NOTIFICATION_ID nowait;
99: begin

Line 156: update CLN_NOTIFICATION_CODES_TL set

152: if (sql%notfound) then
153: raise no_data_found;
154: end if;
155:
156: update CLN_NOTIFICATION_CODES_TL set
157: NOTIFICATION_MESSAGE = X_NOTIFICATION_MESSAGE,
158: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
159: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
160: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 174: delete from CLN_NOTIFICATION_CODES_TL

170: procedure DELETE_ROW (
171: X_NOTIFICATION_ID in NUMBER
172: ) is
173: begin
174: delete from CLN_NOTIFICATION_CODES_TL
175: where NOTIFICATION_ID = X_NOTIFICATION_ID;
176:
177: if (sql%notfound) then
178: raise no_data_found;

Line 192: delete from CLN_NOTIFICATION_CODES_TL T

188:
189: procedure ADD_LANGUAGE
190: is
191: begin
192: delete from CLN_NOTIFICATION_CODES_TL T
193: where not exists
194: (select NULL
195: from CLN_NOTIFICATION_CODES_B B
196: where B.NOTIFICATION_ID = T.NOTIFICATION_ID

Line 199: update CLN_NOTIFICATION_CODES_TL T set (

195: from CLN_NOTIFICATION_CODES_B B
196: where B.NOTIFICATION_ID = T.NOTIFICATION_ID
197: );
198:
199: update CLN_NOTIFICATION_CODES_TL T set (
200: NOTIFICATION_MESSAGE
201: ) = (select
202: B.NOTIFICATION_MESSAGE
203: from CLN_NOTIFICATION_CODES_TL B

Line 203: from CLN_NOTIFICATION_CODES_TL B

199: update CLN_NOTIFICATION_CODES_TL T set (
200: NOTIFICATION_MESSAGE
201: ) = (select
202: B.NOTIFICATION_MESSAGE
203: from CLN_NOTIFICATION_CODES_TL B
204: where B.NOTIFICATION_ID = T.NOTIFICATION_ID
205: and B.LANGUAGE = T.SOURCE_LANG)
206: where (
207: T.NOTIFICATION_ID,

Line 212: from CLN_NOTIFICATION_CODES_TL SUBB, CLN_NOTIFICATION_CODES_TL SUBT

208: T.LANGUAGE
209: ) in (select
210: SUBT.NOTIFICATION_ID,
211: SUBT.LANGUAGE
212: from CLN_NOTIFICATION_CODES_TL SUBB, CLN_NOTIFICATION_CODES_TL SUBT
213: where SUBB.NOTIFICATION_ID = SUBT.NOTIFICATION_ID
214: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
215: and (SUBB.NOTIFICATION_MESSAGE <> SUBT.NOTIFICATION_MESSAGE
216: or (SUBB.NOTIFICATION_MESSAGE is null and SUBT.NOTIFICATION_MESSAGE is not null)

Line 220: insert into CLN_NOTIFICATION_CODES_TL (

216: or (SUBB.NOTIFICATION_MESSAGE is null and SUBT.NOTIFICATION_MESSAGE is not null)
217: or (SUBB.NOTIFICATION_MESSAGE is not null and SUBT.NOTIFICATION_MESSAGE is null)
218: ));
219:
220: insert into CLN_NOTIFICATION_CODES_TL (
221: NOTIFICATION_ID,
222: NOTIFICATION_MESSAGE,
223: CREATION_DATE,
224: CREATED_BY,

Line 240: from CLN_NOTIFICATION_CODES_TL B, FND_LANGUAGES L

236: B.LAST_UPDATED_BY,
237: B.LAST_UPDATE_LOGIN,
238: L.LANGUAGE_CODE,
239: B.SOURCE_LANG
240: from CLN_NOTIFICATION_CODES_TL B, FND_LANGUAGES L
241: where L.INSTALLED_FLAG in ('I', 'B')
242: and B.LANGUAGE = userenv('LANG')
243: and not exists
244: (select NULL

Line 245: from CLN_NOTIFICATION_CODES_TL T

241: where L.INSTALLED_FLAG in ('I', 'B')
242: and B.LANGUAGE = userenv('LANG')
243: and not exists
244: (select NULL
245: from CLN_NOTIFICATION_CODES_TL T
246: where T.NOTIFICATION_ID = B.NOTIFICATION_ID
247: and T.LANGUAGE = L.LANGUAGE_CODE);
248: end ADD_LANGUAGE;
249:

Line 260: UPDATE CLN_NOTIFICATION_CODES_TL SET

256: X_OWNER IN VARCHAR2 ,
257: X_NOTIFICATION_MESSAGE IN VARCHAR2
258: ) IS
259: BEGIN
260: UPDATE CLN_NOTIFICATION_CODES_TL SET
261: NOTIFICATION_MESSAGE = X_NOTIFICATION_MESSAGE,
262: LAST_UPDATE_DATE = sysdate,
263: LAST_UPDATED_BY = Decode(x_owner, 'SEED', 1, 0),
264: LAST_UPDATE_LOGIN = 0,

Line 329: insert into CLN_NOTIFICATION_CODES_TL (

325: l_user_id,
326: 0
327: );
328:
329: insert into CLN_NOTIFICATION_CODES_TL (
330: NOTIFICATION_ID,
331: NOTIFICATION_MESSAGE,
332: CREATION_DATE,
333: CREATED_BY,

Line 353: from CLN_NOTIFICATION_CODES_TL T

349: from FND_LANGUAGES L
350: where L.INSTALLED_FLAG in ('I', 'B')
351: and not exists
352: (select NULL
353: from CLN_NOTIFICATION_CODES_TL T
354: where T.NOTIFICATION_ID = l_notification_id
355: and T.LANGUAGE = L.LANGUAGE_CODE);
356:
357: RETURN;

Line 361: update CLN_NOTIFICATION_CODES_TL set

357: RETURN;
358:
359: END;
360:
361: update CLN_NOTIFICATION_CODES_TL set
362: NOTIFICATION_MESSAGE = X_NOTIFICATION_MESSAGE,
363: LAST_UPDATE_DATE = l_sysdate,
364: LAST_UPDATED_BY = l_user_id,
365: LAST_UPDATE_LOGIN = 0,