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_STATES_PKG dependencies on FND_CONC_RELEASE_STATES

Line 1: package body FND_CONC_RELEASE_STATES_PKG as

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

Line 23: cursor C is select ROWID from FND_CONC_RELEASE_STATES

19: X_LAST_UPDATE_DATE in DATE,
20: X_LAST_UPDATED_BY in NUMBER,
21: X_LAST_UPDATE_LOGIN in NUMBER
22: ) is
23: cursor C is select ROWID from FND_CONC_RELEASE_STATES
24: where CONCURRENT_STATE_ID = X_CONCURRENT_STATE_ID
25: and APPLICATION_ID = X_APPLICATION_ID
26: ;
27: begin

Line 28: insert into FND_CONC_RELEASE_STATES (

24: where CONCURRENT_STATE_ID = X_CONCURRENT_STATE_ID
25: and APPLICATION_ID = X_APPLICATION_ID
26: ;
27: begin
28: insert into FND_CONC_RELEASE_STATES (
29: APPLICATION_ID,
30: CONCURRENT_STATE_ID,
31: CONCURRENT_STATE_NAME,
32: ENABLED_FLAG,

Line 60: insert into FND_CONC_RELEASE_STATES_TL (

56: X_LAST_UPDATED_BY,
57: X_LAST_UPDATE_LOGIN
58: );
59:
60: insert into FND_CONC_RELEASE_STATES_TL (
61: APPLICATION_ID,
62: CONCURRENT_STATE_ID,
63: USER_CONCURRENT_STATE_NAME,
64: DESCRIPTION,

Line 88: from FND_CONC_RELEASE_STATES_TL T

84: from FND_LANGUAGES L
85: where L.INSTALLED_FLAG in ('I', 'B')
86: and not exists
87: (select NULL
88: from FND_CONC_RELEASE_STATES_TL T
89: where T.CONCURRENT_STATE_ID = X_CONCURRENT_STATE_ID
90: and T.APPLICATION_ID = X_APPLICATION_ID
91: and T.LANGUAGE = L.LANGUAGE_CODE);
92:

Line 124: from FND_CONC_RELEASE_STATES

120: END_DATE_ACTIVE,
121: STATUS,
122: LOOKUP_TYPE_ID,
123: UPDATED_FLAG
124: from FND_CONC_RELEASE_STATES
125: where CONCURRENT_STATE_ID = X_CONCURRENT_STATE_ID
126: and APPLICATION_ID = X_APPLICATION_ID
127: for update of CONCURRENT_STATE_ID nowait;
128: recinfo c%rowtype;

Line 133: from FND_CONC_RELEASE_STATES_TL

129:
130: cursor c1 is select
131: USER_CONCURRENT_STATE_NAME,
132: DESCRIPTION
133: from FND_CONC_RELEASE_STATES_TL
134: where CONCURRENT_STATE_ID = X_CONCURRENT_STATE_ID
135: and APPLICATION_ID = X_APPLICATION_ID
136: and LANGUAGE = userenv('LANG')
137: for update of CONCURRENT_STATE_ID nowait;

Line 202: update FND_CONC_RELEASE_STATES set

198: X_LAST_UPDATED_BY in NUMBER,
199: X_LAST_UPDATE_LOGIN in NUMBER
200: ) is
201: begin
202: update FND_CONC_RELEASE_STATES set
203: CONCURRENT_STATE_NAME = X_CONCURRENT_STATE_NAME,
204: ENABLED_FLAG = X_ENABLED_FLAG,
205: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
206: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 220: update FND_CONC_RELEASE_STATES_TL set

216: if (sql%notfound) then
217: raise no_data_found;
218: end if;
219:
220: update FND_CONC_RELEASE_STATES_TL set
221: USER_CONCURRENT_STATE_NAME = X_USER_CONCURRENT_STATE_NAME,
222: DESCRIPTION = X_DESCRIPTION,
223: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
224: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 241: delete from FND_CONC_RELEASE_STATES

237: X_CONCURRENT_STATE_ID in NUMBER,
238: X_APPLICATION_ID in NUMBER
239: ) is
240: begin
241: delete from FND_CONC_RELEASE_STATES
242: where CONCURRENT_STATE_ID = X_CONCURRENT_STATE_ID
243: and APPLICATION_ID = X_APPLICATION_ID;
244:
245: if (sql%notfound) then

Line 249: delete from FND_CONC_RELEASE_STATES_TL

245: if (sql%notfound) then
246: raise no_data_found;
247: end if;
248:
249: delete from FND_CONC_RELEASE_STATES_TL
250: where CONCURRENT_STATE_ID = X_CONCURRENT_STATE_ID
251: and APPLICATION_ID = X_APPLICATION_ID;
252:
253: if (sql%notfound) then

Line 267: delete from FND_CONC_RELEASE_STATES_TL T

263: /* The following delete and update statements are commented out */
264: /* as a quick workaround to fix the time-consuming table handler issue */
265: /* Eventually we'll need to turn them into a separate fix_language procedure */
266: /*
267: delete from FND_CONC_RELEASE_STATES_TL T
268: where not exists
269: (select NULL
270: from FND_CONC_RELEASE_STATES B
271: where B.CONCURRENT_STATE_ID = T.CONCURRENT_STATE_ID

Line 270: from FND_CONC_RELEASE_STATES B

266: /*
267: delete from FND_CONC_RELEASE_STATES_TL T
268: where not exists
269: (select NULL
270: from FND_CONC_RELEASE_STATES B
271: where B.CONCURRENT_STATE_ID = T.CONCURRENT_STATE_ID
272: and B.APPLICATION_ID = T.APPLICATION_ID
273: );
274:

Line 275: update FND_CONC_RELEASE_STATES_TL T set (

271: where B.CONCURRENT_STATE_ID = T.CONCURRENT_STATE_ID
272: and B.APPLICATION_ID = T.APPLICATION_ID
273: );
274:
275: update FND_CONC_RELEASE_STATES_TL T set (
276: USER_CONCURRENT_STATE_NAME,
277: DESCRIPTION
278: ) = (select
279: B.USER_CONCURRENT_STATE_NAME,

Line 281: from FND_CONC_RELEASE_STATES_TL B

277: DESCRIPTION
278: ) = (select
279: B.USER_CONCURRENT_STATE_NAME,
280: B.DESCRIPTION
281: from FND_CONC_RELEASE_STATES_TL B
282: where B.CONCURRENT_STATE_ID = T.CONCURRENT_STATE_ID
283: and B.APPLICATION_ID = T.APPLICATION_ID
284: and B.LANGUAGE = T.SOURCE_LANG)
285: where (

Line 293: from FND_CONC_RELEASE_STATES_TL SUBB, FND_CONC_RELEASE_STATES_TL SUBT

289: ) in (select
290: SUBT.CONCURRENT_STATE_ID,
291: SUBT.APPLICATION_ID,
292: SUBT.LANGUAGE
293: from FND_CONC_RELEASE_STATES_TL SUBB, FND_CONC_RELEASE_STATES_TL SUBT
294: where SUBB.CONCURRENT_STATE_ID = SUBT.CONCURRENT_STATE_ID
295: and SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
296: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
297: and (SUBB.USER_CONCURRENT_STATE_NAME <> SUBT.USER_CONCURRENT_STATE_NAME

Line 304: insert into FND_CONC_RELEASE_STATES_TL (

300: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
301: ));
302: */
303:
304: insert into FND_CONC_RELEASE_STATES_TL (
305: APPLICATION_ID,
306: CONCURRENT_STATE_ID,
307: USER_CONCURRENT_STATE_NAME,
308: DESCRIPTION,

Line 328: from FND_CONC_RELEASE_STATES_TL B, FND_LANGUAGES L

324: B.CREATION_DATE,
325: B.CREATED_BY,
326: L.LANGUAGE_CODE,
327: B.SOURCE_LANG
328: from FND_CONC_RELEASE_STATES_TL B, FND_LANGUAGES L
329: where L.INSTALLED_FLAG in ('I', 'B')
330: and B.LANGUAGE = userenv('LANG')
331: and not exists
332: (select NULL

Line 333: from FND_CONC_RELEASE_STATES_TL T

329: where L.INSTALLED_FLAG in ('I', 'B')
330: and B.LANGUAGE = userenv('LANG')
331: and not exists
332: (select NULL
333: from FND_CONC_RELEASE_STATES_TL T
334: where T.CONCURRENT_STATE_ID = B.CONCURRENT_STATE_ID
335: and T.APPLICATION_ID = B.APPLICATION_ID
336: and T.LANGUAGE = L.LANGUAGE_CODE);
337: end ADD_LANGUAGE;

Line 339: end FND_CONC_RELEASE_STATES_PKG;

335: and T.APPLICATION_ID = B.APPLICATION_ID
336: and T.LANGUAGE = L.LANGUAGE_CODE);
337: end ADD_LANGUAGE;
338:
339: end FND_CONC_RELEASE_STATES_PKG;