DBA Data[Home] [Help]

PACKAGE: APPS.IRC_TEMPLATE_ASSOCIATION_API

Source


1 Package irc_template_association_api as
2 /* $Header: iritaapi.pkh 120.4 2008/02/21 14:28:15 viviswan noship $ */
3 /*#
4  * This package contains APIs for managing template association for an
5  * organisation or job or position.
6  * @rep:scope public
7  * @rep:product irc
8  * @rep:displayname Template Association
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |-----------------------< create_template_association >--------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17  * This API creates a new template association.
18  *
19  * This api creates template association for an organisation, job or position.
20  *
21  * <p><b>Licensing</b><br>
22  * This API is licensed for use with iRecruitment.
23  *
24  * <p><b>Prerequisites</b><br>
25  * A valid Template is required to create a new template association.
26  *
27  * <p><b>Post Success</b><br>
28  * The API creates the template association.
29  *
30  * <p><b>Post Failure</b><br>
31  * The API does not create a template association and an error is raised.
32  *
33  * @param p_validate If true, then validation alone will be performed and the
34  * database will remain unchanged. If false and all validation checks pass,
35  * then the database will be modified.
36  * @param p_template_id Identifies the associated template.
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
39  * not determine when the changes take effect.
40  * @param p_default_association Identifies the default template association.
41  * @param p_job_id Identifies the job that is associated with the template
42  * association.
43  * @param p_position_id Identifies the position that is associated with
44  * the template association.
45  * @param p_organization_id Identifies the organization that is associated
46  * with the template association.
47  * @param p_start_date The start date from which the template association is
48  * in effect.
49  * @param p_end_date The last date till which the template association
50  * is active.
51  * @param p_object_version_number If p_validate is false, then set to the
52  * version number of the created template association. If p_validate is true,
53  * then the value will be null.
54  * @param p_template_association_id Primary key of the template association.
55  * @rep:displayname Create Template Association
56  * @rep:category BUSINESS_ENTITY IRC_JOB_OFFER_LETTER_TEMPLATE
57  * @rep:lifecycle active
58  * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
59  * @rep:scope public
60  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
61 */
62 --
63 -- {End Of Comments}
64 --
65 procedure create_template_association
66   (p_validate                         in  boolean    default false
67   ,p_template_id                      in  number
68   ,p_effective_date                   in  date       default null
69   ,p_default_association              in  varchar2   default null
70   ,p_job_id                           in  number     default null
71   ,p_position_id                      in  number     default null
72   ,p_organization_id                  in  number     default null
73   ,p_start_date                       in  date       default null
74   ,p_end_date                         in  date       default null
75   ,p_object_version_number            out NOCOPY number
76   ,p_template_association_id          out NOCOPY number
77   );
78 --
79 -- ----------------------------------------------------------------------------
80 -- |-----------------------< update_template_association >--------------------|
81 -- ----------------------------------------------------------------------------
82 --
83 -- {Start Of Comments}
84 /*#
85  * This API updates template association for an organization, job
86  * or position.
87  *
88  *
89  * <p><b>Licensing</b><br>
90  * This API is licensed for use with iRecruitment.
91  *
92  * <p><b>Prerequisites</b><br>
93  * Template association must already exist.
94  *
95  * <p><b>Post Success</b><br>
96  * The API updates the template association.
97  *
98  * <p><b>Post Failure</b><br>
99  * Template association will not be updated and an error will be raised.
100  *
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_effective_date Reference date for validating lookup values are
105  * applicable during the start to end active date range. This date does
106  * not determine when the changes take effect.
107  * @param p_template_association_id Identifies the template association.
108  * @param p_template_id Identifies the associated template.
109  * @param p_default_association Identifies the default tempalte association.
110  * @param p_job_id Identifies the job that is associated with the template
111  * association.
112  * @param p_position_id Identifies the position that is associated with
113  * the template association.
114  * @param p_organization_id Identifies the organization that is associated
115  * with the template association.
116  * @param p_start_date The start date from which the template association is
117  * in effect.
118  * @param p_end_date The last date till which the template association
119  * is active.
120  * @param p_object_version_number Pass in the current version number of the
121  * template association to be updated. When the API completes if p_validate is
122  * false, will be set to the new version number of the updated
123  * template association.
124  * If p_validate is true will be set to the same value which was
125  * passed in.
126  * @rep:displayname Update Template Association
127  * @rep:category BUSINESS_ENTITY IRC_JOB_OFFER_LETTER_TEMPLATE
128  * @rep:lifecycle active
129  * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
130  * @rep:scope public
131  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
132 */
133 --
134 -- {End Of Comments}
135 --
136 procedure update_template_association
137 (  p_validate                         in      boolean    default false
138   ,p_effective_date                   in      date       default null
139   ,p_template_association_id          in      number
140   ,p_template_id                      in      number
141   ,p_default_association              in      varchar2   default null
142   ,p_job_id                           in      number     default null
143   ,p_position_id                      in      number     default null
144   ,p_organization_id                  in      number     default null
145   ,p_start_date                       in      date       default null
146   ,p_end_date                         in      date       default null
147   ,p_object_version_number            in out  NOCOPY number
148 );
149 --
150 -- ----------------------------------------------------------------------------
151 -- |-----------------------< delete_template_association >--------------------|
152 -- ----------------------------------------------------------------------------
153 --
154 -- {Start Of Comments}
155 /*#
156  * This API deletes the template association.
157  *
158  *
159  * <p><b>Licensing</b><br>
160  * This API is licensed for use with iRecruitment.
161  *
162  * <p><b>Prerequisites</b><br>
163  * Template association must already exist.
164  *
165  * <p><b>Post Success</b><br>
166  * The API deletes the template association.
167  *
168  * <p><b>Post Failure</b><br>
169  * Template association will not be deleted and an error will be raised.
170  *
171  * @param p_validate If true, then validation alone will be performed and the
172  * database will remain unchanged. If false and all validation checks pass,
173  * then the database will be modified.
174  * @param p_template_association_id Identifies the template association.
175  * @param p_object_version_number Current version number of the template
176  * association to be deleted.
177  * @rep:displayname Delete Template Association
178  * @rep:category BUSINESS_ENTITY IRC_JOB_OFFER_LETTER_TEMPLATE
179  * @rep:lifecycle active
180  * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
181  * @rep:scope public
182  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
183 */
184 --
185 -- {End Of Comments}
186 --
187 procedure delete_template_association
188   (p_validate                       in       boolean    default false
189   ,p_template_association_id        in       number
190   ,p_object_version_number          in       number
191   );
192 
193 --
194 end irc_template_association_api;