APPS.PER_STT_SHD dependencies on PER_SHARED_TYPES

Line 47: from per_shared_types_tl

43: shared_type_id,
44: language,
45: source_lang,
46: shared_type_name
47: from per_shared_types_tl
48: where shared_type_id = p_shared_type_id
49: and language = p_language;
50: --
51: l_proc varchar2(72) := g_package||'api_updating';

Line 118: from per_shared_types_tl

114: select shared_type_id,
115: language,
116: source_lang,
117: shared_type_name
118: from per_shared_types_tl
119: where shared_type_id = p_shared_type_id
120: and language = p_language
121: for update nowait;
122: --

Line 159: hr_utility.set_message_token('TABLE_NAME', 'per_shared_types_tl');

155: -- The object is locked therefore we need to supply a meaningful
156: -- error message.
157: --
158: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
159: hr_utility.set_message_token('TABLE_NAME', 'per_shared_types_tl');
160: hr_utility.raise_error;
161: End lck;
162: --
163: procedure ADD_LANGUAGE

Line 166: delete from PER_SHARED_TYPES_TL T

162: --
163: procedure ADD_LANGUAGE
164: is
165: begin
166: delete from PER_SHARED_TYPES_TL T
167: where not exists
168: (select NULL
169: from PER_SHARED_TYPES B
170: where B.SHARED_TYPE_ID = T.SHARED_TYPE_ID

Line 169: from PER_SHARED_TYPES B

165: begin
166: delete from PER_SHARED_TYPES_TL T
167: where not exists
168: (select NULL
169: from PER_SHARED_TYPES B
170: where B.SHARED_TYPE_ID = T.SHARED_TYPE_ID
171: );
172:
173: update PER_SHARED_TYPES_TL T set (

Line 173: update PER_SHARED_TYPES_TL T set (

169: from PER_SHARED_TYPES B
170: where B.SHARED_TYPE_ID = T.SHARED_TYPE_ID
171: );
172:
173: update PER_SHARED_TYPES_TL T set (
174: SHARED_TYPE_NAME
175: ) = (select
176: B.SHARED_TYPE_NAME
177: from PER_SHARED_TYPES_TL B

Line 177: from PER_SHARED_TYPES_TL B

173: update PER_SHARED_TYPES_TL T set (
174: SHARED_TYPE_NAME
175: ) = (select
176: B.SHARED_TYPE_NAME
177: from PER_SHARED_TYPES_TL B
178: where B.SHARED_TYPE_ID = T.SHARED_TYPE_ID
179: and B.LANGUAGE = T.SOURCE_LANG)
180: where (
181: T.SHARED_TYPE_ID,

Line 186: from PER_SHARED_TYPES_TL SUBB, PER_SHARED_TYPES_TL SUBT

182: T.LANGUAGE
183: ) in (select
184: SUBT.SHARED_TYPE_ID,
185: SUBT.LANGUAGE
186: from PER_SHARED_TYPES_TL SUBB, PER_SHARED_TYPES_TL SUBT
187: where SUBB.SHARED_TYPE_ID = SUBT.SHARED_TYPE_ID
188: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
189: and (SUBB.SHARED_TYPE_NAME <> SUBT.SHARED_TYPE_NAME
190: or (SUBB.SHARED_TYPE_NAME is null and SUBT.SHARED_TYPE_NAME is not null)

Line 194: insert into PER_SHARED_TYPES_TL (

190: or (SUBB.SHARED_TYPE_NAME is null and SUBT.SHARED_TYPE_NAME is not null)
191: or (SUBB.SHARED_TYPE_NAME is not null and SUBT.SHARED_TYPE_NAME is null)
192: ));
193:
194: insert into PER_SHARED_TYPES_TL (
195: SHARED_TYPE_ID,
196: SHARED_TYPE_NAME,
197: LAST_UPDATE_DATE,
198: LAST_UPDATED_BY,

Line 214: from PER_SHARED_TYPES_TL B, FND_LANGUAGES L

210: B.CREATED_BY,
211: B.CREATION_DATE,
212: L.LANGUAGE_CODE,
213: B.SOURCE_LANG
214: from PER_SHARED_TYPES_TL B, FND_LANGUAGES L
215: where L.INSTALLED_FLAG in ('I', 'B')
216: and B.LANGUAGE = userenv('LANG')
217: and not exists
218: (select NULL

Line 219: from PER_SHARED_TYPES_TL T

215: where L.INSTALLED_FLAG in ('I', 'B')
216: and B.LANGUAGE = userenv('LANG')
217: and not exists
218: (select NULL
219: from PER_SHARED_TYPES_TL T
220: where T.SHARED_TYPE_ID = B.SHARED_TYPE_ID
221: and T.LANGUAGE = L.LANGUAGE_CODE);
222: end ADD_LANGUAGE;
223: -- ----------------------------------------------------------------------------