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 HR_ALL_POSITIONS_F

Line 31: from hr_all_positions_f

27: AND SYSTEM_TYPE_CD = 'ELIMINATED';
28: --
29: cursor c3 is
30: select object_version_number, position_definition_id, name
31: from hr_all_positions_f
32: where position_id = p_position_id
33: and p_effective_date between effective_start_date and effective_end_date;
34: --
35: l_ovn number;

Line 125: from hr_all_positions_f

121: SELECT 'x'
122: from dual
123: where exists (
124: select null
125: from hr_all_positions_f
126: where position_definition_id = p_position_definition_id)
127: or exists (
128: select null
129: from per_all_positions

Line 612: from hr_all_positions_f

608: --
609: function get_dt_position_ovn (p_position_id number, p_effective_date date)
610: return number is
611: cursor c1 is select object_version_number
612: from hr_all_positions_f
613: where position_id = p_position_id
614: and p_effective_date between effective_start_date
615: and effective_end_date ;
616: l_proc varchar2(72);

Line 671: from hr_all_Positions_f

667: l_deleted varchar2(10):='N';
668: l_eot date:= TO_DATE('31/12/4712','DD/MM/YYYY');
669: cursor c2 is
670: select position_id, effective_start_date, effective_end_date, availability_status_id
671: from hr_all_Positions_f
672: where position_id = p_position_id
673: order by effective_start_date desc
674: for update;
675: r2 c2%rowtype;

Line 689: delete hr_all_positions_f

685: --
686: if c2%found then
687: l_system_availability_status := system_availability_status(r2.availability_status_id);
688: if l_system_availability_status = 'ELIMINATED' then
689: delete hr_all_positions_f
690: where current of c2;
691: l_deleted := 'Y';
692: end if;
693: end if;

Line 697: update hr_all_positions_f

693: end if;
694: if l_deleted = 'Y' then
695: fetch c2 into r2;
696: if c2%found then
697: update hr_all_positions_f
698: set effective_end_date = l_eot
699: where current of c2;
700: end if;
701: end if;

Line 858: from hr_all_positions_f

854: --
855: cursor get_curr_esd ( p_position_id in number) is
856: select
857: max(effective_start_date)
858: from hr_all_positions_f
859: where position_id = p_position_id and
860: nvl(copied_to_old_table_flag, 'N') = 'Y';
861: --
862: -- bug 2271064 get per_position_definitions segment values where

Line 1246: from hr_all_positions_f

1242: --
1243: function get_dt_position_esd (p_position_id number)
1244: return date is
1245: cursor c1 is select min(effective_start_date)
1246: from hr_all_positions_f
1247: where position_id = p_position_id;
1248: l_proc varchar2(72) ;
1249: l_esd date;
1250: begin

Line 1620: (p_position_id in hr_all_positions_f.position_id%TYPE

1616: --
1617: -- Procedure synchronize_per_all_positions
1618: --
1619: Procedure synchronize_per_all_positions
1620: (p_position_id in hr_all_positions_f.position_id%TYPE
1621: ,p_effective_date in date
1622: ,p_datetrack_mode in varchar2
1623: ,p_object_version_number in out nocopy hr_all_positions_f.object_version_number%TYPE
1624: ) is

Line 1623: ,p_object_version_number in out nocopy hr_all_positions_f.object_version_number%TYPE

1619: Procedure synchronize_per_all_positions
1620: (p_position_id in hr_all_positions_f.position_id%TYPE
1621: ,p_effective_date in date
1622: ,p_datetrack_mode in varchar2
1623: ,p_object_version_number in out nocopy hr_all_positions_f.object_version_number%TYPE
1624: ) is
1625:
1626: --
1627: l_ovn number;

Line 1757: update hr_all_positions_f

1753: hr_utility.set_location(l_proc, 90);
1754: end if;
1755: --
1756: -- update copied_to_old_position_flag in all the following rows
1757: update hr_all_positions_f
1758: set copied_to_old_table_flag = 'N'
1759: where position_id = p_position_id and
1760: effective_end_date >
1761: decode( p_datetrack_mode

Line 1971: l_position_id hr_all_positions_f.position_id%TYPE;

1967: ) is
1968: --
1969: -- Declare cursors and local variables
1970: --
1971: l_position_id hr_all_positions_f.position_id%TYPE;
1972: l_effective_start_date hr_all_positions_f.effective_start_date%TYPE;
1973: l_effective_end_date hr_all_positions_f.effective_end_date%TYPE;
1974: l_proc varchar2(72) ;
1975: l_object_version_number hr_all_positions_f.object_version_number%TYPE;

Line 1972: l_effective_start_date hr_all_positions_f.effective_start_date%TYPE;

1968: --
1969: -- Declare cursors and local variables
1970: --
1971: l_position_id hr_all_positions_f.position_id%TYPE;
1972: l_effective_start_date hr_all_positions_f.effective_start_date%TYPE;
1973: l_effective_end_date hr_all_positions_f.effective_end_date%TYPE;
1974: l_proc varchar2(72) ;
1975: l_object_version_number hr_all_positions_f.object_version_number%TYPE;
1976: --

Line 1973: l_effective_end_date hr_all_positions_f.effective_end_date%TYPE;

1969: -- Declare cursors and local variables
1970: --
1971: l_position_id hr_all_positions_f.position_id%TYPE;
1972: l_effective_start_date hr_all_positions_f.effective_start_date%TYPE;
1973: l_effective_end_date hr_all_positions_f.effective_end_date%TYPE;
1974: l_proc varchar2(72) ;
1975: l_object_version_number hr_all_positions_f.object_version_number%TYPE;
1976: --
1977: l_language_code fnd_languages.language_code%TYPE;

Line 1975: l_object_version_number hr_all_positions_f.object_version_number%TYPE;

1971: l_position_id hr_all_positions_f.position_id%TYPE;
1972: l_effective_start_date hr_all_positions_f.effective_start_date%TYPE;
1973: l_effective_end_date hr_all_positions_f.effective_end_date%TYPE;
1974: l_proc varchar2(72) ;
1975: l_object_version_number hr_all_positions_f.object_version_number%TYPE;
1976: --
1977: l_language_code fnd_languages.language_code%TYPE;
1978: --
1979: l_business_group_id hr_all_positions_f.business_group_id%TYPE;

Line 1979: l_business_group_id hr_all_positions_f.business_group_id%TYPE;

1975: l_object_version_number hr_all_positions_f.object_version_number%TYPE;
1976: --
1977: l_language_code fnd_languages.language_code%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;

Line 1980: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE

1976: --
1977: l_language_code fnd_languages.language_code%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;

Line 1985: l_name hr_all_positions_f.name%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;
1987: l_date_effective hr_all_positions_f.date_effective%TYPE;
1988: l_date_end hr_all_positions_f.date_end%TYPE;
1989: --

Line 1987: l_date_effective hr_all_positions_f.date_effective%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;
1987: l_date_effective hr_all_positions_f.date_effective%TYPE;
1988: l_date_end hr_all_positions_f.date_end%TYPE;
1989: --
1990: l_active_status_id number;
1991: l_availability_Status_id number;

Line 1988: l_date_end hr_all_positions_f.date_end%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;
1987: l_date_effective hr_all_positions_f.date_effective%TYPE;
1988: l_date_end hr_all_positions_f.date_end%TYPE;
1989: --
1990: l_active_status_id number;
1991: l_availability_Status_id number;
1992: l_copied_to_old_table_flag varchar2(30):='N';

Line 1996: l_dummy hr_all_positions_f.object_version_number%TYPE;

1992: l_copied_to_old_table_flag varchar2(30):='N';
1993: l_retcode varchar2(2000);
1994: l_errbuf varchar2(2000);
1995: l_view_all_positions_flag varchar2(30);
1996: l_dummy hr_all_positions_f.object_version_number%TYPE;
1997: --
1998: -- bug 2271064 set up segments as local variables
1999: --
2000: l_segment1 varchar2(60) := p_segment1;

Line 3158: l_object_version_number hr_all_positions_f.object_version_number%TYPE;

3154: --
3155: -- Declare cursors and local variables
3156: --
3157: l_proc varchar2(72) ;
3158: l_object_version_number hr_all_positions_f.object_version_number%TYPE;
3159: l_effective_start_date hr_all_positions_f.effective_start_date%TYPE;
3160: l_effective_end_date hr_all_positions_f.effective_end_date%TYPE;
3161: --
3162: l_language_code fnd_languages.language_code%TYPE;

Line 3159: l_effective_start_date hr_all_positions_f.effective_start_date%TYPE;

3155: -- Declare cursors and local variables
3156: --
3157: l_proc varchar2(72) ;
3158: l_object_version_number hr_all_positions_f.object_version_number%TYPE;
3159: l_effective_start_date hr_all_positions_f.effective_start_date%TYPE;
3160: l_effective_end_date hr_all_positions_f.effective_end_date%TYPE;
3161: --
3162: l_language_code fnd_languages.language_code%TYPE;
3163: --

Line 3160: l_effective_end_date hr_all_positions_f.effective_end_date%TYPE;

3156: --
3157: l_proc varchar2(72) ;
3158: l_object_version_number hr_all_positions_f.object_version_number%TYPE;
3159: l_effective_start_date hr_all_positions_f.effective_start_date%TYPE;
3160: l_effective_end_date hr_all_positions_f.effective_end_date%TYPE;
3161: --
3162: l_language_code fnd_languages.language_code%TYPE;
3163: --
3164: l_valid_grades_changed1 boolean default FALSE;

Line 3168: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE := p_position_definition_id;

3164: l_valid_grades_changed1 boolean default FALSE;
3165: l_valid_grades_changed2 boolean default FALSE;
3166: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3167: l_api_updating boolean;
3168: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE := p_position_definition_id;
3169: l_name hr_all_positions_f.name%TYPE
3170: := p_name;
3171: l_date_effective hr_all_positions_f.date_effective%TYPE;
3172: l_date_end hr_all_positions_f.date_end%TYPE;

Line 3169: l_name hr_all_positions_f.name%TYPE

3165: l_valid_grades_changed2 boolean default FALSE;
3166: l_flex_num fnd_id_flex_segments.id_flex_num%TYPE;
3167: l_api_updating boolean;
3168: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE := p_position_definition_id;
3169: l_name hr_all_positions_f.name%TYPE
3170: := p_name;
3171: l_date_effective hr_all_positions_f.date_effective%TYPE;
3172: l_date_end hr_all_positions_f.date_end%TYPE;
3173: l_business_group_id hr_all_positions_f.business_group_id%TYPE;

Line 3171: l_date_effective hr_all_positions_f.date_effective%TYPE;

3167: l_api_updating boolean;
3168: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE := p_position_definition_id;
3169: l_name hr_all_positions_f.name%TYPE
3170: := p_name;
3171: l_date_effective hr_all_positions_f.date_effective%TYPE;
3172: l_date_end hr_all_positions_f.date_end%TYPE;
3173: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
3174: l_minesd date;
3175: l_ovn number;

Line 3172: l_date_end hr_all_positions_f.date_end%TYPE;

3168: l_position_definition_id hr_all_positions_f.position_definition_id%TYPE := p_position_definition_id;
3169: l_name hr_all_positions_f.name%TYPE
3170: := p_name;
3171: l_date_effective hr_all_positions_f.date_effective%TYPE;
3172: l_date_end hr_all_positions_f.date_end%TYPE;
3173: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
3174: l_minesd date;
3175: l_ovn number;
3176: l_esd date;

Line 3173: l_business_group_id hr_all_positions_f.business_group_id%TYPE;

3169: l_name hr_all_positions_f.name%TYPE
3170: := p_name;
3171: l_date_effective hr_all_positions_f.date_effective%TYPE;
3172: l_date_end hr_all_positions_f.date_end%TYPE;
3173: l_business_group_id hr_all_positions_f.business_group_id%TYPE;
3174: l_minesd date;
3175: l_ovn number;
3176: l_esd date;
3177: l_eed date;

Line 3221: from hr_all_positions_f

3217: where pd.position_definition_id = l_position_definition_id;
3218: --
3219: cursor csr_isfirstrow is
3220: select min(effective_start_date)
3221: from hr_all_positions_f
3222: where position_id = p_position_id;
3223: --
3224: -- bug 2271064 get per_position_definitions segment values where
3225: -- position_definition_id is known

Line 3694: -- explicitly lock the hr_all_positions_f row.

3690: end if;
3691: /*
3692: --
3693: -- Because we may need to maintain the valid grade dates, need to
3694: -- explicitly lock the hr_all_positions_f row.
3695: --
3696: -- hr_psf_shd.lck(p_position_id => p_position_id
3697: -- ,p_object_version_number => l_object_version_number);
3698: --

Line 4119: -- explicitly lock the hr_all_positions_f row.

4115: end if;
4116: -- ----------- Maintain Grade requirements to be investigated
4117: --
4118: -- Because we may need to maintain the valid grade dates, need to
4119: -- explicitly lock the hr_all_positions_f row.
4120: --
4121: -- hr_psf_shd.lck(p_position_id => p_position_id
4122: -- ,p_object_version_number => l_object_version_number);
4123: --

Line 4249: l_object_version_number hr_all_positions_f.object_version_number%TYPE;

4245: --
4246: -- Declare cursors and local variables
4247: --
4248: l_proc varchar2(72) ;
4249: l_object_version_number hr_all_positions_f.object_version_number%TYPE;
4250: l_effective_start_date hr_all_positions_f.effective_start_date%TYPE;
4251: l_effective_end_date hr_all_positions_f.effective_end_date%TYPE;
4252: --
4253: l_view_all_positions_flag varchar2(30);

Line 4250: l_effective_start_date hr_all_positions_f.effective_start_date%TYPE;

4246: -- Declare cursors and local variables
4247: --
4248: l_proc varchar2(72) ;
4249: l_object_version_number hr_all_positions_f.object_version_number%TYPE;
4250: l_effective_start_date hr_all_positions_f.effective_start_date%TYPE;
4251: l_effective_end_date hr_all_positions_f.effective_end_date%TYPE;
4252: --
4253: l_view_all_positions_flag varchar2(30);
4254: --

Line 4251: l_effective_end_date hr_all_positions_f.effective_end_date%TYPE;

4247: --
4248: l_proc varchar2(72) ;
4249: l_object_version_number hr_all_positions_f.object_version_number%TYPE;
4250: l_effective_start_date hr_all_positions_f.effective_start_date%TYPE;
4251: l_effective_end_date hr_all_positions_f.effective_end_date%TYPE;
4252: --
4253: l_view_all_positions_flag varchar2(30);
4254: --
4255: cursor c1 is

Line 4334: from hr_all_positions_f

4330: declare
4331: --
4332: cursor c_position_definition(p_position_id number) is
4333: select position_definition_id
4334: from hr_all_positions_f
4335: where position_id = p_position_id;
4336: --
4337: l_position_definition_id number;
4338: l_pos_def_deleted boolean;

Line 4532: from hr_all_positions_f psf, per_position_definitions pd

4528: procedure regenerate_position_name(p_position_id number) is
4529: cursor c_position(p_position_id number) is
4530: select psf.effective_start_date, psf.position_definition_id,
4531: psf.object_version_number, pd.id_flex_num
4532: from hr_all_positions_f psf, per_position_definitions pd
4533: where position_id = p_position_id
4534: and psf.position_definition_id = pd.position_definition_id
4535: and effective_end_date = hr_api.g_eot;
4536: --

Line 4594: from hr_all_positions_f psf

4590: p_organization_id number) is
4591: --
4592: cursor c_all_positions is
4593: select psf.position_id
4594: from hr_all_positions_f psf
4595: where psf.effective_end_date = hr_api.g_eot;
4596: --
4597: cursor c_bg_positions(p_business_group_id number) is
4598: select psf.position_id

Line 4599: from hr_all_positions_f psf

4595: where psf.effective_end_date = hr_api.g_eot;
4596: --
4597: cursor c_bg_positions(p_business_group_id number) is
4598: select psf.position_id
4599: from hr_all_positions_f psf
4600: where psf.business_group_id = p_business_group_id
4601: and psf.effective_end_date = hr_api.g_eot;
4602: --
4603: cursor c_org_positions(p_organization_id number) is

Line 4605: from hr_all_positions_f psf

4601: and psf.effective_end_date = hr_api.g_eot;
4602: --
4603: cursor c_org_positions(p_organization_id number) is
4604: select psf.position_id
4605: from hr_all_positions_f psf
4606: where psf.organization_id = p_organization_id
4607: and psf.effective_end_date = hr_api.g_eot;
4608: --
4609: l_position_id number;