DBA Data[Home] [Help]

APPS.HR_PFT_UPD dependencies on HR_ALL_POSITIONS_F

Line 66: -- Update the hr_all_positions_f_tl Row

62: --
63: --
64: --
65: --
66: -- Update the hr_all_positions_f_tl Row
67: --
68: update hr_all_positions_f_tl
69: set
70: position_id = p_rec.position_id

Line 68: update hr_all_positions_f_tl

64: --
65: --
66: -- Update the hr_all_positions_f_tl Row
67: --
68: update hr_all_positions_f_tl
69: set
70: position_id = p_rec.position_id
71: ,language = p_rec.language
72: ,source_lang = p_rec.source_lang

Line 208: (p_module_name => 'HR_ALL_POSITIONS_F_TL'

204: --
205: when hr_api.cannot_find_prog_unit then
206: --
207: hr_api.cannot_find_prog_unit_error
208: (p_module_name => 'HR_ALL_POSITIONS_F_TL'
209: ,p_hook_type => 'AU');
210: --
211: end;
212: --

Line 418: --When generated name is null, use hr_all_positions_f.name

414: , l_language.id_flex_num
415: , p_position_definition_id
416: );
417:
418: --When generated name is null, use hr_all_positions_f.name
419: if l_pft_rec.name is null then
420: begin
421: select psf.name into l_pft_rec.name
422: from hr_all_positions_f psf

Line 422: from hr_all_positions_f psf

418: --When generated name is null, use hr_all_positions_f.name
419: if l_pft_rec.name is null then
420: begin
421: select psf.name into l_pft_rec.name
422: from hr_all_positions_f psf
423: where psf.position_id = p_position_id
424: and psf.effective_end_date = hr_general.end_of_time;
425: exception
426: when others then

Line 460: from hr_all_positions_f_tl pft

456: -- source_lang match the specified language.
457: --
458: cursor csr_upd_langs is
459: select pft.language
460: from hr_all_positions_f_tl pft
461: where pft.position_id = p_position_id
462: and p_language_code in (pft.language
463: ,pft.source_lang);
464: --