[Home] [Help]
PACKAGE: APPS.GHR_POI_FLEX_DDF
Source
1 Package ghr_poi_flex_ddf as
2 /* $Header: ghpoiddf.pkh 120.1 2005/06/22 04:21:11 sumarimu noship $ */
3 --
4 -- -----------------------------------------------------------------------------
5 -- |-------------------------------< ddf >--------------------------------------|
6 -- -----------------------------------------------------------------------------
7 -- {Start of Comments}
8 --
9 -- Description:
10 -- This procedure controls the validation processing required for
11 -- developer descriptive flexfields by calling the relevant validation
12 -- procedures. These are called dependant on the value of the relevant
13 -- entity reference field value.
14 --
15 -- Pre Conditions:
16 -- A fully validated entity record structure.
17 --
18 -- In Arguments:
19 -- p_rec (Record structure for relevant entity).
20 --
21 -- Post Success:
22 -- Processing of the calling api continues.
23 --
24 -- Post Failure:
25 -- A failure can only occur under two circumstances:
26 -- 1) The value of reference field is not supported.
27 -- 2) If when the reference field value is null and not all
28 -- the information arguments are not null(i.e. information
29 -- arguments cannot be set without a corresponding reference
30 -- field value).
31 --
32 -- Developer Implementation Notes:
33 -- Developer defined.
34 --
35 -- Access Status:
36 -- Internal Development Use Only.
37 --
38 -- {End of Comments}
39 -- -----------------------------------------------------------------------------
40 procedure ddf
41 (
42 p_position_extra_info_id in number ,
43 p_position_id in number ,
44 p_information_type in varchar2 ,
45 p_request_id in number ,
46 p_program_application_id in number ,
47 p_program_id in number ,
48 p_program_update_date in date ,
49 p_poei_attribute_category in varchar2 ,
50 p_poei_attribute1 in varchar2 ,
51 p_poei_attribute2 in varchar2 ,
52 p_poei_attribute3 in varchar2 ,
53 p_poei_attribute4 in varchar2 ,
54 p_poei_attribute5 in varchar2 ,
55 p_poei_attribute6 in varchar2 ,
56 p_poei_attribute7 in varchar2 ,
57 p_poei_attribute8 in varchar2 ,
58 p_poei_attribute9 in varchar2 ,
59 p_poei_attribute10 in varchar2 ,
60 p_poei_attribute11 in varchar2 ,
61 p_poei_attribute12 in varchar2 ,
62 p_poei_attribute13 in varchar2 ,
63 p_poei_attribute14 in varchar2 ,
64 p_poei_attribute15 in varchar2 ,
65 p_poei_attribute16 in varchar2 ,
66 p_poei_attribute17 in varchar2 ,
67 p_poei_attribute18 in varchar2 ,
68 p_poei_attribute19 in varchar2 ,
69 p_poei_attribute20 in varchar2 ,
70 p_poei_information_category in varchar2 ,
71 p_poei_information1 in varchar2 ,
72 p_poei_information2 in varchar2 ,
73 p_poei_information3 in varchar2 ,
74 p_poei_information4 in varchar2 ,
75 p_poei_information5 in varchar2 ,
76 p_poei_information6 in varchar2 ,
77 p_poei_information7 in varchar2 ,
78 p_poei_information8 in varchar2 ,
79 p_poei_information9 in varchar2 ,
80 p_poei_information10 in varchar2 ,
81 p_poei_information11 in varchar2 ,
82 p_poei_information12 in varchar2 ,
83 p_poei_information13 in varchar2 ,
84 p_poei_information14 in varchar2 ,
85 p_poei_information15 in varchar2 ,
86 p_poei_information16 in varchar2 ,
87 p_poei_information17 in varchar2 ,
88 p_poei_information18 in varchar2 ,
89 p_poei_information19 in varchar2 ,
90 p_poei_information20 in varchar2 ,
91 p_poei_information21 in varchar2 ,
92 p_poei_information22 in varchar2 ,
93 p_poei_information23 in varchar2 ,
94 p_poei_information24 in varchar2 ,
95 p_poei_information25 in varchar2 ,
96 p_poei_information26 in varchar2 ,
97 p_poei_information27 in varchar2 ,
98 p_poei_information28 in varchar2 ,
99 p_poei_information29 in varchar2 ,
100 p_poei_information30 in varchar2
101 );
102
103 procedure create_ddf
104 (
105 p_position_id in number ,
106 p_information_type in varchar2 ,
107 p_poei_attribute_category in varchar2 ,
108 p_poei_attribute1 in varchar2 ,
109 p_poei_attribute2 in varchar2 ,
110 p_poei_attribute3 in varchar2 ,
111 p_poei_attribute4 in varchar2 ,
112 p_poei_attribute5 in varchar2 ,
113 p_poei_attribute6 in varchar2 ,
114 p_poei_attribute7 in varchar2 ,
115 p_poei_attribute8 in varchar2 ,
116 p_poei_attribute9 in varchar2 ,
117 p_poei_attribute10 in varchar2 ,
118 p_poei_attribute11 in varchar2 ,
119 p_poei_attribute12 in varchar2 ,
120 p_poei_attribute13 in varchar2 ,
121 p_poei_attribute14 in varchar2 ,
122 p_poei_attribute15 in varchar2 ,
123 p_poei_attribute16 in varchar2 ,
124 p_poei_attribute17 in varchar2 ,
125 p_poei_attribute18 in varchar2 ,
126 p_poei_attribute19 in varchar2 ,
127 p_poei_attribute20 in varchar2 ,
128 p_poei_information_category in varchar2 ,
129 p_poei_information1 in varchar2 ,
130 p_poei_information2 in varchar2 ,
131 p_poei_information3 in varchar2 ,
132 p_poei_information4 in varchar2 ,
133 p_poei_information5 in varchar2 ,
134 p_poei_information6 in varchar2 ,
135 p_poei_information7 in varchar2 ,
136 p_poei_information8 in varchar2 ,
137 p_poei_information9 in varchar2 ,
138 p_poei_information10 in varchar2 ,
139 p_poei_information11 in varchar2 ,
140 p_poei_information12 in varchar2 ,
141 p_poei_information13 in varchar2 ,
142 p_poei_information14 in varchar2 ,
143 p_poei_information15 in varchar2 ,
144 p_poei_information16 in varchar2 ,
145 p_poei_information17 in varchar2 ,
146 p_poei_information18 in varchar2 ,
147 p_poei_information19 in varchar2 ,
148 p_poei_information20 in varchar2 ,
149 p_poei_information21 in varchar2 ,
150 p_poei_information22 in varchar2 ,
151 p_poei_information23 in varchar2 ,
152 p_poei_information24 in varchar2 ,
153 p_poei_information25 in varchar2 ,
154 p_poei_information26 in varchar2 ,
155 p_poei_information27 in varchar2 ,
156 p_poei_information28 in varchar2 ,
157 p_poei_information29 in varchar2 ,
158 p_poei_information30 in varchar2
159 );
160
161 -- -----------------------------------------------------------------------------------------
162 -- |-----------------------------------< chk_date_from >-----------------------------------|
163 -- -----------------------------------------------------------------------------------------
164 -- {Start of Comments}
165 --
166 -- Description:
167 -- This procedure validates the date_from ddf.
168 --
169 -- Pre Conditions:
170 -- None.
171 --
172 -- In Arguments:
173 -- p_position_description_id
174 -- p_date_from
175 --
176 -- Post Success:
177 -- Processing of the calling api continues.
178 --
179 -- Post Failure:
180 -- Processing stops and error raised.
181 --
182 -- Developer Implementation Notes:
183 -- Developer defined.
184 --
185 -- Access Status:
186 -- Internal Development Use Only.
187 --
188 -- {End of Comments}
189 -- -----------------------------------------------------------------------------
190 --
191 procedure chk_date_from
192 (p_position_description_id in ghr_position_descriptions.position_description_id%TYPE
193 ,p_date_from in per_position_extra_info.poei_information1%TYPE
194 );
195 --
196 -- -----------------------------------------------------------------------------------------
197 -- |----------------------------------< chk_pos_desc_id>-----------------------------------|
198 -- -----------------------------------------------------------------------------------------
199 -- {Start of Comments}
200 --
201 -- Description:
202 -- This procedure validates the pos_desc_id ddf.
203 --
204 -- Pre Conditions:
205 -- None.
206 --
207 -- In Arguments:
208 -- p_position_extra_info_id
209 -- p_pos_desc_id
210 --
211 -- Post Success:
212 -- Processing of the calling api continues.
213 --
214 -- Post Failure:
215 -- Processing stops and error raised.
216 --
217 -- Developer Implementation Notes:
218 -- Developer defined.
219 --
220 -- Access Status:
221 -- Internal Development Use Only.
222 --
223 -- {End of Comments}
224 -- -----------------------------------------------------------------------------
225 --
226 procedure chk_pos_desc_id
227 (p_position_extra_info_id in per_position_extra_info.position_extra_info_id%TYPE
228 ,p_pos_desc_id in per_position_extra_info.poei_information3%TYPE
229 );
230 --
231 -- -----------------------------------------------------------------------------------------
232 -- |-----------------------------------< chk_date_to >-------------------------------------|
233 -- -----------------------------------------------------------------------------------------
234 -- {Start of Comments}
235 --
236 -- Description:
237 -- This procedure validates the date_to ddf.
238 --
239 -- Pre Conditions:
240 -- None.
241 --
242 -- In Arguments:
243 -- p_position_extra_info_id
244 -- p_date_to
245 -- p_date_from
246 --
247 -- Post Success:
248 -- Processing of the calling api continues.
249 --
250 -- Post Failure:
251 -- Processing stops and error raised.
252 --
253 -- Developer Implementation Notes:
254 -- Developer defined.
255 --
256 -- Access Status:
257 -- Internal Development Use Only.
258 --
259 -- {End of Comments}
260 -- -----------------------------------------------------------------------------
261 --
262 procedure chk_date_to
263 (p_position_extra_info_id in per_position_extra_info.position_extra_info_id%TYPE
264 ,p_date_to in per_position_extra_info.poei_information2%TYPE
265 ,p_date_from in per_position_extra_info.poei_information1%TYPE
266 );
267 --
268 end ghr_poi_flex_ddf;