eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_ALL_ASSIGNMENTS_F

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

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

Line 34: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE

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

Line 36: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE

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

Line 37: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE

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

Line 38: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE

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

Line 39: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE

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

Line 40: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE

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

Line 41: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE

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

Line 42: ,p_project_title IN per_all_assignments_f.project_title%TYPE

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

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

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

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

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

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

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

Line 168: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE

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

Line 169: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE

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

Line 170: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE

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

Line 171: ,p_position_id IN per_all_assignments_f.position_id%TYPE

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

Line 172: ,p_job_id IN per_all_assignments_f.job_id%TYPE

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

Line 173: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

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

Line 175: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE

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

Line 176: ,p_location_id IN per_all_assignments_f.location_id%TYPE

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

Line 177: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE

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

Line 178: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE

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

Line 179: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE

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

Line 180: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE

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

Line 181: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE

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

Line 182: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE

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

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

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

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

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

Line 245: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE

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

Line 246: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE

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

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

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

Line 248: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE

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

Line 249: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE

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

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

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

Line 251: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE

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

Line 252: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE

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

Line 253: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE

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

Line 254: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE

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

Line 255: ,p_frequency IN per_all_assignments_f.frequency%TYPE

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

Line 256: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE

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

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

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

Line 258: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE

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

Line 259: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE

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

Line 260: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE

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

Line 261: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE

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

Line 263: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE

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

Line 264: ,p_billing_title IN per_all_assignments_f.title%type

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

Line 266: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE

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

Line 267: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE

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

Line 268: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE

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

Line 269: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE

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

Line 270: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE

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

Line 271: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE

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

Line 272: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE

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

Line 273: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE

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

Line 274: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE

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

Line 275: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE

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

Line 276: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE

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

Line 277: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE

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

Line 278: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE

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

Line 279: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE

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

Line 280: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE

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

Line 281: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE

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

Line 282: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE

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

Line 283: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE

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

Line 284: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE

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

Line 285: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE

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

Line 286: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE

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

Line 287: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE

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

Line 288: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE

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

Line 289: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE

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

Line 290: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE

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

Line 291: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE

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

Line 292: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE

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

Line 293: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE

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

Line 294: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE

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

Line 295: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE

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

Line 296: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE

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

Line 297: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE

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

Line 298: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE

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

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

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

Line 300: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE

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

Line 301: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE

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

Line 302: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE

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

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

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

Line 304: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

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

Line 305: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE

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

Line 306: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE

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

Line 307: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE

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

Line 308: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE

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

Line 309: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE

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

Line 310: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE

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

Line 311: ,p_source_type IN per_all_assignments_f.source_type%TYPE

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

Line 312: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE

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

Line 313: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE

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

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

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

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

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

Line 316: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE

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

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

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

Line 746: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

742: l_assign_payroll_warning BOOLEAN;
743: l_orig_hire_warning BOOLEAN;
744: --
745: l_assignment_id NUMBER;
746: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
747: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
748: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
749: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
750: l_group_name VARCHAR2(240);

Line 747: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;

743: l_orig_hire_warning BOOLEAN;
744: --
745: l_assignment_id NUMBER;
746: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
747: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
748: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
749: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
750: l_group_name VARCHAR2(240);
751: l_asg_effective_start_date DATE;

Line 748: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

744: --
745: l_assignment_id NUMBER;
746: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
747: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
748: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
749: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
750: l_group_name VARCHAR2(240);
751: l_asg_effective_start_date DATE;
752: l_asg_effective_end_date DATE;

Line 749: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

745: l_assignment_id NUMBER;
746: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
747: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
748: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
749: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
750: l_group_name VARCHAR2(240);
751: l_asg_effective_start_date DATE;
752: l_asg_effective_end_date DATE;
753: l_asg_validation_start_date DATE;

Line 811: l_work_at_home per_all_assignments_f.work_at_home%TYPE; --Fix for bug9215178

807: --
808: l_gsp_post_process_warning varchar2(30);
809: l_gsp_post_process_warning2 varchar2(30);
810: --
811: l_work_at_home per_all_assignments_f.work_at_home%TYPE; --Fix for bug9215178
812: l_proc VARCHAR2(72) := g_package||'insert_maintain_data';
813: BEGIN
814: hr_utility.set_location('Entering:'|| l_proc, 10);
815: --

Line 975: FROM per_all_assignments_f asg, per_periods_of_service pds

