eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PSF_UPD dependencies on HR_ALL_POSITIONS_F

Line 130: (p_base_table_name => 'hr_all_positions_f',

126: -- version number.
127: --
128: p_rec.object_version_number :=
129: dt_api.get_object_version_number
130: (p_base_table_name => 'hr_all_positions_f',
131: p_base_key_column => 'position_id',
132: p_base_key_value => p_rec.position_id);
133: --
134: --

Line 135: -- Update the hr_all_positions_f Row

131: p_base_key_column => 'position_id',
132: p_base_key_value => p_rec.position_id);
133: --
134: --
135: -- Update the hr_all_positions_f Row
136: --
137: update hr_all_positions_f
138: set
139: position_id = p_rec.position_id,

Line 137: update hr_all_positions_f

133: --
134: --
135: -- Update the hr_all_positions_f Row
136: --
137: update hr_all_positions_f
138: set
139: position_id = p_rec.position_id,
140: availability_status_id = p_rec.availability_status_id,
141: business_group_id = p_rec.business_group_id,

Line 476: from hr_all_positions_f

472: l_next_esd date;
473: -- cursor to fetch all rows of the position for update
474: cursor pos_all is
475: select date_effective
476: from hr_all_positions_f
477: where position_id = p_rec.position_id
478: for update of date_effective;
479:
480: -- cursor to fetch minimum effective_start_date

Line 483: from hr_all_positions_f

479:
480: -- cursor to fetch minimum effective_start_date
481: cursor pos_min_esd is
482: select min(effective_start_date)
483: from hr_all_positions_f
484: where position_id = p_rec.position_id ;
485:
486: -- cursor to fetch the first row
487: cursor pos_first_row(min_esd date) is

Line 489: from hr_All_positions_f

485:
486: -- cursor to fetch the first row
487: cursor pos_first_row(min_esd date) is
488: select effective_start_date
489: from hr_All_positions_f
490: where position_id = p_rec.position_id and
491: effective_start_date = l_min_esd
492: for update of effective_start_date ;
493:

Line 497: from hr_All_positions_f

493:
494: -- cursor to fetch the previous row from database current row
495: cursor pos_prev_row is
496: select effective_end_date
497: from hr_All_positions_f
498: where position_id = p_rec.position_id and
499: effective_end_date = p_validation_start_date -1
500: for update of effective_end_date ;
501:

Line 505: from hr_All_positions_f pos

501:
502: -- cursor to fetch the next active row from database
503: cursor next_active_row(p_effective_date date) is
504: select effective_start_date
505: from hr_All_positions_f pos
506: where position_id = p_rec.position_id
507: and effective_start_date > p_effective_date
508: and hr_psf_shd.get_availability_status(pos.availability_status_id
509: ,p_rec.business_group_id ) = 'ACTIVE'

Line 514: from hr_all_positions_f

510: order by effective_start_date ;
511: -- cursor to update the current row in database as effective start date is not passed to api
512: cursor current_row (p_effective_start_date date) is
513: select effective_start_date
514: from hr_all_positions_f
515: where position_id = p_rec.position_id
516: and effective_start_date = p_effective_start_date
517: for update of effective_start_date ;
518: l_chg_date_effective boolean;

Line 552: update hr_all_positions_f

548: if g_debug then
549: hr_utility.set_location('date effective change valid '||l_proc,30);
550: end if;
551: for i in pos_all loop
552: update hr_all_positions_f
553: set date_effective = p_rec.date_effective
554: where current of pos_all ;
555: end loop;
556: if hr_psf_bus.all_proposed_only_position(p_rec.position_id) then

Line 571: update hr_all_positions_f

567: end if;
568: -- date effective is less than esd of first row change the esd of first row
569: open pos_first_row(l_min_esd);
570: fetch pos_first_row into l_esd;
571: update hr_all_positions_f
572: set effective_start_date = p_rec.date_effective
573: where current of pos_first_row;
574: close pos_first_row;
575: end if;

Line 587: update hr_all_positions_f

583: if l_prev_eed is not null then
584: if g_debug then
585: hr_utility.set_location('first_active_position_row '||l_proc,55);
586: end if;
587: update hr_all_positions_f
588: set effective_end_date = p_rec.date_effective - 1
589: where current of pos_prev_row;
590: end if;
591: close pos_prev_row;

Line 598: update hr_all_positions_f

594: open current_row(hr_psf_shd.g_old_rec.effective_start_date);
595: fetch current_row into l_old_esd;
596: if l_old_esd is not null then
597: p_rec.effective_start_date := p_rec.date_effective;
598: update hr_all_positions_f
599: set effective_start_date = p_rec.date_effective
600: where current of current_row;
601: end if;
602: close current_row;

Line 703: update hr_all_positions_f

699: hr_utility.set_location('first_active_position'||l_proc, 85);
700: end if;
701: p_rec.date_effective := l_next_esd;
702: for i in pos_all loop
703: update hr_all_positions_f
704: set date_effective = p_rec.date_effective
705: where current of pos_all ;
706: end loop;
707: end if;

Line 721: update hr_all_positions_f

717: -- a proposed position changed in correction mode to active
718: -- then date_effective should be equal to effective_start_date of current row
719: p_rec.date_effective := p_validation_start_date ;
720: for i in pos_all loop
721: update hr_all_positions_f
722: set date_effective = p_rec.date_effective
723: where current of pos_all ;
724: end loop;
725: end if;

Line 734: update hr_all_positions_f

730: hr_utility.set_location('mode update_change_insert'||l_proc, 112);
731: end if;
732: p_rec.date_effective := p_effective_date ;
733: for i in pos_all loop
734: update hr_all_positions_f
735: set date_effective = p_rec.date_effective
736: where current of pos_all ;
737: end loop;
738: end if;

Line 794: from hr_all_positions_f

790: l_new_date_effective date ;
791: l_chg_date_effective boolean ;
792: cursor c1 is
793: select min(effective_start_date)
794: from hr_all_positions_f
795: where position_id = p_rec.position_id;
796:
797: -- cursor to fetch all rows of the position for update
798: cursor pos_all is

Line 800: from hr_all_positions_f

796:
797: -- cursor to fetch all rows of the position for update
798: cursor pos_all is
799: select date_effective
800: from hr_all_positions_f
801: where position_id = p_rec.position_id
802: for update of date_effective;
803:
804: -- cursor to fetch the previous row

Line 807: from hr_all_positions_f

803:
804: -- cursor to fetch the previous row
805: cursor pos_prev is
806: select effective_start_date,effective_end_date
807: from hr_all_positions_f
808: where position_id = p_rec.position_id and
809: effective_end_date = hr_psf_shd.g_old_rec.effective_start_date - 1
810: for update of effective_start_date,effective_end_date;
811:

Line 815: from hr_All_positions_f

811:
812: -- cursor to fetch the first row
813: cursor pos_first(p_min_esd date) is
814: select effective_start_date, effective_end_date
815: from hr_All_positions_f
816: where position_id = p_rec.position_id and
817: effective_start_date = p_min_esd
818: for update of effective_start_date ;
819: -- cursor to fetch ESD from current row

Line 822: from hr_All_positions_f

818: for update of effective_start_date ;
819: -- cursor to fetch ESD from current row
820: cursor pos_current(p_effective_date date) is
821: select effective_start_date
822: from hr_All_positions_f
823: where position_id = p_rec.position_id and
824: p_effective_date between effective_start_date and effective_end_date;
825: -- cursor to check active rows for the position prior to the effective_start_date of their row
826: cursor pos_active_rows(p_position_id number,p_effective_start_date date) is

Line 828: from hr_all_positions_f pos

824: p_effective_date between effective_start_date and effective_end_date;
825: -- cursor to check active rows for the position prior to the effective_start_date of their row
826: cursor pos_active_rows(p_position_id number,p_effective_start_date date) is
827: select count(*)
828: from hr_all_positions_f pos
829: where pos.position_id = p_position_id
830: and pos.effective_start_date < p_effective_start_date
831: and hr_psf_shd.get_availability_status(pos.availability_status_id
832: ,p_rec.business_group_id ) = 'ACTIVE';

Line 881: update hr_all_positions_f

877: fetch pos_current into p_rec.effective_start_date;
878: close pos_current;
879:
880: for i in pos_all loop
881: update hr_all_positions_f
882: set date_effective = p_rec.date_effective
883: where current of pos_all ;
884: end loop;
885:

Line 899: update hr_all_positions_f

895: if l_current_row_stat = 'ACTIVE' then
896: --
897: -- update effective start date of current row
898: --
899: update hr_all_positions_f
900: set effective_Start_date = p_rec.date_effective
901: where position_id = p_rec.position_id and
902: effective_start_date = hr_psf_shd.g_old_rec.effective_start_date;
903: if sql%rowcount = 0 then

Line 914: update hr_all_positions_f

910: p_rec.effective_start_date := p_rec.date_effective;
911: --
912: -- update previous row's effective_end_date
913: for j in pos_prev loop
914: update hr_all_positions_f
915: set effective_end_date = p_rec.date_effective - 1
916: where current of pos_prev ;
917: end loop;
918: end if;

Line 944: update hr_All_positions_f

940: to_char(k.effective_start_date) || l_proc, 110);
941: hr_utility.set_location('p_rec.effective_start_date = ' ||
942: to_char(p_rec.effective_start_date) || l_proc, 110);
943: end if;
944: update hr_All_positions_f
945: set effective_Start_Date = p_rec.date_effective
946: where current of pos_first ;
947:
948: if p_rec.effective_start_date = k.effective_start_date then