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_PERIODS_PKG dependencies on FND_CONC_RELEASE_PERIODS

Line 1: package body FND_CONC_RELEASE_PERIODS_PKG as

1: package body FND_CONC_RELEASE_PERIODS_PKG as
2: /* $Header: AFCPSC5B.pls 120.2 2005/08/19 11:27:39 ddhulla ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 25: cursor C is select ROWID from FND_CONC_RELEASE_PERIODS

21: X_LAST_UPDATE_DATE in DATE,
22: X_LAST_UPDATED_BY in NUMBER,
23: X_LAST_UPDATE_LOGIN in NUMBER
24: ) is
25: cursor C is select ROWID from FND_CONC_RELEASE_PERIODS
26: where CONCURRENT_PERIOD_ID = X_CONCURRENT_PERIOD_ID
27: and APPLICATION_ID = X_APPLICATION_ID
28: ;
29: begin

Line 30: insert into FND_CONC_RELEASE_PERIODS (

26: where CONCURRENT_PERIOD_ID = X_CONCURRENT_PERIOD_ID
27: and APPLICATION_ID = X_APPLICATION_ID
28: ;
29: begin
30: insert into FND_CONC_RELEASE_PERIODS (
31: APPLICATION_ID,
32: CONCURRENT_PERIOD_ID,
33: CONCURRENT_PERIOD_NAME,
34: ENABLED_FLAG,

Line 66: insert into FND_CONC_RELEASE_PERIODS_TL (

62: X_LAST_UPDATED_BY,
63: X_LAST_UPDATE_LOGIN
64: );
65:
66: insert into FND_CONC_RELEASE_PERIODS_TL (
67: APPLICATION_ID,
68: CONCURRENT_PERIOD_ID,
69: USER_CONCURRENT_PERIOD_NAME,
70: DESCRIPTION,

Line 94: from FND_CONC_RELEASE_PERIODS_TL T

90: from FND_LANGUAGES L
91: where L.INSTALLED_FLAG in ('I', 'B')
92: and not exists
93: (select NULL
94: from FND_CONC_RELEASE_PERIODS_TL T
95: where T.CONCURRENT_PERIOD_ID = X_CONCURRENT_PERIOD_ID
96: and T.APPLICATION_ID = X_APPLICATION_ID
97: and T.LANGUAGE = L.LANGUAGE_CODE);
98:

Line 134: from FND_CONC_RELEASE_PERIODS

130: PERIOD_LENGTH,
131: PERIOD_START_TIME,
132: PERIOD_STOP_TIME,
133: UPDATED_FLAG
134: from FND_CONC_RELEASE_PERIODS
135: where CONCURRENT_PERIOD_ID = X_CONCURRENT_PERIOD_ID
136: and APPLICATION_ID = X_APPLICATION_ID
137: for update of CONCURRENT_PERIOD_ID nowait;
138: recinfo c%rowtype;

Line 143: from FND_CONC_RELEASE_PERIODS_TL

139:
140: cursor c1 is select
141: USER_CONCURRENT_PERIOD_NAME,
142: DESCRIPTION
143: from FND_CONC_RELEASE_PERIODS_TL
144: where CONCURRENT_PERIOD_ID = X_CONCURRENT_PERIOD_ID
145: and APPLICATION_ID = X_APPLICATION_ID
146: and LANGUAGE = userenv('LANG')
147: for update of CONCURRENT_PERIOD_ID nowait;

Line 216: update FND_CONC_RELEASE_PERIODS set

212: X_LAST_UPDATED_BY in NUMBER,
213: X_LAST_UPDATE_LOGIN in NUMBER
214: ) is
215: begin
216: update FND_CONC_RELEASE_PERIODS set
217: CONCURRENT_PERIOD_NAME = X_CONCURRENT_PERIOD_NAME,
218: ENABLED_FLAG = X_ENABLED_FLAG,
219: START_DATE_ACTIVE = X_START_DATE_ACTIVE,
220: END_DATE_ACTIVE = X_END_DATE_ACTIVE,

Line 236: update FND_CONC_RELEASE_PERIODS_TL set

232: if (sql%notfound) then
233: raise no_data_found;
234: end if;
235:
236: update FND_CONC_RELEASE_PERIODS_TL set
237: USER_CONCURRENT_PERIOD_NAME = X_USER_CONCURRENT_PERIOD_NAME,
238: DESCRIPTION = X_DESCRIPTION,
239: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
240: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 257: delete from FND_CONC_RELEASE_PERIODS

253: X_CONCURRENT_PERIOD_ID in NUMBER,
254: X_APPLICATION_ID in NUMBER
255: ) is
256: begin
257: delete from FND_CONC_RELEASE_PERIODS
258: where CONCURRENT_PERIOD_ID = X_CONCURRENT_PERIOD_ID
259: and APPLICATION_ID = X_APPLICATION_ID;
260:
261: if (sql%notfound) then

Line 265: delete from FND_CONC_RELEASE_PERIODS_TL

261: if (sql%notfound) then
262: raise no_data_found;
263: end if;
264:
265: delete from FND_CONC_RELEASE_PERIODS_TL
266: where CONCURRENT_PERIOD_ID = X_CONCURRENT_PERIOD_ID
267: and APPLICATION_ID = X_APPLICATION_ID;
268:
269: if (sql%notfound) then

Line 284: delete from FND_CONC_RELEASE_PERIODS_TL T

280: /* as a quick workaround to fix the time-consuming table handler issue */
281: /* Eventually we'll need to turn them into a separate fix_language procedure */
282: /*
283:
284: delete from FND_CONC_RELEASE_PERIODS_TL T
285: where not exists
286: (select NULL
287: from FND_CONC_RELEASE_PERIODS B
288: where B.CONCURRENT_PERIOD_ID = T.CONCURRENT_PERIOD_ID

Line 287: from FND_CONC_RELEASE_PERIODS B

283:
284: delete from FND_CONC_RELEASE_PERIODS_TL T
285: where not exists
286: (select NULL
287: from FND_CONC_RELEASE_PERIODS B
288: where B.CONCURRENT_PERIOD_ID = T.CONCURRENT_PERIOD_ID
289: and B.APPLICATION_ID = T.APPLICATION_ID
290: );
291:

Line 292: update FND_CONC_RELEASE_PERIODS_TL T set (

288: where B.CONCURRENT_PERIOD_ID = T.CONCURRENT_PERIOD_ID
289: and B.APPLICATION_ID = T.APPLICATION_ID
290: );
291:
292: update FND_CONC_RELEASE_PERIODS_TL T set (
293: USER_CONCURRENT_PERIOD_NAME,
294: DESCRIPTION
295: ) = (select
296: B.USER_CONCURRENT_PERIOD_NAME,

Line 298: from FND_CONC_RELEASE_PERIODS_TL B

294: DESCRIPTION
295: ) = (select
296: B.USER_CONCURRENT_PERIOD_NAME,
297: B.DESCRIPTION
298: from FND_CONC_RELEASE_PERIODS_TL B
299: where B.CONCURRENT_PERIOD_ID = T.CONCURRENT_PERIOD_ID
300: and B.APPLICATION_ID = T.APPLICATION_ID
301: and B.LANGUAGE = T.SOURCE_LANG)
302: where (

Line 310: from FND_CONC_RELEASE_PERIODS_TL SUBB, FND_CONC_RELEASE_PERIODS_TL SUBT

306: ) in (select
307: SUBT.CONCURRENT_PERIOD_ID,
308: SUBT.APPLICATION_ID,
309: SUBT.LANGUAGE
310: from FND_CONC_RELEASE_PERIODS_TL SUBB, FND_CONC_RELEASE_PERIODS_TL SUBT
311: where SUBB.CONCURRENT_PERIOD_ID = SUBT.CONCURRENT_PERIOD_ID
312: and SUBB.APPLICATION_ID = SUBT.APPLICATION_ID
313: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
314: and (SUBB.USER_CONCURRENT_PERIOD_NAME <> SUBT.USER_CONCURRENT_PERIOD_NAME

Line 321: insert into FND_CONC_RELEASE_PERIODS_TL (

317: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
318: ));
319: */
320:
321: insert into FND_CONC_RELEASE_PERIODS_TL (
322: APPLICATION_ID,
323: CONCURRENT_PERIOD_ID,
324: USER_CONCURRENT_PERIOD_NAME,
325: DESCRIPTION,

Line 345: from FND_CONC_RELEASE_PERIODS_TL B, FND_LANGUAGES L

341: B.CREATION_DATE,
342: B.CREATED_BY,
343: L.LANGUAGE_CODE,
344: B.SOURCE_LANG
345: from FND_CONC_RELEASE_PERIODS_TL B, FND_LANGUAGES L
346: where L.INSTALLED_FLAG in ('I', 'B')
347: and B.LANGUAGE = userenv('LANG')
348: and not exists
349: (select NULL

Line 350: from FND_CONC_RELEASE_PERIODS_TL T

346: where L.INSTALLED_FLAG in ('I', 'B')
347: and B.LANGUAGE = userenv('LANG')
348: and not exists
349: (select NULL
350: from FND_CONC_RELEASE_PERIODS_TL T
351: where T.CONCURRENT_PERIOD_ID = B.CONCURRENT_PERIOD_ID
352: and T.APPLICATION_ID = B.APPLICATION_ID
353: and T.LANGUAGE = L.LANGUAGE_CODE);
354: end ADD_LANGUAGE;

Line 356: end FND_CONC_RELEASE_PERIODS_PKG;

352: and T.APPLICATION_ID = B.APPLICATION_ID
353: and T.LANGUAGE = L.LANGUAGE_CODE);
354: end ADD_LANGUAGE;
355:
356: end FND_CONC_RELEASE_PERIODS_PKG;