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 969: FROM per_all_assignments_f asg, per_periods_of_service pds

965: -- get the pds id id and ovn
966: SELECT asg.period_of_service_id,
967: pds.object_version_number
968: INTO l_pos_id, l_pos_ovn
969: FROM per_all_assignments_f asg, per_periods_of_service pds
970: WHERE asg.assignment_id = l_assignment_id
971: and asg.period_of_service_id = pds.period_of_service_id;
972:
973: p_period_of_service_id := l_pos_id;

Line 2660: from per_all_assignments_f asg

2656: end if;
2657: if p_assignment_id is not null
2658: and p_assignment_id > 0 then
2659: select asg.object_version_number into l_asg_object_version_number
2660: from per_all_assignments_f asg
2661: where asg.assignment_id=p_assignment_id
2662: -- and p_effective_date between asg.effective_start_date and asg.effective_end_date;
2663: and l_creation_date between asg.effective_start_date and asg.effective_end_date;
2664: --

Line 2701: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE

2697: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
2698: --CWK
2699: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
2700: ,p_npw_number IN per_all_people_f.npw_number%TYPE
2701: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
2702: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
2703: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
2704: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2705: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE

Line 2702: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE

2698: --CWK
2699: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
2700: ,p_npw_number IN per_all_people_f.npw_number%TYPE
2701: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
2702: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
2703: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
2704: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2705: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
2706: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE

Line 2704: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE

2700: ,p_npw_number IN per_all_people_f.npw_number%TYPE
2701: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
2702: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
2703: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
2704: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2705: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
2706: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
2707: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
2708: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE

Line 2705: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE

2701: ,p_placement_date_start IN per_all_assignments_f.period_of_placement_date_start%TYPE
2702: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
2703: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
2704: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2705: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
2706: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
2707: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
2708: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
2709: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE

Line 2706: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE

2702: ,p_projected_assignment_end IN per_all_assignments_f.projected_assignment_end%TYPE
2703: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
2704: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2705: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
2706: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
2707: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
2708: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
2709: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2710: ,p_project_title IN per_all_assignments_f.project_title%TYPE

Line 2707: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE

2703: ,p_pdp_object_version_number IN OUT NOCOPY per_periods_of_placement.object_version_number%TYPE
2704: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2705: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
2706: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
2707: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
2708: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
2709: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2710: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2711: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE

Line 2708: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE

2704: ,p_vendor_employee_number IN per_all_assignments_f.vendor_employee_number%TYPE
2705: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
2706: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
2707: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
2708: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
2709: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2710: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2711: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2712: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE

Line 2709: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE

2705: ,p_vendor_assignment_number IN per_all_assignments_f.vendor_assignment_number%TYPE
2706: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
2707: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
2708: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
2709: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2710: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2711: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2712: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2713: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE

Line 2710: ,p_project_title IN per_all_assignments_f.project_title%TYPE

2706: ,p_vendor_id IN per_all_assignments_f.vendor_id%TYPE
2707: ,p_vendor_site_id IN per_all_assignments_f.vendor_site_id%TYPE
2708: ,p_po_header_id IN per_all_assignments_f.po_header_id%TYPE
2709: ,p_po_line_id IN per_all_assignments_f.po_line_id%TYPE
2710: ,p_project_title IN per_all_assignments_f.project_title%TYPE
2711: ,p_grade_rule_id IN OUT NOCOPY pay_grade_rules_f.grade_rule_id%TYPE
2712: ,p_rate_id IN pay_grade_rules_f.rate_id%TYPE
2713: ,p_rate_currency_code IN pay_grade_rules_f.currency_code%TYPE
2714: ,p_rate_value IN pay_grade_rules_f.value%TYPE

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

2825: ,p_region_of_birth IN per_all_people_f.region_of_birth%TYPE
2826: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
2827: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
2828: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2829: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
2830: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
2831: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
2832: ,p_asg_validation_start_date OUT NOCOPY DATE
2833: ,p_asg_validation_end_date OUT NOCOPY DATE

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

2826: ,p_country_of_birth IN per_all_people_f.country_of_birth%TYPE
2827: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
2828: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2829: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
2830: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
2831: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
2832: ,p_asg_validation_start_date OUT NOCOPY DATE
2833: ,p_asg_validation_end_date OUT NOCOPY DATE
2834: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE

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

