APPS.PER_ABT_SHD dependencies on PER_ABS_ATTENDANCE_TYPES_TL

Line 52: from per_abs_attendance_types_tl

48: absence_attendance_type_id
49: ,name
50: ,language
51: ,source_lang
52: from per_abs_attendance_types_tl
53: where absence_attendance_type_id = p_absence_attendance_type_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;

Line 118: from per_abs_attendance_types_tl

114: absence_attendance_type_id
115: ,name
116: ,language
117: ,source_lang
118: from per_abs_attendance_types_tl
119: where absence_attendance_type_id = p_absence_attendance_type_id
120: and language = p_language
121: for update nowait;
122: --

Line 164: fnd_message.set_token('TABLE_NAME', 'per_abs_attendance_types_tl');

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

Line 175: delete from per_abs_attendance_types_tl t

171: --
172: procedure add_language is
173: begin
174: --
175: delete from per_abs_attendance_types_tl t
176: where not exists
177: (select null
178: from per_absence_attendance_types b
179: where b.absence_attendance_type_id = t.absence_attendance_type_id

Line 182: update per_abs_attendance_types_tl t set (

178: from per_absence_attendance_types b
179: where b.absence_attendance_type_id = t.absence_attendance_type_id
180: );
181:
182: update per_abs_attendance_types_tl t set (
183: name
184: ) = (select
185: b.name
186: from per_abs_attendance_types_tl b

Line 186: from per_abs_attendance_types_tl b

182: update per_abs_attendance_types_tl t set (
183: name
184: ) = (select
185: b.name
186: from per_abs_attendance_types_tl b
187: where b.absence_attendance_type_id = t.absence_attendance_type_id
188: and b.language = t.source_lang)
189: where (
190: t.absence_attendance_type_id,

Line 195: from per_abs_attendance_types_tl subb, per_abs_attendance_types_tl subt

191: t.language
192: ) in (select
193: subt.absence_attendance_type_id,
194: subt.language
195: from per_abs_attendance_types_tl subb, per_abs_attendance_types_tl subt
196: where subb.absence_attendance_type_id = subt.absence_attendance_type_id
197: and subb.language = subt.source_lang
198: and (subb.name <> subt.name
199: ));

Line 201: insert into per_abs_attendance_types_tl (

197: and subb.language = subt.source_lang
198: and (subb.name <> subt.name
199: ));
200:
201: insert into per_abs_attendance_types_tl (
202: absence_attendance_type_id,
203: name,
204: created_by,
205: creation_date,

Line 221: from per_abs_attendance_types_tl b, fnd_languages l

217: b.last_update_date,
218: b.last_update_login,
219: l.language_code,
220: b.source_lang
221: from per_abs_attendance_types_tl b, fnd_languages l
222: where l.installed_flag in ('I', 'B')
223: and b.language = userenv('lang')
224: and not exists
225: (select null

Line 226: from per_abs_attendance_types_tl t

222: where l.installed_flag in ('I', 'B')
223: and b.language = userenv('lang')
224: and not exists
225: (select null
226: from per_abs_attendance_types_tl t
227: where t.absence_attendance_type_id = b.absence_attendance_type_id
228: and t.language = l.language_code);
229: --
230: end;