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.GHR_VALIDATE_PERWSDPO dependencies on PER_POSITION_EXTRA_INFO

Line 29: l_pos_desc_id per_position_extra_info.poei_information5%type :=null;

25:
26: procedure validate_perwsdpo (p_position_id in number,
27: p_effective_date in date ) IS
28:
29: l_pos_desc_id per_position_extra_info.poei_information5%type :=null;
30: l_date_from per_position_extra_info.poei_information3%type :=null;
31: l_date_to per_position_extra_info.poei_information4%type :=null;
32: l_FLSA_DDF per_position_extra_info.poei_information7%type :=null;
33: l_position_occ_DDF per_position_extra_info.poei_information3%type :=null;

Line 30: l_date_from per_position_extra_info.poei_information3%type :=null;

26: procedure validate_perwsdpo (p_position_id in number,
27: p_effective_date in date ) IS
28:
29: l_pos_desc_id per_position_extra_info.poei_information5%type :=null;
30: l_date_from per_position_extra_info.poei_information3%type :=null;
31: l_date_to per_position_extra_info.poei_information4%type :=null;
32: l_FLSA_DDF per_position_extra_info.poei_information7%type :=null;
33: l_position_occ_DDF per_position_extra_info.poei_information3%type :=null;
34: l_super_status_DDF per_position_extra_info.poei_information16%type :=null;

Line 31: l_date_to per_position_extra_info.poei_information4%type :=null;

27: p_effective_date in date ) IS
28:
29: l_pos_desc_id per_position_extra_info.poei_information5%type :=null;
30: l_date_from per_position_extra_info.poei_information3%type :=null;
31: l_date_to per_position_extra_info.poei_information4%type :=null;
32: l_FLSA_DDF per_position_extra_info.poei_information7%type :=null;
33: l_position_occ_DDF per_position_extra_info.poei_information3%type :=null;
34: l_super_status_DDF per_position_extra_info.poei_information16%type :=null;
35: l_position_sens_DDF per_position_extra_info.poei_information13%type :=null;

Line 32: l_FLSA_DDF per_position_extra_info.poei_information7%type :=null;

28:
29: l_pos_desc_id per_position_extra_info.poei_information5%type :=null;
30: l_date_from per_position_extra_info.poei_information3%type :=null;
31: l_date_to per_position_extra_info.poei_information4%type :=null;
32: l_FLSA_DDF per_position_extra_info.poei_information7%type :=null;
33: l_position_occ_DDF per_position_extra_info.poei_information3%type :=null;
34: l_super_status_DDF per_position_extra_info.poei_information16%type :=null;
35: l_position_sens_DDF per_position_extra_info.poei_information13%type :=null;
36: l_compet_level_DDF per_position_extra_info.poei_information9%type :=null;

Line 33: l_position_occ_DDF per_position_extra_info.poei_information3%type :=null;

29: l_pos_desc_id per_position_extra_info.poei_information5%type :=null;
30: l_date_from per_position_extra_info.poei_information3%type :=null;
31: l_date_to per_position_extra_info.poei_information4%type :=null;
32: l_FLSA_DDF per_position_extra_info.poei_information7%type :=null;
33: l_position_occ_DDF per_position_extra_info.poei_information3%type :=null;
34: l_super_status_DDF per_position_extra_info.poei_information16%type :=null;
35: l_position_sens_DDF per_position_extra_info.poei_information13%type :=null;
36: l_compet_level_DDF per_position_extra_info.poei_information9%type :=null;
37: l_working_title_DDF per_position_extra_info.poei_information12%type :=null;

Line 34: l_super_status_DDF per_position_extra_info.poei_information16%type :=null;

30: l_date_from per_position_extra_info.poei_information3%type :=null;
31: l_date_to per_position_extra_info.poei_information4%type :=null;
32: l_FLSA_DDF per_position_extra_info.poei_information7%type :=null;
33: l_position_occ_DDF per_position_extra_info.poei_information3%type :=null;
34: l_super_status_DDF per_position_extra_info.poei_information16%type :=null;
35: l_position_sens_DDF per_position_extra_info.poei_information13%type :=null;
36: l_compet_level_DDF per_position_extra_info.poei_information9%type :=null;
37: l_working_title_DDF per_position_extra_info.poei_information12%type :=null;
38: l_valide_grade_DDF per_position_extra_info.poei_information3%type :=null;

Line 35: l_position_sens_DDF per_position_extra_info.poei_information13%type :=null;

31: l_date_to per_position_extra_info.poei_information4%type :=null;
32: l_FLSA_DDF per_position_extra_info.poei_information7%type :=null;
33: l_position_occ_DDF per_position_extra_info.poei_information3%type :=null;
34: l_super_status_DDF per_position_extra_info.poei_information16%type :=null;
35: l_position_sens_DDF per_position_extra_info.poei_information13%type :=null;
36: l_compet_level_DDF per_position_extra_info.poei_information9%type :=null;
37: l_working_title_DDF per_position_extra_info.poei_information12%type :=null;
38: l_valide_grade_DDF per_position_extra_info.poei_information3%type :=null;
39: l_job_id per_jobs.job_id%type:=null;

