APPS.OKE_COMM_ACTIONS_PKG dependencies on OKE_COMM_ACTIONS_TL

Line 97: insert into OKE_COMM_ACTIONS_TL (

93: , X_ATTRIBUTE14
94: , X_ATTRIBUTE15
95: );
96:
97: insert into OKE_COMM_ACTIONS_TL (
98: COMM_ACTION_CODE
99: , LANGUAGE
100: , CREATION_DATE
101: , CREATED_BY

Line 123: from OKE_COMM_ACTIONS_TL T

119: from FND_LANGUAGES L
120: where L.INSTALLED_FLAG in ('I', 'B')
121: and not exists
122: (select NULL
123: from OKE_COMM_ACTIONS_TL T
124: where T.COMM_ACTION_CODE = X_COMM_ACTION_CODE
125: and T.LANGUAGE = L.LANGUAGE_CODE)
126: ;
127:

Line 196: from OKE_COMM_ACTIONS_TL

192: cursor c1 is select
193: COMM_ACTION_NAME
194: ,DESCRIPTION
195: ,decode(LANGUAGE, userenv('LANG'), 'Y', 'N') BASELANG
196: from OKE_COMM_ACTIONS_TL
197: where COMM_ACTION_CODE= X_COMM_ACTION_CODE
198: and userenv('LANG') in (LANGUAGE, SOURCE_LANG)
199: for update of COMM_ACTION_CODE nowait;
200: tlinfo c1%rowtype;

Line 342: update OKE_COMM_ACTIONS_TL set

338: if (sql%notfound) then
339: raise no_data_found;
340: end if;
341:
342: update OKE_COMM_ACTIONS_TL set
343: LAST_UPDATE_DATE = X_LAST_UPDATE_DATE
344: , LAST_UPDATED_BY = X_LAST_UPDATED_BY
345: , LAST_UPDATE_LOGIN = X_LAST_UPDATE_LOGIN
346: , COMM_ACTION_NAME = X_COMM_ACTION_NAME

Line 361: delete from OKE_COMM_ACTIONS_TL T

357:
358: procedure ADD_LANGUAGE
359: is
360: begin
361: delete from OKE_COMM_ACTIONS_TL T
362: where not exists
363: (select NULL
364: from OKE_COMM_ACTIONS_B B
365: where B.COMM_ACTION_CODE = T.COMM_ACTION_CODE

Line 368: update OKE_COMM_ACTIONS_TL T set (

364: from OKE_COMM_ACTIONS_B B
365: where B.COMM_ACTION_CODE = T.COMM_ACTION_CODE
366: );
367:
368: update OKE_COMM_ACTIONS_TL T set (
369: COMM_ACTION_NAME,
370: DESCRIPTION
371: ) = (select
372: B.COMM_ACTION_NAME,

Line 374: from OKE_COMM_ACTIONS_TL B

370: DESCRIPTION
371: ) = (select
372: B.COMM_ACTION_NAME,
373: B.DESCRIPTION
374: from OKE_COMM_ACTIONS_TL B
375: where B.COMM_ACTION_CODE = T.COMM_ACTION_CODE
376: and B.LANGUAGE = T.SOURCE_LANG)
377: where (
378: T.COMM_ACTION_CODE,

Line 383: from OKE_COMM_ACTIONS_TL SUBB, OKE_COMM_ACTIONS_TL SUBT

379: T.LANGUAGE
380: ) in (select
381: SUBT.COMM_ACTION_CODE,
382: SUBT.LANGUAGE
383: from OKE_COMM_ACTIONS_TL SUBB, OKE_COMM_ACTIONS_TL SUBT
384: where SUBB.COMM_ACTION_CODE = SUBT.COMM_ACTION_CODE
385: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
386: and (SUBB.COMM_ACTION_NAME <> SUBT.COMM_ACTION_NAME
387: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 392: insert into OKE_COMM_ACTIONS_TL (

388: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
389: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
390: ));
391:
392: insert into OKE_COMM_ACTIONS_TL (
393: LAST_UPDATED_BY,
394: LAST_UPDATE_LOGIN,
395: COMM_ACTION_NAME,
396: DESCRIPTION,

Line 414: from OKE_COMM_ACTIONS_TL B, FND_LANGUAGES L

410: B.CREATION_DATE,
411: B.CREATED_BY,
412: L.LANGUAGE_CODE,
413: B.SOURCE_LANG
414: from OKE_COMM_ACTIONS_TL B, FND_LANGUAGES L
415: where L.INSTALLED_FLAG in ('I', 'B')
416: and B.LANGUAGE = userenv('LANG')
417: and not exists
418: (select NULL

Line 419: from OKE_COMM_ACTIONS_TL T

415: where L.INSTALLED_FLAG in ('I', 'B')
416: and B.LANGUAGE = userenv('LANG')
417: and not exists
418: (select NULL
419: from OKE_COMM_ACTIONS_TL T
420: where T.COMM_ACTION_CODE = B.COMM_ACTION_CODE
421: and T.LANGUAGE = L.LANGUAGE_CODE);
422: end ADD_LANGUAGE;
423: