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
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
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
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);
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
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
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
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
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
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
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
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
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
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
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
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
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
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: );
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
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
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
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
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
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
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
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
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
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
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: --
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 >----------------------------|
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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