APPS.XLA_DESCRIPT_DETAILS_F_PKG dependencies on XLA_DESCRIPT_DETAILS_TL

Line 139: INSERT INTO xla_descript_details_tl

135: ,x_last_updated_by
136: ,x_last_update_login)
137: ;
138:
139: INSERT INTO xla_descript_details_tl
140: (description_detail_id
141: ,literal
142: ,creation_date
143: ,created_by

Line 165: FROM xla_descript_details_tl t

161: FROM fnd_languages l
162: WHERE l.installed_flag IN ('I', 'B')
163: AND NOT EXISTS
164: (SELECT NULL
165: FROM xla_descript_details_tl t
166: WHERE t.description_detail_id = x_description_detail_id
167: AND t.language = l.language_code);
168:
169: OPEN c;

Line 227: FROM xla_descript_details_tl

223: CURSOR c1 IS
224: SELECT description_detail_id
225: ,literal
226: ,DECODE(language , USERENV('LANG'), 'Y', 'N') baselang
227: FROM xla_descript_details_tl
228: WHERE description_detail_id = X_description_detail_id
229: AND USERENV('LANG') IN (language ,source_lang)
230: FOR UPDATE OF description_detail_id NOWAIT;
231:

Line 363: UPDATE xla_descript_details_tl

359: IF (SQL%NOTFOUND) THEN
360: RAISE NO_DATA_FOUND;
361: END IF;
362:
363: UPDATE xla_descript_details_tl
364: SET
365: last_update_date = x_last_update_date
366: ,literal = X_literal
367: ,last_updated_by = x_last_updated_by

Line 407: DELETE FROM xla_descript_details_tl

403: p_module => l_log_module,
404: p_level => C_LEVEL_PROCEDURE);
405: END IF;
406:
407: DELETE FROM xla_descript_details_tl
408: WHERE description_detail_id = x_description_detail_id;
409:
410:
411: IF (SQL%NOTFOUND) THEN

Line 453: DELETE FROM xla_descript_details_tl T

449: p_module => l_log_module,
450: p_level => C_LEVEL_PROCEDURE);
451: END IF;
452:
453: DELETE FROM xla_descript_details_tl T
454: WHERE NOT EXISTS
455: (SELECT NULL
456: FROM xla_descript_details_b b
457: WHERE b.description_detail_id = t.description_detail_id);

Line 459: UPDATE xla_descript_details_tl t

455: (SELECT NULL
456: FROM xla_descript_details_b b
457: WHERE b.description_detail_id = t.description_detail_id);
458:
459: UPDATE xla_descript_details_tl t
460: SET (literal)
461: = (SELECT b.literal
462: FROM xla_descript_details_tl b
463: WHERE b.description_detail_id = t.description_detail_id

Line 462: FROM xla_descript_details_tl b

458:
459: UPDATE xla_descript_details_tl t
460: SET (literal)
461: = (SELECT b.literal
462: FROM xla_descript_details_tl b
463: WHERE b.description_detail_id = t.description_detail_id
464: AND b.language = t.source_lang)
465: WHERE (t.description_detail_id
466: ,t.language)

Line 469: FROM xla_descript_details_tl subb

465: WHERE (t.description_detail_id
466: ,t.language)
467: IN (SELECT subt.description_detail_id
468: ,subt.language
469: FROM xla_descript_details_tl subb
470: ,xla_descript_details_tl subt
471: WHERE subb.description_detail_id = subt.description_detail_id
472: AND subb.language = subt.source_lang
473: AND (SUBB.literal <> SUBT.literal

Line 470: ,xla_descript_details_tl subt

466: ,t.language)
467: IN (SELECT subt.description_detail_id
468: ,subt.language
469: FROM xla_descript_details_tl subb
470: ,xla_descript_details_tl subt
471: WHERE subb.description_detail_id = subt.description_detail_id
472: AND subb.language = subt.source_lang
473: AND (SUBB.literal <> SUBT.literal
474: OR (subb.literal IS NULL

Line 481: INSERT INTO xla_descript_details_tl

477: AND subt.literal IS NULL)
478: ))
479: ;
480:
481: INSERT INTO xla_descript_details_tl
482: (description_detail_id
483: ,literal
484: ,creation_date
485: ,created_by

Line 503: FROM xla_descript_details_tl b

499: ,b.last_update_login
500: ,b.amb_context_code
501: ,l.language_code
502: ,b.source_lang
503: FROM xla_descript_details_tl b
504: ,fnd_languages l
505: WHERE l.installed_flag IN ('I', 'B')
506: AND b.language = userenv('LANG')
507: AND NOT EXISTS

Line 509: FROM xla_descript_details_tl t

505: WHERE l.installed_flag IN ('I', 'B')
506: AND b.language = userenv('LANG')
507: AND NOT EXISTS
508: (SELECT NULL
509: FROM xla_descript_details_tl t
510: WHERE t.description_detail_id = b.description_detail_id
511: AND t.language = l.language_code);
512:
513: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 603: FROM xla_descript_details_tl

599:
600: BEGIN
601: SELECT last_updated_by, last_update_date
602: INTO db_luby, db_ludate
603: FROM xla_descript_details_tl
604: WHERE amb_context_code = p_amb_context_code
605: AND description_detail_id = l_description_detail_id
606: AND language = userenv('LANG');
607:

Line 610: UPDATE xla_descript_details_tl

606: AND language = userenv('LANG');
607:
608: IF (fnd_load_util.upload_test(f_luby, f_ludate, db_luby,
609: db_ludate, p_custom_mode)) then
610: UPDATE xla_descript_details_tl
611: SET literal = p_literal
612: ,last_update_date = f_ludate
613: ,last_updated_by = f_luby
614: ,last_update_login = 0