APPS.OTA_UGT_SHD dependencies on OTA_USER_GROUPS_TL

Line 21: If (p_constraint_name = 'OTA_USER_GROUPS_TL_UK1') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'OTA_USER_GROUPS_TL_UK1') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 53: from ota_user_groups_tl

49: ,language
50: ,user_group_name
51: ,description
52: ,source_lang
53: from ota_user_groups_tl
54: where user_group_id = p_user_group_id
55: and language = p_language;
56: --
57: l_fct_ret boolean;

Line 117: from ota_user_groups_tl

113: ,language
114: ,user_group_name
115: ,description
116: ,source_lang
117: from ota_user_groups_tl
118: where user_group_id = p_user_group_id
119: and language = p_language
120: for update nowait;
121: --

Line 163: fnd_message.set_token('TABLE_NAME', 'ota_user_groups_tl');

159: -- The object is locked therefore we need to supply a meaningful
160: -- error message.
161: --
162: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
163: fnd_message.set_token('TABLE_NAME', 'ota_user_groups_tl');
164: fnd_message.raise_error;
165: End lck;
166: --
167: -- ----------------------------------------------------------------------------

Line 178: delete from ota_user_groups_tl T

174: -- ----------------------------------------------------------------------------
175: procedure ADD_LANGUAGE
176: is
177: begin
178: delete from ota_user_groups_tl T
179: where not exists
180: (select NULL
181: from OTA_USER_GROUPS_B B
182: where B.user_group_id = T.user_group_id

Line 185: update ota_user_groups_tl T set (

181: from OTA_USER_GROUPS_B B
182: where B.user_group_id = T.user_group_id
183: );
184:
185: update ota_user_groups_tl T set (
186: USER_GROUP_NAME,
187: DESCRIPTION
188: ) = (select
189: B.USER_GROUP_NAME,

Line 191: from ota_user_groups_tl B

187: DESCRIPTION
188: ) = (select
189: B.USER_GROUP_NAME,
190: B.DESCRIPTION
191: from ota_user_groups_tl B
192: where B.user_group_id = T.user_group_id
193: and B.LANGUAGE = T.SOURCE_LANG)
194: where (
195: T.user_group_id,

Line 200: from ota_user_groups_tl SUBB, ota_user_groups_tl SUBT

196: T.LANGUAGE
197: ) in (select
198: SUBT.user_group_id,
199: SUBT.LANGUAGE
200: from ota_user_groups_tl SUBB, ota_user_groups_tl SUBT
201: where SUBB.user_group_id = SUBT.user_group_id
202: and SUBB.LANGUAGE = SUBT.SOURCE_LANG
203: and (SUBB.USER_GROUP_NAME <> SUBT.USER_GROUP_NAME
204: or SUBB.DESCRIPTION <> SUBT.DESCRIPTION

Line 209: insert into ota_user_groups_tl (

205: or (SUBB.DESCRIPTION is null and SUBT.DESCRIPTION is not null)
206: or (SUBB.DESCRIPTION is not null and SUBT.DESCRIPTION is null)
207: ));
208:
209: insert into ota_user_groups_tl (
210: user_group_id,
211: USER_GROUP_NAME,
212: DESCRIPTION,
213: CREATED_BY,

Line 231: from ota_user_groups_tl B, FND_LANGUAGES L

227: B.LAST_UPDATED_BY,
228: B.LAST_UPDATE_LOGIN,
229: L.LANGUAGE_CODE,
230: B.SOURCE_LANG
231: from ota_user_groups_tl B, FND_LANGUAGES L
232: where L.INSTALLED_FLAG in ('I', 'B')
233: and B.LANGUAGE = userenv('LANG')
234: and not exists
235: (select NULL

Line 236: from ota_user_groups_tl T

232: where L.INSTALLED_FLAG in ('I', 'B')
233: and B.LANGUAGE = userenv('LANG')
234: and not exists
235: (select NULL
236: from ota_user_groups_tl T
237: where T.user_group_id = B.user_group_id
238: and T.LANGUAGE = L.LANGUAGE_CODE);
239: end ADD_LANGUAGE;
240: --