DBA Data[Home] [Help]

APPS.PER_QH_MAINTAIN_UPDATE dependencies on PER_PERIODS_OF_SERVICE

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

28: ,p_correspondence_language IN per_all_people_f.correspondence_language%TYPE
29: ,p_current_applicant_flag IN per_all_people_f.current_applicant_flag%TYPE
30: ,p_current_emp_or_apl_flag IN per_all_people_f.current_emp_or_apl_flag%TYPE
31: ,p_current_employee_flag IN per_all_people_f.current_employee_flag%TYPE
32: ,p_hire_date IN OUT NOCOPY per_periods_of_service.date_start%TYPE -- Bug 3975241
33: --CWK
34: ,p_current_npw_flag IN per_all_people_f.current_npw_flag%TYPE
35: ,p_npw_number IN OUT NOCOPY per_all_people_f.npw_number%TYPE
36: ,p_placement_date_start IN OUT NOCOPY per_all_assignments_f.period_of_placement_date_start%TYPE -- Bug 4287925

Line 352: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE

348: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
349: ,p_current_employer IN per_applications.current_employer%TYPE
350: ,p_termination_reason IN per_applications.termination_reason%TYPE
351: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE
352: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
353: ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE
354: ,p_address_id OUT NOCOPY per_addresses.address_id%TYPE
355: ,p_adr_date_from IN per_addresses.date_from%TYPE
356: ,p_style IN per_addresses.style%TYPE

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

349: ,p_current_employer IN per_applications.current_employer%TYPE
350: ,p_termination_reason IN per_applications.termination_reason%TYPE
351: ,p_app_object_version_number OUT NOCOPY per_applications.object_version_number%TYPE
352: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
353: ,p_pds_object_version_number IN OUT NOCOPY per_periods_of_service.object_version_number%TYPE
354: ,p_address_id OUT NOCOPY per_addresses.address_id%TYPE
355: ,p_adr_date_from IN per_addresses.date_from%TYPE
356: ,p_style IN per_addresses.style%TYPE
357: ,p_address_line1 IN per_addresses.address_line1%TYPE

Line 1070: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE

1066: ,p_appl_attribute20 IN per_applications.appl_attribute20%TYPE
1067: ,p_current_employer IN per_applications.current_employer%TYPE
1068: ,p_termination_reason IN per_applications.termination_reason%TYPE
1069: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
1070: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
1071: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
1072: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
1073: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
1074: ,p_adr_date_from IN per_addresses.date_from%TYPE

Line 1071: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE

1067: ,p_current_employer IN per_applications.current_employer%TYPE
1068: ,p_termination_reason IN per_applications.termination_reason%TYPE
1069: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
1070: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
1071: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
1072: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
1073: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
1074: ,p_adr_date_from IN per_addresses.date_from%TYPE
1075: ,p_style IN per_addresses.style%TYPE

Line 1072: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE

1068: ,p_termination_reason IN per_applications.termination_reason%TYPE
1069: ,p_app_object_version_number IN OUT NOCOPY per_applications.object_version_number%TYPE
1070: ,p_adjusted_svc_date IN per_periods_of_service.adjusted_svc_date%TYPE
1071: ,p_pds_object_version_number IN per_periods_of_service.object_version_number%TYPE
1072: ,p_pds_hire_date IN per_periods_of_service.date_start%TYPE
1073: ,p_address_id IN OUT NOCOPY per_addresses.address_id%TYPE
1074: ,p_adr_date_from IN per_addresses.date_from%TYPE
1075: ,p_style IN per_addresses.style%TYPE
1076: ,p_address_line1 IN per_addresses.address_line1%TYPE

Line 1480: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE

1476: ,p_asg_validation_end_date OUT NOCOPY DATE
1477: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
1478: ,p_application_id per_applications.application_id%TYPE
1479: ,p_app_object_version_number per_applications.object_version_number%TYPE
1480: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
1481: ,p_pds_hire_date per_periods_of_service.date_start%TYPE
1482: ,p_address_id per_addresses.address_id%TYPE
1483: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
1484: ,p_phn_h_phone_id per_phones.phone_id%TYPE

Line 1481: ,p_pds_hire_date per_periods_of_service.date_start%TYPE

1477: ,p_asg_object_version_number per_all_assignments_f.object_version_number%TYPE
1478: ,p_application_id per_applications.application_id%TYPE
1479: ,p_app_object_version_number per_applications.object_version_number%TYPE
1480: ,p_pds_object_version_number per_periods_of_service.object_version_number%TYPE
1481: ,p_pds_hire_date per_periods_of_service.date_start%TYPE
1482: ,p_address_id per_addresses.address_id%TYPE
1483: ,p_addr_object_version_number per_addresses.object_version_number%TYPE
1484: ,p_phn_h_phone_id per_phones.phone_id%TYPE
1485: ,p_phn_h_object_version_number per_phones.object_version_number%TYPE