DBA Data[Home] [Help]

APPS.GHR_NON_SF52_EXTRA_INFO dependencies on GHR_PA_REQUESTS

Line 35: p_effective_date in ghr_pa_requests.effective_date%type,

31: p_second_noa_id in number,
32: p_person_id in per_people_f.person_id%type,
33: p_assignment_id in per_assignments_f.assignment_id%type,
34: p_position_id in per_positions.position_id%type,
35: p_effective_date in ghr_pa_requests.effective_date%type,
36: p_refresh_flag in varchar2 default 'Y'
37: );
38: --
39:

Line 68: p_effective_date in ghr_pa_requests.effective_date%type,

64: p_noa_id in number,
65: p_person_id in per_people_f.person_id%type,
66: p_assignment_id in per_assignments_f.assignment_id%type,
67: p_position_id in per_positions.position_id%type,
68: p_effective_date in ghr_pa_requests.effective_date%type,
69: p_refresh_flag in varchar2 default 'Y'
70: );
71:
72: --------------------------------------------------------------------------------------------------------------

Line 154: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,

150: -- {End of Comments}
151: -- ---------------------------------------------------------------------------
152:
153: Procedure determine_operation
154: (p_pa_request_id in ghr_pa_requests.pa_request_id%type,
155: p_information_type in ghr_pa_request_info_types.information_type%type,
156: p_update_rei in varchar2,
157: p_rei_rec in ghr_pa_request_extra_info%rowtype,
158: p_operation_flag out NOCOPY varchar2,

Line 160: p_object_version_number out NOCOPY ghr_pa_requests.object_version_number%type

156: p_update_rei in varchar2,
157: p_rei_rec in ghr_pa_request_extra_info%rowtype,
158: p_operation_flag out NOCOPY varchar2,
159: p_pa_request_extra_info_id out NOCOPY ghr_pa_request_extra_info.pa_request_extra_info_id%type,
160: p_object_version_number out NOCOPY ghr_pa_requests.object_version_number%type
161: );
162: --
163:
164: --------------------------------------------------------------------------------------------------------------