[Home] [Help]
PACKAGE: APPS.GHR_NON_SF52_EXTRA_INFO
Source
1 PACKAGE GHR_NON_SF52_EXTRA_INFO AS
2 /* $Header: ghddfdef.pkh 120.0.12010000.1 2008/07/28 10:28:04 appldev ship $ */
3
4 --------------------------------------------------------------------------------------------------------------
5 ---------------------------------------< populate_noa_spec_extra_info > --------------------------------------
6 --------------------------------------------------------------------------------------------------------------
7
8
9 -- {Start of Comments}
10 --
11 -- Description:
12 -- To populate/ update the pa_request_extra_info table , based on the first, second noa, position , person ,
13 -- effective date
14 -- Also determine if there is a need to delete the existing extra info ,if it is not relevant to the
15 -- current changes in the pa_request
16 --
17 -- Prerequisites:
18 --
19 -- Developer Implementation Notes:
20 -- None.
21 --
22 -- Access Status:
23 -- Internal Use Only.
24 --
25 -- {End of Comments}
26 -- ---------------------------------------------------------------------------
27
28 Procedure populate_noa_spec_extra_info
29 (p_pa_request_id in number,
30 p_first_noa_id in number,
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
40 --------------------------------------------------------------------------------------------------------------
41 ---------------------------------------< fetch_noa_spec_extra_info > --------------------------------------
42 --------------------------------------------------------------------------------------------------------------
43
44
45 -- {Start of Comments}
46 --
47 -- Description:
48 -- To fetch noa specific extra information for the specific noa code
49 --
50 -- Prerequisites:
51 --
52 -- Developer Implementation Notes:
53 -- None.
54 --
55 -- Access Status:
56 -- Internal Use Only.
57 --
58 -- {End of Comments}
59 -- ---------------------------------------------------------------------------
60
61
62 Procedure fetch_noa_spec_extra_info
63 (p_pa_request_id in number,
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 --------------------------------------------------------------------------------------------------------------
73 ---------------------------------------< fetch_generic_extra_info > --------------------------------------
74 --------------------------------------------------------------------------------------------------------------
75
76
77 -- {Start of Comments}
78 --
79 -- Description:
80 -- To fetch noa generic extra information , dependent on the person
81 -- As of now, only 2 such info types are fetched
82 --
83 -- Prerequisites:
84 --
85 -- Developer Implementation Notes:
86 -- None.
87 --
88 -- Access Status:
89 -- Internal Use Only.
90 --
91 -- {End of Comments}
92 -- ---------------------------------------------------------------------------
93
94
95 Procedure fetch_generic_extra_info
96 (p_pa_request_id in number,
97 p_person_id in number,
98 p_assignment_id in number,
99 p_effective_date in date,
100 p_refresh_flag in varchar2 default 'Y'
101 );
102 --
103
104 --------------------------------------------------------------------------------------------------------------
105 ---------------------------------------< get_information_type > --------------------------------------
106 --------------------------------------------------------------------------------------------------------------
107
108
109 -- {Start of Comments}
110 --
111 -- Description:
112 -- REturns the information type associated with the the given noa code
113 --
114 -- Prerequisites:
115 --
116 -- Developer Implementation Notes:
117 -- None.
118 --
119 -- Access Status:
120 -- Internal Use Only.
121 --
122 -- {End of Comments}
123 -- ---------------------------------------------------------------------------
124
125
126 Procedure get_information_type
127 (p_noa_id in ghr_nature_of_actions.nature_of_action_id%type,
128 p_information_type out NOCOPY ghr_pa_request_info_types.information_type%type
129 );
130 --
131
132 --------------------------------------------------------------------------------------------------------------
133 ---------------------------------------< determine_operation > --------------------------------------
134 --------------------------------------------------------------------------------------------------------------
135
136
137 -- {Start of Comments}
138 --
139 -- Description:
140 -- To determine whether to create/ update / delete the pa request extra information
141 --
142 -- Prerequisites:
143 --
144 -- Developer Implementation Notes:
145 -- None.
146 --
147 -- Access Status:
148 -- Internal Use Only.
149 --
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,
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 --------------------------------------------------------------------------------------------------------------
165 ---------------------------------------< generic_populate_extra_info > --------------------------------------
166 --------------------------------------------------------------------------------------------------------------
167
168
169 -- {Start of Comments}
170 --
171 -- Description:
172 -- Perform Create/ update/ delete of pa_request_extra_info record depending on the flag value passed
173 --
174 -- Prerequisites:
175 --
176 -- Developer Implementation Notes:
177 -- None.
178 --
179 -- Access Status:
180 -- Internal Use Only.
181 --
182 -- {End of Comments}
183 -- ---------------------------------------------------------------------------
184
185
186 Procedure generic_populate_extra_info
187 (p_rei_rec in ghr_pa_request_extra_info%rowtype,
188 p_org_rec in ghr_pa_request_ei_shadow%rowtype,
189 p_flag in varchar2
190 );
191
192
193 Procedure set_ei
194 (p_original in out NOCOPY varchar2,
195 p_as_in_core in varchar2,
196 p_as_in_ddf in out NOCOPY varchar2,
197 p_refresh_flag in varchar2 default 'Y'
198 );
199
200
201
202 end GHR_NON_SF52_EXTRA_INFO;