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_POSITION_API dependencies on PER_POSITIONS

Line 241: l_business_group_id per_positions.business_group_id%TYPE;

237: ) is
238: --
239: -- Declare cursors and local variables
240: --
241: l_business_group_id per_positions.business_group_id%TYPE;
242: l_position_definition_id per_positions.position_definition_id%TYPE
243: := p_position_definition_id;
244: l_old_position_definition_id per_positions.position_definition_id%TYPE;
245: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 242: l_position_definition_id per_positions.position_definition_id%TYPE

238: --
239: -- Declare cursors and local variables
240: --
241: l_business_group_id per_positions.business_group_id%TYPE;
242: l_position_definition_id per_positions.position_definition_id%TYPE
243: := p_position_definition_id;
244: l_old_position_definition_id per_positions.position_definition_id%TYPE;
245: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
246: l_name per_positions.name%TYPE := p_name;

Line 244: l_old_position_definition_id per_positions.position_definition_id%TYPE;

240: --
241: l_business_group_id per_positions.business_group_id%TYPE;
242: l_position_definition_id per_positions.position_definition_id%TYPE
243: := p_position_definition_id;
244: l_old_position_definition_id per_positions.position_definition_id%TYPE;
245: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
246: l_name per_positions.name%TYPE := p_name;
247: l_proc varchar2(72) ;
248: l_date_effective per_positions.date_effective%TYPE;

Line 246: l_name per_positions.name%TYPE := p_name;

242: l_position_definition_id per_positions.position_definition_id%TYPE
243: := p_position_definition_id;
244: l_old_position_definition_id per_positions.position_definition_id%TYPE;
245: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
246: l_name per_positions.name%TYPE := p_name;
247: l_proc varchar2(72) ;
248: l_date_effective per_positions.date_effective%TYPE;
249: l_date_end per_positions.date_end%TYPE;
250: --

Line 248: l_date_effective per_positions.date_effective%TYPE;

244: l_old_position_definition_id per_positions.position_definition_id%TYPE;
245: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
246: l_name per_positions.name%TYPE := p_name;
247: l_proc varchar2(72) ;
248: l_date_effective per_positions.date_effective%TYPE;
249: l_date_end per_positions.date_end%TYPE;
250: --
251: l_effective_start_date date;
252: l_effective_end_date date;

Line 249: l_date_end per_positions.date_end%TYPE;

245: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
246: l_name per_positions.name%TYPE := p_name;
247: l_proc varchar2(72) ;
248: l_date_effective per_positions.date_effective%TYPE;
249: l_date_end per_positions.date_end%TYPE;
250: --
251: l_effective_start_date date;
252: l_effective_end_date date;
253: l_active_status_id number;

Line 295: l_position_id per_positions.position_id%TYPE;

291: --
292: --
293: -- Declare additional OUT variables
294: --
295: l_position_id per_positions.position_id%TYPE;
296: --
297: cursor csr_job_bg is
298: select business_group_id
299: from per_jobs

Line 795: l_object_version_number per_positions.object_version_number%TYPE;

791: --
792: -- bug 2271064 initialize l_position_definition_id and segment variables with
793: -- values where these are passed into program.
794: --
795: l_object_version_number per_positions.object_version_number%TYPE;
796: l_proc varchar2(72);
797: l_valid_grades_changed1 boolean default FALSE;
798: l_valid_grades_changed2 boolean default FALSE;
799: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;

Line 801: l_position_definition_id per_positions.position_definition_id%TYPE

797: l_valid_grades_changed1 boolean default FALSE;
798: l_valid_grades_changed2 boolean default FALSE;
799: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
800: l_api_updating boolean;
801: l_position_definition_id per_positions.position_definition_id%TYPE
802: := p_position_definition_id;
803: l_name per_positions.name%TYPE
804: := p_name;
805: l_date_effective per_positions.date_effective%TYPE;

Line 803: l_name per_positions.name%TYPE

799: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
800: l_api_updating boolean;
801: l_position_definition_id per_positions.position_definition_id%TYPE
802: := p_position_definition_id;
803: l_name per_positions.name%TYPE
804: := p_name;
805: l_date_effective per_positions.date_effective%TYPE;
806: l_date_end per_positions.date_end%TYPE;
807: l_business_group_id per_positions.business_group_id%TYPE;

Line 805: l_date_effective per_positions.date_effective%TYPE;

801: l_position_definition_id per_positions.position_definition_id%TYPE
802: := p_position_definition_id;
803: l_name per_positions.name%TYPE
804: := p_name;
805: l_date_effective per_positions.date_effective%TYPE;
806: l_date_end per_positions.date_end%TYPE;
807: l_business_group_id per_positions.business_group_id%TYPE;
808: l_effective_start_date date;
809: l_effective_end_date date;

Line 806: l_date_end per_positions.date_end%TYPE;

802: := p_position_definition_id;
803: l_name per_positions.name%TYPE
804: := p_name;
805: l_date_effective per_positions.date_effective%TYPE;
806: l_date_end per_positions.date_end%TYPE;
807: l_business_group_id per_positions.business_group_id%TYPE;
808: l_effective_start_date date;
809: l_effective_end_date date;
810: l_effective_date date;

Line 807: l_business_group_id per_positions.business_group_id%TYPE;

803: l_name per_positions.name%TYPE
804: := p_name;
805: l_date_effective per_positions.date_effective%TYPE;
806: l_date_end per_positions.date_end%TYPE;
807: l_business_group_id per_positions.business_group_id%TYPE;
808: l_effective_start_date date;
809: l_effective_end_date date;
810: l_effective_date date;
811: --

Line 1982: l_old_position_definition_id per_positions.position_definition_id%TYPE;

1978: --
1979: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
1980: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE
1981: := p_position_definition_id;
1982: l_old_position_definition_id per_positions.position_definition_id%TYPE;
1983: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
1984: l_pos_def_id_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
1985: l_name hr_all_positions_f.name%TYPE
1986: := p_name;

Line 3712: PER_POSITIONS_PKG.maintain_valid_grades

3708: hr_psf_shd.g_old_rec.date_effective <>
3709: nvl(p_date_effective, hr_api.g_date)) THEN
3710: --
3711:
3712: PER_POSITIONS_PKG.maintain_valid_grades
3713: (p_validate => p_validate
3714: ,p_position_id => p_position_id
3715: ,p_maintenance_mode => 'DATE_EFFECTIVE'
3716: ,p_date_end => l_date_end

Line 3733: pER_POSITIONS_PKG.maintain_valid_grades

3729: IF ((nvl(p_date_end, hr_api.g_date) <> hr_api.g_date) and
3730: nvl(hr_psf_shd.g_old_rec.date_end, hr_api.g_date) <>
3731: nvl(p_date_end, hr_api.g_date)) THEN
3732: --
3733: pER_POSITIONS_PKG.maintain_valid_grades
3734: (p_validate => p_validate
3735: ,p_position_id => p_position_id
3736: ,p_maintenance_mode => 'DATE_END'
3737: ,p_date_end => l_date_end