2827: ,p_per_object_version_number IN OUT NOCOPY per_all_people_f.object_version_number%TYPE
2828: ,p_assignment_update_allowed IN VARCHAR2 DEFAULT 'TRUE'
2829: ,p_assignment_id IN OUT NOCOPY per_all_assignments_f.assignment_id%TYPE
2830: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
2831: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
2832: ,p_asg_validation_start_date OUT NOCOPY DATE
2833: ,p_asg_validation_end_date OUT NOCOPY DATE
2834: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
2835: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE

Line 2834: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE

2830: ,p_asg_effective_start_date IN OUT NOCOPY per_all_assignments_f.effective_start_date%TYPE
2831: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
2832: ,p_asg_validation_start_date OUT NOCOPY DATE
2833: ,p_asg_validation_end_date OUT NOCOPY DATE
2834: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
2835: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
2836: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
2837: ,p_position_id IN per_all_assignments_f.position_id%TYPE
2838: ,p_job_id IN per_all_assignments_f.job_id%TYPE

Line 2835: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE

2831: ,p_asg_effective_end_date IN OUT NOCOPY per_all_assignments_f.effective_end_date%TYPE
2832: ,p_asg_validation_start_date OUT NOCOPY DATE
2833: ,p_asg_validation_end_date OUT NOCOPY DATE
2834: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
2835: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
2836: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
2837: ,p_position_id IN per_all_assignments_f.position_id%TYPE
2838: ,p_job_id IN per_all_assignments_f.job_id%TYPE
2839: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

Line 2836: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE

2832: ,p_asg_validation_start_date OUT NOCOPY DATE
2833: ,p_asg_validation_end_date OUT NOCOPY DATE
2834: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
2835: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
2836: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
2837: ,p_position_id IN per_all_assignments_f.position_id%TYPE
2838: ,p_job_id IN per_all_assignments_f.job_id%TYPE
2839: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
2840: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE

Line 2837: ,p_position_id IN per_all_assignments_f.position_id%TYPE

2833: ,p_asg_validation_end_date OUT NOCOPY DATE
2834: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
2835: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
2836: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
2837: ,p_position_id IN per_all_assignments_f.position_id%TYPE
2838: ,p_job_id IN per_all_assignments_f.job_id%TYPE
2839: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
2840: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
2841: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE

Line 2838: ,p_job_id IN per_all_assignments_f.job_id%TYPE

2834: ,p_recruiter_id IN per_all_assignments_f.recruiter_id%TYPE
2835: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
2836: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
2837: ,p_position_id IN per_all_assignments_f.position_id%TYPE
2838: ,p_job_id IN per_all_assignments_f.job_id%TYPE
2839: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
2840: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
2841: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
2842: ,p_location_id IN per_all_assignments_f.location_id%TYPE

Line 2839: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE

2835: ,p_grade_id IN per_all_assignments_f.grade_id%TYPE
2836: ,p_grade_ladder_pgm_id IN per_all_assignments_f.grade_ladder_pgm_id%TYPE
2837: ,p_position_id IN per_all_assignments_f.position_id%TYPE
2838: ,p_job_id IN per_all_assignments_f.job_id%TYPE
2839: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
2840: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
2841: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
2842: ,p_location_id IN per_all_assignments_f.location_id%TYPE
2843: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE

Line 2841: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE

2837: ,p_position_id IN per_all_assignments_f.position_id%TYPE
2838: ,p_job_id IN per_all_assignments_f.job_id%TYPE
2839: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
2840: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
2841: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
2842: ,p_location_id IN per_all_assignments_f.location_id%TYPE
2843: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
2844: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
2845: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE

Line 2842: ,p_location_id IN per_all_assignments_f.location_id%TYPE

2838: ,p_job_id IN per_all_assignments_f.job_id%TYPE
2839: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
2840: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
2841: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
2842: ,p_location_id IN per_all_assignments_f.location_id%TYPE
2843: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
2844: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
2845: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
2846: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE

Line 2843: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE

2839: ,p_assignment_status_type_id IN per_all_assignments_f.assignment_status_type_id%TYPE
2840: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
2841: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
2842: ,p_location_id IN per_all_assignments_f.location_id%TYPE
2843: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
2844: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
2845: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
2846: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
2847: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE

Line 2844: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE

2840: ,p_system_status IN per_assignment_status_types.per_system_status%TYPE
2841: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
2842: ,p_location_id IN per_all_assignments_f.location_id%TYPE
2843: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
2844: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
2845: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
2846: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
2847: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
2848: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE

Line 2845: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE

2841: ,p_payroll_id IN per_all_assignments_f.payroll_id%TYPE
2842: ,p_location_id IN per_all_assignments_f.location_id%TYPE
2843: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
2844: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
2845: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
2846: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
2847: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
2848: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
2849: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE

Line 2846: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE

2842: ,p_location_id IN per_all_assignments_f.location_id%TYPE
2843: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
2844: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
2845: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
2846: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
2847: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
2848: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
2849: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
2850: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE

Line 2847: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE

2843: ,p_person_referred_by_id IN per_all_assignments_f.person_referred_by_id%TYPE
2844: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
2845: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
2846: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
2847: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
2848: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
2849: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
2850: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
2851: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE

Line 2848: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE

2844: ,p_supervisor_id IN per_all_assignments_f.supervisor_id%TYPE
2845: ,p_supervisor_assignment_id IN per_all_assignments_f.supervisor_assignment_id%TYPE
2846: ,p_recruitment_activity_id IN per_all_assignments_f.recruitment_activity_id%TYPE
2847: ,p_source_organization_id IN per_all_assignments_f.source_organization_id%TYPE
2848: ,p_organization_id IN per_all_assignments_f.organization_id%TYPE
2849: ,p_pgp_segment1 IN pay_people_groups.segment1%TYPE
2850: ,p_pgp_segment2 IN pay_people_groups.segment2%TYPE
2851: ,p_pgp_segment3 IN pay_people_groups.segment3%TYPE
2852: ,p_pgp_segment4 IN pay_people_groups.segment4%TYPE

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

2875: ,p_pgp_segment27 IN pay_people_groups.segment27%TYPE
2876: ,p_pgp_segment28 IN pay_people_groups.segment28%TYPE
2877: ,p_pgp_segment29 IN pay_people_groups.segment29%TYPE
2878: ,p_pgp_segment30 IN pay_people_groups.segment30%TYPE
2879: ,p_people_group_id IN OUT NOCOPY per_all_assignments_f.people_group_id%TYPE
2880: ,p_scl_segment1 IN hr_soft_coding_keyflex.segment1%TYPE
2881: ,p_scl_segment2 IN hr_soft_coding_keyflex.segment2%TYPE
2882: ,p_scl_segment3 IN hr_soft_coding_keyflex.segment3%TYPE
2883: ,p_scl_segment4 IN hr_soft_coding_keyflex.segment4%TYPE

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

2906: ,p_scl_segment27 IN hr_soft_coding_keyflex.segment27%TYPE
2907: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
2908: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
2909: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
2910: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
2911: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
2912: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
2913: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
2914: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE

Line 2911: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE

2907: ,p_scl_segment28 IN hr_soft_coding_keyflex.segment28%TYPE
2908: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
2909: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
2910: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
2911: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
2912: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
2913: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
2914: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
2915: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE

Line 2912: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE

2908: ,p_scl_segment29 IN hr_soft_coding_keyflex.segment29%TYPE
2909: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
2910: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
2911: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
2912: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
2913: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
2914: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
2915: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
2916: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE

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

2909: ,p_scl_segment30 IN hr_soft_coding_keyflex.segment30%TYPE
2910: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
2911: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
2912: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
2913: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
2914: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
2915: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
2916: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
2917: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE

Line 2914: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE

2910: ,p_soft_coding_keyflex_id IN OUT NOCOPY per_all_assignments_f.soft_coding_keyflex_id%TYPE
2911: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
2912: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
2913: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
2914: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
2915: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
2916: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
2917: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
2918: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE

Line 2915: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE

2911: ,p_vacancy_id IN per_all_assignments_f.vacancy_id%TYPE
2912: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
2913: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
2914: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
2915: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
2916: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
2917: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
2918: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
2919: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE

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

2912: ,p_pay_basis_id IN per_all_assignments_f.pay_basis_id%TYPE
2913: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
2914: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
2915: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
2916: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
2917: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
2918: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
2919: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
2920: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE

Line 2917: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE

2913: ,p_assignment_sequence IN OUT NOCOPY per_all_assignments_f.assignment_sequence%TYPE
2914: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
2915: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
2916: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
2917: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
2918: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
2919: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
2920: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
2921: ,p_frequency IN per_all_assignments_f.frequency%TYPE

Line 2918: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE

2914: ,p_assignment_type IN per_all_assignments_f.assignment_type%TYPE
2915: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
2916: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
2917: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
2918: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
2919: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
2920: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
2921: ,p_frequency IN per_all_assignments_f.frequency%TYPE
2922: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE

Line 2919: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE

2915: ,p_asg_primary_flag IN per_all_assignments_f.primary_flag%TYPE
2916: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
2917: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
2918: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
2919: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
2920: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
2921: ,p_frequency IN per_all_assignments_f.frequency%TYPE
2922: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
2923: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE

Line 2920: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE

2916: ,p_assignment_number IN OUT NOCOPY per_all_assignments_f.assignment_number%TYPE
2917: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
2918: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
2919: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
2920: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
2921: ,p_frequency IN per_all_assignments_f.frequency%TYPE
2922: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
2923: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
2924: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE

Line 2921: ,p_frequency IN per_all_assignments_f.frequency%TYPE

2917: ,p_date_probation_end IN per_all_assignments_f.date_probation_end%TYPE
2918: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
2919: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
2920: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
2921: ,p_frequency IN per_all_assignments_f.frequency%TYPE
2922: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
2923: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
2924: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
2925: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE

Line 2922: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE

2918: ,p_default_code_comb_id IN per_all_assignments_f.default_code_comb_id%TYPE
2919: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
2920: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
2921: ,p_frequency IN per_all_assignments_f.frequency%TYPE
2922: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
2923: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
2924: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
2925: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
2926: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE

Line 2923: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE

2919: ,p_employment_category IN per_all_assignments_f.employment_category%TYPE
2920: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
2921: ,p_frequency IN per_all_assignments_f.frequency%TYPE
2922: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
2923: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
2924: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
2925: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
2926: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
2927: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE

Line 2924: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE

2920: ,p_employee_category IN per_all_assignments_f.employee_category%TYPE
2921: ,p_frequency IN per_all_assignments_f.frequency%TYPE
2922: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
2923: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
2924: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
2925: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
2926: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
2927: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
2928: --

Line 2925: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE

2921: ,p_frequency IN per_all_assignments_f.frequency%TYPE
2922: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
2923: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
2924: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
2925: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
2926: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
2927: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
2928: --
2929: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE

Line 2926: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE

2922: ,p_normal_hours IN per_all_assignments_f.normal_hours%TYPE
2923: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
2924: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
2925: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
2926: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
2927: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
2928: --
2929: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
2930: ,p_billing_title IN per_all_assignments_f.title%type

Line 2927: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE

2923: ,p_period_of_service_id IN per_all_assignments_f.period_of_service_id%TYPE
2924: ,p_probation_period IN per_all_assignments_f.probation_period%TYPE
2925: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
2926: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
2927: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
2928: --
2929: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
2930: ,p_billing_title IN per_all_assignments_f.title%type
2931: --

Line 2929: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE

2925: ,p_probation_unit IN per_all_assignments_f.probation_unit%TYPE
2926: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
2927: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
2928: --
2929: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
2930: ,p_billing_title IN per_all_assignments_f.title%type
2931: --
2932: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
2933: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE

Line 2930: ,p_billing_title IN per_all_assignments_f.title%type

2926: ,p_notice_period IN per_all_assignments_f.notice_period%TYPE
2927: ,p_notice_unit IN per_all_assignments_f.notice_period_uom%TYPE
2928: --
2929: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
2930: ,p_billing_title IN per_all_assignments_f.title%type
2931: --
2932: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
2933: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
2934: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE

Line 2932: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE

2928: --
2929: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
2930: ,p_billing_title IN per_all_assignments_f.title%type
2931: --
2932: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
2933: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
2934: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
2935: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
2936: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE

Line 2933: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE

2929: ,p_set_of_books_id IN per_all_assignments_f.set_of_books_id%TYPE
2930: ,p_billing_title IN per_all_assignments_f.title%type
2931: --
2932: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
2933: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
2934: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
2935: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
2936: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
2937: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE

Line 2934: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE

2930: ,p_billing_title IN per_all_assignments_f.title%type
2931: --
2932: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
2933: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
2934: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
2935: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
2936: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
2937: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
2938: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE

Line 2935: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE

2931: --
2932: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
2933: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
2934: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
2935: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
2936: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
2937: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
2938: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
2939: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE

Line 2936: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE

2932: ,p_time_normal_finish IN per_all_assignments_f.time_normal_finish%TYPE
2933: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
2934: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
2935: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
2936: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
2937: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
2938: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
2939: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
2940: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE

Line 2937: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE

2933: ,p_time_normal_start IN per_all_assignments_f.time_normal_start%TYPE
2934: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
2935: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
2936: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
2937: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
2938: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
2939: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
2940: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
2941: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE

Line 2938: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE

2934: ,p_ass_attribute_category IN per_all_assignments_f.ass_attribute_category%TYPE
2935: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
2936: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
2937: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
2938: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
2939: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
2940: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
2941: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
2942: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE

Line 2939: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE

2935: ,p_ass_attribute1 IN per_all_assignments_f.ass_attribute1%TYPE
2936: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
2937: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
2938: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
2939: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
2940: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
2941: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
2942: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
2943: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE

Line 2940: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE

2936: ,p_ass_attribute2 IN per_all_assignments_f.ass_attribute2%TYPE
2937: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
2938: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
2939: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
2940: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
2941: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
2942: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
2943: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
2944: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE

Line 2941: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE

2937: ,p_ass_attribute3 IN per_all_assignments_f.ass_attribute3%TYPE
2938: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
2939: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
2940: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
2941: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
2942: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
2943: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
2944: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
2945: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE

Line 2942: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE

2938: ,p_ass_attribute4 IN per_all_assignments_f.ass_attribute4%TYPE
2939: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
2940: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
2941: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
2942: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
2943: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
2944: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
2945: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
2946: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE

Line 2943: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE

2939: ,p_ass_attribute5 IN per_all_assignments_f.ass_attribute5%TYPE
2940: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
2941: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
2942: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
2943: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
2944: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
2945: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
2946: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
2947: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE

Line 2944: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE

2940: ,p_ass_attribute6 IN per_all_assignments_f.ass_attribute6%TYPE
2941: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
2942: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
2943: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
2944: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
2945: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
2946: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
2947: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
2948: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE

Line 2945: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE

2941: ,p_ass_attribute7 IN per_all_assignments_f.ass_attribute7%TYPE
2942: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
2943: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
2944: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
2945: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
2946: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
2947: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
2948: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
2949: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE

Line 2946: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE

2942: ,p_ass_attribute8 IN per_all_assignments_f.ass_attribute8%TYPE
2943: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
2944: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
2945: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
2946: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
2947: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
2948: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
2949: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
2950: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE

Line 2947: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE

2943: ,p_ass_attribute9 IN per_all_assignments_f.ass_attribute9%TYPE
2944: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
2945: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
2946: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
2947: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
2948: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
2949: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
2950: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
2951: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE

Line 2948: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE

2944: ,p_ass_attribute10 IN per_all_assignments_f.ass_attribute10%TYPE
2945: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
2946: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
2947: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
2948: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
2949: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
2950: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
2951: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
2952: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE

Line 2949: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE

2945: ,p_ass_attribute11 IN per_all_assignments_f.ass_attribute11%TYPE
2946: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
2947: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
2948: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
2949: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
2950: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
2951: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
2952: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
2953: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE

Line 2950: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE

2946: ,p_ass_attribute12 IN per_all_assignments_f.ass_attribute12%TYPE
2947: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
2948: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
2949: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
2950: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
2951: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
2952: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
2953: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
2954: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE

Line 2951: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE

2947: ,p_ass_attribute13 IN per_all_assignments_f.ass_attribute13%TYPE
2948: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
2949: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
2950: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
2951: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
2952: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
2953: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
2954: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
2955: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE

Line 2952: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE

2948: ,p_ass_attribute14 IN per_all_assignments_f.ass_attribute14%TYPE
2949: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
2950: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
2951: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
2952: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
2953: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
2954: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
2955: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
2956: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE

Line 2953: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE

2949: ,p_ass_attribute15 IN per_all_assignments_f.ass_attribute15%TYPE
2950: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
2951: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
2952: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
2953: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
2954: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
2955: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
2956: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
2957: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE

Line 2954: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE

2950: ,p_ass_attribute16 IN per_all_assignments_f.ass_attribute16%TYPE
2951: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
2952: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
2953: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
2954: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
2955: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
2956: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
2957: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
2958: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE

Line 2955: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE

2951: ,p_ass_attribute17 IN per_all_assignments_f.ass_attribute17%TYPE
2952: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
2953: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
2954: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
2955: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
2956: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
2957: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
2958: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
2959: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE

Line 2956: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE

2952: ,p_ass_attribute18 IN per_all_assignments_f.ass_attribute18%TYPE
2953: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
2954: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
2955: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
2956: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
2957: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
2958: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
2959: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
2960: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE

Line 2957: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE

2953: ,p_ass_attribute19 IN per_all_assignments_f.ass_attribute19%TYPE
2954: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
2955: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
2956: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
2957: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
2958: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
2959: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
2960: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
2961: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE

Line 2958: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE

2954: ,p_ass_attribute20 IN per_all_assignments_f.ass_attribute20%TYPE
2955: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
2956: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
2957: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
2958: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
2959: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
2960: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
2961: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
2962: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE

Line 2959: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE

2955: ,p_ass_attribute21 IN per_all_assignments_f.ass_attribute21%TYPE
2956: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
2957: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
2958: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
2959: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
2960: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
2961: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
2962: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
2963: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE

Line 2960: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE

2956: ,p_ass_attribute22 IN per_all_assignments_f.ass_attribute22%TYPE
2957: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
2958: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
2959: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
2960: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
2961: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
2962: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
2963: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
2964: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE

Line 2961: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE

2957: ,p_ass_attribute23 IN per_all_assignments_f.ass_attribute23%TYPE
2958: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
2959: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
2960: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
2961: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
2962: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
2963: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
2964: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
2965: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE

Line 2962: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE

2958: ,p_ass_attribute24 IN per_all_assignments_f.ass_attribute24%TYPE
2959: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
2960: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
2961: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
2962: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
2963: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
2964: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
2965: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
2966: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE

Line 2963: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE

2959: ,p_ass_attribute25 IN per_all_assignments_f.ass_attribute25%TYPE
2960: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
2961: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
2962: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
2963: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
2964: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
2965: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
2966: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
2967: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE

Line 2964: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE

2960: ,p_ass_attribute26 IN per_all_assignments_f.ass_attribute26%TYPE
2961: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
2962: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
2963: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
2964: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
2965: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
2966: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
2967: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
2968: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE

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

2961: ,p_ass_attribute27 IN per_all_assignments_f.ass_attribute27%TYPE
2962: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
2963: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
2964: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
2965: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
2966: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
2967: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
2968: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
2969: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE

Line 2966: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE

2962: ,p_ass_attribute28 IN per_all_assignments_f.ass_attribute28%TYPE
2963: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
2964: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
2965: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
2966: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
2967: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
2968: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
2969: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
2970: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

Line 2967: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE

2963: ,p_ass_attribute29 IN per_all_assignments_f.ass_attribute29%TYPE
2964: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
2965: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
2966: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
2967: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
2968: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
2969: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
2970: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
2971: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE

Line 2968: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE

2964: ,p_ass_attribute30 IN per_all_assignments_f.ass_attribute30%TYPE
2965: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
2966: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
2967: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
2968: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
2969: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
2970: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
2971: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
2972: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE

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

