1 Package ota_skill_provision_api AUTHID CURRENT_USER as
2 /* $Header: ottspapi.pkh 120.1 2005/10/02 02:08:49 aroussel $ */
3 /*#
4 * This package contains the Course Other Information APIs.
5 * @rep:scope public
6 * @rep:product ota
7 * @rep:displayname Course Other Information
8 */
9 --
10 -- ----------------------------------------------------------------------------
11 -- |--------------------------< create_skill_provision >----------------------|
12 -- ----------------------------------------------------------------------------
13 --
14 -- {Start Of Comments}
15 /*#
16 * This API creates a Course Other Information record.
17 *
18 * This business process creates Course Other Information.
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 Course for which the other information is being defined should exist,
25 * and the course other information should be enabled for application, OTA.
26 *
27 * <p><b>Post Success</b><br>
28 * The Course Other Information record is created.
29 *
30 * <p><b>Post Failure</b><br>
31 * The API is unable to create Course Other Information, an error is thrown
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_skill_provision_id The Course Other Information number generation
36 * method determines when the API derives and passes
37 * @param p_activity_version_id {@rep:casecolumn
38 * OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID}
39 * @param p_object_version_number If p_validate is false, then set to the
40 * version number of the created Course Other Information. If p_validate is
41 * true, then the value will be null.
42 * @param p_type {@rep:casecolumn OTA_SKILL_PROVISIONS.TYPE}
43 * @param p_comments {@rep:casecolumn OTA_SKILL_PROVISIONS.COMMENTS}
44 * @param p_tsp_information_category This context value determines which
45 * Flexfield Structure to use with the Descriptive flexfield segments.
46 * @param p_tsp_information1 Descriptive Flexfield
47 * @param p_tsp_information2 Descriptive Flexfield
48 * @param p_tsp_information3 Descriptive Flexfield
49 * @param p_tsp_information4 Descriptive Flexfield
50 * @param p_tsp_information5 Descriptive Flexfield
51 * @param p_tsp_information6 Descriptive Flexfield
52 * @param p_tsp_information7 Descriptive Flexfield
53 * @param p_tsp_information8 Descriptive Flexfield
54 * @param p_tsp_information9 Descriptive Flexfield
55 * @param p_tsp_information10 Descriptive Flexfield
56 * @param p_tsp_information11 Descriptive Flexfield
57 * @param p_tsp_information12 Descriptive Flexfield
58 * @param p_tsp_information13 Descriptive Flexfield
59 * @param p_tsp_information14 Descriptive Flexfield
60 * @param p_tsp_information15 Descriptive Flexfield
61 * @param p_tsp_information16 Descriptive Flexfield
62 * @param p_tsp_information17 Descriptive Flexfield
63 * @param p_tsp_information18 Descriptive Flexfield
64 * @param p_tsp_information19 Descriptive Flexfield
65 * @param p_tsp_information20 Descriptive Flexfield
66 * @param p_analysis_criteria_id {@rep:casecolumn
67 * PER_ANALYSIS_CRITERIA.ANALYSIS_CRITERIA_ID}
68 * @rep:displayname Create Course Other Information
69 * @rep:category BUSINESS_ENTITY OTA_LEARNING_COURSE
70 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
71 * @rep:scope public
72 * @rep:lifecycle active
73 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
74 */
75 --
76 -- {End Of Comments}
77 --
78 Procedure create_skill_provision
79 (
80 p_skill_provision_id out nocopy number,
81 p_activity_version_id in number,
82 p_object_version_number out nocopy number,
83 p_type in varchar2,
84 p_comments in varchar2 default null,
85 p_tsp_information_category in varchar2 default null,
86 p_tsp_information1 in varchar2 default null,
87 p_tsp_information2 in varchar2 default null,
88 p_tsp_information3 in varchar2 default null,
89 p_tsp_information4 in varchar2 default null,
90 p_tsp_information5 in varchar2 default null,
91 p_tsp_information6 in varchar2 default null,
92 p_tsp_information7 in varchar2 default null,
93 p_tsp_information8 in varchar2 default null,
94 p_tsp_information9 in varchar2 default null,
95 p_tsp_information10 in varchar2 default null,
96 p_tsp_information11 in varchar2 default null,
97 p_tsp_information12 in varchar2 default null,
98 p_tsp_information13 in varchar2 default null,
99 p_tsp_information14 in varchar2 default null,
100 p_tsp_information15 in varchar2 default null,
101 p_tsp_information16 in varchar2 default null,
102 p_tsp_information17 in varchar2 default null,
103 p_tsp_information18 in varchar2 default null,
104 p_tsp_information19 in varchar2 default null,
105 p_tsp_information20 in varchar2 default null,
106 p_analysis_criteria_id in number,
107 p_validate in boolean default false
108 );
109 --
110 -- ----------------------------------------------------------------------------
111 -- |--------------------------< update_skill_provision >----------------------|
112 -- ----------------------------------------------------------------------------
113 --
114 -- {Start Of Comments}
115 /*#
116 * This API updates a Course Other Information record.
117 *
118 *
119 * <p><b>Licensing</b><br>
120 * This API is licensed for use with Learning Management.
121 *
122 * <p><b>Prerequisites</b><br>
123 * The Course Other Information record must exist
124 *
125 * <p><b>Post Success</b><br>
126 * The Course Other Information record is updated.
127 *
128 * <p><b>Post Failure</b><br>
129 * The Course Other Information record is not updated, and an error is thrown.
130 * @param p_validate If true, then validation alone will be performed and the
131 * database will remain unchanged. If false and all validation checks pass,
132 * then the database will be modified.
133 * @param p_skill_provision_id The unique identifier for the Course Other
134 * Information record.
135 * @param p_activity_version_id {@rep:casecolumn
136 * OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID}
137 * @param p_object_version_number Pass in the variable holding for the version
138 * number of the Course Other Information record to be updated. When the API
139 * completes if p_validate is false, will be set to the new version number of
140 * the Course Other Information record. If p_validate is true will be set to
141 * the same value which was passed in.
142 * @param p_type {@rep:casecolumn OTA_SKILL_PROVISIONS.TYPE}
143 * @param p_comments {@rep:casecolumn OTA_SKILL_PROVISIONS.COMMENTS}
144 * @param p_tsp_information_category This context value determines which
145 * Flexfield Structure to use with the Descriptive flexfield segments.
146 * @param p_tsp_information1 Descriptive Flexfield
147 * @param p_tsp_information2 Descriptive Flexfield
148 * @param p_tsp_information3 Descriptive Flexfield
149 * @param p_tsp_information4 Descriptive Flexfield
150 * @param p_tsp_information5 Descriptive Flexfield
151 * @param p_tsp_information6 Descriptive Flexfield
152 * @param p_tsp_information7 Descriptive Flexfield
153 * @param p_tsp_information8 Descriptive Flexfield
154 * @param p_tsp_information9 Descriptive Flexfield
155 * @param p_tsp_information10 Descriptive Flexfield
156 * @param p_tsp_information11 Descriptive Flexfield
157 * @param p_tsp_information12 Descriptive Flexfield
158 * @param p_tsp_information13 Descriptive Flexfield
159 * @param p_tsp_information14 Descriptive Flexfield
160 * @param p_tsp_information15 Descriptive Flexfield
161 * @param p_tsp_information16 Descriptive Flexfield
162 * @param p_tsp_information17 Descriptive Flexfield
163 * @param p_tsp_information18 Descriptive Flexfield
164 * @param p_tsp_information19 Descriptive Flexfield
165 * @param p_tsp_information20 Descriptive Flexfield
166 * @param p_analysis_criteria_id {@rep:casecolumn
167 * PER_ANALYSIS_CRITERIA.ANALYSIS_CRITERIA_ID}
168 * @rep:displayname Update Course Other Information
169 * @rep:category BUSINESS_ENTITY OTA_LEARNING_COURSE
170 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
171 * @rep:scope public
172 * @rep:lifecycle active
173 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
174 */
175 --
176 -- {End Of Comments}
177 --
178 Procedure update_skill_provision
179 (
180 p_skill_provision_id in number,
181 p_activity_version_id in number default hr_api.g_number,
182 p_object_version_number in out nocopy number,
183 p_type in varchar2 default hr_api.g_varchar2,
184 p_comments in varchar2 default hr_api.g_varchar2,
185 p_tsp_information_category in varchar2 default hr_api.g_varchar2,
186 p_tsp_information1 in varchar2 default hr_api.g_varchar2,
187 p_tsp_information2 in varchar2 default hr_api.g_varchar2,
188 p_tsp_information3 in varchar2 default hr_api.g_varchar2,
189 p_tsp_information4 in varchar2 default hr_api.g_varchar2,
190 p_tsp_information5 in varchar2 default hr_api.g_varchar2,
191 p_tsp_information6 in varchar2 default hr_api.g_varchar2,
192 p_tsp_information7 in varchar2 default hr_api.g_varchar2,
193 p_tsp_information8 in varchar2 default hr_api.g_varchar2,
194 p_tsp_information9 in varchar2 default hr_api.g_varchar2,
195 p_tsp_information10 in varchar2 default hr_api.g_varchar2,
196 p_tsp_information11 in varchar2 default hr_api.g_varchar2,
197 p_tsp_information12 in varchar2 default hr_api.g_varchar2,
198 p_tsp_information13 in varchar2 default hr_api.g_varchar2,
199 p_tsp_information14 in varchar2 default hr_api.g_varchar2,
200 p_tsp_information15 in varchar2 default hr_api.g_varchar2,
201 p_tsp_information16 in varchar2 default hr_api.g_varchar2,
202 p_tsp_information17 in varchar2 default hr_api.g_varchar2,
203 p_tsp_information18 in varchar2 default hr_api.g_varchar2,
204 p_tsp_information19 in varchar2 default hr_api.g_varchar2,
205 p_tsp_information20 in varchar2 default hr_api.g_varchar2,
206 p_analysis_criteria_id in number default hr_api.g_number,
207 p_validate in boolean default false
208 );
209 --
210 -- ----------------------------------------------------------------------------
211 -- |--------------------------< delete_skill_provision >----------------------|
212 -- ----------------------------------------------------------------------------
213 --
214 -- {Start Of Comments}
215 /*#
216 * This API deletes a Course Other Information record.
217 *
218 *
219 * <p><b>Licensing</b><br>
220 * This API is licensed for use with Learning Management.
221 *
222 * <p><b>Prerequisites</b><br>
223 * The Course Other Information record must exist
224 *
225 * <p><b>Post Success</b><br>
226 * The Course Other Information record is deleted from the underlying system
227 *
228 * <p><b>Post Failure</b><br>
229 * The API is unable to delete the Course Other Information record, an error is
230 * thrown
231 * @param p_validate If true, then validation alone will be performed and the
232 * database will remain unchanged. If false and all validation checks pass,
233 * then the database will be modified.
234 * @param p_skill_provision_id The unique identifier for the Course Other
235 * Information record.
236 * @param p_object_version_number Current version number of the Course Other
237 * Information to be deleted
238 * @rep:displayname Delete Course Other Information
239 * @rep:category BUSINESS_ENTITY OTA_LEARNING_COURSE
240 * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
241 * @rep:scope public
242 * @rep:lifecycle active
243 * @rep:ihelp PER/@scalapi APIs in Oracle HRMS
244 */
245 --
246 -- {End Of Comments}
247 --
248 Procedure delete_skill_provision
249 (
250 p_skill_provision_id in number,
251 p_object_version_number in number,
252 p_validate in boolean default false
253 );
254 end ota_skill_provision_api;