[Home] [Help]
PACKAGE: APPS.OTA_LRNG_PATH_UTIL
Source
1 PACKAGE OTA_LRNG_PATH_UTIL AUTHID CURRENT_USER as
2 /* $Header: otlpswrs.pkh 120.4 2011/05/17 13:30:58 nchinnam ship $ */
3
4 -- ---------------------------------------------------------------------------
5 -- |----------------------< chk_complete_path_ok >--------------------------|
6 -- ---------------------------------------------------------------------------
7 --
8
9 -- {Start Of Comments}
10 --
11 -- Description:
12 --
13 -- Prerequisites:
14 --
15 --
16 -- In Arguments:
17 --
18 --
19 -- Post Success:
20 --
21 -- Post Failure:
22 --
23 --
24 -- Access Status:
25 -- Internal Development Use Only.
26 --
27 -- {End Of Comments}
28 -- ---------------------------------------------------------------------------
29 Function chk_complete_path_ok(p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type)
30 return varchar2;
31
32 -- ---------------------------------------------------------------------------
33 -- |----------------------< chk_login_person >--------------------------|
34 -- ---------------------------------------------------------------------------
35 -- {Start Of Comments}
36 --
37 -- Description:
38 -- Checks whether the login person is Manager or employee
39 --
40 -- Prerequisites:
41 --
42 --
43 -- In Arguments:
44 -- p_lp_enrollment_id
45 --
46 --
47 -- Post Success:
48 -- 'M' is returned for Manager
49 -- 'E' is returned for employee
50 -- Post Failure:
51 --
52 --
53 -- Access Status:
54 -- Internal Development Use Only.
55 --
56 -- {End Of Comments}
57 -- ---------------------------------------------------------------------------
58
59 FUNCTION chk_login_person ( p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE)
60 RETURN VARCHAR2;
61 -- ----------------------------------------------------------------------------
62 -- |----------------------<get_person_id>-----------------------------------------|
63 -- ----------------------------------------------------------------------------
64 -- {Start Of Comments}
65 --
66 -- Description:
67 -- Returns the person_id associated with the learning path
68 --
69 -- Prerequisites:
70 --
71 --
72 -- In Parameters:
73 --
74 -- p_lp_enrollment_id
75 --
76 -- Post Success:
77 -- Processing continues if the the dates are legal.
78 --
79 -- Post Failure:
80 -- If an error has occurred, an error message will be raised.
81 --
82 -- Developer Implementation Notes:
83 -- None
84 --
85 -- Access Status:
86 -- Internal Row Handler Use Only.
87 --
88 -- {End Of Comments}
89 -- ----------------------------------------------------------------------------
90
91 FUNCTION get_person_id(p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE)
92 RETURN number;
93
94 -- ---------------------------------------------------------------------------
95 -- |----------------------< complete_path >--------------------------|
96 -- ---------------------------------------------------------------------------
97 --
98
99 PROCEDURE complete_path(p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type);
100
101 -- ----------------------------------------------------------------------------
102 -- |----------------------<get_no_of_mandatory_courses> -----------------------|
103 -- ----------------------------------------------------------------------------
104 -- {Start Of Comments}
105 --
106 -- Description:
107 -- Returns the number of mandatory courses for a learning path
108 --
109 -- Prerequisites:
110 --
111 --
112 -- In Parameters:
113 --
114 -- p_learning_path_id
115 --
116 -- Post Success:
117 -- Returns the number of mandatory courses for a learning path
118 --
119 -- Post Failure:
120 -- If an error has occurred, an error message will be raised.
121 --
122 -- Developer Implementation Notes:
123 -- None
124 --
125 -- Access Status:
126 -- Internal Row Handler Use Only.
127 --
128 -- {End Of Comments}
129 -- ----------------------------------------------------------------------------
130
131 FUNCTION get_no_of_mandatory_courses(p_learning_path_id IN ota_learning_paths.learning_path_id%TYPE,
132 p_path_source_code IN ota_learning_paths.path_source_code%TYPE)
133 RETURN number;
134
135
136 -- ----------------------------------------------------------------------------
137 -- |----------------------<get_no_of_completed_courses> -----------------------|
138 -- ----------------------------------------------------------------------------
139 -- {Start Of Comments}
140 --
141 -- Description:
142 -- Returns the number of completed courses for a learning path
143 --
144 -- Prerequisites:
145 --
146 --
147 -- In Parameters:
148 --
149 -- p_lp_enrollment_id
150 -- p_path_source_code
151 --
152 -- Post Success:
153 -- Returns the number of completed courses for an lp enrollment
154 --
155 -- Post Failure:
156 -- If an error has occurred, an error message will be raised.
157 --
158 -- Developer Implementation Notes:
159 -- None
160 --
161 -- Access Status:
162 -- Internal Row Handler Use Only.
163 --
164 -- {End Of Comments}
165 -- ----------------------------------------------------------------------------
166
167 FUNCTION get_no_of_completed_courses(p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE,
168 p_path_source_code IN ota_learning_paths.path_source_code%TYPE)
169 RETURN number;
170
171 -- ---------------------------------------------------------------------------
172 -- |----------------------< Update_lpe_lpm_changes >--------------------------|
173 -- ---------------------------------------------------------------------------
174 -- {Start Of Comments}
175 --
176 -- Description:
177 -- Updates no_of_completed_courses and no_of_mandatory_courses for the
178 -- p_lp_enrollment_id passed, and marks the path completed if it meets the
179 -- completion criteria.
180 --
181 -- Prerequisites:
182 --
183 --
184 -- In Arguments:
185 -- p_lp_enrollment_id
186 -- p_completion_target_date new completion_target_date
187 --
188 --
189 -- Post Success:
190 -- 'S' is returned for successful update of no_of_completed_courses and
191 -- no_of_mandatory_courses
192 -- 'C' is returned for successful completion of path.
193 -- 'F' is returned for no update.
194 -- Post Failure:
195 --
196 --
197 -- Access Status:
198 -- Internal Development Use Only.
199 --
200 -- {End Of Comments}
201 -- ---------------------------------------------------------------------------
202
203 Procedure Update_lpe_lpm_changes( p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE,
204 --Modified for Bug#3891087
205 --p_path_source_code IN ota_learning_paths.path_source_code%TYPE,
206 p_completion_target_date IN ota_lp_enrollments.completion_target_date%TYPE,
207 p_return_status OUT NOCOPY VARCHAR2);
208
209 -- ---------------------------------------------------------------------------
210 -- |----------------------< get_lpe_crse_compl_status_msg >--------------------------|
211 -- ---------------------------------------------------------------------------
212 -- {Start Of Comments}
213 --
214 -- Description:
215 -- Retrieves tokenized message for displaying Learning Path course completion
216 -- status.
217 --
218 -- Prerequisites:
219 --
220 --
221 -- In Arguments:
222 -- no_of_completed_courses
223 -- no_of_mandatory_courses
224 --
225 -- Post Success:
226 -- Return of form of tokenized "no_of_completed_courses of no_of_mandatory_courses
227 -- courses completed."
228 --
229 -- Post Failure:
230 --
231 -- Access Status:
232 -- Internal Development Use Only.
233 --
234 -- {End Of Comments}
235 -- ---------------------------------------------------------------------------
236 FUNCTION get_lpe_crse_compl_status_msg(no_of_completed_courses IN number, no_of_mandatory_courses IN number)
237 RETURN varchar2;
238
239 -- ---------------------------------------------------------------------------
240 -- |----------------------< get_talent_mgmt_lp >--------------------------|
241 -- ---------------------------------------------------------------------------
242 --
243
244 FUNCTION get_talent_mgmt_lp(p_person_id IN ota_lp_enrollments.person_id%TYPE
245 ,p_source_function_code IN ota_learning_paths.source_function_code%TYPE
246 ,p_source_id IN ota_learning_paths.source_id%TYPE
247 ,p_assignment_id IN ota_learning_paths.assignment_id%TYPE
248 ,p_business_group_id IN NUMBER)
249 RETURN NUMBER;
250
251
252 -- ----------------------------------------------------------------------------
253 -- |----------------------<get_no_of_mand_compl_courses> ----------------------|
254 -- ----------------------------------------------------------------------------
255 -- {Start Of Comments}
256 --
257 -- Description:
258 -- Returns the number of mandatory completed courses for a learning path section
259 --
260 -- Prerequisites:
261 --
262 --
263 -- In Parameters:
264 --
265 -- p_learning_path_section_id
266 -- p_person_id
267 -- p_contact_id
268 --
269 -- Post Success:
270 -- Returns the number of mand completed courses for a learning path section
271 --
272 -- Post Failure:
273 -- If an error has occurred, an error message will be raised.
274 --
275 -- Developer Implementation Notes:
276 -- None
277 --
278 -- Access Status:
279 -- Internal Row Handler Use Only.
280 --
281 -- {End Of Comments}
282 -- ----------------------------------------------------------------------------
283
284 FUNCTION get_no_of_mand_compl_courses(p_learning_path_section_id IN ota_lp_sections.learning_path_section_id%TYPE,
285 p_person_id IN ota_learning_paths.person_id%TYPE,
286 p_contact_id IN ota_learning_paths.contact_id%TYPE)
287 RETURN number;
288
289 Function is_path_successful(p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type)
290 return varchar2;
291
292 Procedure Start_comp_proc_success_attnd(p_person_id in number ,
293 p_event_id in ota_Events.event_id%type);
294
295 -- Added this function for Bug# 7430475
296 FUNCTION get_no_of_mand_compl_courses(p_lp_enrollment_id IN ota_lp_enrollments.lp_enrollment_id%TYPE)
297 RETURN number;
298
299 function get_lp_current_status(p_lp_enrollment_id in ota_lp_enrollments.lp_enrollment_id%type)
300 return varchar2 ;
301
302 function get_lp_enroll_id(p_event_id IN ota_events.event_id%type,
303 p_person_id IN ota_lp_enrollments.person_id%type,
304 p_contact_id ota_lp_enrollments.contact_id%type)
305 return ota_lp_enrollments.lp_enrollment_id%type;
306
307 END ota_lrng_path_util;
308