2965: ,p_asg_object_version_number IN OUT NOCOPY per_all_assignments_f.object_version_number%TYPE
2966: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
2967: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
2968: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
2969: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
2970: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
2971: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
2972: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
2973: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE

Line 2970: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE

2966: ,p_bargaining_unit_code IN per_all_assignments_f.bargaining_unit_code%TYPE
2967: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
2968: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
2969: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
2970: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
2971: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
2972: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
2973: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
2974: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE

Line 2971: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE

2967: ,p_labour_union_member_flag IN per_all_assignments_f.labour_union_member_flag%TYPE
2968: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
2969: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
2970: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
2971: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
2972: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
2973: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
2974: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
2975: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE

Line 2972: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE

2968: ,p_hourly_salaried_code IN per_all_assignments_f.hourly_salaried_code%TYPE
2969: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
2970: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
2971: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
2972: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
2973: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
2974: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
2975: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
2976: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE

Line 2973: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE

2969: ,p_special_ceiling_step_id IN OUT NOCOPY per_all_assignments_f.special_ceiling_step_id%TYPE
2970: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
2971: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
2972: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
2973: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
2974: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
2975: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
2976: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
2977: ,p_source_type IN per_all_assignments_f.source_type%TYPE

Line 2974: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE

2970: ,p_change_reason IN per_all_assignments_f.change_reason%TYPE
2971: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
2972: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
2973: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
2974: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
2975: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
2976: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
2977: ,p_source_type IN per_all_assignments_f.source_type%TYPE
2978: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE

Line 2975: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE

2971: ,p_internal_address_line IN per_all_assignments_f.internal_address_line%TYPE
2972: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
2973: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
2974: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
2975: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
2976: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
2977: ,p_source_type IN per_all_assignments_f.source_type%TYPE
2978: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
2979: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE

Line 2976: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE

2972: ,p_manager_flag IN per_all_assignments_f.manager_flag%TYPE
2973: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
2974: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
2975: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
2976: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
2977: ,p_source_type IN per_all_assignments_f.source_type%TYPE
2978: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
2979: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
2980: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE

Line 2977: ,p_source_type IN per_all_assignments_f.source_type%TYPE

2973: ,p_perf_review_period IN per_all_assignments_f.perf_review_period%TYPE
2974: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
2975: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
2976: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
2977: ,p_source_type IN per_all_assignments_f.source_type%TYPE
2978: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
2979: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
2980: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
2981: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE

Line 2978: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE

2974: ,p_perf_review_period_frequency IN per_all_assignments_f.perf_review_period_frequency%TYPE
2975: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
2976: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
2977: ,p_source_type IN per_all_assignments_f.source_type%TYPE
2978: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
2979: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
2980: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
2981: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
2982: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE

Line 2979: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE

2975: ,p_sal_review_period IN per_all_assignments_f.sal_review_period%TYPE
2976: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
2977: ,p_source_type IN per_all_assignments_f.source_type%TYPE
2978: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
2979: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
2980: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
2981: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
2982: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
2983: --Bug 3063591 Start Here

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

2976: ,p_sal_review_period_frequency IN per_all_assignments_f.sal_review_period_frequency%TYPE
2977: ,p_source_type IN per_all_assignments_f.source_type%TYPE
2978: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
2979: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
2980: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
2981: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
2982: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
2983: --Bug 3063591 Start Here
2984: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null

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

2977: ,p_source_type IN per_all_assignments_f.source_type%TYPE
2978: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
2979: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
2980: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
2981: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
2982: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
2983: --Bug 3063591 Start Here
2984: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
2985: --Bug 3063591 End Here

Line 2982: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE

2978: ,p_contract_id IN per_all_assignments_f.contract_id%TYPE
2979: ,p_collective_agreement_id IN per_all_assignments_f.collective_agreement_id%TYPE
2980: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
2981: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
2982: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
2983: --Bug 3063591 Start Here
2984: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
2985: --Bug 3063591 End Here
2986: ,p_application_id IN per_applications.application_id%TYPE

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

