DBA Data[Home] [Help]

PACKAGE: APPS.IRC_VACANCY_CONSIDERATIONS_API

Source


1 Package IRC_VACANCY_CONSIDERATIONS_API AUTHID CURRENT_USER as
2 /* $Header: irivcapi.pkh 120.2 2008/02/21 14:29:37 viviswan noship $ */
3 /*#
4  * This package contains APIs for marking the consideration status of a
5  * candidate for a vacancy.
6  * @rep:scope public
7  * @rep:product irc
8  * @rep:displayname Vacancy Consideration
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |-----------------------< create_vacancy_consideration >-------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17  * This API creates a consideration status for a candidate for a vacancy.
18  *
19  * If the consideration status is PURSUE then a notification will be sent to
20  * the candidate to ask them to apply for the vacancy. If the consideration
21  * status is REJECT then the candidate will not show up in searches for
22  * candidates for this vacancy. If the status is CONSIDER then no further
23  * action is taken.
24  *
25  * <p><b>Licensing</b><br>
26  * This API is licensed for use with iRecruitment.
27  *
28  * <p><b>Prerequisites</b><br>
29  * The vacancy and the candidate must exist in the database
30  *
31  * <p><b>Post Success</b><br>
32  * The vacancy consideration status is recorded in the database, and a
33  * notification may be sent to the candidate
34  *
35  * <p><b>Post Failure</b><br>
36  * The vacancy consideration status will not be stored and an error will be
37  * raised
38  * @param p_validate If true, then validation alone will be performed and the
39  * database will remain unchanged. If false and all validation checks pass,
40  * then the database will be modified.
41  * @param p_person_id Identifies the person for whom you create the
42  * consideration status record.
43  * @param p_vacancy_id Identifies the vacancy that the candidate is being
44  * considered for
45  * @param p_consideration_status Indicates the consideration status (PURSUE,
46  * CONSIDER or NO)
47  * @param p_vacancy_consideration_id If p_validate is false, then this uniquely
48  * identifies the consideration status recorded. If p_validate is true, then
49  * set to null.
50  * @param p_object_version_number If p_validate is false, then set to the
51  * version number of the created consideration status. If p_validate is true,
52  * then the value will be null.
53  * @param p_effective_date Reference date for validating lookup values are
54  * applicable during the start to end active date range. This date does not
55  * determine when the changes take effect.
56  * @rep:displayname Create Vacancy Consideration
57  * @rep:category BUSINESS_ENTITY IRC_VACANCY_CONSIDERATION
58  * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
59  * @rep:scope public
60  * @rep:lifecycle active
61  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
62 */
63 --
64 -- {End Of Comments}
65 --
66 procedure create_vacancy_consideration
67   (p_validate                      in     boolean  default false
68   ,p_person_id                     in     number
69   ,p_vacancy_id                    in     number
70   ,p_consideration_status          in     varchar2 default 'CONSIDER'
71   ,p_vacancy_consideration_id      out nocopy     number
72   ,p_object_version_number         out nocopy    number
73   ,p_effective_date                in     date
74   );
75 --
76 -- ----------------------------------------------------------------------------
77 -- |-----------------------< update_vacancy_consideration >-------------------|
78 -- ----------------------------------------------------------------------------
79 --
80 -- {Start Of Comments}
81 /*#
82  * This API updates a consideration status for a candidate for a vacancy.
83  *
84  * If the consideration status is PURSUE then a notification will be sent to
85  * the candidate to ask them to apply for the vacancy. If the consideration
86  * status is NO then the candidate will not show up in searches for candidates
87  * for this vacancy. If the status is CONSIDER then no further action is taken.
88  *
89  * <p><b>Licensing</b><br>
90  * This API is licensed for use with iRecruitment.
91  *
92  * <p><b>Prerequisites</b><br>
93  * The vacancy consideration must already exist
94  *
95  * <p><b>Post Success</b><br>
96  * The vacancy consideration record is updated
97  *
98  * <p><b>Post Failure</b><br>
99  * The vacancy consideration record will not be updated and an error will be
100  * raised
101  * @param p_validate If true, then validation alone will be performed and the
102  * database will remain unchanged. If false and all validation checks pass,
103  * then the database will be modified.
104  * @param p_vacancy_consideration_id Identifies the vacancy consideration
105  * record to be updated
106  * @param p_party_id Obsolete parameter. Do not use
107  * @param p_consideration_status Indicates the consideration status (PURSUE,
108  * CONSIDER or NO)
109  * @param p_object_version_number Pass in the current version number of the
110  * consideration status to be updated. When the API completes if p_validate is
111  * false, will be set to the new version number of the updated consideration
112  * status. If p_validate is true will be set to the same value which was passed
113  * in.
114  * @param p_effective_date Reference date for validating lookup values are
115  * applicable during the start to end active date range. This date does not
116  * determine when the changes take effect.
117  * @rep:displayname Update Vacancy Consideration
118  * @rep:category BUSINESS_ENTITY IRC_VACANCY_CONSIDERATION
119  * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
120  * @rep:scope public
121  * @rep:lifecycle active
122  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
123 */
124 --
125 -- {End Of Comments}
126 --
127 procedure update_vacancy_consideration
128   (p_validate                      in     boolean  default false
129   ,p_vacancy_consideration_id      in     number
130   ,p_party_id                      in     number   default hr_api.g_number
131   ,p_consideration_status          in     varchar2 default hr_api.g_varchar2
132   ,p_object_version_number         in out nocopy number
133   ,p_effective_date                in     date
134   );
135 --
136 -- ----------------------------------------------------------------------------
137 -- |-----------------------< delete_vacancy_consideration >-------------------|
138 -- ----------------------------------------------------------------------------
139 --
140 -- {Start Of Comments}
141 /*#
142  * This API removes a vacancy consideration status.
143  *
144  * If a notification has been sent to the candidate, it will not be unsent.
145  *
146  * <p><b>Licensing</b><br>
147  * This API is licensed for use with iRecruitment.
148  *
149  * <p><b>Prerequisites</b><br>
150  * The vacancy consideration must already exist
151  *
152  * <p><b>Post Success</b><br>
153  * The vacancy consideration record is deleted
154  *
155  * <p><b>Post Failure</b><br>
156  * The vacancy consideration record will not be deleted and an error will be
157  * raised
158  * @param p_validate If true, then validation alone will be performed and the
159  * database will remain unchanged. If false and all validation checks pass,
160  * then the database will be modified.
161  * @param p_vacancy_consideration_id Identifies the vacancy consideration
162  * record to be deleted
163  * @param p_object_version_number Current version number of the consideration
164  * status to be deleted.
165  * @rep:displayname Delete Vacancy Consideration
166  * @rep:category BUSINESS_ENTITY IRC_VACANCY_CONSIDERATION
167  * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
168  * @rep:scope public
169  * @rep:lifecycle active
170  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
171 */
172 --
173 -- {End Of Comments}
174 --
175 procedure delete_vacancy_consideration
176   (p_validate                      in     boolean  default false
177   ,p_vacancy_consideration_id      in     number
178   ,p_object_version_number         in     number
179   );
180 --
181 -- ----------------------------------------------------------------------------
182 -- |--------------------------< NOTIFY_SEEKER_IF_REQUIRED >-------------------|
183 -- ----------------------------------------------------------------------------
184 -- Comment
185 --   This procedure will send an email to a job seeker under certain
186 --   circumstances.
187 --
188 -- Access Status:
189 --   Private
190 --
191 -- {End Of Comments}
192 --
193 procedure notify_seeker_if_required
194   (
195    p_person_id                     in     number
196   ,p_vacancy_id                    in     number
197   ,p_consideration_status          in     varchar2
198   ,p_effective_date                in     date
199   ,p_validate_only                 in     boolean);
200  end IRC_VACANCY_CONSIDERATIONS_API;