APPS.PER_SHT_SHD dependencies on PER_SHARED_TYPES_TL

Line 473: update per_shared_types_tl

469: , last_updated_by = l_last_updated_by
470: , last_update_login = l_last_update_login
471: where shared_type_id = l_shared_type_id;
472:
473: update per_shared_types_tl
474: set shared_type_name = p_shared_type_name
475: , last_update_date = l_last_update_date
476: , last_updated_by = l_last_updated_by
477: , last_update_login = l_last_update_login

Line 482: insert into per_shared_types_tl

478: , source_lang = userenv('LANG')
479: where shared_type_id = l_shared_type_id
480: and userenv('LANG') in (LANGUAGE,SOURCE_LANG);
481: if sql%notfound then
482: insert into per_shared_types_tl
483: (shared_type_id,
484: shared_type_name,
485: language,
486: source_lang,

Line 502: and not exists (select null from per_shared_types_tl t

498: l_last_updated_by,
499: l_last_update_date,
500: l_last_update_login from fnd_languages l
501: where l.installed_flag in ('I','B')
502: and not exists (select null from per_shared_types_tl t
503: where t.shared_type_id = l_shared_type_id
504: and t.language = l.language_code);
505: end if;
506: else

Line 558: update per_shared_types_tl

554: , last_updated_by = l_last_updated_by
555: , last_update_login = l_last_update_login
556: where shared_type_id = l_shared_type_id;
557:
558: update per_shared_types_tl
559: set shared_type_name = p_shared_type_name
560: , last_update_date = l_last_update_date
561: , last_updated_by = l_last_updated_by
562: , last_update_login = l_last_update_login

Line 567: insert into per_shared_types_tl

563: , source_lang = userenv('LANG')
564: where shared_type_id = l_shared_type_id
565: and userenv('LANG') in (LANGUAGE,SOURCE_LANG);
566: if sql%notfound then
567: insert into per_shared_types_tl
568: (shared_type_id,
569: shared_type_name,
570: language,
571: source_lang,

Line 587: and not exists (select null from per_shared_types_tl t

583: l_last_updated_by,
584: l_last_update_date,
585: l_last_update_login from fnd_languages l
586: where l.installed_flag in ('I','B')
587: and not exists (select null from per_shared_types_tl t
588: where t.shared_type_id = l_shared_type_id
589: and t.language = l.language_code);
590: else
591: -- record has been updated by custom, update the share_type_code only.

Line 688: insert into per_shared_types_tl

684: l_last_update_login,
685: l_creation_date,
686: l_last_update_date,
687: l_object_version_number);
688: insert into per_shared_types_tl
689: (shared_type_id,
690: shared_type_name,
691: language,
692: source_lang,

Line 708: and not exists (select null from per_shared_types_tl t

704: l_last_updated_by,
705: l_last_update_date,
706: l_last_update_login from fnd_languages l
707: where l.installed_flag in ('I','B')
708: and not exists (select null from per_shared_types_tl t
709: where t.shared_type_id = l_shared_type_id
710: and t.language = l.language_code);
711: end if;
712: end if;