APPS.PER_REFRESH_POSITION dependencies on PER_ALL_POSITIONS

Line 91: from per_all_positions

87: l_object_version_number number := p_object_version_number;
88: --
89: cursor c_ovn(p_position_id number) is
90: select object_version_number
91: from per_all_positions
92: where position_id = p_position_id;
93: begin
94: --
95: hr_utility.set_location('Entering : '||l_proc, 10);

Line 497: -- call per_all_positions api.

493: --
494: l_rowid := rec.rowid ;
495: l_position_id := rec.position_id ;
496: l_object_version_number := rec.object_version_number;
497: -- call per_all_positions api.
498: if (check_position_table(rec.position_id, l_object_version_number)) then
499: --
500: hr_utility.set_location(l_proc||' Lock per_all_positions api call ', 20);
501: --

Line 500: hr_utility.set_location(l_proc||' Lock per_all_positions api call ', 20);

496: l_object_version_number := rec.object_version_number;
497: -- call per_all_positions api.
498: if (check_position_table(rec.position_id, l_object_version_number)) then
499: --
500: hr_utility.set_location(l_proc||' Lock per_all_positions api call ', 20);
501: --
502: begin
503: -- lock
504: if p_full_hr = 'N' or rec.effective_start_date <= p_refresh_date then

Line 509: hr_utility.set_location(l_proc||' upd per_all_positions api call ', 30);

505:
506: per_pos_shd.lck(p_position_id => rec.position_id
507: , p_object_version_number => l_object_version_number);
508: --
509: hr_utility.set_location(l_proc||' upd per_all_positions api call ', 30);
510: --
511: per_pos_upd.upd
512: (p_position_id => rec.position_id
513: ,p_successor_position_id => rec.successor_position_id

Line 604: hr_utility.set_location(l_proc||' insert per_all_positions api call ', 50);

600: hr_utility.set_location(l_proc, 50);
601: --
602: begin
603: --
604: hr_utility.set_location(l_proc||' insert per_all_positions api call ', 50);
605: --
606: per_pos_ins.ins
607: (p_position_id => rec.position_id
608: ,p_business_group_id => rec.business_group_id

Line 680: hr_utility.set_location(l_proc||' after ins per_all_positions ', 50);

676: if p_effective_date between rec.effective_start_date and rec.effective_end_date then
677: p_object_version_number := l_object_version_number;
678: end if;
679: --
680: hr_utility.set_location(l_proc||' after ins per_all_positions ', 50);
681: --
682: exception
683: when others then
684: hr_utility.set_location(l_proc||' When Others raised ', 50);

Line 738: from per_all_positions p

734:
735: l_ovn number := 0;
736: cursor c_chk_pos is
737: select object_version_number
738: from per_all_positions p
739: where position_id = p_position_id
740: and position_id not in ( select position_id from hr_all_positions_f where position_id = p_position_id) ;
741: begin
742: hr_utility.set_location('Entering:'||g_package||'refresh_position_purge', 600);

Line 791: -- following update is put in place for Non HR Products who refers per_all_positions

787: -- purge position if purged from hr_all_positions_f
788: --
789: refresh_position_purge(p_position_id => p_position_id);
790: --
791: -- following update is put in place for Non HR Products who refers per_all_positions
792: --
793: update per_all_positions
794: set date_end = hr_general.get_position_date_end(position_id)
795: where position_id = p_position_id;

Line 793: update per_all_positions

789: refresh_position_purge(p_position_id => p_position_id);
790: --
791: -- following update is put in place for Non HR Products who refers per_all_positions
792: --
793: update per_all_positions
794: set date_end = hr_general.get_position_date_end(position_id)
795: where position_id = p_position_id;
796: --
797: hr_utility.set_location('Entering:'||g_package||'refresh_single_position', 500);