971: -- get the pds id id and ovn
972: SELECT asg.period_of_service_id,
973: pds.object_version_number
974: INTO l_pos_id, l_pos_ovn
975: FROM per_all_assignments_f asg, per_periods_of_service pds
976: WHERE asg.assignment_id = l_assignment_id
977: and asg.period_of_service_id = pds.period_of_service_id;
978:
979: p_period_of_service_id := l_pos_id;

Line 2693: from per_all_assignments_f asg

2689: end if;
2690: if p_assignment_id is not null
2691: and p_assignment_id > 0 then
2692: select asg.object_version_number into l_asg_object_version_number
2693: from per_all_assignments_f asg
2694: where asg.assignment_id=p_assignment_id
2695: -- and p_effective_date between asg.effective_start_date and asg.effective_end_date;
2696: and l_creation_date between asg.effective_start_date and asg.effective_end_date;
2697: --

Line 2735: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE

2731: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
2732: --CWK
2733: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
2734: ,p_npw_number IN per_all_people_f.npw_number%TYPE
2735: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
2736: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
2737: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
2738: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2739: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE

Line 2736: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE

2732: --CWK
2733: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
2734: ,p_npw_number IN per_all_people_f.npw_number%TYPE
2735: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
2736: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
2737: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
2738: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2739: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
2740: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE

Line 2738: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE

2734: ,p_npw_number IN per_all_people_f.npw_number%TYPE
2735: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
2736: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
2737: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
2738: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2739: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
2740: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
2741: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
2742: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE

Line 2739: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE

2735: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
2736: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
2737: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
2738: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2739: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
2740: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
2741: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
2742: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
2743: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE

Line 2740: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE

2736: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
2737: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
2738: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2739: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
2740: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
2741: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
2742: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
2743: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2744: ,p_project_title IN per_all_assignments_f.project_title%TYPE

Line 2741: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE

2737: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
2738: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2739: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
2740: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
2741: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
2742: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
2743: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2744: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2745: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE

Line 2742: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE

2738: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2739: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
2740: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
2741: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
2742: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
2743: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2744: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2745: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2746: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE

Line 2743: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE

2739: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
2740: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
2741: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
2742: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
2743: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2744: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2745: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2746: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2747: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE

Line 2744: ,p_project_title IN per_all_assignments_f.project_title%TYPE

2740: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
2741: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
2742: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
2743: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2744: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2745: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2746: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2747: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2748: ,p_rate_value IN pay_grade_rules_f.value%TYPE

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

2859: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
2860: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
2861: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
2862: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2863: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
2864: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
2865: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
2866: ,p_asg_validation_start_date OUT NOCOPY DATE
2867: ,p_asg_validation_end_date OUT NOCOPY DATE

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

2860: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
2861: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
2862: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2863: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
2864: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
2865: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
2866: ,p_asg_validation_start_date OUT NOCOPY DATE
2867: ,p_asg_validation_end_date OUT NOCOPY DATE
2868: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE

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

2861: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
2862: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2863: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
2864: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
2865: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
2866: ,p_asg_validation_start_date OUT NOCOPY DATE
2867: ,p_asg_validation_end_date OUT NOCOPY DATE
2868: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
2869: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE

Line 2868: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE

2864: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
2865: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
2866: ,p_asg_validation_start_date OUT NOCOPY DATE
2867: ,p_asg_validation_end_date OUT NOCOPY DATE
2868: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
2869: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
2870: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
2871: ,p_position_id IN per_all_assignments_f.position_id%TYPE
2872: ,p_job_id IN per_all_assignments_f.job_id%TYPE

Line 2869: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE

2865: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
2866: ,p_asg_validation_start_date OUT NOCOPY DATE
2867: ,p_asg_validation_end_date OUT NOCOPY DATE
2868: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
2869: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
2870: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
2871: ,p_position_id IN per_all_assignments_f.position_id%TYPE
2872: ,p_job_id IN per_all_assignments_f.job_id%TYPE
2873: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

Line 2870: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE

2866: ,p_asg_validation_start_date OUT NOCOPY DATE
2867: ,p_asg_validation_end_date OUT NOCOPY DATE
2868: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
2869: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
2870: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
2871: ,p_position_id IN per_all_assignments_f.position_id%TYPE
2872: ,p_job_id IN per_all_assignments_f.job_id%TYPE
2873: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
2874: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE

Line 2871: ,p_position_id IN per_all_assignments_f.position_id%TYPE

2867: ,p_asg_validation_end_date OUT NOCOPY DATE
2868: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
2869: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
2870: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
2871: ,p_position_id IN per_all_assignments_f.position_id%TYPE
2872: ,p_job_id IN per_all_assignments_f.job_id%TYPE
2873: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
2874: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
2875: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE

Line 2872: ,p_job_id IN per_all_assignments_f.job_id%TYPE

2868: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
2869: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
2870: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
2871: ,p_position_id IN per_all_assignments_f.position_id%TYPE
2872: ,p_job_id IN per_all_assignments_f.job_id%TYPE
2873: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
2874: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
2875: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
2876: ,p_location_id IN per_all_assignments_f.location_id%TYPE

Line 2873: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

2869: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
2870: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
2871: ,p_position_id IN per_all_assignments_f.position_id%TYPE
2872: ,p_job_id IN per_all_assignments_f.job_id%TYPE
2873: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
2874: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
2875: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
2876: ,p_location_id IN per_all_assignments_f.location_id%TYPE
2877: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE

Line 2875: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE

2871: ,p_position_id IN per_all_assignments_f.position_id%TYPE
2872: ,p_job_id IN per_all_assignments_f.job_id%TYPE
2873: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
2874: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
2875: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
2876: ,p_location_id IN per_all_assignments_f.location_id%TYPE
2877: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
2878: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
2879: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE

Line 2876: ,p_location_id IN per_all_assignments_f.location_id%TYPE

2872: ,p_job_id IN per_all_assignments_f.job_id%TYPE
2873: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
2874: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
2875: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
2876: ,p_location_id IN per_all_assignments_f.location_id%TYPE
2877: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
2878: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
2879: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
2880: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE

Line 2877: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE

2873: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
2874: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
2875: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
2876: ,p_location_id IN per_all_assignments_f.location_id%TYPE
2877: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
2878: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
2879: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
2880: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
2881: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE

Line 2878: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE

2874: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
2875: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
2876: ,p_location_id IN per_all_assignments_f.location_id%TYPE
2877: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
2878: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
2879: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
2880: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
2881: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
2882: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE

Line 2879: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE

2875: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
2876: ,p_location_id IN per_all_assignments_f.location_id%TYPE
2877: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
2878: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
2879: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
2880: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
2881: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
2882: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
2883: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE

Line 2880: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE

2876: ,p_location_id IN per_all_assignments_f.location_id%TYPE
2877: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
2878: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
2879: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
2880: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
2881: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
2882: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
2883: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
2884: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE

Line 2881: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE

2877: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
2878: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
2879: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
2880: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
2881: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
2882: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
2883: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
2884: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
2885: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE

Line 2882: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE

2878: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
2879: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
2880: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
2881: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
2882: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
2883: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
2884: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
2885: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
2886: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE

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

2909: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
2910: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
2911: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
2912: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
2913: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
2914: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
2915: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
2916: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
2917: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE

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

2940: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
2941: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
2942: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
2943: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
2944: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
2945: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
2946: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
2947: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
2948: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE

Line 2945: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE

2941: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
2942: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
2943: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
2944: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
2945: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
2946: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
2947: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
2948: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
2949: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE

Line 2946: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE

2942: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
2943: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
2944: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
2945: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
2946: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
2947: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
2948: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
2949: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
2950: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE

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

2943: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
2944: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
2945: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
2946: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
2947: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
2948: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
2949: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
2950: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
2951: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE

Line 2948: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE

2944: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
2945: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
2946: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
2947: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
2948: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
2949: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
2950: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
2951: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
2952: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE

Line 2949: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE

2945: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
2946: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
2947: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
2948: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
2949: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
2950: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
2951: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
2952: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
2953: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE

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

2946: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
2947: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
2948: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
2949: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
2950: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
2951: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
2952: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
2953: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
2954: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE

Line 2951: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE

2947: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
2948: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
2949: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
2950: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
2951: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
2952: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
2953: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
2954: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
2955: ,p_frequency IN per_all_assignments_f.frequency%TYPE

Line 2952: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE

2948: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
2949: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
2950: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
2951: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
2952: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
2953: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
2954: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
2955: ,p_frequency IN per_all_assignments_f.frequency%TYPE
2956: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE

Line 2953: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE

2949: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
2950: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
2951: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
2952: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
2953: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
2954: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
2955: ,p_frequency IN per_all_assignments_f.frequency%TYPE
2956: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
2957: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE

Line 2954: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE

2950: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
2951: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
2952: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
2953: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
2954: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
2955: ,p_frequency IN per_all_assignments_f.frequency%TYPE
2956: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
2957: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
2958: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE

Line 2955: ,p_frequency IN per_all_assignments_f.frequency%TYPE

2951: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
2952: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
2953: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
2954: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
2955: ,p_frequency IN per_all_assignments_f.frequency%TYPE
2956: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
2957: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
2958: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
2959: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE

Line 2956: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE

2952: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
2953: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
2954: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
2955: ,p_frequency IN per_all_assignments_f.frequency%TYPE
2956: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
2957: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
2958: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
2959: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
2960: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE

Line 2957: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE

2953: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
2954: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
2955: ,p_frequency IN per_all_assignments_f.frequency%TYPE
2956: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
2957: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
2958: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
2959: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
2960: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
2961: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE

Line 2958: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE

2954: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
2955: ,p_frequency IN per_all_assignments_f.frequency%TYPE
2956: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
2957: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
2958: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
2959: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
2960: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
2961: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
2962: --

Line 2959: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE

2955: ,p_frequency IN per_all_assignments_f.frequency%TYPE
2956: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
2957: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
2958: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
2959: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
2960: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
2961: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
2962: --
2963: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE

Line 2960: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE

2956: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
2957: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
2958: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
2959: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
2960: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
2961: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
2962: --
2963: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
2964: ,p_billing_title IN per_all_assignments_f.title%type

Line 2961: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE

2957: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
2958: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
2959: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
2960: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
2961: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
2962: --
2963: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
2964: ,p_billing_title IN per_all_assignments_f.title%type
2965: --

Line 2963: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE

2959: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
2960: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
2961: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
2962: --
2963: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
2964: ,p_billing_title IN per_all_assignments_f.title%type
2965: --
2966: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
2967: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE

Line 2964: ,p_billing_title IN per_all_assignments_f.title%type

2960: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
2961: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
2962: --
2963: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
2964: ,p_billing_title IN per_all_assignments_f.title%type
2965: --
2966: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
2967: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
2968: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE

Line 2966: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE

2962: --
2963: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
2964: ,p_billing_title IN per_all_assignments_f.title%type
2965: --
2966: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
2967: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
2968: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
2969: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
2970: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE

Line 2967: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE

2963: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
2964: ,p_billing_title IN per_all_assignments_f.title%type
2965: --
2966: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
2967: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
2968: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
2969: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
2970: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
2971: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE

Line 2968: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE

2964: ,p_billing_title IN per_all_assignments_f.title%type
2965: --
2966: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
2967: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
2968: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
2969: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
2970: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
2971: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
2972: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE

Line 2969: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE

2965: --
2966: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
2967: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
2968: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
2969: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
2970: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
2971: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
2972: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
2973: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE

Line 2970: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE

2966: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
2967: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
2968: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
2969: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
2970: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
2971: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
2972: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
2973: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
2974: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE

Line 2971: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE

2967: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
2968: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
2969: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
2970: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
2971: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
2972: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
2973: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
2974: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
2975: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE

Line 2972: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE

2968: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
2969: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
2970: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
2971: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
2972: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
2973: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
2974: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
2975: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
2976: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE

Line 2973: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE

2969: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
2970: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
2971: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
2972: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
2973: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
2974: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
2975: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
2976: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
2977: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE

Line 2974: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE

2970: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
2971: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
2972: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
2973: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
2974: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
2975: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
2976: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
2977: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
2978: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE

Line 2975: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE

2971: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
2972: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
2973: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
2974: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
2975: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
2976: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
2977: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
2978: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
2979: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE

Line 2976: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE

2972: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
2973: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
2974: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
2975: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
2976: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
2977: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
2978: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
2979: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
2980: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE

Line 2977: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE

2973: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
2974: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
2975: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
2976: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
2977: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
2978: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
2979: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
2980: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
2981: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE

Line 2978: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE

2974: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
2975: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
2976: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
2977: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
2978: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
2979: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
2980: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
2981: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
2982: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE

Line 2979: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE

2975: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
2976: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
2977: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
2978: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
2979: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
2980: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
2981: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
2982: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
2983: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE

Line 2980: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE

2976: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
2977: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
2978: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
2979: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
2980: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
2981: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
2982: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
2983: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
2984: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE

Line 2981: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE

2977: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
2978: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
2979: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
2980: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
2981: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
2982: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
2983: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
2984: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
2985: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE

Line 2982: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE

2978: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
2979: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
2980: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
2981: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
2982: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
2983: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
2984: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
2985: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
2986: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE

Line 2983: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE

2979: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
2980: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
2981: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
2982: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
2983: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
2984: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
2985: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
2986: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
2987: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE

Line 2984: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE

2980: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
2981: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
2982: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
2983: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
2984: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
2985: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
2986: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
2987: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
2988: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE

Line 2985: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE

2981: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
2982: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
2983: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
2984: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
2985: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
2986: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
2987: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
2988: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
2989: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE

Line 2986: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE

2982: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
2983: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
2984: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
2985: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
2986: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
2987: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
2988: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
2989: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
2990: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE

Line 2987: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE

2983: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
2984: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
2985: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
2986: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
2987: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
2988: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
2989: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
2990: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
2991: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE

Line 2988: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE

2984: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
2985: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
2986: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
2987: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
2988: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
2989: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
2990: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
2991: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
2992: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE

Line 2989: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE

2985: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
2986: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
2987: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
2988: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
2989: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
2990: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
2991: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
2992: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
2993: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE

Line 2990: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE

2986: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
2987: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
2988: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
2989: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
2990: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
2991: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
2992: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
2993: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
2994: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE

Line 2991: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE

2987: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
2988: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
2989: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
2990: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
2991: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
2992: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
2993: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
2994: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
2995: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE

Line 2992: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE

2988: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
2989: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
2990: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
2991: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
2992: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
2993: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
2994: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
2995: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
2996: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE

Line 2993: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE

2989: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
2990: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
2991: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
2992: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
2993: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
2994: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
2995: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
2996: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
2997: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE

Line 2994: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE

2990: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
2991: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
2992: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
2993: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
2994: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
2995: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
2996: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
2997: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
2998: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE

Line 2995: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE

2991: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
2992: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
2993: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
2994: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
2995: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
2996: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
2997: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
2998: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
2999: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

Line 2996: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE

2992: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
2993: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
2994: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
2995: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
2996: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
2997: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
2998: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
2999: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
3000: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE

Line 2997: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE

2993: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
2994: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
2995: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
2996: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
2997: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
2998: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
2999: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
3000: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
3001: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE

Line 2998: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE

2994: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
2995: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
2996: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
2997: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
2998: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
2999: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
3000: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
3001: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
3002: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE

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

2995: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
2996: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
2997: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
2998: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
2999: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
3000: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
3001: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
3002: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
3003: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE

Line 3000: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE

2996: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
2997: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
2998: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
2999: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
3000: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
3001: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
3002: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
3003: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
3004: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

Line 3001: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE

2997: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
2998: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
2999: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
3000: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
3001: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
3002: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
3003: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
3004: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
3005: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE

Line 3002: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE

2998: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
2999: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
3000: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
3001: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
3002: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
3003: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
3004: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
3005: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
3006: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE

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

2999: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
3000: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
3001: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
3002: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
3003: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
3004: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
3005: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
3006: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
3007: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE

Line 3004: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

3000: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
3001: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
3002: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
3003: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
3004: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
3005: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
3006: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
3007: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
3008: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE

Line 3005: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE

3001: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
3002: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
3003: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
3004: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
3005: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
3006: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
3007: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
3008: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
3009: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE

Line 3006: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE

3002: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
3003: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
3004: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
3005: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
3006: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
3007: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
3008: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
3009: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
3010: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE

Line 3007: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE

3003: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
3004: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
3005: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
3006: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
3007: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
3008: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
3009: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
3010: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
3011: ,p_source_type IN per_all_assignments_f.source_type%TYPE

Line 3008: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE

3004: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
3005: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
3006: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
3007: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
3008: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
3009: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
3010: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
3011: ,p_source_type IN per_all_assignments_f.source_type%TYPE
3012: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE

Line 3009: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE

3005: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
3006: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
3007: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
3008: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
3009: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
3010: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
3011: ,p_source_type IN per_all_assignments_f.source_type%TYPE
3012: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
3013: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE

Line 3010: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE

3006: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
3007: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
3008: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
3009: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
3010: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
3011: ,p_source_type IN per_all_assignments_f.source_type%TYPE
3012: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
3013: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
3014: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE

Line 3011: ,p_source_type IN per_all_assignments_f.source_type%TYPE

3007: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
3008: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
3009: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
3010: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
3011: ,p_source_type IN per_all_assignments_f.source_type%TYPE
3012: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
3013: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
3014: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
3015: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE

Line 3012: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE

3008: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
3009: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
3010: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
3011: ,p_source_type IN per_all_assignments_f.source_type%TYPE
3012: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
3013: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
3014: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
3015: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
3016: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE

Line 3013: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE

3009: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
3010: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
3011: ,p_source_type IN per_all_assignments_f.source_type%TYPE
3012: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
3013: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
3014: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
3015: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
3016: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
3017: --Bug 3063591 Start Here

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

3010: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
3011: ,p_source_type IN per_all_assignments_f.source_type%TYPE
3012: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
3013: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
3014: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
3015: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
3016: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
3017: --Bug 3063591 Start Here
3018: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null

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

3011: ,p_source_type IN per_all_assignments_f.source_type%TYPE
3012: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
3013: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
3014: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
3015: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
3016: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
3017: --Bug 3063591 Start Here
3018: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
3019: --Bug 3063591 End Here

Line 3016: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE

3012: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
3013: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
3014: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
3015: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
3016: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
3017: --Bug 3063591 Start Here
3018: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
3019: --Bug 3063591 End Here
3020: ,p_application_id IN per_applications.application_id%TYPE

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

3014: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
3015: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
3016: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
3017: --Bug 3063591 Start Here
3018: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
3019: --Bug 3063591 End Here
3020: ,p_application_id IN per_applications.application_id%TYPE
3021: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
3022: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE

Line 3446: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

3442: l_assign_payroll_warning BOOLEAN;
3443: l_orig_hire_warning BOOLEAN;
3444: --
3445: l_assignment_id NUMBER;
3446: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3447: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3448: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3449: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
3450: l_group_name VARCHAR2(240);

Line 3447: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

3443: l_orig_hire_warning BOOLEAN;
3444: --
3445: l_assignment_id NUMBER;
3446: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3447: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3448: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3449: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
3450: l_group_name VARCHAR2(240);
3451: l_asg_effective_start_date DATE;

Line 3448: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

3444: --
3445: l_assignment_id NUMBER;
3446: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3447: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3448: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3449: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
3450: l_group_name VARCHAR2(240);
3451: l_asg_effective_start_date DATE;
3452: l_asg_effective_end_date DATE;

Line 3449: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;

3445: l_assignment_id NUMBER;
3446: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3447: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3448: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3449: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
3450: l_group_name VARCHAR2(240);
3451: l_asg_effective_start_date DATE;
3452: l_asg_effective_end_date DATE;
3453: l_asg_validation_start_date DATE;

Line 7024: from per_all_assignments_f asg

7020: end if;
7021: if p_assignment_id is not null
7022: and p_assignment_id > 0 then
7023: select asg.object_version_number into l_asg_object_version_number
7024: from per_all_assignments_f asg
7025: where asg.assignment_id=p_assignment_id
7026: and p_effective_date between asg.effective_start_date and asg.effective_end_date;
7027: --
7028: p_asg_object_version_number := l_asg_object_version_number;

Line 7056: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE

7052: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
7053: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
7054: --
7055: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
7056: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
7057: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
7058: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
7059: ,p_asg_validation_start_date OUT NOCOPY DATE
7060: ,p_asg_validation_end_date OUT NOCOPY DATE

Line 7057: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE

7053: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
7054: --
7055: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
7056: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
7057: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
7058: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
7059: ,p_asg_validation_start_date OUT NOCOPY DATE
7060: ,p_asg_validation_end_date OUT NOCOPY DATE
7061: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE

Line 7058: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE

7054: --
7055: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
7056: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
7057: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
7058: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
7059: ,p_asg_validation_start_date OUT NOCOPY DATE
7060: ,p_asg_validation_end_date OUT NOCOPY DATE
7061: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
7062: ,p_application_id per_applications.application_id%TYPE

Line 7061: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE

7057: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
7058: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
7059: ,p_asg_validation_start_date OUT NOCOPY DATE
7060: ,p_asg_validation_end_date OUT NOCOPY DATE
7061: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
7062: ,p_application_id per_applications.application_id%TYPE
7063: ,p_app_object_version_number per_applications.object_version_number%TYPE
7064: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
7065: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE