APPS.HR_PFT_SHD dependencies on HR_ALL_POSITIONS_F

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'HR_ALL_POSITIONS_F_TL_PK') 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 52: from hr_all_positions_f_tl

48: position_id
49: ,language
50: ,source_lang
51: ,name
52: from hr_all_positions_f_tl
53: where position_id = p_position_id
54: and language = p_language;
55: --
56: l_fct_ret boolean;

Line 118: from hr_all_positions_f_tl

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

Line 164: fnd_message.set_token('TABLE_NAME', 'hr_all_positions_f_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', 'hr_all_positions_f_tl');
165: fnd_message.raise_error;
166: End lck;
167: --
168: -- ----------------------------------------------------------------------------

Line 190: , hr_all_positions_f_tl pft

186: , pft.source_lang
187: , l.nls_language
188: , pft.name
189: from per_position_definitions psd
190: , hr_all_positions_f_tl pft
191: , hr_all_positions_f psf
192: , fnd_languages l
193: where psf.effective_end_date = hr_api.g_eot
194: and psd.position_definition_id = psf.position_definition_id

Line 191: , hr_all_positions_f psf

187: , l.nls_language
188: , pft.name
189: from per_position_definitions psd
190: , hr_all_positions_f_tl pft
191: , hr_all_positions_f psf
192: , fnd_languages l
193: where psf.effective_end_date = hr_api.g_eot
194: and psd.position_definition_id = psf.position_definition_id
195: and psf.position_id = pft.position_id

Line 199: from hr_all_positions_f_tl pft2

195: and psf.position_id = pft.position_id
196: and pft.language = userenv('LANG')
197: and l.installed_flag in ('I', 'B')
198: and not exists (select null
199: from hr_all_positions_f_tl pft2
200: where pft2.position_id = pft.position_id
201: and pft2.language = l.language_code)
202: order by l.language_code;
203: --

Line 214: delete from HR_ALL_POSITIONS_F_TL T

210: Begin
211: --
212: hr_utility.set_location('Entering:'||l_proc, 5);
213: --
214: delete from HR_ALL_POSITIONS_F_TL T
215: where not exists
216: (select NULL
217: from HR_ALL_POSITIONS_F B
218: where B.POSITION_ID = T.POSITION_ID

Line 217: from HR_ALL_POSITIONS_F B

213: --
214: delete from HR_ALL_POSITIONS_F_TL T
215: where not exists
216: (select NULL
217: from HR_ALL_POSITIONS_F B
218: where B.POSITION_ID = T.POSITION_ID
219: );
220: --
221: --

Line 237: insert into hr_all_positions_f_tl (

233: l_current_nls_language := l_position_tl.nls_language;
234:
235: End if;
236: --
237: insert into hr_all_positions_f_tl (
238: position_id
239: , name
240: , created_by
241: , creation_date