2980: ,p_cagr_id_flex_num IN OUT NOCOPY per_all_assignments_f.cagr_id_flex_num%TYPE
2981: ,p_cagr_grade_def_id IN OUT NOCOPY per_all_assignments_f.cagr_grade_def_id%TYPE
2982: ,p_establishment_id IN per_all_assignments_f.establishment_id%TYPE
2983: --Bug 3063591 Start Here
2984: ,p_work_at_home IN per_all_assignments_f.work_at_home%TYPE default null
2985: --Bug 3063591 End Here
2986: ,p_application_id IN per_applications.application_id%TYPE
2987: ,p_projected_hire_date IN per_applications.projected_hire_date%TYPE
2988: ,p_appl_attribute_category IN per_applications.appl_attribute_category%TYPE

Line 3412: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;

3408: l_assign_payroll_warning BOOLEAN;
3409: l_orig_hire_warning BOOLEAN;
3410: --
3411: l_assignment_id NUMBER;
3412: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3413: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3414: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3415: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
3416: l_group_name VARCHAR2(240);

Line 3413: l_assignment_number per_all_assignments_f.assignment_number%TYPE;

3409: l_orig_hire_warning BOOLEAN;
3410: --
3411: l_assignment_id NUMBER;
3412: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3413: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3414: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3415: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
3416: l_group_name VARCHAR2(240);
3417: l_asg_effective_start_date DATE;

Line 3414: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;

3410: --
3411: l_assignment_id NUMBER;
3412: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3413: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3414: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3415: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
3416: l_group_name VARCHAR2(240);
3417: l_asg_effective_start_date DATE;
3418: l_asg_effective_end_date DATE;

Line 3415: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;

3411: l_assignment_id NUMBER;
3412: l_assignment_sequence per_all_assignments_f.assignment_sequence%TYPE;
3413: l_assignment_number per_all_assignments_f.assignment_number%TYPE;
3414: l_asg_object_version_number per_all_assignments_f.object_version_number%TYPE;
3415: l_special_ceiling_step_id per_all_assignments_f.special_ceiling_step_id%TYPE;
3416: l_group_name VARCHAR2(240);
3417: l_asg_effective_start_date DATE;
3418: l_asg_effective_end_date DATE;
3419: l_asg_validation_start_date DATE;

Line 6984: from per_all_assignments_f asg

6980: end if;
6981: if p_assignment_id is not null
6982: and p_assignment_id > 0 then
6983: select asg.object_version_number into l_asg_object_version_number
6984: from per_all_assignments_f asg
6985: where asg.assignment_id=p_assignment_id
6986: and p_effective_date between asg.effective_start_date and asg.effective_end_date;
6987: --
6988: p_asg_object_version_number := l_asg_object_version_number;

Line 7016: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE

7012: ,p_rate_effective_end_date pay_grade_rules_f.effective_end_date%TYPE
7013: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
7014: --
7015: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
7016: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
7017: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
7018: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
7019: ,p_asg_validation_start_date OUT NOCOPY DATE
7020: ,p_asg_validation_end_date OUT NOCOPY DATE

Line 7017: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE

7013: ,p_rate_object_version_number pay_grade_rules_f.object_version_number%TYPE
7014: --
7015: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
7016: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
7017: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
7018: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
7019: ,p_asg_validation_start_date OUT NOCOPY DATE
7020: ,p_asg_validation_end_date OUT NOCOPY DATE
7021: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE

Line 7018: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE

7014: --
7015: ,p_assignment_update_allowed VARCHAR2 DEFAULT 'TRUE'
7016: ,p_assignment_id per_all_assignments_f.assignment_id%TYPE
7017: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
7018: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
7019: ,p_asg_validation_start_date OUT NOCOPY DATE
7020: ,p_asg_validation_end_date OUT NOCOPY DATE
7021: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
7022: ,p_application_id per_applications.application_id%TYPE

Line 7021: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE

7017: ,p_asg_effective_start_date per_all_assignments_f.effective_start_date%TYPE
7018: ,p_asg_effective_end_date per_all_assignments_f.effective_end_date%TYPE
7019: ,p_asg_validation_start_date OUT NOCOPY DATE
7020: ,p_asg_validation_end_date OUT NOCOPY DATE
7021: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
7022: ,p_application_id per_applications.application_id%TYPE
7023: ,p_app_object_version_number per_applications.object_version_number%TYPE
7024: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
7025: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE