[Home] [Help]
PACKAGE: APPS.PER_QH_POPULATE
Source
1 package per_qh_populate AUTHID CURRENT_USER as
2 /* $Header: peqhpopl.pkh 120.0.12020000.1 2012/06/29 01:56:46 appldev ship $ */
3 -- ----------------------------------------------------------------------------
4 -- |---------------------------< get_location >----------------------------|
5 -- ----------------------------------------------------------------------------
6 --
7 function get_location
8 (p_location_id number) return varchar2;
9 --
10 -- ----------------------------------------------------------------------------
11 -- |---------------------------< get_organization >----------------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 function get_organization
15 (p_organization_id number) return varchar2;
16 --
17 -- ----------------------------------------------------------------------------
18 -- |---------------------------< get_job >----------------------------|
19 -- ----------------------------------------------------------------------------
20 --
21 function get_job
22 (p_job_id number) return varchar2;
23 --
24 -- ----------------------------------------------------------------------------
25 -- |---------------------------< get_position >----------------------------|
26 -- ----------------------------------------------------------------------------
27 --
28 function get_position
29 (p_position_id number
30 ,p_effective_date date) return varchar2;
31 --
32 -- ----------------------------------------------------------------------------
33 -- |---------------------------< get_salary_basis >----------------------------|
34 -- ----------------------------------------------------------------------------
35 --
36 procedure get_salary_basis
37 (p_pay_basis_id IN number
38 ,p_pay_basis OUT NOCOPY varchar2
39 ,p_pay_basis_meaning OUT NOCOPY VARCHAR2
40 ,p_salary_basis OUT NOCOPY VARCHAR2);
41 --
42 -- ----------------------------------------------------------------------------
43 -- |---------------------------< get_payroll >----------------------------|
44 -- ----------------------------------------------------------------------------
45 --
46 function get_payroll
47 (p_payroll_id number
48 ,p_effective_date date) return varchar2;
49 --
50 -- ----------------------------------------------------------------------------
51 -- |---------------------------< get_full_name >----------------------------|
52 -- ----------------------------------------------------------------------------
53 --
54 function get_full_name
55 (p_person_id number
56 ,p_effective_date date) return varchar2;
57 --
58 -- ----------------------------------------------------------------------------
59 -- |-----------------< get_supervisor_assgn_number >--------------------------|
60 -- ----------------------------------------------------------------------------
61 --
62 function get_supervisor_assgn_number
63 (p_supervisor_assgn_id number
64 ,p_business_group_id number) return varchar2;
65 --
66 -- ----------------------------------------------------------------------------
67 -- |---------------------------< get_grade >----------------------------|
68 -- ----------------------------------------------------------------------------
69 --
70 function get_grade
71 (p_grade_id number) return varchar2;
72 --
73 -- ----------------------------------------------------------------------------
74 -- |---------------------------< get_grade_lddder >---------------------------|
75 -- ----------------------------------------------------------------------------
76 --
77 function get_grade_ladder
78 (p_grade_ladder_pgm_id number
79 ,p_effective_date date) return varchar2;
80 --
81 -- ----------------------------------------------------------------------------
82 -- |---------------------------< get_bg_defaults >----------------------------|
83 -- ----------------------------------------------------------------------------
84 --
85 procedure get_bg_defaults
86 (p_business_group_id IN per_business_groups.business_group_id%type
87 ,p_defaulting IN varchar2
88 ,p_time_normal_start OUT NOCOPY per_all_assignments_f.time_normal_start%type
89 ,p_time_normal_finish OUT NOCOPY per_all_assignments_f.time_normal_finish%type
90 ,p_normal_hours OUT NOCOPY per_all_assignments_f.normal_hours%type
91 ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
92 ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
93 ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
94 ,p_location OUT NOCOPY hr_locations.location_code%type
95 ,p_gre OUT NOCOPY hr_soft_coding_keyflex.segment1%type);
96 --
97 -- ----------------------------------------------------------------------------
98 -- |--------------------------< get_pos_defaults >----------------------------|
99 -- ----------------------------------------------------------------------------
100 --
101 procedure get_pos_defaults
102 (p_position_id IN per_all_assignments_f.position_id%type
103 ,p_effective_date IN date
104 ,p_defaulting IN varchar2
105 ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
106 ,p_organization OUT NOCOPY hr_organization_units.name%type
107 ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
108 ,p_job OUT NOCOPY per_jobs.name%type
109 ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
110 ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
111 ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
112 ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
113 ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
114 ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
115 ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
116 ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
117 ,p_location OUT NOCOPY hr_locations.location_code%type
118 ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
119 ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
120 ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
121 ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
122 ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
123 ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
124 ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
125 ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
126 ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
127 ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
128 ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
129 ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
130 ,p_grade OUT NOCOPY per_grades.name%type
131 ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
132 ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
133 );
134 --
135 -- ----------------------------------------------------------------------------
136 -- |--------------------------< get_org_defaults >----------------------------|
137 -- ----------------------------------------------------------------------------
138 --
139 procedure get_org_defaults
140 (p_organization_id IN per_all_assignments_f.organization_id%type
141 ,p_defaulting IN varchar2
142 ,p_effective_date IN date
143 ,p_vacancy_id IN OUT NOCOPY per_vacancies.vacancy_id%type
144 ,p_vacancy IN OUT NOCOPY per_vacancies.name%type
145 ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
146 ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
147 ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
148 ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
149 ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
150 ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
151 ,p_location OUT NOCOPY hr_locations.location_code%type
152 ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
153 ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
154 ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
155 ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
156 ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
157 ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
158 ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
159 ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
160 ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
161 ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
162 ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
163 ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
164 );
165 --
166 -- ----------------------------------------------------------------------------
167 -- |--------------------------< get_vac_defaults >----------------------------|
168 -- ----------------------------------------------------------------------------
169 --
170 procedure get_vac_defaults
171 (p_vacancy_id IN per_all_assignments_f.vacancy_id%type
172 ,p_defaulting IN varchar2
173 ,p_effective_date IN date
174 ,p_recruiter_id IN OUT NOCOPY per_all_assignments_f.recruiter_id%type
175 ,p_recruiter OUT NOCOPY per_all_people_f.full_name%type
176 ,p_grade_id IN OUT NOCOPY per_all_assignments_f.grade_id%type
177 ,p_grade OUT NOCOPY per_grades.name%type
178 ,p_position_id IN OUT NOCOPY per_all_assignments_f.position_id%type
179 ,p_position OUT NOCOPY hr_all_positions_f.name%type
180 ,p_job_id IN OUT NOCOPY per_all_assignments_f.job_id%type
181 ,p_job OUT NOCOPY per_jobs.name%type
182 ,p_location_id IN OUT NOCOPY per_all_assignments_f.location_id%type
183 ,p_location OUT NOCOPY hr_locations.location_code%type
184 ,p_organization_id IN OUT NOCOPY per_all_assignments_f.organization_id%type
185 ,p_organization OUT NOCOPY hr_organization_units.name%type
186 ,p_time_normal_start IN OUT NOCOPY per_all_assignments_f.time_normal_start%type
187 ,p_time_normal_finish IN OUT NOCOPY per_all_assignments_f.time_normal_finish%type
188 ,p_normal_hours IN OUT NOCOPY per_all_assignments_f.normal_hours%type
189 ,p_frequency IN OUT NOCOPY per_all_assignments_f.frequency%type
190 ,p_frequency_meaning OUT NOCOPY hr_lookups.meaning%type
191 ,p_probation_period IN OUT NOCOPY per_all_assignments_f.probation_period%type
192 ,p_probation_unit IN OUT NOCOPY per_all_assignments_f.probation_unit%type
193 ,p_probation_unit_meaning OUT NOCOPY hr_lookups.meaning%type
194 ,p_pay_basis_id IN OUT NOCOPY per_all_assignments_f.pay_basis_id%type
195 ,p_salary_basis OUT NOCOPY per_pay_bases.name%type
196 ,p_pay_basis OUT NOCOPY per_pay_bases.pay_basis%type
197 ,p_pay_basis_meaning OUT NOCOPY hr_lookups.meaning%type
198 ,p_payroll_id IN OUT NOCOPY per_all_assignments_f.payroll_id%type
199 ,p_payroll OUT NOCOPY pay_all_payrolls_f.payroll_name%type
200 ,p_supervisor_id IN OUT NOCOPY per_all_assignments_f.supervisor_id%type
201 ,p_supervisor OUT NOCOPY per_all_people_f.full_name%type
202 ,p_bargaining_unit IN OUT NOCOPY per_all_assignments_f.bargaining_unit_code%type
203 ,p_bargaining_unit_meaning OUT NOCOPY hr_lookups.meaning%type
204 ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%type
205 ,p_pgp_segment1 OUT NOCOPY pay_people_groups.segment1%type
206 ,p_pgp_segment2 OUT NOCOPY pay_people_groups.segment2%type
207 ,p_pgp_segment3 OUT NOCOPY pay_people_groups.segment3%type
208 ,p_pgp_segment4 OUT NOCOPY pay_people_groups.segment4%type
209 ,p_pgp_segment5 OUT NOCOPY pay_people_groups.segment5%type
210 ,p_pgp_segment6 OUT NOCOPY pay_people_groups.segment6%type
211 ,p_pgp_segment7 OUT NOCOPY pay_people_groups.segment7%type
212 ,p_pgp_segment8 OUT NOCOPY pay_people_groups.segment8%type
213 ,p_pgp_segment9 OUT NOCOPY pay_people_groups.segment9%type
214 ,p_pgp_segment10 OUT NOCOPY pay_people_groups.segment10%type
215 ,p_pgp_segment11 OUT NOCOPY pay_people_groups.segment11%type
216 ,p_pgp_segment12 OUT NOCOPY pay_people_groups.segment12%type
217 ,p_pgp_segment13 OUT NOCOPY pay_people_groups.segment13%type
218 ,p_pgp_segment14 OUT NOCOPY pay_people_groups.segment14%type
219 ,p_pgp_segment15 OUT NOCOPY pay_people_groups.segment15%type
220 ,p_pgp_segment16 OUT NOCOPY pay_people_groups.segment16%type
221 ,p_pgp_segment17 OUT NOCOPY pay_people_groups.segment17%type
222 ,p_pgp_segment18 OUT NOCOPY pay_people_groups.segment18%type
223 ,p_pgp_segment19 OUT NOCOPY pay_people_groups.segment19%type
224 ,p_pgp_segment20 OUT NOCOPY pay_people_groups.segment20%type
225 ,p_pgp_segment21 OUT NOCOPY pay_people_groups.segment21%type
226 ,p_pgp_segment22 OUT NOCOPY pay_people_groups.segment22%type
227 ,p_pgp_segment23 OUT NOCOPY pay_people_groups.segment23%type
228 ,p_pgp_segment24 OUT NOCOPY pay_people_groups.segment24%type
229 ,p_pgp_segment25 OUT NOCOPY pay_people_groups.segment25%type
230 ,p_pgp_segment26 OUT NOCOPY pay_people_groups.segment26%type
231 ,p_pgp_segment27 OUT NOCOPY pay_people_groups.segment27%type
232 ,p_pgp_segment28 OUT NOCOPY pay_people_groups.segment28%type
233 ,p_pgp_segment29 OUT NOCOPY pay_people_groups.segment29%type
234 ,p_pgp_segment30 OUT NOCOPY pay_people_groups.segment30%type
235 );
236
237 end per_qh_populate;