APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_ALL_ASSIGNMENTS_F

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

25: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
26: --CWK
27: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
28: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
29: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925
30: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
31: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
32: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
33: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE

Line 30: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE

26: --CWK
27: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
28: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
29: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925
30: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
31: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
32: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
33: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
34: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE

Line 32: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE

28: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
29: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925
30: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
31: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
32: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
33: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
34: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
35: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
36: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE

Line 33: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE

29: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925
30: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
31: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
32: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
33: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
34: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
35: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
36: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
37: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE

Line 34: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE

30: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
31: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
32: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
33: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
34: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
35: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
36: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
37: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
38: ,p_project_title IN per_all_assignments_f.project_title%TYPE

Line 35: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE

31: ,p_pdp_object_version_number OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
32: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
33: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
34: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
35: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
36: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
37: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
38: ,p_project_title IN per_all_assignments_f.project_title%TYPE
39: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE

Line 36: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE

32: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
33: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
34: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
35: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
36: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
37: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
38: ,p_project_title IN per_all_assignments_f.project_title%TYPE
39: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
40: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE

Line 37: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE

33: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
34: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
35: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
36: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
37: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
38: ,p_project_title IN per_all_assignments_f.project_title%TYPE
39: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
40: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
41: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE

Line 38: ,p_project_title IN per_all_assignments_f.project_title%TYPE

34: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
35: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
36: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
37: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
38: ,p_project_title IN per_all_assignments_f.project_title%TYPE
39: ,p_grade_rule_id OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
40: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
41: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
42: ,p_rate_value IN pay_grade_rules_f.value%TYPE

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

155: ,p_party_id IN per_all_people_f.party_id%TYPE default null
156: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
157: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
158: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
159: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
160: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
161: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
162: ,p_asg_validation_start_date OUT NOCOPY DATE
163: ,p_asg_validation_end_date OUT NOCOPY DATE

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

156: ,p_fast_path_employee IN per_all_people_f.fast_path_employee%TYPE default null
157: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
158: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
159: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
160: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
161: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
162: ,p_asg_validation_start_date OUT NOCOPY DATE
163: ,p_asg_validation_end_date OUT NOCOPY DATE
164: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE

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

157: ,p_rehire_authorizor IN per_all_people_f.rehire_authorizor%TYPE default null
158: ,p_per_object_version_number OUT NOCOPY per_all_people_f.object_version_number%TYPE
159: ,p_assignment_id OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
160: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
161: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
162: ,p_asg_validation_start_date OUT NOCOPY DATE
163: ,p_asg_validation_end_date OUT NOCOPY DATE
164: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
165: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE

Line 164: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE

160: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
161: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
162: ,p_asg_validation_start_date OUT NOCOPY DATE
163: ,p_asg_validation_end_date OUT NOCOPY DATE
164: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
165: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
166: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
167: ,p_position_id IN per_all_assignments_f.position_id%TYPE
168: ,p_job_id IN per_all_assignments_f.job_id%TYPE

Line 165: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE

161: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
162: ,p_asg_validation_start_date OUT NOCOPY DATE
163: ,p_asg_validation_end_date OUT NOCOPY DATE
164: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
165: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
166: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
167: ,p_position_id IN per_all_assignments_f.position_id%TYPE
168: ,p_job_id IN per_all_assignments_f.job_id%TYPE
169: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

Line 166: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE

162: ,p_asg_validation_start_date OUT NOCOPY DATE
163: ,p_asg_validation_end_date OUT NOCOPY DATE
164: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
165: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
166: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
167: ,p_position_id IN per_all_assignments_f.position_id%TYPE
168: ,p_job_id IN per_all_assignments_f.job_id%TYPE
169: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
170: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE

Line 167: ,p_position_id IN per_all_assignments_f.position_id%TYPE

163: ,p_asg_validation_end_date OUT NOCOPY DATE
164: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
165: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
166: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
167: ,p_position_id IN per_all_assignments_f.position_id%TYPE
168: ,p_job_id IN per_all_assignments_f.job_id%TYPE
169: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
170: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
171: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE

Line 168: ,p_job_id IN per_all_assignments_f.job_id%TYPE

164: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
165: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
166: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
167: ,p_position_id IN per_all_assignments_f.position_id%TYPE
168: ,p_job_id IN per_all_assignments_f.job_id%TYPE
169: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
170: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
171: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
172: ,p_location_id IN per_all_assignments_f.location_id%TYPE

Line 169: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

165: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
166: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
167: ,p_position_id IN per_all_assignments_f.position_id%TYPE
168: ,p_job_id IN per_all_assignments_f.job_id%TYPE
169: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
170: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
171: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
172: ,p_location_id IN per_all_assignments_f.location_id%TYPE
173: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE

Line 171: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE

167: ,p_position_id IN per_all_assignments_f.position_id%TYPE
168: ,p_job_id IN per_all_assignments_f.job_id%TYPE
169: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
170: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
171: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
172: ,p_location_id IN per_all_assignments_f.location_id%TYPE
173: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
174: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
175: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE

Line 172: ,p_location_id IN per_all_assignments_f.location_id%TYPE

168: ,p_job_id IN per_all_assignments_f.job_id%TYPE
169: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
170: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
171: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
172: ,p_location_id IN per_all_assignments_f.location_id%TYPE
173: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
174: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
175: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
176: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE

Line 173: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE

169: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
170: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
171: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
172: ,p_location_id IN per_all_assignments_f.location_id%TYPE
173: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
174: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
175: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
176: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
177: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE

Line 174: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE

170: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
171: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
172: ,p_location_id IN per_all_assignments_f.location_id%TYPE
173: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
174: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
175: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
176: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
177: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
178: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE

Line 175: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE

171: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
172: ,p_location_id IN per_all_assignments_f.location_id%TYPE
173: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
174: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
175: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
176: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
177: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
178: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
179: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE

Line 176: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE

172: ,p_location_id IN per_all_assignments_f.location_id%TYPE
173: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
174: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
175: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
176: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
177: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
178: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
179: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
180: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE

Line 177: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE

173: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
174: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
175: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
176: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
177: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
178: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
179: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
180: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
181: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE

Line 178: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE

174: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
175: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
176: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
177: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
178: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
179: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
180: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
181: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
182: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE

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

205: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
206: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
207: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
208: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
209: ,p_people_group_id OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
210: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
211: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
212: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
213: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE

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

236: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
237: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
238: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
239: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
240: ,p_soft_coding_keyflex_id OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
241: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
242: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
243: ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
244: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE

Line 241: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE

237: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
238: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
239: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
240: ,p_soft_coding_keyflex_id OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
241: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
242: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
243: ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
244: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
245: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE

Line 242: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE

238: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
239: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
240: ,p_soft_coding_keyflex_id OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
241: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
242: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
243: ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
244: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
245: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
246: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE

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

239: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
240: ,p_soft_coding_keyflex_id OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
241: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
242: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
243: ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
244: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
245: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
246: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
247: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE

Line 244: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE

240: ,p_soft_coding_keyflex_id OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
241: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
242: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
243: ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
244: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
245: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
246: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
247: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
248: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE

Line 245: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE

241: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
242: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
243: ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
244: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
245: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
246: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
247: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
248: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
249: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE

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

242: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
243: ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
244: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
245: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
246: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
247: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
248: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
249: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
250: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE

Line 247: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE

243: ,p_assignment_sequence OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
244: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
245: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
246: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
247: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
248: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
249: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
250: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
251: ,p_frequency IN per_all_assignments_f.frequency%TYPE

Line 248: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE

244: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
245: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
246: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
247: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
248: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
249: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
250: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
251: ,p_frequency IN per_all_assignments_f.frequency%TYPE
252: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE

Line 249: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE

245: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
246: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
247: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
248: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
249: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
250: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
251: ,p_frequency IN per_all_assignments_f.frequency%TYPE
252: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
253: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE

Line 250: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE

246: ,p_assignment_number OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
247: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
248: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
249: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
250: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
251: ,p_frequency IN per_all_assignments_f.frequency%TYPE
252: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
253: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE
254: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE

Line 251: ,p_frequency IN per_all_assignments_f.frequency%TYPE

247: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
248: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
249: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
250: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
251: ,p_frequency IN per_all_assignments_f.frequency%TYPE
252: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
253: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE
254: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
255: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE

Line 252: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE

248: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
249: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
250: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
251: ,p_frequency IN per_all_assignments_f.frequency%TYPE
252: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
253: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE
254: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
255: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
256: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE

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

249: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
250: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
251: ,p_frequency IN per_all_assignments_f.frequency%TYPE
252: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
253: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE
254: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
255: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
256: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
257: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE

Line 254: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE

250: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
251: ,p_frequency IN per_all_assignments_f.frequency%TYPE
252: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
253: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE
254: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
255: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
256: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
257: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
258: --

Line 255: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE

251: ,p_frequency IN per_all_assignments_f.frequency%TYPE
252: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
253: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE
254: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
255: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
256: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
257: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
258: --
259: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE

Line 256: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE

252: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
253: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE
254: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
255: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
256: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
257: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
258: --
259: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
260: ,p_billing_title IN per_all_assignments_f.title%type

Line 257: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE

253: ,p_period_of_service_id IN OUT NOCOPY per_all_assignments_f.period_of_service_id%TYPE
254: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
255: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
256: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
257: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
258: --
259: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
260: ,p_billing_title IN per_all_assignments_f.title%type
261: --

Line 259: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE

255: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
256: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
257: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
258: --
259: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
260: ,p_billing_title IN per_all_assignments_f.title%type
261: --
262: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
263: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE

Line 260: ,p_billing_title IN per_all_assignments_f.title%type

256: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
257: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
258: --
259: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
260: ,p_billing_title IN per_all_assignments_f.title%type
261: --
262: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
263: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
264: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE

Line 262: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE

258: --
259: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
260: ,p_billing_title IN per_all_assignments_f.title%type
261: --
262: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
263: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
264: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
265: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
266: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE

Line 263: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE

259: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
260: ,p_billing_title IN per_all_assignments_f.title%type
261: --
262: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
263: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
264: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
265: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
266: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
267: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE

Line 264: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE

260: ,p_billing_title IN per_all_assignments_f.title%type
261: --
262: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
263: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
264: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
265: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
266: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
267: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
268: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE

Line 265: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE

261: --
262: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
263: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
264: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
265: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
266: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
267: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
268: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
269: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE

Line 266: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE

262: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
263: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
264: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
265: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
266: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
267: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
268: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
269: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
270: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE

Line 267: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE

263: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
264: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
265: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
266: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
267: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
268: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
269: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
270: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
271: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE

Line 268: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE

264: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
265: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
266: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
267: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
268: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
269: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
270: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
271: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
272: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE

Line 269: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE

265: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
266: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
267: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
268: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
269: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
270: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
271: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
272: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
273: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE

Line 270: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE

266: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
267: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
268: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
269: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
270: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
271: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
272: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
273: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
274: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE

Line 271: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE

267: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
268: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
269: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
270: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
271: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
272: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
273: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
274: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
275: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE

Line 272: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE

268: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
269: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
270: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
271: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
272: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
273: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
274: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
275: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
276: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE

Line 273: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE

269: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
270: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
271: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
272: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
273: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
274: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
275: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
276: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
277: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE

Line 274: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE

270: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
271: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
272: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
273: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
274: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
275: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
276: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
277: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
278: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE

Line 275: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE

271: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
272: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
273: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
274: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
275: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
276: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
277: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
278: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
279: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE

Line 276: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE

272: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
273: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
274: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
275: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
276: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
277: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
278: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
279: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
280: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE

Line 277: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE

273: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
274: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
275: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
276: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
277: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
278: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
279: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
280: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
281: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE

Line 278: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE

274: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
275: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
276: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
277: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
278: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
279: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
280: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
281: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
282: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE

Line 279: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE

275: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
276: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
277: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
278: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
279: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
280: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
281: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
282: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
283: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE

Line 280: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE

276: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
277: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
278: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
279: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
280: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
281: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
282: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
283: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
284: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE

Line 281: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE

277: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
278: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
279: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
280: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
281: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
282: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
283: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
284: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
285: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE

Line 282: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE

278: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
279: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
280: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
281: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
282: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
283: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
284: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
285: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
286: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE

Line 283: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE

279: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
280: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
281: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
282: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
283: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
284: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
285: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
286: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
287: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE

Line 284: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE

280: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
281: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
282: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
283: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
284: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
285: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
286: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
287: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
288: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE

Line 285: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE

281: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
282: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
283: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
284: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
285: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
286: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
287: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
288: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
289: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE

Line 286: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE

282: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
283: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
284: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
285: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
286: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
287: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
288: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
289: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
290: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE

Line 287: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE

283: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
284: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
285: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
286: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
287: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
288: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
289: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
290: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
291: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE

Line 288: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE

284: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
285: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
286: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
287: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
288: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
289: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
290: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
291: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
292: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE

Line 289: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE

285: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
286: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
287: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
288: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
289: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
290: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
291: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
292: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
293: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE

Line 290: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE

286: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
287: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
288: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
289: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
290: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
291: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
292: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
293: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
294: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE

Line 291: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE

287: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
288: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
289: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
290: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
291: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
292: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
293: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
294: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
295: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

Line 292: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE

288: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
289: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
290: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
291: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
292: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
293: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
294: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
295: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
296: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE

Line 293: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE

289: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
290: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
291: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
292: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
293: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
294: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
295: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
296: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
297: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE

Line 294: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE

290: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
291: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
292: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
293: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
294: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
295: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
296: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
297: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
298: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE

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

291: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
292: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
293: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
294: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
295: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
296: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
297: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
298: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
299: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE

Line 296: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE

292: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
293: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
294: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
295: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
296: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
297: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
298: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
299: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
300: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

Line 297: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE

293: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
294: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
295: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
296: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
297: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
298: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
299: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
300: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
301: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE

Line 298: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE

294: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
295: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
296: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
297: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
298: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
299: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
300: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
301: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
302: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE

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

295: ,p_asg_object_version_number OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
296: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
297: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
298: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
299: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
300: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
301: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
302: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
303: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE

Line 300: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

296: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
297: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
298: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
299: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
300: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
301: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
302: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
303: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
304: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE

Line 301: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE

297: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
298: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
299: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
300: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
301: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
302: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
303: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
304: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
305: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE

Line 302: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE

298: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
299: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
300: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
301: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
302: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
303: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
304: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
305: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
306: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE

Line 303: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE

299: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
300: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
301: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
302: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
303: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
304: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
305: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
306: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
307: ,p_source_type IN per_all_assignments_f.source_type%TYPE

Line 304: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE

300: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
301: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
302: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
303: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
304: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
305: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
306: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
307: ,p_source_type IN per_all_assignments_f.source_type%TYPE
308: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE

Line 305: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE

301: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
302: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
303: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
304: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
305: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
306: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
307: ,p_source_type IN per_all_assignments_f.source_type%TYPE
308: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
309: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE

Line 306: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE

302: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
303: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
304: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
305: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
306: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
307: ,p_source_type IN per_all_assignments_f.source_type%TYPE
308: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
309: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
310: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE

Line 307: ,p_source_type IN per_all_assignments_f.source_type%TYPE

303: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
304: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
305: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
306: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
307: ,p_source_type IN per_all_assignments_f.source_type%TYPE
308: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
309: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
310: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
311: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE

Line 308: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE

304: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
305: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
306: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
307: ,p_source_type IN per_all_assignments_f.source_type%TYPE
308: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
309: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
310: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
311: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
312: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE

Line 309: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE

305: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
306: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
307: ,p_source_type IN per_all_assignments_f.source_type%TYPE
308: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
309: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
310: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
311: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
312: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
313: --Bug 3063591 Start Here

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

306: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
307: ,p_source_type IN per_all_assignments_f.source_type%TYPE
308: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
309: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
310: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
311: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
312: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
313: --Bug 3063591 Start Here
314: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null

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

307: ,p_source_type IN per_all_assignments_f.source_type%TYPE
308: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
309: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
310: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
311: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
312: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
313: --Bug 3063591 Start Here
314: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
315: --Bug 3063591 End Here

Line 312: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE

308: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
309: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
310: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
311: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
312: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
313: --Bug 3063591 Start Here
314: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
315: --Bug 3063591 End Here
316: ,p_application_id OUT NOCOPY per_applications.application_id%TYPE

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

310: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
311: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
312: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
313: --Bug 3063591 Start Here
314: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
315: --Bug 3063591 End Here
316: ,p_application_id OUT NOCOPY per_applications.application_id%TYPE
317: -- Bug 3900299 Starts Here
318: ,p_app_date_received IN OUT NOCOPY per_applications.date_received%TYPE

Line 752: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE

748: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
749: --CWK
750: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
751: ,p_npw_number IN per_all_people_f.npw_number%TYPE
752: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
753: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
754: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
755: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
756: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE

Line 753: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE

749: --CWK
750: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
751: ,p_npw_number IN per_all_people_f.npw_number%TYPE
752: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
753: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
754: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
755: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
756: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
757: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE

Line 755: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE

751: ,p_npw_number IN per_all_people_f.npw_number%TYPE
752: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
753: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
754: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
755: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
756: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
757: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
758: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
759: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE

Line 756: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE

752: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
753: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
754: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
755: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
756: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
757: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
758: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
759: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
760: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE

Line 757: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE

753: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
754: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
755: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
756: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
757: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
758: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
759: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
760: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
761: ,p_project_title IN per_all_assignments_f.project_title%TYPE

Line 758: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE

754: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
755: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
756: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
757: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
758: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
759: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
760: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
761: ,p_project_title IN per_all_assignments_f.project_title%TYPE
762: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE

Line 759: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE

755: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
756: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
757: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
758: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
759: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
760: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
761: ,p_project_title IN per_all_assignments_f.project_title%TYPE
762: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
763: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE

Line 760: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE

756: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
757: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
758: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
759: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
760: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
761: ,p_project_title IN per_all_assignments_f.project_title%TYPE
762: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
763: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
764: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE

Line 761: ,p_project_title IN per_all_assignments_f.project_title%TYPE

757: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
758: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
759: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
760: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
761: ,p_project_title IN per_all_assignments_f.project_title%TYPE
762: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
763: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
764: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
765: ,p_rate_value IN pay_grade_rules_f.value%TYPE

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

876: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
877: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
878: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
879: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
880: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
881: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
882: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
883: ,p_asg_validation_start_date OUT NOCOPY DATE
884: ,p_asg_validation_end_date OUT NOCOPY DATE

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

877: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
878: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
879: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
880: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
881: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
882: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
883: ,p_asg_validation_start_date OUT NOCOPY DATE
884: ,p_asg_validation_end_date OUT NOCOPY DATE
885: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE

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

878: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
879: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
880: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
881: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
882: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
883: ,p_asg_validation_start_date OUT NOCOPY DATE
884: ,p_asg_validation_end_date OUT NOCOPY DATE
885: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
886: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE

Line 885: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE

881: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
882: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
883: ,p_asg_validation_start_date OUT NOCOPY DATE
884: ,p_asg_validation_end_date OUT NOCOPY DATE
885: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
886: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
887: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
888: ,p_position_id IN per_all_assignments_f.position_id%TYPE
889: ,p_job_id IN per_all_assignments_f.job_id%TYPE

Line 886: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE

882: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
883: ,p_asg_validation_start_date OUT NOCOPY DATE
884: ,p_asg_validation_end_date OUT NOCOPY DATE
885: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
886: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
887: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
888: ,p_position_id IN per_all_assignments_f.position_id%TYPE
889: ,p_job_id IN per_all_assignments_f.job_id%TYPE
890: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

Line 887: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE

883: ,p_asg_validation_start_date OUT NOCOPY DATE
884: ,p_asg_validation_end_date OUT NOCOPY DATE
885: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
886: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
887: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
888: ,p_position_id IN per_all_assignments_f.position_id%TYPE
889: ,p_job_id IN per_all_assignments_f.job_id%TYPE
890: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
891: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE

Line 888: ,p_position_id IN per_all_assignments_f.position_id%TYPE

884: ,p_asg_validation_end_date OUT NOCOPY DATE
885: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
886: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
887: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
888: ,p_position_id IN per_all_assignments_f.position_id%TYPE
889: ,p_job_id IN per_all_assignments_f.job_id%TYPE
890: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
891: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
892: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE

Line 889: ,p_job_id IN per_all_assignments_f.job_id%TYPE

885: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
886: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
887: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
888: ,p_position_id IN per_all_assignments_f.position_id%TYPE
889: ,p_job_id IN per_all_assignments_f.job_id%TYPE
890: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
891: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
892: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
893: ,p_location_id IN per_all_assignments_f.location_id%TYPE

Line 890: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

886: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
887: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
888: ,p_position_id IN per_all_assignments_f.position_id%TYPE
889: ,p_job_id IN per_all_assignments_f.job_id%TYPE
890: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
891: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
892: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
893: ,p_location_id IN per_all_assignments_f.location_id%TYPE
894: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE

Line 892: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE

888: ,p_position_id IN per_all_assignments_f.position_id%TYPE
889: ,p_job_id IN per_all_assignments_f.job_id%TYPE
890: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
891: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
892: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
893: ,p_location_id IN per_all_assignments_f.location_id%TYPE
894: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
895: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
896: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE

Line 893: ,p_location_id IN per_all_assignments_f.location_id%TYPE

889: ,p_job_id IN per_all_assignments_f.job_id%TYPE
890: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
891: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
892: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
893: ,p_location_id IN per_all_assignments_f.location_id%TYPE
894: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
895: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
896: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
897: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE

Line 894: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE

890: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
891: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
892: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
893: ,p_location_id IN per_all_assignments_f.location_id%TYPE
894: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
895: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
896: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
897: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
898: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE

Line 895: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE

891: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
892: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
893: ,p_location_id IN per_all_assignments_f.location_id%TYPE
894: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
895: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
896: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
897: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
898: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
899: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE

Line 896: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE

892: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
893: ,p_location_id IN per_all_assignments_f.location_id%TYPE
894: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
895: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
896: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
897: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
898: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
899: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
900: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE

Line 897: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE

893: ,p_location_id IN per_all_assignments_f.location_id%TYPE
894: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
895: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
896: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
897: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
898: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
899: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
900: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
901: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE

Line 898: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE

894: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
895: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
896: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
897: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
898: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
899: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
900: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
901: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
902: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE

Line 899: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE

895: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
896: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
897: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
898: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
899: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
900: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
901: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
902: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
903: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE

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

926: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
927: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
928: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
929: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
930: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
931: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
932: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
933: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
934: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE

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

957: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
958: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
959: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
960: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
961: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
962: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
963: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
964: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
965: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE

Line 962: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE

958: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
959: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
960: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
961: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
962: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
963: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
964: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
965: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
966: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE

Line 963: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE

959: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
960: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
961: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
962: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
963: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
964: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
965: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
966: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
967: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE

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

960: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
961: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
962: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
963: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
964: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
965: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
966: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
967: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
968: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE

Line 965: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE

961: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
962: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
963: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
964: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
965: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
966: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
967: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
968: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
969: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE

Line 966: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE

962: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
963: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
964: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
965: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
966: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
967: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
968: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
969: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
970: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE

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

963: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
964: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
965: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
966: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
967: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
968: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
969: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
970: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
971: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE

Line 968: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE

964: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
965: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
966: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
967: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
968: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
969: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
970: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
971: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
972: ,p_frequency IN per_all_assignments_f.frequency%TYPE

Line 969: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE

965: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
966: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
967: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
968: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
969: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
970: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
971: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
972: ,p_frequency IN per_all_assignments_f.frequency%TYPE
973: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE

Line 970: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE

966: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
967: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
968: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
969: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
970: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
971: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
972: ,p_frequency IN per_all_assignments_f.frequency%TYPE
973: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
974: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE

Line 971: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE

967: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
968: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
969: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
970: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
971: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
972: ,p_frequency IN per_all_assignments_f.frequency%TYPE
973: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
974: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
975: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE

Line 972: ,p_frequency IN per_all_assignments_f.frequency%TYPE

968: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
969: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
970: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
971: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
972: ,p_frequency IN per_all_assignments_f.frequency%TYPE
973: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
974: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
975: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
976: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE

Line 973: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE

969: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
970: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
971: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
972: ,p_frequency IN per_all_assignments_f.frequency%TYPE
973: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
974: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
975: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
976: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
977: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE

Line 974: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE

970: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
971: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
972: ,p_frequency IN per_all_assignments_f.frequency%TYPE
973: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
974: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
975: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
976: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
977: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
978: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE

Line 975: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE

971: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
972: ,p_frequency IN per_all_assignments_f.frequency%TYPE
973: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
974: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
975: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
976: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
977: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
978: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
979: --

Line 976: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE

972: ,p_frequency IN per_all_assignments_f.frequency%TYPE
973: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
974: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
975: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
976: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
977: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
978: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
979: --
980: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE

Line 977: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE

973: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
974: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
975: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
976: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
977: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
978: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
979: --
980: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
981: ,p_billing_title IN per_all_assignments_f.title%type

Line 978: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE

974: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
975: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
976: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
977: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
978: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
979: --
980: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
981: ,p_billing_title IN per_all_assignments_f.title%type
982: --

Line 980: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE

976: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
977: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
978: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
979: --
980: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
981: ,p_billing_title IN per_all_assignments_f.title%type
982: --
983: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
984: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE

Line 981: ,p_billing_title IN per_all_assignments_f.title%type

977: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
978: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
979: --
980: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
981: ,p_billing_title IN per_all_assignments_f.title%type
982: --
983: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
984: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
985: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE

Line 983: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE

979: --
980: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
981: ,p_billing_title IN per_all_assignments_f.title%type
982: --
983: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
984: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
985: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
986: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
987: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE

Line 984: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE

980: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
981: ,p_billing_title IN per_all_assignments_f.title%type
982: --
983: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
984: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
985: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
986: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
987: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
988: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE

Line 985: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE

981: ,p_billing_title IN per_all_assignments_f.title%type
982: --
983: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
984: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
985: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
986: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
987: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
988: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
989: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE

Line 986: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE

982: --
983: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
984: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
985: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
986: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
987: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
988: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
989: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
990: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE

Line 987: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE

983: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
984: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
985: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
986: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
987: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
988: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
989: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
990: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
991: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE

Line 988: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE

984: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
985: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
986: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
987: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
988: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
989: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
990: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
991: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
992: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE

Line 989: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE

985: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
986: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
987: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
988: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
989: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
990: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
991: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
992: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
993: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE

Line 990: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE

986: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
987: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
988: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
989: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
990: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
991: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
992: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
993: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
994: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE

Line 991: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE

987: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
988: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
989: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
990: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
991: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
992: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
993: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
994: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
995: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE

Line 992: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE

988: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
989: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
990: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
991: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
992: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
993: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
994: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
995: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
996: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE

Line 993: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE

989: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
990: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
991: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
992: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
993: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
994: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
995: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
996: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
997: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE

Line 994: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE

990: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
991: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
992: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
993: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
994: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
995: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
996: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
997: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
998: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE

Line 995: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE

991: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
992: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
993: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
994: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
995: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
996: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
997: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
998: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
999: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE

Line 996: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE

992: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
993: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
994: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
995: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
996: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
997: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
998: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
999: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
1000: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE

Line 997: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE

993: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
994: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
995: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
996: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
997: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
998: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
999: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
1000: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
1001: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE

Line 998: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE

994: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
995: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
996: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
997: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
998: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
999: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
1000: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
1001: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
1002: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE

Line 999: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE

995: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
996: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
997: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
998: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
999: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
1000: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
1001: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
1002: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
1003: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE

Line 1000: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE

996: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
997: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
998: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
999: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
1000: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
1001: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
1002: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
1003: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
1004: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE

Line 1001: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE

997: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
998: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
999: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
1000: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
1001: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
1002: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
1003: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
1004: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
1005: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE

Line 1002: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE

998: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
999: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
1000: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
1001: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
1002: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
1003: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
1004: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
1005: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
1006: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE

Line 1003: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE

999: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
1000: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
1001: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
1002: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
1003: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
1004: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
1005: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
1006: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
1007: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE

Line 1004: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE

1000: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
1001: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
1002: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
1003: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
1004: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
1005: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
1006: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
1007: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
1008: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE

Line 1005: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE

1001: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
1002: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
1003: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
1004: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
1005: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
1006: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
1007: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
1008: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
1009: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE

Line 1006: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE

1002: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
1003: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
1004: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
1005: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
1006: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
1007: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
1008: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
1009: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
1010: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE

Line 1007: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE

1003: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
1004: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
1005: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
1006: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
1007: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
1008: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
1009: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
1010: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
1011: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE

Line 1008: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE

1004: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
1005: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
1006: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
1007: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
1008: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
1009: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
1010: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
1011: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
1012: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE

Line 1009: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE

1005: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
1006: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
1007: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
1008: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
1009: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
1010: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
1011: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
1012: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
1013: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE

Line 1010: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE

1006: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
1007: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
1008: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
1009: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
1010: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
1011: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
1012: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
1013: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
1014: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE

Line 1011: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE

1007: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
1008: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
1009: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
1010: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
1011: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
1012: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
1013: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
1014: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
1015: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE

Line 1012: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE

1008: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
1009: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
1010: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
1011: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
1012: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
1013: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
1014: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
1015: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
1016: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

Line 1013: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE

1009: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
1010: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
1011: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
1012: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
1013: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
1014: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
1015: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
1016: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
1017: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE

Line 1014: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE

1010: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
1011: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
1012: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
1013: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
1014: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
1015: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
1016: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
1017: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
1018: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE

Line 1015: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE

1011: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
1012: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
1013: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
1014: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
1015: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
1016: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
1017: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
1018: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
1019: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE

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

1012: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
1013: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
1014: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
1015: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
1016: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
1017: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
1018: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
1019: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
1020: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE

Line 1017: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE

1013: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
1014: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
1015: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
1016: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
1017: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
1018: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
1019: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
1020: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
1021: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

Line 1018: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE

1014: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
1015: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
1016: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
1017: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
1018: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
1019: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
1020: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
1021: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
1022: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE

Line 1019: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE

1015: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
1016: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
1017: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
1018: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
1019: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
1020: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
1021: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
1022: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
1023: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE

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

1016: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
1017: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
1018: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
1019: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
1020: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
1021: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
1022: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
1023: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
1024: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE

Line 1021: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

1017: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
1018: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
1019: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
1020: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
1021: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
1022: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
1023: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
1024: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
1025: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE

Line 1022: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE

1018: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
1019: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
1020: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
1021: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
1022: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
1023: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
1024: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
1025: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
1026: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE

Line 1023: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE

1019: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
1020: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
1021: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
1022: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
1023: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
1024: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
1025: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
1026: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
1027: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE

Line 1024: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE

1020: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
1021: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
1022: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
1023: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
1024: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
1025: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
1026: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
1027: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
1028: ,p_source_type IN per_all_assignments_f.source_type%TYPE

Line 1025: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE

1021: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
1022: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
1023: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
1024: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
1025: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
1026: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
1027: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
1028: ,p_source_type IN per_all_assignments_f.source_type%TYPE
1029: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE

Line 1026: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE

1022: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
1023: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
1024: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
1025: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
1026: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
1027: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
1028: ,p_source_type IN per_all_assignments_f.source_type%TYPE
1029: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
1030: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE

Line 1027: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE

1023: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
1024: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
1025: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
1026: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
1027: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
1028: ,p_source_type IN per_all_assignments_f.source_type%TYPE
1029: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
1030: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
1031: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE

Line 1028: ,p_source_type IN per_all_assignments_f.source_type%TYPE

1024: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
1025: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
1026: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
1027: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
1028: ,p_source_type IN per_all_assignments_f.source_type%TYPE
1029: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
1030: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
1031: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
1032: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE

Line 1029: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE

1025: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
1026: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
1027: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
1028: ,p_source_type IN per_all_assignments_f.source_type%TYPE
1029: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
1030: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
1031: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
1032: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
1033: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE

Line 1030: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE

1026: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
1027: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
1028: ,p_source_type IN per_all_assignments_f.source_type%TYPE
1029: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
1030: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
1031: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
1032: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
1033: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
1034: --Bug 3063591 Start Here

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

1027: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
1028: ,p_source_type IN per_all_assignments_f.source_type%TYPE
1029: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
1030: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
1031: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
1032: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
1033: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
1034: --Bug 3063591 Start Here
1035: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null

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

1028: ,p_source_type IN per_all_assignments_f.source_type%TYPE
1029: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
1030: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
1031: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
1032: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
1033: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
1034: --Bug 3063591 Start Here
1035: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
1036: --Bug 3063591 End Here

Line 1033: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE

1029: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
1030: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
1031: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
1032: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
1033: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
1034: --Bug 3063591 Start Here
1035: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
1036: --Bug 3063591 End Here
1037: ,p_application_id IN per_applications.application_id%TYPE

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

1031: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
1032: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
1033: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
1034: --Bug 3063591 Start Here
1035: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
1036: --Bug 3063591 End Here
1037: ,p_application_id IN per_applications.application_id%TYPE
1038: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
1039: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE

Line 1465: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE

1461: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
1462: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
1463: --
1464: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
1465: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
1466: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
1467: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
1468: ,p_asg_validation_start_date OUT NOCOPY DATE
1469: ,p_asg_validation_end_date OUT NOCOPY DATE

Line 1466: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE

1462: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
1463: --
1464: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
1465: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
1466: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
1467: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
1468: ,p_asg_validation_start_date OUT NOCOPY DATE
1469: ,p_asg_validation_end_date OUT NOCOPY DATE
1470: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE

Line 1467: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE

1463: --
1464: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
1465: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
1466: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
1467: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
1468: ,p_asg_validation_start_date OUT NOCOPY DATE
1469: ,p_asg_validation_end_date OUT NOCOPY DATE
1470: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
1471: ,p_application_id per_applications.application_id%TYPE

Line 1470: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE

1466: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
1467: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
1468: ,p_asg_validation_start_date OUT NOCOPY DATE
1469: ,p_asg_validation_end_date OUT NOCOPY DATE
1470: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
1471: ,p_application_id per_applications.application_id%TYPE
1472: ,p_app_object_version_number per_applications.object_version_number%TYPE
1473: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
1474: ,p_pds_hire_date per_periods_of_service.date_start%TYPE