DBA Data[Home] [Help]

APPS.GHR_PA_REQUESTS_PKG dependencies on HR_ALL_POSITIONS_F

Line 71: p_position_id hr_all_positions_f.position_id%TYPE

67: -- possibly need description returned not just name?
68:
69: -- Bug#5482191 Added the function get_personnel_system_indicator
70: FUNCTION get_personnel_system_indicator(
71: p_position_id hr_all_positions_f.position_id%TYPE
72: ,p_effective_date date)
73: RETURN VARCHAR2;
74:
75: --Begin bug# 8653508

Line 77: p_position_id hr_all_positions_f.position_id%TYPE

73: RETURN VARCHAR2;
74:
75: --Begin bug# 8653508
76: FUNCTION get_flsa_category(
77: p_position_id hr_all_positions_f.position_id%TYPE
78: ,p_effective_date date default sysdate)
79: RETURN VARCHAR2;
80:
81: FUNCTION get_bargaining_unit(

Line 82: p_position_id hr_all_positions_f.position_id%TYPE

78: ,p_effective_date date default sysdate)
79: RETURN VARCHAR2;
80:
81: FUNCTION get_bargaining_unit(
82: p_position_id hr_all_positions_f.position_id%TYPE
83: ,p_effective_date date default sysdate)
84: RETURN VARCHAR2;
85:
86: FUNCTION get_work_schedule(

Line 87: p_position_id hr_all_positions_f.position_id%TYPE

83: ,p_effective_date date default sysdate)
84: RETURN VARCHAR2;
85:
86: FUNCTION get_work_schedule(
87: p_position_id hr_all_positions_f.position_id%TYPE
88: ,p_effective_date date default sysdate)
89: RETURN VARCHAR2;
90:
91: FUNCTION get_valid_grade(

Line 92: p_position_id hr_all_positions_f.position_id%TYPE

88: ,p_effective_date date default sysdate)
89: RETURN VARCHAR2;
90:
91: FUNCTION get_valid_grade(
92: p_position_id hr_all_positions_f.position_id%TYPE
93: ,p_effective_date date default sysdate)
94: RETURN VARCHAR2;
95:
96: FUNCTION get_duty_station(

Line 97: p_position_id hr_all_positions_f.position_id%TYPE

93: ,p_effective_date date default sysdate)
94: RETURN VARCHAR2;
95:
96: FUNCTION get_duty_station(
97: p_position_id hr_all_positions_f.position_id%TYPE
98: ,p_effective_date date default sysdate)
99: RETURN VARCHAR2;
100:
101: FUNCTION get_occ_series(

Line 102: p_position_id hr_all_positions_f.position_id%TYPE

98: ,p_effective_date date default sysdate)
99: RETURN VARCHAR2;
100:
101: FUNCTION get_occ_series(
102: p_position_id hr_all_positions_f.position_id%TYPE
103: ,p_effective_date date default sysdate,
104: p_business_group_id in per_assignments_f.business_group_id%type)
105: RETURN VARCHAR2;
106:

Line 108: p_position_id hr_all_positions_f.position_id%TYPE

104: p_business_group_id in per_assignments_f.business_group_id%type)
105: RETURN VARCHAR2;
106:
107: FUNCTION get_appropriation_code(
108: p_position_id hr_all_positions_f.position_id%TYPE
109: ,p_effective_date date default sysdate)
110: RETURN VARCHAR2;
111:
112: --Bug# 9647383

Line 113: FUNCTION get_pos_organization( p_position_id hr_all_positions_f.position_id%TYPE

109: ,p_effective_date date default sysdate)
110: RETURN VARCHAR2;
111:
112: --Bug# 9647383
113: FUNCTION get_pos_organization( p_position_id hr_all_positions_f.position_id%TYPE
114: ,p_effective_date date default sysdate
115: ,p_business_group_id in per_assignments_f.business_group_id%type)
116: RETURN VARCHAR2;
117: --End bug# 8653508

Line 180: PROCEDURE get_SF52_pos_ddf_details (p_position_id IN hr_all_positions_f.position_id%TYPE

176: ,p_pay_rate_determinant OUT NOCOPY varchar2
177: ,p_work_schedule OUT NOCOPY varchar2
178: ,p_part_time_hours OUT NOCOPY varchar2);
179: --
180: PROCEDURE get_SF52_pos_ddf_details (p_position_id IN hr_all_positions_f.position_id%TYPE
181: ,p_date_effective IN date default sysdate
182: ,p_flsa_category OUT NOCOPY varchar2
183: ,p_bargaining_unit_status OUT NOCOPY varchar2
184: ,p_work_schedule OUT NOCOPY varchar2

Line 209: (p_position_id IN hr_all_positions_f.position_id%TYPE

205: ,p_country OUT NOCOPY per_addresses.country%TYPE
206: ,p_territory_short_name OUT NOCOPY varchar2);
207: --
208: PROCEDURE get_SF52_to_data_elements
209: (p_position_id IN hr_all_positions_f.position_id%TYPE
210: ,p_effective_date IN date default sysdate
211: ,p_prd IN ghr_pa_requests.pay_rate_determinant%TYPE
212: ,p_grade_id IN OUT NOCOPY number
213: ,p_job_id IN OUT NOCOPY number