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.CAC_VIEW_COLLAB_DETAILS_PKG dependencies on CAC_VIEW_COLLAB_DETAILS

Line 1: PACKAGE BODY CAC_VIEW_COLLAB_DETAILS_PKG AS

1: PACKAGE BODY CAC_VIEW_COLLAB_DETAILS_PKG AS
2: /* $Header: jtfcvcdb.pls 115.2 2004/06/29 20:29:59 cijang noship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out NOCOPY VARCHAR2,

Line 24: cursor C is select ROWID from CAC_VIEW_COLLAB_DETAILS

20: X_LAST_UPDATE_DATE in DATE,
21: X_LAST_UPDATED_BY in NUMBER,
22: X_LAST_UPDATE_LOGIN in NUMBER) is
23:
24: cursor C is select ROWID from CAC_VIEW_COLLAB_DETAILS
25: where COLLAB_ID = X_COLLAB_ID
26: ;
27: begin
28:

Line 29: insert into CAC_VIEW_COLLAB_DETAILS (

25: where COLLAB_ID = X_COLLAB_ID
26: ;
27: begin
28:
29: insert into CAC_VIEW_COLLAB_DETAILS (
30: COLLAB_ID,
31: TASK_ID,
32: MEETING_MODE,
33: MEETING_ID,

Line 63: insert into CAC_VIEW_COLLAB_DETAILS_TL (

59: X_LAST_UPDATED_BY,
60: X_LAST_UPDATE_LOGIN
61: );
62:
63: insert into CAC_VIEW_COLLAB_DETAILS_TL (
64: CREATED_BY,
65: CREATION_DATE,
66: LAST_UPDATED_BY,
67: LAST_UPDATE_DATE,

Line 89: from CAC_VIEW_COLLAB_DETAILS_TL T

85: from FND_LANGUAGES L
86: where L.INSTALLED_FLAG in ('I', 'B')
87: and not exists
88: (select NULL
89: from CAC_VIEW_COLLAB_DETAILS_TL T
90: where T.COLLAB_ID = X_COLLAB_ID
91: and T.LANGUAGE = L.LANGUAGE_CODE);
92:
93: open c;

Line 128: from CAC_VIEW_COLLAB_DETAILS

124: PLAYBACK_URL,
125: DOWNLOAD_URL,
126: CHAT_URL,
127: IS_STANDALONE_LOCATION
128: from CAC_VIEW_COLLAB_DETAILS
129: where COLLAB_ID = X_COLLAB_ID
130: for update of COLLAB_ID nowait;
131: recinfo c%rowtype;
132:

Line 137: from CAC_VIEW_COLLAB_DETAILS_TL

133: cursor c1 is select
134: LOCATION,
135: DIAL_IN,
136: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
137: from CAC_VIEW_COLLAB_DETAILS_TL
138: where COLLAB_ID = X_COLLAB_ID
139: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
140: for update of COLLAB_ID nowait;
141: begin

Line 209: update CAC_VIEW_COLLAB_DETAILS set

205: X_LAST_UPDATED_BY in NUMBER,
206: X_LAST_UPDATE_LOGIN in NUMBER
207: ) is
208: begin
209: update CAC_VIEW_COLLAB_DETAILS set
210: TASK_ID = X_TASK_ID,
211: MEETING_MODE = X_MEETING_MODE,
212: MEETING_ID = X_MEETING_ID,
213: MEETING_URL = X_MEETING_URL,

Line 228: update CAC_VIEW_COLLAB_DETAILS_TL set

224: if (sql%notfound) then
225: raise no_data_found;
226: end if;
227:
228: update CAC_VIEW_COLLAB_DETAILS_TL set
229: LOCATION = X_LOCATION,
230: DIAL_IN = X_DIAL_IN,
231: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
232: LAST_UPDATED_BY = X_LAST_UPDATED_BY,

Line 247: delete from CAC_VIEW_COLLAB_DETAILS_TL

243: procedure DELETE_ROW (
244: X_COLLAB_ID in NUMBER
245: ) is
246: begin
247: delete from CAC_VIEW_COLLAB_DETAILS_TL
248: where COLLAB_ID = X_COLLAB_ID;
249:
250: if (sql%notfound) then
251: raise no_data_found;

Line 254: delete from CAC_VIEW_COLLAB_DETAILS

250: if (sql%notfound) then
251: raise no_data_found;
252: end if;
253:
254: delete from CAC_VIEW_COLLAB_DETAILS
255: where COLLAB_ID = X_COLLAB_ID;
256:
257: if (sql%notfound) then
258: raise no_data_found;

Line 265: delete from CAC_VIEW_COLLAB_DETAILS_TL T

261:
262: procedure ADD_LANGUAGE
263: is
264: begin
265: delete from CAC_VIEW_COLLAB_DETAILS_TL T
266: where not exists
267: (select NULL
268: from CAC_VIEW_COLLAB_DETAILS B
269: where B.COLLAB_ID = T.COLLAB_ID

Line 268: from CAC_VIEW_COLLAB_DETAILS B

264: begin
265: delete from CAC_VIEW_COLLAB_DETAILS_TL T
266: where not exists
267: (select NULL
268: from CAC_VIEW_COLLAB_DETAILS B
269: where B.COLLAB_ID = T.COLLAB_ID
270: );
271:
272: update CAC_VIEW_COLLAB_DETAILS_TL T set (

Line 272: update CAC_VIEW_COLLAB_DETAILS_TL T set (

268: from CAC_VIEW_COLLAB_DETAILS B
269: where B.COLLAB_ID = T.COLLAB_ID
270: );
271:
272: update CAC_VIEW_COLLAB_DETAILS_TL T set (
273: LOCATION,
274: DIAL_IN
275: ) = (select
276: B.LOCATION,

Line 278: from CAC_VIEW_COLLAB_DETAILS_TL B

274: DIAL_IN
275: ) = (select
276: B.LOCATION,
277: B.DIAL_IN
278: from CAC_VIEW_COLLAB_DETAILS_TL B
279: where B.COLLAB_ID = T.COLLAB_ID
280: and B.LANGUAGE = T.SOURCE_LANG)
281: where (
282: T.COLLAB_ID,

Line 287: from CAC_VIEW_COLLAB_DETAILS_TL SUBB, CAC_VIEW_COLLAB_DETAILS_TL SUBT

283: T.LANGUAGE
284: ) in (select
285: SUBT.COLLAB_ID,
286: SUBT.LANGUAGE
287: from CAC_VIEW_COLLAB_DETAILS_TL SUBB, CAC_VIEW_COLLAB_DETAILS_TL SUBT
288: where SUBB.COLLAB_ID = SUBT.COLLAB_ID
289: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
290: and (SUBB.LOCATION <> SUBT.LOCATION
291: or (SUBB.LOCATION is null and SUBT.LOCATION is not null)

Line 298: insert into CAC_VIEW_COLLAB_DETAILS_TL (

294: or (SUBB.DIAL_IN is null and SUBT.DIAL_IN is not null)
295: or (SUBB.DIAL_IN is not null and SUBT.DIAL_IN is null)
296: ));
297:
298: insert into CAC_VIEW_COLLAB_DETAILS_TL (
299: CREATED_BY,
300: CREATION_DATE,
301: LAST_UPDATED_BY,
302: LAST_UPDATE_DATE,

Line 320: from CAC_VIEW_COLLAB_DETAILS_TL B, FND_LANGUAGES L

316: B.LOCATION,
317: B.DIAL_IN,
318: L.LANGUAGE_CODE,
319: B.SOURCE_LANG
320: from CAC_VIEW_COLLAB_DETAILS_TL B, FND_LANGUAGES L
321: where L.INSTALLED_FLAG in ('I', 'B')
322: and B.LANGUAGE = userenv('LANG')
323: and not exists
324: (select NULL

Line 325: from CAC_VIEW_COLLAB_DETAILS_TL T

321: where L.INSTALLED_FLAG in ('I', 'B')
322: and B.LANGUAGE = userenv('LANG')
323: and not exists
324: (select NULL
325: from CAC_VIEW_COLLAB_DETAILS_TL T
326: where T.COLLAB_ID = B.COLLAB_ID
327: and T.LANGUAGE = L.LANGUAGE_CODE);
328: end ADD_LANGUAGE;
329:

Line 332: END CAC_VIEW_COLLAB_DETAILS_PKG;

328: end ADD_LANGUAGE;
329:
330:
331:
332: END CAC_VIEW_COLLAB_DETAILS_PKG;