Line 36: l_compet_level_DDF per_position_extra_info.poei_information9%type :=null;

32: l_FLSA_DDF per_position_extra_info.poei_information7%type :=null;
33: l_position_occ_DDF per_position_extra_info.poei_information3%type :=null;
34: l_super_status_DDF per_position_extra_info.poei_information16%type :=null;
35: l_position_sens_DDF per_position_extra_info.poei_information13%type :=null;
36: l_compet_level_DDF per_position_extra_info.poei_information9%type :=null;
37: l_working_title_DDF per_position_extra_info.poei_information12%type :=null;
38: l_valide_grade_DDF per_position_extra_info.poei_information3%type :=null;
39: l_job_id per_jobs.job_id%type:=null;
40: l_business_group_id per_positions.business_group_id%type :=null;

Line 37: l_working_title_DDF per_position_extra_info.poei_information12%type :=null;

33: l_position_occ_DDF per_position_extra_info.poei_information3%type :=null;
34: l_super_status_DDF per_position_extra_info.poei_information16%type :=null;
35: l_position_sens_DDF per_position_extra_info.poei_information13%type :=null;
36: l_compet_level_DDF per_position_extra_info.poei_information9%type :=null;
37: l_working_title_DDF per_position_extra_info.poei_information12%type :=null;
38: l_valide_grade_DDF per_position_extra_info.poei_information3%type :=null;
39: l_job_id per_jobs.job_id%type:=null;
40: l_business_group_id per_positions.business_group_id%type :=null;
41: l_occ_series_KF varchar2(150) :=null;

Line 38: l_valide_grade_DDF per_position_extra_info.poei_information3%type :=null;

34: l_super_status_DDF per_position_extra_info.poei_information16%type :=null;
35: l_position_sens_DDF per_position_extra_info.poei_information13%type :=null;
36: l_compet_level_DDF per_position_extra_info.poei_information9%type :=null;
37: l_working_title_DDF per_position_extra_info.poei_information12%type :=null;
38: l_valide_grade_DDF per_position_extra_info.poei_information3%type :=null;
39: l_job_id per_jobs.job_id%type:=null;
40: l_business_group_id per_positions.business_group_id%type :=null;
41: l_occ_series_KF varchar2(150) :=null;
42:

Line 43: l_pay_table_id_DDF per_position_extra_info.poei_information5%type :=null;

39: l_job_id per_jobs.job_id%type:=null;
40: l_business_group_id per_positions.business_group_id%type :=null;
41: l_occ_series_KF varchar2(150) :=null;
42:
43: l_pay_table_id_DDF per_position_extra_info.poei_information5%type :=null;
44: l_pay_basis_DDF per_position_extra_info.poei_information6%type :=null;
45: l_Per_office_id_DDF per_position_extra_info.poei_information3%type :=null;
46: l_BU_Status_DDF per_position_extra_info.poei_information8%type :=null;
47: l_Work_Schedule_DDF per_position_extra_info.poei_information10%type :=null;

Line 44: l_pay_basis_DDF per_position_extra_info.poei_information6%type :=null;

40: l_business_group_id per_positions.business_group_id%type :=null;
41: l_occ_series_KF varchar2(150) :=null;
42:
43: l_pay_table_id_DDF per_position_extra_info.poei_information5%type :=null;
44: l_pay_basis_DDF per_position_extra_info.poei_information6%type :=null;
45: l_Per_office_id_DDF per_position_extra_info.poei_information3%type :=null;
46: l_BU_Status_DDF per_position_extra_info.poei_information8%type :=null;
47: l_Work_Schedule_DDF per_position_extra_info.poei_information10%type :=null;
48:

Line 45: l_Per_office_id_DDF per_position_extra_info.poei_information3%type :=null;

41: l_occ_series_KF varchar2(150) :=null;
42:
43: l_pay_table_id_DDF per_position_extra_info.poei_information5%type :=null;
44: l_pay_basis_DDF per_position_extra_info.poei_information6%type :=null;
45: l_Per_office_id_DDF per_position_extra_info.poei_information3%type :=null;
46: l_BU_Status_DDF per_position_extra_info.poei_information8%type :=null;
47: l_Work_Schedule_DDF per_position_extra_info.poei_information10%type :=null;
48:
49: l_FLSA_table ghr_position_descriptions.FLSA%type :=null;

Line 46: l_BU_Status_DDF per_position_extra_info.poei_information8%type :=null;

42:
43: l_pay_table_id_DDF per_position_extra_info.poei_information5%type :=null;
44: l_pay_basis_DDF per_position_extra_info.poei_information6%type :=null;
45: l_Per_office_id_DDF per_position_extra_info.poei_information3%type :=null;
46: l_BU_Status_DDF per_position_extra_info.poei_information8%type :=null;
47: l_Work_Schedule_DDF per_position_extra_info.poei_information10%type :=null;
48:
49: l_FLSA_table ghr_position_descriptions.FLSA%type :=null;
50: l_position_occ_table ghr_position_descriptions.position_status%type :=null;

Line 47: l_Work_Schedule_DDF per_position_extra_info.poei_information10%type :=null;

43: l_pay_table_id_DDF per_position_extra_info.poei_information5%type :=null;
44: l_pay_basis_DDF per_position_extra_info.poei_information6%type :=null;
45: l_Per_office_id_DDF per_position_extra_info.poei_information3%type :=null;
46: l_BU_Status_DDF per_position_extra_info.poei_information8%type :=null;
47: l_Work_Schedule_DDF per_position_extra_info.poei_information10%type :=null;
48:
49: l_FLSA_table ghr_position_descriptions.FLSA%type :=null;
50: l_position_occ_table ghr_position_descriptions.position_status%type :=null;
51: l_super_status_table ghr_position_descriptions.position_is%type :=null;

Line 62: from per_position_extra_info poei

58: l_occ_series_table ghr_pd_classifications.occupational_code%type :=null;
59:
60: cursor c_pos_extra_info is
61: select poei.poei_information3,poei.poei_information4,poei.poei_information5
62: from per_position_extra_info poei
63: where poei.position_id=p_position_id and poei.information_type='GHR_US_POSITION_DESCRIPTION';
64:
65: cursor c_pos_extra_info_DDF1 is
66: select poei.poei_information3,poei.poei_information7

Line 70: from per_position_extra_info poei

66: select poei.poei_information3,poei.poei_information7
67: ,poei.poei_information8,poei.poei_information10
68: ,poei.poei_information16,poei.poei_information13
69: ,poei.poei_information9,poei.poei_information12
70: from per_position_extra_info poei
71: where poei.position_id=p_position_id
72: and poei.information_type='GHR_US_POS_GRP1';
73:
74: cursor c_pos_extra_info_DDF2 is

Line 76: from per_position_extra_info poei

72: and poei.information_type='GHR_US_POS_GRP1';
73:
74: cursor c_pos_extra_info_DDF2 is
75: select poei.poei_information3
76: from per_position_extra_info poei
77: where poei.position_id=p_position_id and poei.information_type='GHR_US_POS_GRP2';
78:
79: cursor c_pos_extra_info_DDF3 is
80: select poei.poei_information3,poei.poei_information5,poei.poei_information6

Line 81: from per_position_extra_info poei

77: where poei.position_id=p_position_id and poei.information_type='GHR_US_POS_GRP2';
78:
79: cursor c_pos_extra_info_DDF3 is
80: select poei.poei_information3,poei.poei_information5,poei.poei_information6
81: from per_position_extra_info poei
82: where poei.position_id=p_position_id and poei.information_type='GHR_US_POS_VALID_GRADE';
83:
84: cursor c_pos_table is
85: select pos.job_id, pos.business_group_id

Line 249: l_expire_date PER_POSITION_EXTRA_INFO.POEI_INFORMATION3%type;

245: ,p_date in date)
246: RETURN BOOLEAN IS
247: --
248: l_chk_position_obligated boolean :=false;
249: l_expire_date PER_POSITION_EXTRA_INFO.POEI_INFORMATION3%type;
250: l_obligate_type PER_POSITION_EXTRA_INFO.POEI_INFORMATION4%type;
251: l_pos_ei_data PER_POSITION_EXTRA_INFO%ROWTYPE;
252:
253: BEGIN

Line 250: l_obligate_type PER_POSITION_EXTRA_INFO.POEI_INFORMATION4%type;

246: RETURN BOOLEAN IS
247: --
248: l_chk_position_obligated boolean :=false;
249: l_expire_date PER_POSITION_EXTRA_INFO.POEI_INFORMATION3%type;
250: l_obligate_type PER_POSITION_EXTRA_INFO.POEI_INFORMATION4%type;
251: l_pos_ei_data PER_POSITION_EXTRA_INFO%ROWTYPE;
252:
253: BEGIN
254:

Line 251: l_pos_ei_data PER_POSITION_EXTRA_INFO%ROWTYPE;

247: --
248: l_chk_position_obligated boolean :=false;
249: l_expire_date PER_POSITION_EXTRA_INFO.POEI_INFORMATION3%type;
250: l_obligate_type PER_POSITION_EXTRA_INFO.POEI_INFORMATION4%type;
251: l_pos_ei_data PER_POSITION_EXTRA_INFO%ROWTYPE;
252:
253: BEGIN
254:
255: ghr_history_fetch.fetch_positionei (p_position_id => p_position_id