DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_PERIODS_OF_SERVICE

Line 25: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241

21: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
22: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
23: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
24: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
25: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
26: --CWK
27: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
28: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
29: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925

Line 345: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE

341: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
342: ,p_current_employer IN per_applications.current_employer%TYPE
343: ,p_termination_reason IN per_applications.termination_reason%TYPE
344: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE
345: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
346: ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE
347: ,p_address_id OUT NOCOPY per_addresses.address_id%TYPE
348: ,p_adr_date_from IN per_addresses.date_from%TYPE
349: ,p_style IN per_addresses.style%TYPE

Line 346: ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE

342: ,p_current_employer IN per_applications.current_employer%TYPE
343: ,p_termination_reason IN per_applications.termination_reason%TYPE
344: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE
345: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
346: ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE
347: ,p_address_id OUT NOCOPY per_addresses.address_id%TYPE
348: ,p_adr_date_from IN per_addresses.date_from%TYPE
349: ,p_style IN per_addresses.style%TYPE
350: ,p_address_line1 IN per_addresses.address_line1%TYPE

Line 1063: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE

1059: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
1060: ,p_current_employer IN per_applications.current_employer%TYPE
1061: ,p_termination_reason IN per_applications.termination_reason%TYPE
1062: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
1063: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
1064: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
1065: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
1066: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
1067: ,p_adr_date_from IN per_addresses.date_from%TYPE

Line 1064: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE

1060: ,p_current_employer IN per_applications.current_employer%TYPE
1061: ,p_termination_reason IN per_applications.termination_reason%TYPE
1062: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
1063: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
1064: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
1065: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
1066: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
1067: ,p_adr_date_from IN per_addresses.date_from%TYPE
1068: ,p_style IN per_addresses.style%TYPE

Line 1065: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE

1061: ,p_termination_reason IN per_applications.termination_reason%TYPE
1062: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
1063: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
1064: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
1065: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
1066: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
1067: ,p_adr_date_from IN per_addresses.date_from%TYPE
1068: ,p_style IN per_addresses.style%TYPE
1069: ,p_address_line1 IN per_addresses.address_line1%TYPE

Line 1473: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE

1469: ,p_asg_validation_end_date OUT NOCOPY DATE
1470: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
1471: ,p_application_id per_applications.application_id%TYPE
1472: ,p_app_object_version_number per_applications.object_version_number%TYPE
1473: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
1474: ,p_pds_hire_date per_periods_of_service.date_start%TYPE
1475: ,p_address_id per_addresses.address_id%TYPE
1476: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
1477: ,p_phn_h_phone_id per_phones.phone_id%TYPE

Line 1474: ,p_pds_hire_date per_periods_of_service.date_start%TYPE

1470: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
1471: ,p_application_id per_applications.application_id%TYPE
1472: ,p_app_object_version_number per_applications.object_version_number%TYPE
1473: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
1474: ,p_pds_hire_date per_periods_of_service.date_start%TYPE
1475: ,p_address_id per_addresses.address_id%TYPE
1476: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
1477: ,p_phn_h_phone_id per_phones.phone_id%TYPE
1478: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE