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.PER_QH_MAINTAIN_UPDATE dependencies on PER_ALL_ASSIGNMENTS_F

Line 6: p_qh_organization_id per_all_assignments_f.organization_id%TYPE default NULL;

2: /* $Header: peqhmnti.pkh 120.5.12020000.1 2012/06/29 01:56:39 appldev ship $ */
3:
4: -- Fix For Bug 8246722 Starts--
5:
6: p_qh_organization_id per_all_assignments_f.organization_id%TYPE default NULL;
7:
8: -- Fix For Bug 8246722 Ends--
9:
10: PROCEDURE insert_maintain_data

Line 36: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925

32: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
33: --CWK
34: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
35: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
36: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925
37: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
38: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
39: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
40: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE

Line 37: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE

33: --CWK
34: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
35: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
36: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925
37: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
38: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
39: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
40: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
41: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE

Line 39: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE

35: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
36: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925
37: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
38: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
39: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
40: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
41: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
42: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
43: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE

Line 40: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE

36: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925
37: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
38: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
39: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
40: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
41: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
42: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
43: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
44: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE

Line 41: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE

37: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
38: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
39: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
40: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
41: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
42: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
43: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
44: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
45: ,p_project_title IN per_all_assignments_f.project_title%TYPE

Line 42: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE

38: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
39: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
40: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
41: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
42: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
43: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
44: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
45: ,p_project_title IN per_all_assignments_f.project_title%TYPE
46: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE

Line 43: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE

39: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
40: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
41: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
42: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
43: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
44: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
45: ,p_project_title IN per_all_assignments_f.project_title%TYPE
46: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
47: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE

Line 44: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE

40: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
41: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
42: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
43: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
44: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
45: ,p_project_title IN per_all_assignments_f.project_title%TYPE
46: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
47: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
48: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE

Line 45: ,p_project_title IN per_all_assignments_f.project_title%TYPE

41: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
42: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
43: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
44: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
45: ,p_project_title IN per_all_assignments_f.project_title%TYPE
46: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
47: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
48: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
49: ,p_rate_value IN pay_grade_rules_f.value%TYPE

Line 166: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE

162: ,p_party_id IN per_all_people_f.party_id%TYPE default null
163: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
164: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
165: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
166: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
167: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
168: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
169: ,p_asg_validation_start_date OUT NOCOPY DATE
170: ,p_asg_validation_end_date OUT NOCOPY DATE

Line 167: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

163: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
164: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
165: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
166: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
167: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
168: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
169: ,p_asg_validation_start_date OUT NOCOPY DATE
170: ,p_asg_validation_end_date OUT NOCOPY DATE
171: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE

Line 168: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

164: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
165: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
166: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
167: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
168: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
169: ,p_asg_validation_start_date OUT NOCOPY DATE
170: ,p_asg_validation_end_date OUT NOCOPY DATE
171: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
172: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE

Line 171: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE

167: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
168: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
169: ,p_asg_validation_start_date OUT NOCOPY DATE
170: ,p_asg_validation_end_date OUT NOCOPY DATE
171: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
172: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
173: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
174: ,p_position_id IN per_all_assignments_f.position_id%TYPE
175: ,p_job_id IN per_all_assignments_f.job_id%TYPE

Line 172: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE

168: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
169: ,p_asg_validation_start_date OUT NOCOPY DATE
170: ,p_asg_validation_end_date OUT NOCOPY DATE
171: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
172: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
173: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
174: ,p_position_id IN per_all_assignments_f.position_id%TYPE
175: ,p_job_id IN per_all_assignments_f.job_id%TYPE
176: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

Line 173: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE

169: ,p_asg_validation_start_date OUT NOCOPY DATE
170: ,p_asg_validation_end_date OUT NOCOPY DATE
171: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
172: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
173: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
174: ,p_position_id IN per_all_assignments_f.position_id%TYPE
175: ,p_job_id IN per_all_assignments_f.job_id%TYPE
176: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
177: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE

Line 174: ,p_position_id IN per_all_assignments_f.position_id%TYPE

170: ,p_asg_validation_end_date OUT NOCOPY DATE
171: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
172: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
173: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
174: ,p_position_id IN per_all_assignments_f.position_id%TYPE
175: ,p_job_id IN per_all_assignments_f.job_id%TYPE
176: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
177: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
178: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE

Line 175: ,p_job_id IN per_all_assignments_f.job_id%TYPE

171: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
172: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
173: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
174: ,p_position_id IN per_all_assignments_f.position_id%TYPE
175: ,p_job_id IN per_all_assignments_f.job_id%TYPE
176: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
177: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
178: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
179: ,p_location_id IN per_all_assignments_f.location_id%TYPE

Line 176: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

172: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
173: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
174: ,p_position_id IN per_all_assignments_f.position_id%TYPE
175: ,p_job_id IN per_all_assignments_f.job_id%TYPE
176: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
177: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
178: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
179: ,p_location_id IN per_all_assignments_f.location_id%TYPE
180: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE

Line 178: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE

174: ,p_position_id IN per_all_assignments_f.position_id%TYPE
175: ,p_job_id IN per_all_assignments_f.job_id%TYPE
176: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
177: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
178: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
179: ,p_location_id IN per_all_assignments_f.location_id%TYPE
180: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
181: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
182: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE

Line 179: ,p_location_id IN per_all_assignments_f.location_id%TYPE

175: ,p_job_id IN per_all_assignments_f.job_id%TYPE
176: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
177: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
178: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
179: ,p_location_id IN per_all_assignments_f.location_id%TYPE
180: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
181: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
182: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
183: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE

Line 180: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE

176: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
177: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
178: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
179: ,p_location_id IN per_all_assignments_f.location_id%TYPE
180: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
181: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
182: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
183: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
184: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE

Line 181: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE

177: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
178: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
179: ,p_location_id IN per_all_assignments_f.location_id%TYPE
180: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
181: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
182: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
183: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
184: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
185: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE

Line 182: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE

178: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
179: ,p_location_id IN per_all_assignments_f.location_id%TYPE
180: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
181: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
182: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
183: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
184: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
185: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
186: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE

Line 183: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE

179: ,p_location_id IN per_all_assignments_f.location_id%TYPE
180: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
181: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
182: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
183: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
184: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
185: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
186: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
187: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE

Line 184: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE

180: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
181: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
182: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
183: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
184: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
185: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
186: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
187: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
188: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE

Line 185: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE

181: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
182: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
183: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
184: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
185: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
186: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
187: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
188: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
189: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE

Line 216: ,p_people_group_id OUT NOCOPY per_all_assignments_f.people_group_id%TYPE

212: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
213: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
214: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
215: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
216: ,p_people_group_id OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
217: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
218: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
219: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
220: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE

Line 247: ,p_soft_coding_keyflex_id OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE

243: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
244: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
245: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
246: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
247: ,p_soft_coding_keyflex_id OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
248: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
249: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
250: ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
251: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE

Line 248: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE

244: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
245: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
246: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
247: ,p_soft_coding_keyflex_id OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
248: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
249: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
250: ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
251: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
252: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE

Line 249: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE

245: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
246: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
247: ,p_soft_coding_keyflex_id OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
248: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
249: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
250: ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
251: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
252: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
253: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE

Line 250: ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE

246: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
247: ,p_soft_coding_keyflex_id OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
248: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
249: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
250: ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
251: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
252: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
253: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
254: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE

Line 251: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE

247: ,p_soft_coding_keyflex_id OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
248: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
249: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
250: ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
251: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
252: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
253: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
254: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
255: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE

Line 252: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE

248: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
249: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
250: ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
251: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
252: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
253: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
254: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
255: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
256: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE

Line 253: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE

249: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
250: ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
251: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
252: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
253: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
254: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
255: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
256: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
257: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE

Line 254: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE

250: ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
251: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
252: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
253: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
254: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
255: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
256: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
257: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
258: ,p_frequency IN per_all_assignments_f.frequency%TYPE

Line 255: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE

251: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
252: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
253: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
254: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
255: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
256: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
257: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
258: ,p_frequency IN per_all_assignments_f.frequency%TYPE
259: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE

Line 256: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE

252: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
253: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
254: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
255: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
256: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
257: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
258: ,p_frequency IN per_all_assignments_f.frequency%TYPE
259: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
260: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE

Line 257: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE

253: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
254: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
255: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
256: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
257: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
258: ,p_frequency IN per_all_assignments_f.frequency%TYPE
259: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
260: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE
261: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE

Line 258: ,p_frequency IN per_all_assignments_f.frequency%TYPE

254: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
255: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
256: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
257: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
258: ,p_frequency IN per_all_assignments_f.frequency%TYPE
259: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
260: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE
261: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
262: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE

Line 259: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE

255: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
256: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
257: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
258: ,p_frequency IN per_all_assignments_f.frequency%TYPE
259: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
260: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE
261: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
262: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
263: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE

Line 260: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE

256: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
257: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
258: ,p_frequency IN per_all_assignments_f.frequency%TYPE
259: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
260: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE
261: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
262: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
263: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
264: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE

Line 261: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE

257: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
258: ,p_frequency IN per_all_assignments_f.frequency%TYPE
259: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
260: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE
261: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
262: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
263: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
264: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
265: --

Line 262: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE

258: ,p_frequency IN per_all_assignments_f.frequency%TYPE
259: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
260: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE
261: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
262: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
263: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
264: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
265: --
266: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE

Line 263: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE

259: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
260: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE
261: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
262: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
263: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
264: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
265: --
266: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
267: ,p_billing_title IN per_all_assignments_f.title%type

Line 264: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE

260: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE
261: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
262: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
263: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
264: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
265: --
266: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
267: ,p_billing_title IN per_all_assignments_f.title%type
268: --

Line 266: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE

262: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
263: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
264: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
265: --
266: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
267: ,p_billing_title IN per_all_assignments_f.title%type
268: --
269: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
270: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE

Line 267: ,p_billing_title IN per_all_assignments_f.title%type

263: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
264: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
265: --
266: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
267: ,p_billing_title IN per_all_assignments_f.title%type
268: --
269: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
270: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
271: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE

Line 269: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE

265: --
266: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
267: ,p_billing_title IN per_all_assignments_f.title%type
268: --
269: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
270: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
271: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
272: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
273: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE

Line 270: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE

266: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
267: ,p_billing_title IN per_all_assignments_f.title%type
268: --
269: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
270: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
271: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
272: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
273: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
274: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE

Line 271: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE

267: ,p_billing_title IN per_all_assignments_f.title%type
268: --
269: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
270: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
271: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
272: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
273: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
274: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
275: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE

Line 272: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE

268: --
269: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
270: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
271: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
272: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
273: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
274: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
275: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
276: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE

Line 273: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE

269: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
270: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
271: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
272: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
273: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
274: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
275: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
276: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
277: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE

Line 274: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE

270: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
271: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
272: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
273: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
274: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
275: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
276: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
277: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
278: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE

Line 275: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE

271: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
272: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
273: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
274: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
275: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
276: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
277: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
278: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
279: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE

Line 276: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE

272: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
273: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
274: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
275: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
276: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
277: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
278: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
279: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
280: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE

Line 277: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE

273: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
274: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
275: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
276: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
277: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
278: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
279: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
280: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
281: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE

Line 278: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE

274: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
275: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
276: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
277: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
278: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
279: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
280: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
281: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
282: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE

Line 279: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE

275: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
276: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
277: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
278: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
279: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
280: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
281: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
282: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
283: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE

Line 280: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE

276: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
277: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
278: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
279: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
280: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
281: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
282: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
283: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
284: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE

Line 281: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE

277: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
278: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
279: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
280: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
281: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
282: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
283: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
284: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
285: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE

Line 282: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE

278: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
279: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
280: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
281: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
282: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
283: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
284: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
285: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
286: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE

Line 283: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE

279: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
280: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
281: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
282: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
283: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
284: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
285: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
286: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
287: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE

Line 284: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE

280: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
281: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
282: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
283: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
284: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
285: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
286: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
287: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
288: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE

Line 285: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE

281: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
282: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
283: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
284: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
285: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
286: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
287: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
288: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
289: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE

Line 286: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE

282: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
283: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
284: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
285: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
286: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
287: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
288: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
289: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
290: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE

Line 287: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE

283: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
284: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
285: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
286: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
287: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
288: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
289: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
290: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
291: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE

Line 288: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE

284: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
285: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
286: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
287: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
288: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
289: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
290: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
291: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
292: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE

Line 289: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE

285: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
286: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
287: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
288: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
289: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
290: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
291: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
292: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
293: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE

Line 290: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE

286: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
287: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
288: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
289: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
290: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
291: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
292: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
293: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
294: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE

Line 291: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE

287: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
288: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
289: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
290: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
291: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
292: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
293: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
294: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
295: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE

Line 292: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE

288: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
289: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
290: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
291: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
292: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
293: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
294: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
295: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
296: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE

Line 293: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE

289: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
290: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
291: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
292: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
293: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
294: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
295: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
296: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
297: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE

Line 294: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE

290: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
291: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
292: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
293: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
294: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
295: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
296: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
297: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
298: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE

Line 295: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE

291: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
292: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
293: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
294: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
295: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
296: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
297: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
298: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
299: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE

Line 296: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE

292: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
293: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
294: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
295: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
296: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
297: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
298: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
299: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
300: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE

Line 297: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE

293: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
294: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
295: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
296: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
297: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
298: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
299: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
300: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
301: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE

Line 298: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE

294: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
295: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
296: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
297: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
298: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
299: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
300: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
301: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
302: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

Line 299: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE

295: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
296: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
297: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
298: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
299: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
300: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
301: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
302: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
303: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE

Line 300: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE

296: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
297: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
298: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
299: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
300: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
301: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
302: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
303: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
304: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE

Line 301: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE

297: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
298: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
299: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
300: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
301: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
302: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
303: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
304: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
305: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE

Line 302: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

298: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
299: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
300: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
301: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
302: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
303: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
304: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
305: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
306: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE

Line 303: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE

299: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
300: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
301: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
302: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
303: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
304: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
305: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
306: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
307: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

Line 304: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE

300: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
301: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
302: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
303: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
304: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
305: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
306: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
307: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
308: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE

Line 305: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE

301: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
302: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
303: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
304: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
305: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
306: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
307: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
308: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
309: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE

Line 306: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE

302: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
303: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
304: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
305: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
306: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
307: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
308: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
309: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
310: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE

Line 307: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

303: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
304: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
305: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
306: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
307: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
308: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
309: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
310: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
311: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE

Line 308: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE

304: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
305: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
306: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
307: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
308: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
309: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
310: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
311: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
312: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE

Line 309: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE

305: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
306: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
307: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
308: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
309: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
310: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
311: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
312: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
313: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE

Line 310: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE

306: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
307: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
308: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
309: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
310: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
311: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
312: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
313: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
314: ,p_source_type IN per_all_assignments_f.source_type%TYPE

Line 311: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE

307: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
308: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
309: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
310: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
311: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
312: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
313: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
314: ,p_source_type IN per_all_assignments_f.source_type%TYPE
315: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE

Line 312: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE

308: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
309: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
310: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
311: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
312: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
313: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
314: ,p_source_type IN per_all_assignments_f.source_type%TYPE
315: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
316: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE

Line 313: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE

309: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
310: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
311: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
312: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
313: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
314: ,p_source_type IN per_all_assignments_f.source_type%TYPE
315: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
316: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
317: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE

Line 314: ,p_source_type IN per_all_assignments_f.source_type%TYPE

310: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
311: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
312: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
313: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
314: ,p_source_type IN per_all_assignments_f.source_type%TYPE
315: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
316: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
317: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
318: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE

Line 315: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE

311: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
312: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
313: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
314: ,p_source_type IN per_all_assignments_f.source_type%TYPE
315: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
316: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
317: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
318: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
319: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE

Line 316: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE

312: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
313: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
314: ,p_source_type IN per_all_assignments_f.source_type%TYPE
315: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
316: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
317: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
318: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
319: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
320: --Bug 3063591 Start Here

Line 317: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE

313: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
314: ,p_source_type IN per_all_assignments_f.source_type%TYPE
315: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
316: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
317: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
318: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
319: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
320: --Bug 3063591 Start Here
321: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null

Line 318: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE

314: ,p_source_type IN per_all_assignments_f.source_type%TYPE
315: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
316: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
317: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
318: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
319: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
320: --Bug 3063591 Start Here
321: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
322: --Bug 3063591 End Here

Line 319: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE

315: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
316: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
317: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
318: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
319: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
320: --Bug 3063591 Start Here
321: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
322: --Bug 3063591 End Here
323: ,p_application_id OUT NOCOPY per_applications.application_id%TYPE

Line 321: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null

317: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
318: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
319: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
320: --Bug 3063591 Start Here
321: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
322: --Bug 3063591 End Here
323: ,p_application_id OUT NOCOPY per_applications.application_id%TYPE
324: -- Bug 3900299 Starts Here
325: ,p_app_date_received IN OUT NOCOPY per_applications.date_received%TYPE

Line 759: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE

755: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
756: --CWK
757: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
758: ,p_npw_number IN per_all_people_f.npw_number%TYPE
759: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
760: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
761: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
762: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
763: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE

Line 760: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE

756: --CWK
757: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
758: ,p_npw_number IN per_all_people_f.npw_number%TYPE
759: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
760: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
761: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
762: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
763: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
764: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE

Line 762: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE

758: ,p_npw_number IN per_all_people_f.npw_number%TYPE
759: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
760: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
761: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
762: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
763: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
764: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
765: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
766: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE

Line 763: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE

759: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
760: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
761: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
762: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
763: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
764: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
765: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
766: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
767: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE

Line 764: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE

760: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
761: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
762: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
763: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
764: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
765: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
766: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
767: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
768: ,p_project_title IN per_all_assignments_f.project_title%TYPE

Line 765: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE

761: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
762: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
763: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
764: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
765: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
766: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
767: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
768: ,p_project_title IN per_all_assignments_f.project_title%TYPE
769: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE

Line 766: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE

762: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
763: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
764: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
765: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
766: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
767: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
768: ,p_project_title IN per_all_assignments_f.project_title%TYPE
769: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
770: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE

Line 767: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE

763: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
764: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
765: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
766: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
767: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
768: ,p_project_title IN per_all_assignments_f.project_title%TYPE
769: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
770: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
771: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE

Line 768: ,p_project_title IN per_all_assignments_f.project_title%TYPE

764: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
765: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
766: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
767: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
768: ,p_project_title IN per_all_assignments_f.project_title%TYPE
769: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
770: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
771: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
772: ,p_rate_value IN pay_grade_rules_f.value%TYPE

Line 887: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE

883: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
884: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
885: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
886: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
887: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
888: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
889: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
890: ,p_asg_validation_start_date OUT NOCOPY DATE
891: ,p_asg_validation_end_date OUT NOCOPY DATE

Line 888: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE

884: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
885: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
886: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
887: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
888: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
889: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
890: ,p_asg_validation_start_date OUT NOCOPY DATE
891: ,p_asg_validation_end_date OUT NOCOPY DATE
892: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE

Line 889: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE

885: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
886: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
887: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
888: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
889: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
890: ,p_asg_validation_start_date OUT NOCOPY DATE
891: ,p_asg_validation_end_date OUT NOCOPY DATE
892: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
893: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE

Line 892: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE

888: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
889: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
890: ,p_asg_validation_start_date OUT NOCOPY DATE
891: ,p_asg_validation_end_date OUT NOCOPY DATE
892: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
893: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
894: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
895: ,p_position_id IN per_all_assignments_f.position_id%TYPE
896: ,p_job_id IN per_all_assignments_f.job_id%TYPE

Line 893: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE

889: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
890: ,p_asg_validation_start_date OUT NOCOPY DATE
891: ,p_asg_validation_end_date OUT NOCOPY DATE
892: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
893: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
894: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
895: ,p_position_id IN per_all_assignments_f.position_id%TYPE
896: ,p_job_id IN per_all_assignments_f.job_id%TYPE
897: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

Line 894: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE

890: ,p_asg_validation_start_date OUT NOCOPY DATE
891: ,p_asg_validation_end_date OUT NOCOPY DATE
892: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
893: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
894: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
895: ,p_position_id IN per_all_assignments_f.position_id%TYPE
896: ,p_job_id IN per_all_assignments_f.job_id%TYPE
897: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
898: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE

Line 895: ,p_position_id IN per_all_assignments_f.position_id%TYPE

891: ,p_asg_validation_end_date OUT NOCOPY DATE
892: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
893: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
894: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
895: ,p_position_id IN per_all_assignments_f.position_id%TYPE
896: ,p_job_id IN per_all_assignments_f.job_id%TYPE
897: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
898: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
899: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE

Line 896: ,p_job_id IN per_all_assignments_f.job_id%TYPE

892: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
893: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
894: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
895: ,p_position_id IN per_all_assignments_f.position_id%TYPE
896: ,p_job_id IN per_all_assignments_f.job_id%TYPE
897: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
898: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
899: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
900: ,p_location_id IN per_all_assignments_f.location_id%TYPE

Line 897: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

893: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
894: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
895: ,p_position_id IN per_all_assignments_f.position_id%TYPE
896: ,p_job_id IN per_all_assignments_f.job_id%TYPE
897: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
898: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
899: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
900: ,p_location_id IN per_all_assignments_f.location_id%TYPE
901: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE

Line 899: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE

895: ,p_position_id IN per_all_assignments_f.position_id%TYPE
896: ,p_job_id IN per_all_assignments_f.job_id%TYPE
897: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
898: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
899: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
900: ,p_location_id IN per_all_assignments_f.location_id%TYPE
901: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
902: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
903: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE

Line 900: ,p_location_id IN per_all_assignments_f.location_id%TYPE

896: ,p_job_id IN per_all_assignments_f.job_id%TYPE
897: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
898: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
899: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
900: ,p_location_id IN per_all_assignments_f.location_id%TYPE
901: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
902: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
903: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
904: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE

Line 901: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE

897: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
898: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
899: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
900: ,p_location_id IN per_all_assignments_f.location_id%TYPE
901: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
902: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
903: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
904: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
905: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE

Line 902: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE

898: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
899: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
900: ,p_location_id IN per_all_assignments_f.location_id%TYPE
901: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
902: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
903: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
904: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
905: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
906: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE

Line 903: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE

899: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
900: ,p_location_id IN per_all_assignments_f.location_id%TYPE
901: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
902: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
903: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
904: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
905: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
906: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
907: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE

Line 904: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE

900: ,p_location_id IN per_all_assignments_f.location_id%TYPE
901: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
902: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
903: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
904: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
905: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
906: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
907: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
908: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE

Line 905: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE

901: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
902: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
903: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
904: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
905: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
906: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
907: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
908: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
909: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE

Line 906: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE

902: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
903: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
904: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
905: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
906: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
907: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
908: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
909: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
910: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE

Line 937: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE

933: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
934: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
935: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
936: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
937: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
938: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
939: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
940: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
941: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE

Line 968: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE

964: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
965: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
966: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
967: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
968: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
969: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
970: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
971: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
972: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE

Line 969: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE

965: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
966: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
967: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
968: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
969: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
970: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
971: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
972: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
973: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE

Line 970: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE

966: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
967: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
968: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
969: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
970: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
971: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
972: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
973: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
974: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE

Line 971: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE

967: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
968: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
969: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
970: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
971: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
972: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
973: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
974: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
975: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE

Line 972: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE

968: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
969: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
970: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
971: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
972: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
973: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
974: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
975: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
976: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE

Line 973: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE

969: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
970: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
971: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
972: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
973: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
974: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
975: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
976: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
977: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE

Line 974: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE

970: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
971: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
972: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
973: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
974: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
975: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
976: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
977: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
978: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE

Line 975: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE

971: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
972: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
973: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
974: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
975: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
976: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
977: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
978: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
979: ,p_frequency IN per_all_assignments_f.frequency%TYPE

Line 976: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE

972: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
973: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
974: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
975: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
976: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
977: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
978: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
979: ,p_frequency IN per_all_assignments_f.frequency%TYPE
980: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE

Line 977: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE

973: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
974: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
975: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
976: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
977: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
978: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
979: ,p_frequency IN per_all_assignments_f.frequency%TYPE
980: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
981: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE

Line 978: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE

974: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
975: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
976: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
977: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
978: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
979: ,p_frequency IN per_all_assignments_f.frequency%TYPE
980: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
981: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
982: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE

Line 979: ,p_frequency IN per_all_assignments_f.frequency%TYPE

975: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
976: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
977: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
978: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
979: ,p_frequency IN per_all_assignments_f.frequency%TYPE
980: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
981: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
982: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
983: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE

Line 980: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE

976: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
977: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
978: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
979: ,p_frequency IN per_all_assignments_f.frequency%TYPE
980: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
981: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
982: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
983: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
984: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE

Line 981: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE

977: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
978: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
979: ,p_frequency IN per_all_assignments_f.frequency%TYPE
980: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
981: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
982: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
983: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
984: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
985: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE

Line 982: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE

978: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
979: ,p_frequency IN per_all_assignments_f.frequency%TYPE
980: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
981: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
982: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
983: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
984: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
985: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
986: --

Line 983: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE

979: ,p_frequency IN per_all_assignments_f.frequency%TYPE
980: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
981: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
982: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
983: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
984: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
985: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
986: --
987: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE

Line 984: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE

980: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
981: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
982: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
983: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
984: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
985: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
986: --
987: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
988: ,p_billing_title IN per_all_assignments_f.title%type

Line 985: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE

981: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
982: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
983: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
984: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
985: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
986: --
987: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
988: ,p_billing_title IN per_all_assignments_f.title%type
989: --

Line 987: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE

983: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
984: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
985: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
986: --
987: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
988: ,p_billing_title IN per_all_assignments_f.title%type
989: --
990: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
991: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE

Line 988: ,p_billing_title IN per_all_assignments_f.title%type

984: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
985: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
986: --
987: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
988: ,p_billing_title IN per_all_assignments_f.title%type
989: --
990: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
991: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
992: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE

Line 990: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE

986: --
987: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
988: ,p_billing_title IN per_all_assignments_f.title%type
989: --
990: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
991: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
992: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
993: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
994: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE

Line 991: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE

987: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
988: ,p_billing_title IN per_all_assignments_f.title%type
989: --
990: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
991: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
992: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
993: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
994: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
995: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE

Line 992: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE

988: ,p_billing_title IN per_all_assignments_f.title%type
989: --
990: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
991: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
992: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
993: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
994: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
995: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
996: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE

Line 993: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE

989: --
990: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
991: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
992: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
993: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
994: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
995: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
996: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
997: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE

Line 994: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE

990: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
991: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
992: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
993: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
994: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
995: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
996: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
997: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
998: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE

Line 995: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE

991: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
992: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
993: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
994: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
995: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
996: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
997: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
998: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
999: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE

Line 996: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE

992: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
993: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
994: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
995: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
996: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
997: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
998: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
999: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
1000: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE

Line 997: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE

993: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
994: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
995: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
996: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
997: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
998: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
999: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
1000: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
1001: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE

Line 998: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE

994: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
995: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
996: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
997: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
998: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
999: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
1000: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
1001: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
1002: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE

Line 999: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE

995: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
996: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
997: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
998: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
999: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
1000: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
1001: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
1002: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
1003: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE

Line 1000: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE

996: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
997: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
998: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
999: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
1000: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
1001: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
1002: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
1003: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
1004: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE

Line 1001: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE

997: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
998: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
999: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
1000: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
1001: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
1002: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
1003: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
1004: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
1005: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE

Line 1002: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE

998: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
999: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
1000: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
1001: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
1002: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
1003: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
1004: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
1005: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
1006: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE

Line 1003: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE

999: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
1000: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
1001: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
1002: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
1003: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
1004: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
1005: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
1006: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
1007: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE

Line 1004: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE

1000: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
1001: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
1002: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
1003: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
1004: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
1005: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
1006: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
1007: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
1008: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE

Line 1005: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE

1001: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
1002: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
1003: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
1004: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
1005: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
1006: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
1007: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
1008: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
1009: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE

Line 1006: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE

1002: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
1003: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
1004: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
1005: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
1006: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
1007: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
1008: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
1009: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
1010: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE

Line 1007: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE

1003: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
1004: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
1005: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
1006: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
1007: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
1008: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
1009: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
1010: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
1011: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE

Line 1008: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE

1004: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
1005: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
1006: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
1007: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
1008: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
1009: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
1010: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
1011: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
1012: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE

Line 1009: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE

1005: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
1006: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
1007: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
1008: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
1009: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
1010: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
1011: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
1012: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
1013: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE

Line 1010: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE

1006: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
1007: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
1008: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
1009: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
1010: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
1011: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
1012: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
1013: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
1014: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE

Line 1011: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE

1007: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
1008: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
1009: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
1010: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
1011: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
1012: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
1013: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
1014: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
1015: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE

Line 1012: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE

1008: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
1009: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
1010: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
1011: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
1012: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
1013: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
1014: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
1015: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
1016: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE

Line 1013: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE

1009: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
1010: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
1011: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
1012: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
1013: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
1014: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
1015: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
1016: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
1017: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE

Line 1014: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE

1010: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
1011: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
1012: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
1013: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
1014: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
1015: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
1016: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
1017: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
1018: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE

Line 1015: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE

1011: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
1012: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
1013: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
1014: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
1015: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
1016: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
1017: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
1018: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
1019: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE

Line 1016: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE

1012: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
1013: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
1014: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
1015: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
1016: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
1017: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
1018: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
1019: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
1020: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE

Line 1017: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE

1013: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
1014: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
1015: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
1016: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
1017: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
1018: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
1019: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
1020: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
1021: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE

Line 1018: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE

1014: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
1015: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
1016: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
1017: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
1018: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
1019: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
1020: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
1021: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
1022: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE

Line 1019: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE

1015: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
1016: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
1017: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
1018: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
1019: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
1020: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
1021: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
1022: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
1023: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

Line 1020: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE

1016: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
1017: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
1018: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
1019: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
1020: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
1021: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
1022: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
1023: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
1024: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE

Line 1021: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE

1017: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
1018: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
1019: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
1020: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
1021: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
1022: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
1023: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
1024: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
1025: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE

Line 1022: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE

1018: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
1019: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
1020: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
1021: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
1022: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
1023: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
1024: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
1025: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
1026: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE

Line 1023: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

1019: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
1020: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
1021: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
1022: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
1023: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
1024: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
1025: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
1026: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
1027: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE

Line 1024: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE

1020: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
1021: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
1022: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
1023: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
1024: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
1025: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
1026: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
1027: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
1028: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

Line 1025: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE

1021: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
1022: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
1023: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
1024: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
1025: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
1026: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
1027: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
1028: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
1029: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE

Line 1026: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE

1022: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
1023: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
1024: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
1025: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
1026: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
1027: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
1028: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
1029: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
1030: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE

Line 1027: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE

1023: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
1024: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
1025: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
1026: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
1027: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
1028: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
1029: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
1030: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
1031: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE

Line 1028: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

1024: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
1025: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
1026: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
1027: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
1028: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
1029: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
1030: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
1031: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
1032: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE

Line 1029: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE

1025: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
1026: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
1027: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
1028: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
1029: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
1030: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
1031: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
1032: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
1033: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE

Line 1030: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE

1026: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
1027: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
1028: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
1029: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
1030: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
1031: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
1032: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
1033: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
1034: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE

Line 1031: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE

1027: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
1028: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
1029: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
1030: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
1031: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
1032: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
1033: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
1034: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
1035: ,p_source_type IN per_all_assignments_f.source_type%TYPE

Line 1032: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE

1028: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
1029: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
1030: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
1031: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
1032: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
1033: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
1034: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
1035: ,p_source_type IN per_all_assignments_f.source_type%TYPE
1036: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE

Line 1033: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE

1029: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
1030: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
1031: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
1032: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
1033: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
1034: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
1035: ,p_source_type IN per_all_assignments_f.source_type%TYPE
1036: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
1037: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE

Line 1034: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE

1030: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
1031: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
1032: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
1033: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
1034: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
1035: ,p_source_type IN per_all_assignments_f.source_type%TYPE
1036: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
1037: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
1038: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE

Line 1035: ,p_source_type IN per_all_assignments_f.source_type%TYPE

1031: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
1032: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
1033: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
1034: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
1035: ,p_source_type IN per_all_assignments_f.source_type%TYPE
1036: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
1037: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
1038: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
1039: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE

Line 1036: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE

1032: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
1033: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
1034: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
1035: ,p_source_type IN per_all_assignments_f.source_type%TYPE
1036: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
1037: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
1038: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
1039: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
1040: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE

Line 1037: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE

1033: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
1034: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
1035: ,p_source_type IN per_all_assignments_f.source_type%TYPE
1036: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
1037: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
1038: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
1039: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
1040: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
1041: --Bug 3063591 Start Here

Line 1038: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE

1034: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
1035: ,p_source_type IN per_all_assignments_f.source_type%TYPE
1036: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
1037: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
1038: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
1039: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
1040: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
1041: --Bug 3063591 Start Here
1042: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null

Line 1039: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE

1035: ,p_source_type IN per_all_assignments_f.source_type%TYPE
1036: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
1037: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
1038: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
1039: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
1040: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
1041: --Bug 3063591 Start Here
1042: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
1043: --Bug 3063591 End Here

Line 1040: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE

1036: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
1037: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
1038: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
1039: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
1040: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
1041: --Bug 3063591 Start Here
1042: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
1043: --Bug 3063591 End Here
1044: ,p_application_id IN per_applications.application_id%TYPE

Line 1042: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null

1038: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
1039: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
1040: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
1041: --Bug 3063591 Start Here
1042: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
1043: --Bug 3063591 End Here
1044: ,p_application_id IN per_applications.application_id%TYPE
1045: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
1046: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE

Line 1472: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE

1468: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
1469: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
1470: --
1471: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
1472: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
1473: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
1474: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
1475: ,p_asg_validation_start_date OUT NOCOPY DATE
1476: ,p_asg_validation_end_date OUT NOCOPY DATE

Line 1473: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE

1469: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
1470: --
1471: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
1472: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
1473: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
1474: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
1475: ,p_asg_validation_start_date OUT NOCOPY DATE
1476: ,p_asg_validation_end_date OUT NOCOPY DATE
1477: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE

Line 1474: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE

1470: --
1471: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
1472: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
1473: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
1474: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
1475: ,p_asg_validation_start_date OUT NOCOPY DATE
1476: ,p_asg_validation_end_date OUT NOCOPY DATE
1477: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
1478: ,p_application_id per_applications.application_id%TYPE

Line 1477: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE

1473: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
1474: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
1475: ,p_asg_validation_start_date OUT NOCOPY DATE
1476: ,p_asg_validation_end_date OUT NOCOPY DATE
1477: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
1478: ,p_application_id per_applications.application_id%TYPE
1479: ,p_app_object_version_number per_applications.object_version_number%TYPE
1480: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
1481: ,p_pds_hire_date per_periods_of_service.date_start%TYPE