APPS.XLA_TB_DEFINITION_PVT dependencies on XLA_TB_DEFINITIONS_TL

Line 229: INSERT INTO xla_tb_definitions_tl

225: ,p_last_update_date
226: ,p_last_update_login
227: );
228:
229: INSERT INTO xla_tb_definitions_tl
230: (
231: definition_code
232: ,name
233: ,description

Line 257: FROM xla_tb_definitions_tl t

253: FROM fnd_languages l
254: WHERE l.installed_flag in ('I', 'B')
255: AND NOT EXISTS
256: (SELECT NULL
257: FROM xla_tb_definitions_tl t
258: WHERE t.definition_code = p_definition_code
259: AND t.language = l.language_code);
260:
261:

Line 379: UPDATE xla_tb_definitions_tl

375: IF (sql%NOTFOUND) THEN
376: RAISE no_data_found;
377: END IF;
378:
379: UPDATE xla_tb_definitions_tl
380: SET name = p_name
381: ,description = p_description
382: ,last_update_date = p_last_update_date
383: ,last_updated_by = p_last_updated_by

Line 424: DELETE FROM xla_tb_definitions_tl

420:
421: DELETE FROM xla_tb_defn_details
422: WHERE definition_code = p_definition_code;
423:
424: DELETE FROM xla_tb_definitions_tl
425: WHERE definition_code = p_definition_code;
426:
427: IF SQL%NOTFOUND then
428: RAISE no_data_found;

Line 468: DELETE FROM xla_tb_definitions_tl t

464:
465:
466: BEGIN
467:
468: DELETE FROM xla_tb_definitions_tl t
469: WHERE NOT EXISTS
470: (SELECT NULL
471: FROM xla_tb_definitions_b b
472: WHERE b.definition_code = t.definition_code

Line 475: UPDATE xla_tb_definitions_tl t

471: FROM xla_tb_definitions_b b
472: WHERE b.definition_code = t.definition_code
473: );
474:
475: UPDATE xla_tb_definitions_tl t
476: SET (
477: NAME
478: ,description
479: ) =

Line 483: FROM xla_tb_definitions_tl b

479: ) =
480: (
481: SELECT b.NAME
482: ,b.description
483: FROM xla_tb_definitions_tl b
484: WHERE b.definition_code = t.definition_code
485: AND b.language = t.source_lang)
486: WHERE (
487: t.definition_code

Line 491: FROM xla_tb_definitions_tl subb

487: t.definition_code
488: ,t.language
489: ) IN (SELECT subt.definition_code
490: ,subt.language
491: FROM xla_tb_definitions_tl subb
492: ,xla_tb_definitions_tl subt
493: WHERE subb.definition_code = subt.definition_code
494: AND subb.language = subt.source_lang
495: AND (subb.NAME <> subt.NAME

Line 492: ,xla_tb_definitions_tl subt

488: ,t.language
489: ) IN (SELECT subt.definition_code
490: ,subt.language
491: FROM xla_tb_definitions_tl subb
492: ,xla_tb_definitions_tl subt
493: WHERE subb.definition_code = subt.definition_code
494: AND subb.language = subt.source_lang
495: AND (subb.NAME <> subt.NAME
496: OR subb.description <> subt.description

Line 502: INSERT INTO xla_tb_definitions_tl

498: OR (subb.description IS NOT NULL AND subt.description IS NULL)
499: )
500: );
501:
502: INSERT INTO xla_tb_definitions_tl
503: (
504: definition_code
505: ,name
506: ,description

Line 526: FROM xla_tb_definitions_tl b, fnd_languages l

522: ,b.last_updated_by
523: ,b.last_update_login
524: ,l.language_code
525: ,b.source_lang
526: FROM xla_tb_definitions_tl b, fnd_languages l
527: WHERE l.installed_flag IN ('I', 'B')
528: AND b.language = userenv('LANG')
529: AND NOT EXISTS
530: (SELECT NULL

Line 531: FROM xla_tb_definitions_tl t

527: WHERE l.installed_flag IN ('I', 'B')
528: AND b.language = userenv('LANG')
529: AND NOT EXISTS
530: (SELECT NULL
531: FROM xla_tb_definitions_tl t
532: WHERE t.definition_code = b.definition_code
533: AND t.language = l.language_code);
534:
535: EXCEPTION

Line 569: FROM xla_tb_definitions_tl

565:
566: CURSOR c_tl IS
567: SELECT last_updated_by
568: ,last_update_date
569: FROM xla_tb_definitions_tl
570: WHERE definition_code = p_definition_code
571: AND LANGUAGE = userenv('LANG');
572:
573: l_definition_code VARCHAR2(30);

Line 599: UPDATE xla_tb_definitions_tl

595: ,p_db_id => l_db_last_updated_by
596: ,p_db_lud => l_db_last_update_date
597: ,p_custom_mode => p_custom_mode)
598: THEN
599: UPDATE xla_tb_definitions_tl
600: SET name = p_name
601: ,description = p_description
602: ,last_updated_by = l_last_updated_by
603: ,last_update_date = l_last_update_date