DBA Data[Home] [Help]

PACKAGE: APPS.IRC_NOTIFICATION_PREFS_API

Source


1 Package IRC_NOTIFICATION_PREFS_API AUTHID CURRENT_USER as
2 /* $Header: irinpapi.pkh 120.4 2008/02/21 14:16:27 viviswan noship $ */
3 /*#
4  * This package contains Notification Preferences APIs.
5  * @rep:scope public
6  * @rep:product irc
7  * @rep:displayname Notification Preferences
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |------------------------< create_notification_prefs >---------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16  * This API creates notification preferences for a person.
17  *
18  * These notification preferences are used for recruiting purposes only.
19  *
20  * <p><b>Licensing</b><br>
21  * This API is licensed for use with iRecruitment.
22  *
23  * <p><b>Prerequisites</b><br>
24  * The person must already exist
25  *
26  * <p><b>Post Success</b><br>
27  * The notification preferences will be created in the database
28  *
29  * <p><b>Post Failure</b><br>
30  * The notification preferences will not be created in the database and an
31  * error will be raised
32  * @param p_validate If true, then validation alone will be performed and the
33  * database will remain unchanged. If false and all validation checks pass,
34  * then the database will be modified.
35  * @param p_person_id Identifies the person for whom you create the
36  * notification preferences record.
37  * @param p_effective_date Reference date for validating lookup values are
38  * applicable during the start to end active date range. This date does not
39  * determine when the changes take effect.
40  * @param p_address_id The existing address that is used for recruiting
41  * purposes
42  * @param p_matching_jobs Indicates if the person wants to receive emails about
43  * matching jobs (Y or N)
44  * @param p_matching_job_freq The number of days between receiving emails about
45  * matching jobs. Valid values are defined by 'IRC_MESSAGE_FREQ' lookup type.
46  * @param p_allow_access Indicates if managers may search for the person for
47  * recruiting (Y or N)
48  * @param p_receive_info_mail Indicates if the person wants to receive general
49  * recruiting emails (Y or N)
50  * @param p_attribute_category This context value determines which flexfield
51  * structure to use with the descriptive flexfield segments.
52  * @param p_attribute1 Descriptive flexfield segment.
53  * @param p_attribute2 Descriptive flexfield segment.
54  * @param p_attribute3 Descriptive flexfield segment.
55  * @param p_attribute4 Descriptive flexfield segment.
56  * @param p_attribute5 Descriptive flexfield segment.
57  * @param p_attribute6 Descriptive flexfield segment.
58  * @param p_attribute7 Descriptive flexfield segment.
59  * @param p_attribute8 Descriptive flexfield segment.
60  * @param p_attribute9 Descriptive flexfield segment.
61  * @param p_attribute10 Descriptive flexfield segment.
62  * @param p_attribute11 Descriptive flexfield segment.
63  * @param p_attribute12 Descriptive flexfield segment.
64  * @param p_attribute13 Descriptive flexfield segment.
65  * @param p_attribute14 Descriptive flexfield segment.
66  * @param p_attribute15 Descriptive flexfield segment.
67  * @param p_attribute16 Descriptive flexfield segment.
68  * @param p_attribute17 Descriptive flexfield segment.
69  * @param p_attribute18 Descriptive flexfield segment.
70  * @param p_attribute19 Descriptive flexfield segment.
71  * @param p_attribute20 Descriptive flexfield segment.
72  * @param p_attribute21 Descriptive flexfield segment.
73  * @param p_attribute22 Descriptive flexfield segment.
74  * @param p_attribute23 Descriptive flexfield segment.
75  * @param p_attribute24 Descriptive flexfield segment.
76  * @param p_attribute25 Descriptive flexfield segment.
77  * @param p_attribute26 Descriptive flexfield segment.
78  * @param p_attribute27 Descriptive flexfield segment.
79  * @param p_attribute28 Descriptive flexfield segment.
80  * @param p_attribute29 Descriptive flexfield segment.
81  * @param p_attribute30 Descriptive flexfield segment.
82  * @param p_notification_preference_id If p_validate is false, then this
83  * uniquely identifies the notification preferences created. If p_validate is
84  * true, then set to null.
85  * @param p_object_version_number If p_validate is false, then set to the
86  * version number of the created notification preferences. If p_validate is
87  * true, then the value will be null.
88  * @param p_agency_id Identifies the agency.
89  * @param p_attempt_id Identifies the registration assessment attempt.
90  * @rep:displayname Create Notification Preferences
91  * @rep:category BUSINESS_ENTITY IRC_CANDIDATE_NOTIFY_PREFS
92  * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
93  * @rep:scope public
94  * @rep:lifecycle active
95  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
96 */
97 --
98 -- {End Of Comments}
99 --
100 procedure CREATE_NOTIFICATION_PREFS
101   (p_validate                      in     boolean  default false
102   ,p_person_id                     in     number
103   ,p_effective_date                in     date
104   ,p_address_id                    in     number   default null
105   ,p_matching_jobs                 in     varchar2 default 'N'
106   ,p_matching_job_freq             in     varchar2 default '1'
107   ,p_allow_access                  in     varchar2 default 'N'
108   ,p_receive_info_mail             in     varchar2 default 'N'
109   ,p_attribute_category            in     varchar2 default null
110   ,p_attribute1                    in     varchar2 default null
111   ,p_attribute2                    in     varchar2 default null
112   ,p_attribute3                    in     varchar2 default null
113   ,p_attribute4                    in     varchar2 default null
114   ,p_attribute5                    in     varchar2 default null
115   ,p_attribute6                    in     varchar2 default null
116   ,p_attribute7                    in     varchar2 default null
117   ,p_attribute8                    in     varchar2 default null
118   ,p_attribute9                    in     varchar2 default null
119   ,p_attribute10                   in     varchar2 default null
120   ,p_attribute11                   in     varchar2 default null
121   ,p_attribute12                   in     varchar2 default null
122   ,p_attribute13                   in     varchar2 default null
123   ,p_attribute14                   in     varchar2 default null
124   ,p_attribute15                   in     varchar2 default null
125   ,p_attribute16                   in     varchar2 default null
126   ,p_attribute17                   in     varchar2 default null
127   ,p_attribute18                   in     varchar2 default null
128   ,p_attribute19                   in     varchar2 default null
129   ,p_attribute20                   in     varchar2 default null
130   ,p_attribute21                   in     varchar2 default null
131   ,p_attribute22                   in     varchar2 default null
132   ,p_attribute23                   in     varchar2 default null
133   ,p_attribute24                   in     varchar2 default null
134   ,p_attribute25                   in     varchar2 default null
135   ,p_attribute26                   in     varchar2 default null
136   ,p_attribute27                   in     varchar2 default null
137   ,p_attribute28                   in     varchar2 default null
138   ,p_attribute29                   in     varchar2 default null
139   ,p_attribute30                   in     varchar2 default null
140   ,p_agency_id                     in     number   default null
141   ,p_attempt_id                    in     number   default null
142   ,p_notification_preference_id       out nocopy number
143   ,p_object_version_number            out nocopy number
144   );
145 --
146 -- ----------------------------------------------------------------------------
147 -- |------------------------< update_notification_prefs >---------------------|
148 -- ----------------------------------------------------------------------------
149 --
150 -- {Start Of Comments}
151 /*#
152  * This API updates notification preferences for a person.
153  *
154  * These notification preferences are only used for recruiting purposes.
155  *
156  * <p><b>Licensing</b><br>
157  * This API is licensed for use with iRecruitment.
158  *
159  * <p><b>Prerequisites</b><br>
160  * The notification preferences must already exist
161  *
162  * <p><b>Post Success</b><br>
163  * The notification preferences will be updated in the database
164  *
165  * <p><b>Post Failure</b><br>
166  * The notification preferences will not be updated in the database and an
167  * error will be raised
168  * @param p_validate If true, then validation alone will be performed and the
169  * database will remain unchanged. If false and all validation checks pass,
170  * then the database will be modified.
171  * @param p_party_id Obsolete parameter. Do not use
172  * @param p_person_id Identifies the person for whom you update the
173  * notification preferences record.
174  * @param p_effective_date Reference date for validating lookup values are
175  * applicable during the start to end active date range. This date does not
176  * determine when the changes take effect.
177  * @param p_matching_jobs Indicates if the person wants to receive emails about
178  * matching jobs (Y or N)
179  * @param p_matching_job_freq The number of days between receiving emails about
180  * matching jobs. Valid values are defined by 'IRC_MESSAGE_FREQ' lookup type.
181  * @param p_allow_access Indicates if managers may search for the person for
182  * recruiting (Y or N)
183  * @param p_receive_info_mail Indicates if the person wants to receive general
184  * recruiting emails (Y or N)
185  * @param p_address_id The existing address that is used for recruiting
186  * purposes
187  * @param p_attribute_category This context value determines which flexfield
188  * structure to use with the descriptive flexfield segments.
189  * @param p_attribute1 Descriptive flexfield segment.
190  * @param p_attribute2 Descriptive flexfield segment.
191  * @param p_attribute3 Descriptive flexfield segment.
192  * @param p_attribute4 Descriptive flexfield segment.
193  * @param p_attribute5 Descriptive flexfield segment.
194  * @param p_attribute6 Descriptive flexfield segment.
195  * @param p_attribute7 Descriptive flexfield segment.
196  * @param p_attribute8 Descriptive flexfield segment.
197  * @param p_attribute9 Descriptive flexfield segment.
198  * @param p_attribute10 Descriptive flexfield segment.
199  * @param p_attribute11 Descriptive flexfield segment.
200  * @param p_attribute12 Descriptive flexfield segment.
201  * @param p_attribute13 Descriptive flexfield segment.
202  * @param p_attribute14 Descriptive flexfield segment.
203  * @param p_attribute15 Descriptive flexfield segment.
204  * @param p_attribute16 Descriptive flexfield segment.
205  * @param p_attribute17 Descriptive flexfield segment.
206  * @param p_attribute18 Descriptive flexfield segment.
207  * @param p_attribute19 Descriptive flexfield segment.
208  * @param p_attribute20 Descriptive flexfield segment.
209  * @param p_attribute21 Descriptive flexfield segment.
210  * @param p_attribute22 Descriptive flexfield segment.
211  * @param p_attribute23 Descriptive flexfield segment.
212  * @param p_attribute24 Descriptive flexfield segment.
213  * @param p_attribute25 Descriptive flexfield segment.
214  * @param p_attribute26 Descriptive flexfield segment.
215  * @param p_attribute27 Descriptive flexfield segment.
216  * @param p_attribute28 Descriptive flexfield segment.
217  * @param p_attribute29 Descriptive flexfield segment.
218  * @param p_attribute30 Descriptive flexfield segment.
219  * @param p_notification_preference_id Identifies the notification preferences
220  * to be updated
221  * @param p_object_version_number Pass in the current version number of the
222  * notification preferences to be updated. When the API completes if p_validate
223  * is false, will be set to the new version number of the updated notification
224  * preferences. If p_validate is true will be set to the same value which was
225  * passed in.
226  * @param p_agency_id Identifies the agency.
227  * @param p_attempt_id Identifies the registration assessment attempt.
228  * @rep:displayname Update Notification Preferences
229  * @rep:category BUSINESS_ENTITY IRC_CANDIDATE_NOTIFY_PREFS
230  * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
231  * @rep:scope public
232  * @rep:lifecycle active
233  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
234 */
235 --
236 -- {End Of Comments}
237 --
238 procedure UPDATE_NOTIFICATION_PREFS
239   (p_validate                      in     boolean  default false
240   ,p_party_id                      in     number   default hr_api.g_number
241   ,p_person_id                     in     number   default hr_api.g_number
242   ,p_effective_date                in     date
243   ,p_matching_jobs                 in     varchar2 default hr_api.g_varchar2
244   ,p_matching_job_freq             in     varchar2 default hr_api.g_varchar2
245   ,p_allow_access                  in     varchar2 default hr_api.g_varchar2
246   ,p_receive_info_mail             in     varchar2 default hr_api.g_varchar2
247   ,p_address_id                    in     number   default hr_api.g_number
248   ,p_attribute_category            in     varchar2 default hr_api.g_varchar2
249   ,p_attribute1                    in     varchar2 default hr_api.g_varchar2
250   ,p_attribute2                    in     varchar2 default hr_api.g_varchar2
251   ,p_attribute3                    in     varchar2 default hr_api.g_varchar2
252   ,p_attribute4                    in     varchar2 default hr_api.g_varchar2
253   ,p_attribute5                    in     varchar2 default hr_api.g_varchar2
254   ,p_attribute6                    in     varchar2 default hr_api.g_varchar2
255   ,p_attribute7                    in     varchar2 default hr_api.g_varchar2
256   ,p_attribute8                    in     varchar2 default hr_api.g_varchar2
257   ,p_attribute9                    in     varchar2 default hr_api.g_varchar2
258   ,p_attribute10                   in     varchar2 default hr_api.g_varchar2
259   ,p_attribute11                   in     varchar2 default hr_api.g_varchar2
260   ,p_attribute12                   in     varchar2 default hr_api.g_varchar2
261   ,p_attribute13                   in     varchar2 default hr_api.g_varchar2
262   ,p_attribute14                   in     varchar2 default hr_api.g_varchar2
263   ,p_attribute15                   in     varchar2 default hr_api.g_varchar2
264   ,p_attribute16                   in     varchar2 default hr_api.g_varchar2
265   ,p_attribute17                   in     varchar2 default hr_api.g_varchar2
266   ,p_attribute18                   in     varchar2 default hr_api.g_varchar2
267   ,p_attribute19                   in     varchar2 default hr_api.g_varchar2
268   ,p_attribute20                   in     varchar2 default hr_api.g_varchar2
269   ,p_attribute21                   in     varchar2 default hr_api.g_varchar2
270   ,p_attribute22                   in     varchar2 default hr_api.g_varchar2
271   ,p_attribute23                   in     varchar2 default hr_api.g_varchar2
272   ,p_attribute24                   in     varchar2 default hr_api.g_varchar2
273   ,p_attribute25                   in     varchar2 default hr_api.g_varchar2
274   ,p_attribute26                   in     varchar2 default hr_api.g_varchar2
275   ,p_attribute27                   in     varchar2 default hr_api.g_varchar2
276   ,p_attribute28                   in     varchar2 default hr_api.g_varchar2
277   ,p_attribute29                   in     varchar2 default hr_api.g_varchar2
278   ,p_attribute30                   in     varchar2 default hr_api.g_varchar2
279   ,p_notification_preference_id    in     number
280   ,p_agency_id                     in     number   default hr_api.g_number
281   ,p_attempt_id                    in     number   default hr_api.g_number
282   ,p_object_version_number         in out nocopy number
283   );
284 --
285 -- ----------------------------------------------------------------------------
286 -- |------------------------< delete_notification_prefs >---------------------|
287 -- ----------------------------------------------------------------------------
288 --
289 -- {Start Of Comments}
290 /*#
291  * This API deletes notification preferences for a person.
292  *
293  *
294  * <p><b>Licensing</b><br>
295  * This API is licensed for use with iRecruitment.
296  *
297  * <p><b>Prerequisites</b><br>
298  * The notification preferences must already exist
299  *
300  * <p><b>Post Success</b><br>
301  * The notification preferences will be deleted from the database
302  *
303  * <p><b>Post Failure</b><br>
304  * The notification preferences will not be deleted from the database and an
305  * error will be raised
306  * @param p_validate If true, then validation alone will be performed and the
307  * database will remain unchanged. If false and all validation checks pass,
308  * then the database will be modified.
309  * @param p_notification_preference_id Identifies the notification preferences
310  * to be deleted
311  * @param p_object_version_number Current version number of the notification
312  * preferences to be deleted.
313  * @rep:displayname Delete Notification Preferences
314  * @rep:category BUSINESS_ENTITY IRC_CANDIDATE_NOTIFY_PREFS
315  * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
316  * @rep:scope public
317  * @rep:lifecycle active
318  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
319 */
320 --
321 -- {End Of Comments}
322 --
323 procedure DELETE_NOTIFICATION_PREFS
324   (p_validate                      in     boolean  default false
325   ,p_notification_preference_id    in     number
326   ,p_object_version_number         in     number
327   );
328 --
329 end IRC_NOTIFICATION_PREFS_API;