APPS.CN_EVENTS_ALL_PKG dependencies on CN_EVENTS_ALL_TL

Line 45: insert into CN_EVENTS_ALL_TL (

41: X_LAST_UPDATE_LOGIN,
42: X_ORG_ID,
43: 1);
44:
45: insert into CN_EVENTS_ALL_TL (
46: EVENT_ID,
47: NAME,
48: LAST_UPDATE_DATE,
49: LAST_UPDATED_BY,

Line 71: from CN_EVENTS_ALL_TL T

67: from FND_LANGUAGES L
68: where L.INSTALLED_FLAG in ('I', 'B')
69: and not exists
70: (select NULL
71: from CN_EVENTS_ALL_TL T
72: where T.EVENT_ID = X_EVENT_ID
73: and T.LANGUAGE = L.language_code AND
74: ORG_ID = X_ORG_ID);
75:

Line 105: from CN_EVENTS_ALL_TL

101:
102: cursor c1 is select
103: NAME,
104: decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
105: from CN_EVENTS_ALL_TL
106: where EVENT_ID = X_EVENT_ID
107: and userenv('LANG') in (LANGUAGE, SOURCE_LANG) AND
108: ORG_ID = X_ORG_ID
109: for update of EVENT_ID nowait;

Line 186: UPDATE CN_EVENTS_ALL_TL

182: if (sql%notfound) then
183: raise no_data_found;
184: end if;
185:
186: UPDATE CN_EVENTS_ALL_TL
187: SET NAME = X_NAME,
188: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE,
189: LAST_UPDATED_BY = X_LAST_UPDATED_BY,
190: LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN,

Line 206: delete from CN_EVENTS_ALL_TL

202: X_EVENT_ID in NUMBER,
203: X_ORG_ID IN NUMBER
204: ) is
205: begin
206: delete from CN_EVENTS_ALL_TL
207: where EVENT_ID = X_EVENT_ID AND
208: ORG_ID = X_ORG_ID;
209:
210: IF (SQL%NOTFOUND) THEN

Line 226: delete from CN_EVENTS_ALL_TL T

222:
223: procedure ADD_LANGUAGE
224: is
225: begin
226: delete from CN_EVENTS_ALL_TL T
227: where not exists
228: (select NULL
229: from CN_EVENTS_ALL_B B
230: where B.EVENT_ID = T.event_id

Line 233: update CN_EVENTS_ALL_TL T set (

229: from CN_EVENTS_ALL_B B
230: where B.EVENT_ID = T.event_id
231: and B.ORG_ID = T.ORG_ID);
232:
233: update CN_EVENTS_ALL_TL T set (
234: NAME
235: ) = (select
236: B.NAME
237: from CN_EVENTS_ALL_TL B

Line 237: from CN_EVENTS_ALL_TL B

233: update CN_EVENTS_ALL_TL T set (
234: NAME
235: ) = (select
236: B.NAME
237: from CN_EVENTS_ALL_TL B
238: where B.EVENT_ID = T.EVENT_ID
239: and B.LANGUAGE = T.source_lang
240: and B.ORG_ID = T.ORG_ID)
241:

Line 248: from CN_EVENTS_ALL_TL SUBB, CN_EVENTS_ALL_TL SUBT

244: T.LANGUAGE
245: ) in (select
246: SUBT.EVENT_ID,
247: SUBT.LANGUAGE
248: from CN_EVENTS_ALL_TL SUBB, CN_EVENTS_ALL_TL SUBT
249: where SUBB.EVENT_ID = SUBT.EVENT_ID
250: and SUBB.LANGUAGE = SUBT.source_lang
251: and SUBB.org_id = SUBT.org_id
252: and (SUBB.NAME <> SUBT.name

Line 257: insert into CN_EVENTS_ALL_TL (

253: or (SUBB.NAME is null and SUBT.NAME is not null)
254: or (SUBB.NAME is not null and SUBT.NAME is null)
255: ));
256:
257: insert into CN_EVENTS_ALL_TL (
258: ORG_ID,
259: EVENT_ID,
260: NAME,
261: LAST_UPDATE_DATE,

Line 279: from CN_EVENTS_ALL_TL B, FND_LANGUAGES L

275: B.CREATION_DATE,
276: B.CREATED_BY,
277: L.LANGUAGE_CODE,
278: B.SOURCE_LANG
279: from CN_EVENTS_ALL_TL B, FND_LANGUAGES L
280: where L.INSTALLED_FLAG in ('I', 'B')
281: and B.LANGUAGE = userenv('LANG')
282: and not exists
283: (select NULL

Line 284: from CN_EVENTS_ALL_TL T

280: where L.INSTALLED_FLAG in ('I', 'B')
281: and B.LANGUAGE = userenv('LANG')
282: and not exists
283: (select NULL
284: from CN_EVENTS_ALL_TL T
285: where T.EVENT_ID = B.EVENT_ID
286: and T.LANGUAGE = L.language_code
287: and T.ORG_ID = B.ORG_ID);
288: end ADD_LANGUAGE;

Line 351: UPDATE cn_events_all_tl SET

347: x_org_id
348: );
349: END IF;
350: -- Load The record to _TL table
351: UPDATE cn_events_all_tl SET
352: name = x_name,
353: last_update_date = sysdate,
354: last_updated_by = user_id,
355: last_update_login = 0,

Line 363: INSERT INTO cn_events_all_tl

359: AND org_id = x_org_id;
360:
361: IF (SQL%NOTFOUND) THEN
362: -- Insert new record to _TL table
363: INSERT INTO cn_events_all_tl
364: (event_id,
365: name,
366: creation_date,
367: created_by,

Line 389: FROM cn_events_all_tl t

385: FROM fnd_languages l
386: WHERE l.installed_flag IN ('I', 'B')
387: AND NOT EXISTS
388: (SELECT NULL
389: FROM cn_events_all_tl t
390: WHERE t.event_id = x_event_id
391: AND t.language = l.language_code);
392: END IF;
393: << end_load_row >>

Line 419: UPDATE cn_events_all_tl SET

415: ELSE
416: user_id := 0;
417: END IF;
418: -- Update the translation
419: UPDATE cn_events_all_tl SET
420: name = x_name,
421: last_update_date = sysdate,
422: last_updated_by = user_id,
423: last_update_login = 0,