APPS.JTF_OBJECTS_PKG dependencies on JTF_OBJECTS_TL

Line 153: insert into JTF_OBJECTS_TL (

149: X_OA_WEB_FUNCTION_NAME,
150: X_OA_WEB_FUNCTION_PARAMETERS
151: );
152:
153: insert into JTF_OBJECTS_TL (
154: OBJECT_CODE,
155: NAME,
156: DESCRIPTION,
157: LOV_WINDOW_TITLE,

Line 185: from JTF_OBJECTS_TL T

181: from FND_LANGUAGES L
182: where L.INSTALLED_FLAG in ('I', 'B')
183: and not exists
184: (select NULL
185: from JTF_OBJECTS_TL T
186: where T.OBJECT_CODE = X_OBJECT_CODE
187: and T.LANGUAGE = L.LANGUAGE_CODE);
188:
189: open c;

Line 333: update JTF_OBJECTS_TL set

329: if (sql%notfound) then
330: raise no_data_found;
331: end if;
332:
333: update JTF_OBJECTS_TL set
334: NAME = X_NAME,
335: DESCRIPTION = X_DESCRIPTION,
336: LOV_WINDOW_TITLE = X_LOV_WINDOW_TITLE,
337: LOV_NAME_TITLE = X_LOV_NAME_TITLE,

Line 355: delete from JTF_OBJECTS_TL

351: procedure DELETE_ROW (
352: X_OBJECT_CODE in VARCHAR2
353: ) is
354: begin
355: delete from JTF_OBJECTS_TL
356: where OBJECT_CODE = X_OBJECT_CODE;
357:
358: if (sql%notfound) then
359: raise no_data_found;

Line 375: TYPE ob_tab IS TABLE OF jtf_objects_tl.object_code%type ;

371: is
372:
373:
374:
375: TYPE ob_tab IS TABLE OF jtf_objects_tl.object_code%type ;
376: ob_tab_var ob_tab:=ob_tab();
377: cursor c is
378: select distinct object_code from JTF_OBJECTS_TL;
379:

Line 378: select distinct object_code from JTF_OBJECTS_TL;

374:
375: TYPE ob_tab IS TABLE OF jtf_objects_tl.object_code%type ;
376: ob_tab_var ob_tab:=ob_tab();
377: cursor c is
378: select distinct object_code from JTF_OBJECTS_TL;
379:
380:
381: begin
382: /* Solving Perf. Bug 3723927*/

Line 387: delete from JTF_OBJECTS_TL T

383: /* The following delete and update statements are commented out */
384: /* as a quick workaround to fix the time-consuming table handler issue */
385: /*
386:
387: delete from JTF_OBJECTS_TL T
388: where not exists
389: (select NULL
390: from JTF_OBJECTS_B B
391: where B.OBJECT_CODE = T.OBJECT_CODE

Line 394: update JTF_OBJECTS_TL T set (

390: from JTF_OBJECTS_B B
391: where B.OBJECT_CODE = T.OBJECT_CODE
392: );
393:
394: update JTF_OBJECTS_TL T set (
395: NAME,
396: DESCRIPTION,
397: LOV_WINDOW_TITLE,
398: LOV_NAME_TITLE,

Line 406: from JTF_OBJECTS_TL B

402: B.DESCRIPTION,
403: B.LOV_WINDOW_TITLE,
404: B.LOV_NAME_TITLE,
405: B.LOV_DETAILS_TITLE
406: from JTF_OBJECTS_TL B
407: where B.OBJECT_CODE = T.OBJECT_CODE
408: and B.LANGUAGE = T.SOURCE_LANG)
409: where (
410: T.OBJECT_CODE,

Line 415: from JTF_OBJECTS_TL SUBB, JTF_OBJECTS_TL SUBT

411: T.LANGUAGE
412: ) in (select
413: SUBT.OBJECT_CODE,
414: SUBT.LANGUAGE
415: from JTF_OBJECTS_TL SUBB, JTF_OBJECTS_TL SUBT
416: where SUBB.OBJECT_CODE = SUBT.OBJECT_CODE
417: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
418: and (SUBB.NAME <> SUBT.NAME
419: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 449: insert into JTF_OBJECTS_TL (

445:
446:
447: FORALL i in ob_tab_var.first..ob_tab_var.last
448:
449: insert into JTF_OBJECTS_TL (
450: OBJECT_CODE,
451: NAME,
452: DESCRIPTION,
453: LOV_WINDOW_TITLE,

Line 477: from JTF_OBJECTS_TL B, FND_LANGUAGES L

473: B.LAST_UPDATE_DATE,
474: B.LAST_UPDATE_LOGIN,
475: L.LANGUAGE_CODE,
476: B.SOURCE_LANG
477: from JTF_OBJECTS_TL B, FND_LANGUAGES L
478: where L.INSTALLED_FLAG in ('I', 'B')
479: and B.LANGUAGE = userenv('LANG')
480: and b.object_code=ob_tab_var(i)
481: and not exists

Line 483: from JTF_OBJECTS_TL T

479: and B.LANGUAGE = userenv('LANG')
480: and b.object_code=ob_tab_var(i)
481: and not exists
482: (select NULL
483: from JTF_OBJECTS_TL T
484: where T.OBJECT_CODE = B.OBJECT_CODE
485: and T.LANGUAGE = L.LANGUAGE_CODE);
486:
487: end if; -- for If ( ob_tab_var.COUNT > 0) then

Line 499: update jtf_objects_tl set

495: X_lov_window_title in varchar2,
496: X_lov_name_title in varchar2,
497: X_lov_details_title in varchar2 ) is
498: begin
499: update jtf_objects_tl set
500: NAME= X_NAME,
501: DESCRIPTION= X_DESCRIPTION,
502: lov_window_title = X_lov_window_title ,
503: lov_name_title = X_lov_name_title,