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.FND_CONC_RELEASE_CLASSES_PKG dependencies on FND_CONC_RELEASE_CLASSES

Line 1: package body FND_CONC_RELEASE_CLASSES_PKG as

1: package body FND_CONC_RELEASE_CLASSES_PKG as
2: /* $Header: AFCPSC1B.pls 120.2 2005/08/19 20:49:41 jtoruno ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 21: cursor C is select ROWID from FND_CONC_RELEASE_CLASSES

17: X_LAST_UPDATE_DATE in DATE,
18: X_LAST_UPDATED_BY in NUMBER,
19: X_LAST_UPDATE_LOGIN in NUMBER
20: ) is
21: cursor C is select ROWID from FND_CONC_RELEASE_CLASSES
22: where RELEASE_CLASS_ID = X_RELEASE_CLASS_ID
23: and APPLICATION_ID = X_APPLICATION_ID
24: ;
25: begin

Line 26: insert into FND_CONC_RELEASE_CLASSES (

22: where RELEASE_CLASS_ID = X_RELEASE_CLASS_ID
23: and APPLICATION_ID = X_APPLICATION_ID
24: ;
25: begin
26: insert into FND_CONC_RELEASE_CLASSES (
27: APPLICATION_ID,
28: RELEASE_CLASS_ID,
29: RELEASE_CLASS_NAME,
30: ENABLED_FLAG,

Line 54: insert into FND_CONC_RELEASE_CLASSES_TL (

50: X_LAST_UPDATED_BY,
51: X_LAST_UPDATE_LOGIN
52: );
53:
54: insert into FND_CONC_RELEASE_CLASSES_TL (
55: APPLICATION_ID,
56: RELEASE_CLASS_ID,
57: USER_RELEASE_CLASS_NAME,
58: DESCRIPTION,

Line 82: from FND_CONC_RELEASE_CLASSES_TL T

78: from FND_LANGUAGES L
79: where L.INSTALLED_FLAG in ('I', 'B')
80: and not exists
81: (select NULL
82: from FND_CONC_RELEASE_CLASSES_TL T
83: where T.RELEASE_CLASS_ID = X_RELEASE_CLASS_ID
84: and T.APPLICATION_ID = X_APPLICATION_ID
85: and T.LANGUAGE = L.LANGUAGE_CODE);
86:

Line 114: from FND_CONC_RELEASE_CLASSES

110: ENABLED_FLAG,
111: START_DATE_ACTIVE,
112: END_DATE_ACTIVE,
113: UPDATED_FLAG
114: from FND_CONC_RELEASE_CLASSES
115: where RELEASE_CLASS_ID = X_RELEASE_CLASS_ID
116: and APPLICATION_ID = X_APPLICATION_ID
117: for update of RELEASE_CLASS_ID nowait;
118: recinfo c%rowtype;

Line 123: from FND_CONC_RELEASE_CLASSES_TL

119:
120: cursor c1 is select
121: USER_RELEASE_CLASS_NAME,
122: DESCRIPTION
123: from FND_CONC_RELEASE_CLASSES_TL
124: where RELEASE_CLASS_ID = X_RELEASE_CLASS_ID
125: and APPLICATION_ID = X_APPLICATION_ID
126: and LANGUAGE = userenv('LANG')
127: for update of RELEASE_CLASS_ID nowait;

Line 188: update FND_CONC_RELEASE_CLASSES set

184: X_LAST_UPDATED_BY in NUMBER,
185: X_LAST_UPDATE_LOGIN in NUMBER
186: ) is
187: begin
188: update FND_CONC_RELEASE_CLASSES set
189: RELEASE_CLASS_NAME = X_RELEASE_CLASS_NAME,
190: ENABLED_FLAG = X_ENABLED_FLAG,
191: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
192: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 204: update FND_CONC_RELEASE_CLASSES_TL set

200: if (sql%notfound) then
201: raise no_data_found;
202: end if;
203:
204: update FND_CONC_RELEASE_CLASSES_TL set
205: USER_RELEASE_CLASS_NAME = X_USER_RELEASE_CLASS_NAME,
206: DESCRIPTION = X_DESCRIPTION,
207: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
208: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 225: delete from FND_CONC_RELEASE_CLASSES

221: X_RELEASE_CLASS_ID in NUMBER,
222: X_APPLICATION_ID in NUMBER
223: ) is
224: begin
225: delete from FND_CONC_RELEASE_CLASSES
226: where RELEASE_CLASS_ID = X_RELEASE_CLASS_ID
227: and APPLICATION_ID = X_APPLICATION_ID;
228:
229: if (sql%notfound) then

Line 233: delete from FND_CONC_RELEASE_CLASSES_TL

229: if (sql%notfound) then
230: raise no_data_found;
231: end if;
232:
233: delete from FND_CONC_RELEASE_CLASSES_TL
234: where RELEASE_CLASS_ID = X_RELEASE_CLASS_ID
235: and APPLICATION_ID = X_APPLICATION_ID;
236:
237: if (sql%notfound) then

Line 252: delete from FND_CONC_RELEASE_CLASSES_TL T

248: /* as a quick workaround to fix the time-consuming table handler issue */
249: /* Eventually we'll need to turn them into a separate fix_language procedure */
250: /*
251:
252: delete from FND_CONC_RELEASE_CLASSES_TL T
253: where not exists
254: (select NULL
255: from FND_CONC_RELEASE_CLASSES B
256: where B.RELEASE_CLASS_ID = T.RELEASE_CLASS_ID

Line 255: from FND_CONC_RELEASE_CLASSES B

251:
252: delete from FND_CONC_RELEASE_CLASSES_TL T
253: where not exists
254: (select NULL
255: from FND_CONC_RELEASE_CLASSES B
256: where B.RELEASE_CLASS_ID = T.RELEASE_CLASS_ID
257: and B.APPLICATION_ID = T.APPLICATION_ID
258: );
259:

Line 260: update FND_CONC_RELEASE_CLASSES_TL T set (

256: where B.RELEASE_CLASS_ID = T.RELEASE_CLASS_ID
257: and B.APPLICATION_ID = T.APPLICATION_ID
258: );
259:
260: update FND_CONC_RELEASE_CLASSES_TL T set (
261: USER_RELEASE_CLASS_NAME,
262: DESCRIPTION
263: ) = (select
264: B.USER_RELEASE_CLASS_NAME,

Line 266: from FND_CONC_RELEASE_CLASSES_TL B

262: DESCRIPTION
263: ) = (select
264: B.USER_RELEASE_CLASS_NAME,
265: B.DESCRIPTION
266: from FND_CONC_RELEASE_CLASSES_TL B
267: where B.RELEASE_CLASS_ID = T.RELEASE_CLASS_ID
268: and B.APPLICATION_ID = T.APPLICATION_ID
269: and B.LANGUAGE = T.SOURCE_LANG)
270: where (

Line 278: from FND_CONC_RELEASE_CLASSES_TL SUBB, FND_CONC_RELEASE_CLASSES_TL SUBT

274: ) in (select
275: SUBT.RELEASE_CLASS_ID,
276: SUBT.APPLICATION_ID,
277: SUBT.LANGUAGE
278: from FND_CONC_RELEASE_CLASSES_TL SUBB, FND_CONC_RELEASE_CLASSES_TL SUBT
279: where SUBB.RELEASE_CLASS_ID = SUBT.RELEASE_CLASS_ID
280: and SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
281: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
282: and (SUBB.USER_RELEASE_CLASS_NAME <> SUBT.USER_RELEASE_CLASS_NAME

Line 289: insert into FND_CONC_RELEASE_CLASSES_TL (

285: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
286: ));
287: */
288:
289: insert into FND_CONC_RELEASE_CLASSES_TL (
290: APPLICATION_ID,
291: RELEASE_CLASS_ID,
292: USER_RELEASE_CLASS_NAME,
293: DESCRIPTION,

Line 313: from FND_CONC_RELEASE_CLASSES_TL B, FND_LANGUAGES L

309: B.CREATION_DATE,
310: B.CREATED_BY,
311: L.LANGUAGE_CODE,
312: B.SOURCE_LANG
313: from FND_CONC_RELEASE_CLASSES_TL B, FND_LANGUAGES L
314: where L.INSTALLED_FLAG in ('I', 'B')
315: and B.LANGUAGE = userenv('LANG')
316: and not exists
317: (select NULL

Line 318: from FND_CONC_RELEASE_CLASSES_TL T

314: where L.INSTALLED_FLAG in ('I', 'B')
315: and B.LANGUAGE = userenv('LANG')
316: and not exists
317: (select NULL
318: from FND_CONC_RELEASE_CLASSES_TL T
319: where T.RELEASE_CLASS_ID = B.RELEASE_CLASS_ID
320: and T.APPLICATION_ID = B.APPLICATION_ID
321: and T.LANGUAGE = L.LANGUAGE_CODE);
322: end ADD_LANGUAGE;

Line 324: end FND_CONC_RELEASE_CLASSES_PKG;

320: and T.APPLICATION_ID = B.APPLICATION_ID
321: and T.LANGUAGE = L.LANGUAGE_CODE);
322: end ADD_LANGUAGE;
323:
324: end FND_CONC_RELEASE_CLASSES_PKG;