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_DISJS_PKG dependencies on FND_CONC_RELEASE_DISJS

Line 1: package body FND_CONC_RELEASE_DISJS_PKG as

1: package body FND_CONC_RELEASE_DISJS_PKG as
2: /* $Header: AFCPSC3B.pls 120.2 2005/08/19 10:56:56 ddhulla ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 21: cursor C is select ROWID from FND_CONC_RELEASE_DISJS

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_DISJS
22: where DISJUNCTION_ID = X_DISJUNCTION_ID
23: and APPLICATION_ID = X_APPLICATION_ID
24: ;
25: begin

Line 26: insert into FND_CONC_RELEASE_DISJS (

22: where DISJUNCTION_ID = X_DISJUNCTION_ID
23: and APPLICATION_ID = X_APPLICATION_ID
24: ;
25: begin
26: insert into FND_CONC_RELEASE_DISJS (
27: APPLICATION_ID,
28: DISJUNCTION_ID,
29: DISJUNCTION_NAME,
30: ENABLED_FLAG,

Line 54: insert into FND_CONC_RELEASE_DISJS_TL (

50: X_LAST_UPDATED_BY,
51: X_LAST_UPDATE_LOGIN
52: );
53:
54: insert into FND_CONC_RELEASE_DISJS_TL (
55: APPLICATION_ID,
56: DISJUNCTION_ID,
57: USER_DISJUNCTION_NAME,
58: DESCRIPTION,

Line 82: from FND_CONC_RELEASE_DISJS_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_DISJS_TL T
83: where T.DISJUNCTION_ID = X_DISJUNCTION_ID
84: and T.APPLICATION_ID = X_APPLICATION_ID
85: and T.LANGUAGE = L.LANGUAGE_CODE);
86:

Line 114: from FND_CONC_RELEASE_DISJS

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

Line 123: from FND_CONC_RELEASE_DISJS_TL

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

Line 188: update FND_CONC_RELEASE_DISJS set

184: X_LAST_UPDATED_BY in NUMBER,
185: X_LAST_UPDATE_LOGIN in NUMBER
186: ) is
187: begin
188: update FND_CONC_RELEASE_DISJS set
189: DISJUNCTION_NAME = X_DISJUNCTION_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_DISJS_TL set

200: if (sql%notfound) then
201: raise no_data_found;
202: end if;
203:
204: update FND_CONC_RELEASE_DISJS_TL set
205: USER_DISJUNCTION_NAME = X_USER_DISJUNCTION_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_DISJS

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

Line 233: delete from FND_CONC_RELEASE_DISJS_TL

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

Line 252: delete from FND_CONC_RELEASE_DISJS_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_DISJS_TL T
253: where not exists
254: (select NULL
255: from FND_CONC_RELEASE_DISJS B
256: where B.DISJUNCTION_ID = T.DISJUNCTION_ID

Line 255: from FND_CONC_RELEASE_DISJS B

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

Line 260: update FND_CONC_RELEASE_DISJS_TL T set (

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

Line 266: from FND_CONC_RELEASE_DISJS_TL B

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

Line 278: from FND_CONC_RELEASE_DISJS_TL SUBB, FND_CONC_RELEASE_DISJS_TL SUBT

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

Line 289: insert into FND_CONC_RELEASE_DISJS_TL (

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

Line 313: from FND_CONC_RELEASE_DISJS_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_DISJS_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_DISJS_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_DISJS_TL T
319: where T.DISJUNCTION_ID = B.DISJUNCTION_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_DISJS_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_DISJS_PKG;