DBA Data[Home] [Help]

PACKAGE: APPS.OTA_CATEGORY_USAGE_API

Source


1 Package ota_category_usage_api as
2 /* $Header: otctuapi.pkh 120.1 2005/10/02 02:07:23 aroussel $ */
3 /*#
4  * This package contains the category usage APIs that create or update a
5  * Category or Delivery Mode.
6  * @rep:scope public
7  * @rep:product ota
8  * @rep:displayname Category Usage
9 */
10 --
11 -- ----------------------------------------------------------------------------
12 -- |-----------------------------< create_category >--------------------------|
13 -- ----------------------------------------------------------------------------
14 --
15 -- {Start Of Comments}
16 /*#
17  * This API creates a category.
18  *
19  *
20  * <p><b>Licensing</b><br>
21  * This API is licensed for use with Learning Management.
22  *
23  * <p><b>Prerequisites</b><br>
24  * The business group that owns this category should exist.
25  *
26  * <p><b>Post Success</b><br>
27  * Record for category created
28  *
29  * <p><b>Post Failure</b><br>
30  * Record for category is not created and an error is raised
31  * @param p_validate If true, then validation alone will be performed and the
32  * database will remain unchanged. If false and all validation checks pass,
33  * then the database will be modified.
34  * @param p_effective_date Reference date for validating lookup values are
35  * applicable during the start to end active date range. This date does not
36  * determine when the changes take effect.
37  * @param p_business_group_id {@rep:casecolumn
38  * OTA_CATEGORY_USAGES.BUSINESS_GROUP_ID}
39  * @param p_category {@rep:casecolumn OTA_CATEGORY_USAGES_TL.CATEGORY}
40  * @param p_type The category's type. Valid values are defined in the
41  * 'CATEGORY_TYPE' lookup type.
42  * @param p_description {@rep:casecolumn OTA_CATEGORY_USAGES_TL.DESCRIPTION}
43  * @param p_parent_cat_usage_id Since a category can be created within a
44  * category, this value determines the category_usage_id of the parent
45  * category. It should be a valid category_usage_id within the same business
46  * group.
47  * @param p_synchronous_flag This flag is used only for categories of type 'DM'
48  * (Delivery Modes). Valid values are defined in the 'YES_NO' lookup type.
49  * @param p_online_flag This flag is used only for category of type 'DM'
50  * (Delivery Modes). Valid values are defined in the 'YES_NO' lookup type.
51  * @param p_attribute_category This context value determines which flexfield
52  * structure to use with the descriptive flexfield segments.
53  * @param p_attribute1 Descriptive flexfield segment.
54  * @param p_attribute2 Descriptive flexfield segment.
55  * @param p_attribute3 Descriptive flexfield segment.
56  * @param p_attribute4 Descriptive flexfield segment.
57  * @param p_attribute5 Descriptive flexfield segment.
58  * @param p_attribute6 Descriptive flexfield segment.
59  * @param p_attribute7 Descriptive flexfield segment.
60  * @param p_attribute8 Descriptive flexfield segment.
61  * @param p_attribute9 Descriptive flexfield segment.
62  * @param p_attribute10 Descriptive flexfield segment.
63  * @param p_attribute11 Descriptive flexfield segment.
64  * @param p_attribute12 Descriptive flexfield segment.
65  * @param p_attribute13 Descriptive flexfield segment.
66  * @param p_attribute14 Descriptive flexfield segment.
67  * @param p_attribute15 Descriptive flexfield segment.
68  * @param p_attribute16 Descriptive flexfield segment.
69  * @param p_attribute17 Descriptive flexfield segment.
70  * @param p_attribute18 Descriptive flexfield segment.
71  * @param p_attribute19 Descriptive flexfield segment.
72  * @param p_attribute20 Descriptive flexfield segment.
73  * @param p_data_source {@rep:casecolumn OTA_CATEGORY_USAGES.DATA_SOURCE}
74  * @param p_start_date_active {@rep:casecolumn
75  * OTA_CATEGORY_USAGES.START_DATE_ACTIVE}
76  * @param p_end_date_active {@rep:casecolumn
77  * OTA_CATEGORY_USAGES.END_DATE_ACTIVE}
78  * @param p_category_usage_id {@rep:casecolumn
79  * OTA_CATEGORY_USAGES.CATEGORY_USAGE_ID}
80  * @param p_object_version_number If p_validate is false, then it is set to the
81  * version number of the created external learning. If p_validate is true, then
82  * the value is null.
83  * @param p_comments If profile 'HR:Use Standard Attachments
84  * (PER_ATTACHMENT_USAGE)' is set to 'No', this text serves as HR-specific
85  * attachment text.
86  * @rep:displayname Create Category
87  * @rep:category BUSINESS_ENTITY OTA_LEARNING_CATALOG_CAT_USE
88  * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
89  * @rep:scope public
90  * @rep:lifecycle active
91  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
92 */
93 --
94 -- {End Of Comments}
95 --
96 procedure Create_category
97   (p_validate                      in     boolean  default false
98   ,p_effective_date                in     date
99   ,p_business_group_id             in     number
100   ,p_category                      in     varchar2
101   ,p_type                          in	  varchar2
102   ,p_description                   in     varchar2
103   ,p_parent_cat_usage_id           in	  number
104   ,p_synchronous_flag              in	  varchar2
105   ,p_online_flag                   in	  varchar2 default null
106   ,p_attribute_category            in     varchar2 default null
107   ,p_attribute1                    in     varchar2 default null
108   ,p_attribute2                    in     varchar2 default null
109   ,p_attribute3                    in     varchar2 default null
110   ,p_attribute4                    in     varchar2 default null
111   ,p_attribute5                    in     varchar2 default null
112   ,p_attribute6                    in     varchar2 default null
113   ,p_attribute7                    in     varchar2 default null
114   ,p_attribute8                    in     varchar2 default null
115   ,p_attribute9                    in     varchar2 default null
116   ,p_attribute10                   in     varchar2 default null
117   ,p_attribute11                   in     varchar2 default null
118   ,p_attribute12                   in     varchar2 default null
119   ,p_attribute13                   in     varchar2 default null
120   ,p_attribute14                   in     varchar2 default null
121   ,p_attribute15                   in     varchar2 default null
122   ,p_attribute16                   in     varchar2 default null
123   ,p_attribute17                   in     varchar2 default null
124   ,p_attribute18                   in     varchar2 default null
125   ,p_attribute19                   in     varchar2 default null
126   ,p_attribute20                   in     varchar2 default null
127   ,p_data_source                   in     varchar2 default null
128   ,p_start_date_active             in     date
129   ,p_end_date_active               in     date default null
130   ,p_category_usage_id             out nocopy number
131   ,p_object_version_number         out nocopy number
132   ,p_comments                      in     varchar2 default null
133 
134   );
135 --
136 -- ----------------------------------------------------------------------------
137 -- |-----------------------------< update_category >--------------------------|
138 -- ----------------------------------------------------------------------------
139 --
140 -- {Start Of Comments}
141 /*#
142  * This API updates a category.
143  *
144  *
145  * <p><b>Licensing</b><br>
146  * This API is licensed for use with Learning Management.
147  *
148  * <p><b>Prerequisites</b><br>
149  * Category record must exist for the user.
150  *
151  * <p><b>Post Success</b><br>
152  * Record for category is updated
153  *
154  * <p><b>Post Failure</b><br>
155  * Record for category is not update and an error is raised
156  * @param p_validate If true, then validation alone will be performed and the
157  * database will remain unchanged. If false and all validation checks pass,
158  * then the database will be modified.
159  * @param p_effective_date Reference date for validating lookup values are
160  * applicable during the start to end active date range. This date does not
161  * determine when the changes take effect.
162  * @param p_category_usage_id {@rep:casecolumn
163  * OTA_CATEGORY_USAGES.CATEGORY_USAGE_ID}
164  * @param p_object_version_number Pass in the current version number of the
165  * category to be updated. When the API completes, if p_validate is false, the
166  * number is set to the new version number of the updated category. If
167  * p_validate is true the number remains unchanged.
168  * @param p_category {@rep:casecolumn OTA_CATEGORY_USAGES_TL.CATEGORY}
169  * @param p_type The category's type. Valid values are defined in the
170  * 'CATEGORY_TYPE' lookup type.
171  * @param p_description {@rep:casecolumn OTA_CATEGORY_USAGES_TL.DESCRIPTION}
172  * @param p_parent_cat_usage_id Since a category can be created within a
173  * category, this value determines the category_usage_id of the parent
174  * category. It should be a valid category_usage_id within the same business
175  * group.
176  * @param p_synchronous_flag This flag is used only for categories of type 'DM'
177  * (Delivery Mode). Valid values are defined in the 'YES_NO' lookup type.
178  * @param p_online_flag This flag is used only for categories of type 'DM'
179  * (Delivery Mode). Valid values are defined in the 'YES_NO' lookup type.
180  * @param p_attribute_category This context value determines which flexfield
181  * structure to use with the descriptive flexfield segments.
182  * @param p_attribute1 Descriptive flexfield segment.
183  * @param p_attribute2 Descriptive flexfield segment.
184  * @param p_attribute3 Descriptive flexfield segment.
185  * @param p_attribute4 Descriptive flexfield segment.
186  * @param p_attribute5 Descriptive flexfield segment.
187  * @param p_attribute6 Descriptive flexfield segment.
191  * @param p_attribute10 Descriptive flexfield segment.
188  * @param p_attribute7 Descriptive flexfield segment.
189  * @param p_attribute8 Descriptive flexfield segment.
190  * @param p_attribute9 Descriptive flexfield segment.
192  * @param p_attribute11 Descriptive flexfield segment.
193  * @param p_attribute12 Descriptive flexfield segment.
194  * @param p_attribute13 Descriptive flexfield segment.
195  * @param p_attribute14 Descriptive flexfield segment.
196  * @param p_attribute15 Descriptive flexfield segment.
197  * @param p_attribute16 Descriptive flexfield segment.
198  * @param p_attribute17 Descriptive flexfield segment.
199  * @param p_attribute18 Descriptive flexfield segment.
200  * @param p_attribute19 Descriptive flexfield segment.
201  * @param p_attribute20 Descriptive flexfield segment.
202  * @param p_data_source {@rep:casecolumn OTA_CATEGORY_USAGES.DATA_SOURCE}
203  * @param p_start_date_active {@rep:casecolumn
204  * OTA_CATEGORY_USAGES.START_DATE_ACTIVE}
205  * @param p_end_date_active {@rep:casecolumn
206  * OTA_CATEGORY_USAGES.END_DATE_ACTIVE}
207  * @param p_comments If the profile 'HR:Use Standard Attachments
208  * (PER_ATTACHMENT_USAGE)' is set to 'No', this text serves as HR-specific
209  * attachment text.
210  * @rep:displayname Update Category
211  * @rep:category BUSINESS_ENTITY OTA_LEARNING_CATALOG_CAT_USE
212  * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
213  * @rep:scope public
214  * @rep:lifecycle active
215  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
216 */
217 --
218 -- {End Of Comments}
219 --
220 procedure Update_category
221   (p_validate                      in     boolean  default false
222   ,p_effective_date                in     date
223   ,p_category_usage_id             in     number
224   ,p_object_version_number         in out nocopy number
225   ,p_category                      in     varchar2
226   ,p_type                          in	  varchar2
227   ,p_description                   in     varchar2
228   ,p_parent_cat_usage_id           in	  number
229   ,p_synchronous_flag              in	  varchar2
230   ,p_online_flag                   in	  varchar2 default null
231   ,p_attribute_category            in     varchar2 default null
232   ,p_attribute1                    in     varchar2 default null
233   ,p_attribute2                    in     varchar2 default null
234   ,p_attribute3                    in     varchar2 default null
235   ,p_attribute4                    in     varchar2 default null
236   ,p_attribute5                    in     varchar2 default null
237   ,p_attribute6                    in     varchar2 default null
238   ,p_attribute7                    in     varchar2 default null
239   ,p_attribute8                    in     varchar2 default null
240   ,p_attribute9                    in     varchar2 default null
241   ,p_attribute10                   in     varchar2 default null
242   ,p_attribute11                   in     varchar2 default null
243   ,p_attribute12                   in     varchar2 default null
244   ,p_attribute13                   in     varchar2 default null
245   ,p_attribute14                   in     varchar2 default null
246   ,p_attribute15                   in     varchar2 default null
247   ,p_attribute16                   in     varchar2 default null
248   ,p_attribute17                   in     varchar2 default null
249   ,p_attribute18                   in     varchar2 default null
250   ,p_attribute19                   in     varchar2 default null
251   ,p_attribute20                   in     varchar2 default null
252   ,p_data_source                   in     varchar2 default null
253   ,p_start_date_active             in     date
254   ,p_end_date_active               in     date default null
255   ,p_comments                      in     varchar2 default null
256 
257   );
258 --
259 -- ----------------------------------------------------------------------------
260 -- |-----------------------------< delete_category >--------------------------|
261 -- ----------------------------------------------------------------------------
262 --
263 -- {Start Of Comments}
264 /*#
265  * This API deletes a category.
266  *
267  *
268  * <p><b>Licensing</b><br>
269  * This API is licensed for use with Learning Management.
270  *
271  * <p><b>Prerequisites</b><br>
272  * Category record must exist for the user.
273  *
274  * <p><b>Post Success</b><br>
275  * Record for category is deleted.
276  *
277  * <p><b>Post Failure</b><br>
278  * Record for category is not deleted and an error is raised.
279  * @param p_validate If true, then validation alone will be performed and the
280  * database will remain unchanged. If false and all validation checks pass,
281  * then the database will be modified.
282  * @param p_category_usage_id {@rep:casecolumn
283  * OTA_CATEGORY_USAGES.CATEGORY_USAGE_ID}
284  * @param p_object_version_number Pass in the current version number of the
285  * category to be deleted.
286  * @rep:displayname Delete Category
287  * @rep:category BUSINESS_ENTITY OTA_LEARNING_CATALOG_CAT_USE
288  * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
289  * @rep:scope public
290  * @rep:lifecycle active
291  * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
292 */
293 --
294 -- {End Of Comments}
295 --
296 procedure delete_category
297   (p_validate                      in     boolean  default false
298   ,p_category_usage_id             in     number
299   ,p_object_version_number         in     number
300   );
301 
302 end ota_category_usage_api;