DBA Data[Home] [Help]

PACKAGE: APPS.PAY_ECU_API

Source


1 Package PAY_ECU_API as
2 /* $Header: pyecuapi.pkh 120.2 2005/12/12 23:31:49 pgongada noship $ */
3 /*#
4  * This package contains Element Classification Usages API.
5  * @rep:scope public
6  * @rep:product PAY
7  * @rep:displayname ecu
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |           Global Definitions - Internal Development Use Only             |
12 -- ----------------------------------------------------------------------------
13 --
14 g_api_dml  boolean;                               -- Global api dml status
15 g_package  varchar2(33) := '  pay_ecu_api.';
16 --
17 -- ----------------------------------------------------------------------------
18 -- |-------------------------< create_ele_class_usages >----------------------|
19 -- ----------------------------------------------------------------------------
20 --
21 -- {Start Of Comments}
22 /*#
23  * This API creates a new Element classification usage.
24  *
25  * <p><b>Licensing</b><br>
26  * This API is licensed for use with Payroll.
27  *
28  * <p><b>Prerequisites</b><br>
29  * The Classification, Runtype should exist on the Effective date.
30  * The Business Group and Legislation should also exist on the Effective date
31  * if they are specified.
32  *
33  * <p><b>Post Success</b><br>
34  * Creates a new Element classification usage.
35  *
36  * <p><b>Post Failure</b><br>
37  * Element classification usage is not created and an error is raised.
38  *
39  * @param p_validate If true, then validation alone will be performed and
40  * the database will remain unchanged. If false and all validation checks pass,
41  * then the database will be modified.
42  * @param p_effective_date Effective date of the Element classification
43  * usage to be created.
44  * @param p_run_type_id Run type id.
45  * @param p_classification_id Element classification id.
46  * @param p_business_group_id Business Group of the Element classification
47  * usage to be created.
48  * @param p_legislation_code Legislation Code of the Element classification
49  * usage to be created.
50  * @param p_element_class_usage_id If p_validate is false, then set to the
51  * newly created Element classification usage id and if p_validate is true,
52  * then set to null.
53  * @param p_object_version_number If p_validate is false, then set to the
54  * Object version number of the newly created Element classification usage
55  * and if p_validate is true, then set to null.
56  * @param p_effective_start_date If p_validate is false, then set to the
57  * Effective start date of the Element classification usage and if p_validate
58  * is true, then set to null.
59  * @param p_effective_end_date If p_validate is false, then set to the
60  * Effective end date of the Element classification usage and if p_validate
61  * is true, then set to null.
62  * @rep:displayname HRMS Element Classification
63  * @rep:category BUSINESS_ENTITY PAY_ELEMENT_CLASSIFICATION
64  * @rep:lifecycle active
65  * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
66  * @rep:scope public
67  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
68 */
69 --
70 -- {End Of Comments}
71 --
72 procedure CREATE_ELE_CLASS_USAGES
73   (p_validate                      in     boolean  default false
74   ,p_effective_date                in     date
75   ,p_run_type_id                   in	  number
76   ,p_classification_id             in     number
77   ,p_business_group_id             in     number   default null
78   ,p_legislation_code              in     varchar2 default null
79   ,p_element_class_usage_id        out nocopy   number
80   ,p_object_version_number         out nocopy   number
81   ,p_effective_start_date          out nocopy   date
82   ,p_effective_end_date            out nocopy   date
83   );
84 --
85 --
86 -- ----------------------------------------------------------------------------
87 -- |-------------------------< update_ele_class_usages >----------------------|
88 -- ----------------------------------------------------------------------------
89 --
90 -- {Start Of Comments}
91 /*#
92  * This API updates an Element classification usage.
93  *
94  * <p><b>Licensing</b><br>
95  * This API is licensed for use with Payroll.
96  *
97  * <p><b>Prerequisites</b><br>
98  * The Element classification usage must exist.
99  * The Classification, Runtype should exist on the Effective date if specified.
100  *
101  * <p><b>Post Success</b><br>
102  * Updates the specified Element classification usage.
103  *
104  * <p><b>Post Failure</b><br>
105  * Element classification usage is not updated and an error is raised.
106  *
107  * @param p_validate If true, then validation alone will be performed and
108  * the database will remain unchanged. If false and all validation checks pass,
109  * then the database will be modified.
110  * @param p_effective_date Effective date on which the Element
111  * classification usage should be updated.
112  * @param p_datetrack_mode Date track mode of the update.
113  * @param p_run_type_id Run type id.
114  * @param p_classification_id Element classification id.
115  * @param p_business_group_id Business Group of the Element classification
116  * usage.
117  * @param p_legislation_code Legislation Code of the Element classification
118  * usage.
119  * @param p_element_class_usage_id Element classification usage to be
120  * updated.
121  * @param p_object_version_number Object version number of the Element
122  * classification usage to be updated. If p_validate is false, then
123  * set to the Object version number of the updated record and if p_validate is
124  * true, then set to null.
125  * @param p_effective_start_date If p_validate is false, then set to the
126  * Effective start date of the Element classification usage and if p_validate
127  * is true, then set to null.
128  * @param p_effective_end_date If p_validate is false, then set to the
129  * Effective end date of the Element classification usage and if p_validate
130  * is true, then set to null.
131  * @rep:displayname HRMS Element Classification
132  * @rep:category BUSINESS_ENTITY PAY_ELEMENT_CLASSIFICATION
133  * @rep:lifecycle active
134  * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
135  * @rep:scope public
136  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
137 */
138 --
139 -- {End Of Comments}
140 --
141 procedure UPDATE_ELE_CLASS_USAGES
142   (p_validate                      in     boolean  default false
143   ,p_effective_date                in     date
144   ,p_datetrack_mode                in     varchar2
145   ,p_run_type_id                   in	  number   default hr_api.g_number
146   ,p_classification_id             in     number   default hr_api.g_number
147   ,p_business_group_id             in     number   default hr_api.g_number
148   ,p_legislation_code              in     varchar2 default hr_api.g_varchar2
149   ,p_element_class_usage_id        in out nocopy   number
150   ,p_object_version_number         in out nocopy   number
151   ,p_effective_start_date          out    nocopy   date
152   ,p_effective_end_date            out    nocopy   date
153   );
154 --
155 --
156 -- ----------------------------------------------------------------------------
157 -- |-------------------------< delete_ele_class_usages >----------------------|
158 -- ----------------------------------------------------------------------------
159 --
160 -- {Start Of Comments}
161 /*#
162  * This API deletes an Element classification usage.
163  *
164  * <p><b>Licensing</b><br>
165  * This API is licensed for use with Payroll.
166  *
167  * <p><b>Prerequisites</b><br>
168  * The Element classification usage must exist.
169  *
170  * <p><b>Post Success</b><br>
171  * Deletes the Element classification usage.
172  *
173  * <p><b>Post Failure</b><br>
174  * Element classification usage is not deleted and an error is raised.
175  *
176  * @param p_validate If true, then validation alone will be performed and
177  * the database will remain unchanged. If false and all validation checks pass,
178  * then the database will be modified.
179  * @param p_effective_date Effective date on which the Element
180  * classification usage should be updated.
181  * @param p_datetrack_mode Date track mode of the delete.
182  * @param p_element_class_usage_id Element classification usage to be
183  * deleted.
184  * @param p_object_version_number Object version number of the Element
185  * classification usage to be deleted. If p_validate is false, then set
186  * to the Object version number of the deleted record and if p_validate is
187  * true, then set to null.
188  * @param p_effective_start_date If p_validate is false, then set to the
189  * Effective start date of the Element classification usage and if p_validate
193  * is true, then set to null.
190  * is true, then set to null.
191  * @param p_effective_end_date If p_validate is false, then set to the
192  * Effective end date of the Element classification usage and if p_validate
194  * @rep:displayname HRMS Element Classification
195  * @rep:category BUSINESS_ENTITY PAY_ELEMENT_CLASSIFICATION
196  * @rep:lifecycle active
197  * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
198  * @rep:scope public
199  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
200 */
201 --
202 -- {End Of Comments}
203 --
204 --
205 procedure DELETE_ELE_CLASS_USAGES
206   (p_validate                      in     boolean  default false
207   ,p_effective_date                in     date
208   ,p_datetrack_mode                in     varchar2
209   ,p_element_class_usage_id        in     number
210   ,p_object_version_number         in out nocopy   number
211   ,p_effective_start_date          out    nocopy   date
212   ,p_effective_end_date            out    nocopy   date
213   );
214 --
215 end PAY_ECU_API;