4 gv_wf_review_region_item constant wf_item_attributes.name%type
1 PACKAGE ota_add_training_ss AUTHID CURRENT_USER AS
2 /* $Header: otaddwrs.pkh 120.0.12000000.1 2007/01/18 03:34:57 appldev noship $ */
3
5 := 'HR_REVIEW_REGION_ITEM';
6 /*
7 ||===========================================================================
8 || PROCEDURE: save_add_training
9 ||---------------------------------------------------------------------------
10 ||
11 || Description:
12 || This procedure will save additional training details in Transaction table.
13 ||
14 ||
15 || Pre Conditions:
16 ||
17 || In Arguments:
18 ||
19 ||
20 ||
21 || out nocopy Arguments:
22 ||
23 || In out nocopy Arguments:
24 ||
25 || Post Success:
26 ||
27 ||
28 || Post Failure:
29 || Raises an exception
30 ||
31 || Access Status:
32 || Public.
33 ||
34 ||===========================================================================
35 */
36
37 PROCEDURE save_add_training(
38 p_login_person_id NUMBER DEFAULT NULL
39 , p_item_type IN VARCHAR2
40 , p_item_key IN VARCHAR2
41 , p_activity_id IN NUMBER
42 , p_save_mode IN VARCHAR2 DEFAULT NULL
43 , p_error_message OUT NOCOPY VARCHAR2
44 , p_title IN VARCHAR2
45 , p_supplier IN VARCHAR2
46 , p_eq_ota_activity IN VARCHAR2
47 , p_location IN VARCHAR2
48 , p_trntype IN VARCHAR2
49 , p_duration IN VARCHAR2
50 , p_duration_unit IN VARCHAR2
51 , p_status IN VARCHAR2
52 , p_completion_date IN Date
53 , p_award IN VARCHAR2
54 , p_score IN VARCHAR2
55 , p_internal_contact_person IN VARCHAR2
56 , p_historyId IN VARCHAR2
57 , p_nth_information_category IN VARCHAR2 DEFAULT NULL
58 , p_nth_information1 IN VARCHAR2 DEFAULT NULL
59 , p_nth_information2 IN VARCHAR2 DEFAULT NULL
60 , p_nth_information3 IN VARCHAR2 DEFAULT NULL
61 , p_nth_information4 IN VARCHAR2 DEFAULT NULL
62 , p_nth_information5 IN VARCHAR2 DEFAULT NULL
63 , p_nth_information6 IN VARCHAR2 DEFAULT NULL
64 , p_nth_information7 IN VARCHAR2 DEFAULT NULL
65 , p_nth_information8 IN VARCHAR2 DEFAULT NULL
66 , p_nth_information9 IN VARCHAR2 DEFAULT NULL
67 , p_nth_information10 IN VARCHAR2 DEFAULT NULL
68 , p_nth_information11 IN VARCHAR2 DEFAULT NULL
69 , p_nth_information12 IN VARCHAR2 DEFAULT NULL
70 , p_nth_information13 in VARCHAR2 DEFAULT NULL
71 , p_nth_information14 in VARCHAR2 DEFAULT NULL
72 , p_nth_information15 in VARCHAR2 DEFAULT NULL
73 , p_nth_information16 in VARCHAR2 DEFAULT NULL
74 , p_nth_information17 in VARCHAR2 DEFAULT NULL
75 , p_nth_information18 in VARCHAR2 DEFAULT NULL
76 , p_nth_information19 in VARCHAR2 DEFAULT NULL
77 , p_nth_information20 in VARCHAR2 DEFAULT NULL
78 , p_contact_name in VARCHAR2
79 , p_activity_name in VARCHAR2
80 , p_obj_ver_no in VARCHAR2
81 , p_business_grp_id in VARCHAR2
82 , p_person_id in NUMBER
83 , p_from in VARCHAR2
84 , p_oafunc in VARCHAR2 DEFAULT NULL
85 , p_processname in VARCHAR2 DEFAULT NULL
86 , p_calledfrom in VARCHAR2 DEFAULT NULL
87 , p_frommenu in VARCHAR2 DEFAULT NULL
88 , p_org_id in VARCHAR2
89 , p_transaction_mode IN VARCHAR2
90 , p_check_changes_result OUT NOCOPY VARCHAR2 --new parameter
91 , p_Status_Meaning IN VARCHAR2
92 , p_Type_Meaning IN VARCHAR2
93 );
94
95
96
97
98 -- ---------------------------------------------------------------------------
99 -- ---------------------- < get_add_trg_data_from_tt> -------------------------
100 -- ---------------------------------------------------------------------------
101 -- Purpose: This procedure will get transaction data which are saved earlier
102 -- in the current transaction. This is invoked when a user click BACK
103 -- button to go back from the Review page or make further changes or
107
104 -- vice-versa. Hence, we need to use
105 -- the item_type item_key passed in to retrieve the transaction record.
106 -- ---------------------------------------------------------------------------
108 PROCEDURE get_add_trg_data_from_tt
109 (p_item_type in VARCHAR2
110 ,p_item_key in VARCHAR2
111 ,p_activity_id in VARCHAR2
112 ,p_trans_rec_count out nocopy NUMBER
113 ,p_person_id out nocopy NUMBER
114 ,p_add_trg_data out nocopy VARCHAR2
115 );
116
117 -- ---------------------------------------------------------------------------
118 -- ---------------------- < get_add_trg_data_from_tt> ---------------------
119 -- ---------------------------------------------------------------------------
120 -- Purpose: This procedure will get transaction data which are pending for
121 -- approval in workflow for a transaction step id.
122 -- This is a overloaded version
123 -- ---------------------------------------------------------------------------
124
125 procedure get_add_trg_data_from_tt
126 (p_transaction_step_id in NUMBER
127 ,p_add_trg_data out nocopy VARCHAR2
128 );
129
130 PROCEDURE get_pending_transaction_data
131 (p_processname IN VARCHAR2,
132 p_item_type IN VARCHAR2,
133 p_person_id IN NUMBER,
134 p_exclude_historyid OUT NOCOPY VARCHAR2,
135 p_transaction_step_ids OUT NOCOPY VARCHAR2) ;
136
137 procedure process_api
138 (p_validate IN BOOLEAN DEFAULT FALSE
139 ,p_transaction_step_id IN NUMBER DEFAULT NULL
140 ,p_effective_date in varchar2 DEFAULT NULL
141 );
142
143
144
145
146 -- ---------------------------------------------------------------------------
147 -- ---------------------- < create_add_training_tt > ---------------------
148 -- ---------------------------------------------------------------------------
149 -- Purpose: This procedure will get transaction data which are pending for
150 -- approval in workflow for a transaction step id and creates
151 -- a additional training record.
152 -- ---------------------------------------------------------------------------
153
154
155 procedure create_add_training_tt
156 (p_validate IN BOOLEAN DEFAULT FALSE
157 ,p_transaction_step_id IN NUMBER DEFAULT NULL
158 );
159
160
161 -- ---------------------------------------------------------------------------
162 -- ---------------------- < update_add_training_tt > ---------------------
163 -- ---------------------------------------------------------------------------
164 -- Purpose: This procedure will get transaction data which are pending for
165 -- approval in workflow for a transaction step id and updates
166 -- corresponding additional training record.
167 -- ---------------------------------------------------------------------------
168
169 procedure update_add_training_tt
170 (p_validate IN BOOLEAN DEFAULT FALSE
171 ,p_transaction_step_id IN NUMBER DEFAULT NULL
172 );
173
174
175
176 -- ----------------------------------------------------------------------------
177 -- |-----------------------------< delete_add_training >--------------------------|
178 -- ----------------------------------------------------------------------------
179 -- {Start Of Comments}
180 --
181 -- Description:
182 -- This package is used by self service application to delete additional training records.
183 --
184 -- Prerequisites:
185 --
186 -- In Parameters:
187 --
188 -- Post Success:
189 -- Additional Training data will be deleted.
190 --
191 -- Post Failure:
192 -- Status will be passed to the caller and the caller will raise a notification.
193 --
194 -- Developer Implementation Notes:
195 -- The attrbute in parameters should be modified as to the business process
196 -- requirements.
197 --
198 -- Access Status:
199 -- Internal Development Use Only.
200 --
201 -- {End Of Comments}
202 -- ----------------------------------------------------------------------------
203 PROCEDURE delete_add_training
204 ( p_nota_history_id IN OTA_NOTRNG_HISTORIES.NOTA_HISTORY_ID%TYPE
205 , p_trng_title IN VARCHAR2
206 , p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE
207 , p_item_key IN WF_ITEMS.ITEM_TYPE%TYPE
208 , p_message OUT NOCOPY VARCHAR2
209 );
210
211
212
213 -- ----------------------------------------------------------------------------
214 -- |-----------------------------< create_add_training >--------------------------|
215 -- ----------------------------------------------------------------------------
216 -- {Start Of Comments}
217 --
218 -- Description:
219 -- This package is used by self service application to create additional training records.
220 --
221 -- Prerequisites:
222 --
223 -- In Parameters:
224 --
225 -- Post Success:
226 -- Additional Training data will be created.
227 --
228 -- Post Failure:
229 -- Status will be passed to the caller and the caller will raise a notification.
230 --
231 -- Developer Implementation Notes:
232 -- The attrbute in parameters should be modified as to the business process
233 -- requirements.
234 --
235 -- Access Status:
236 -- Internal Development Use Only.
237 --
238 -- {End Of Comments}
239 -- ----------------------------------------------------------------------------
240
241
245 ,p_person_id in NUMBER
242 Procedure create_add_training
243 (p_effective_date in date
244 ,p_nota_history_id out nocopy NUMBER
246 ,p_contact_id in NUMBER DEFAULT NULL
247 ,p_trng_title in VARCHAR2
248 ,p_provider in VARCHAR2
249 ,p_type in VARCHAR2 DEFAULT NULL
250 ,p_centre in VARCHAR2 DEFAULT NULL
251 ,p_completion_date in date
252 ,p_award in VARCHAR2 DEFAULT NULL
253 ,p_rating in VARCHAR2 DEFAULT NULL
254 ,p_duration in NUMBER DEFAULT NULL
255 ,p_duration_units in VARCHAR2 DEFAULT NULL
256 ,p_activity_version_id in NUMBER DEFAULT NULL
257 ,p_status in VARCHAR2 DEFAULT NULL
258 ,p_verified_by_id in NUMBER DEFAULT NULL
259 ,p_nth_information_category in VARCHAR2 DEFAULT NULL
260 ,p_nth_information1 in VARCHAR2 DEFAULT NULL
261 ,p_nth_information2 in VARCHAR2 DEFAULT NULL
262 ,p_nth_information3 in VARCHAR2 DEFAULT NULL
263 ,p_nth_information4 in VARCHAR2 DEFAULT NULL
264 ,p_nth_information5 in VARCHAR2 DEFAULT NULL
265 ,p_nth_information6 in VARCHAR2 DEFAULT NULL
266 ,p_nth_information7 in VARCHAR2 DEFAULT NULL
267 ,p_nth_information8 in VARCHAR2 DEFAULT NULL
268 ,p_nth_information9 in VARCHAR2 DEFAULT NULL
269 ,p_nth_information10 in VARCHAR2 DEFAULT NULL
270 ,p_nth_information11 in VARCHAR2 DEFAULT NULL
271 ,p_nth_information12 in VARCHAR2 DEFAULT NULL
272 ,p_nth_information13 in VARCHAR2 DEFAULT NULL
273 ,p_nth_information15 in VARCHAR2 DEFAULT NULL
274 ,p_nth_information16 in VARCHAR2 DEFAULT NULL
275 ,p_nth_information17 in VARCHAR2 DEFAULT NULL
276 ,p_nth_information18 in VARCHAR2 DEFAULT NULL
277 ,p_nth_information19 in VARCHAR2 DEFAULT NULL
278 ,p_nth_information20 in VARCHAR2 DEFAULT NULL
279 ,p_org_id in NUMBER DEFAULT NULL
280 ,p_object_version_NUMBER out nocopy NUMBER
281 ,p_business_group_id in NUMBER
282 ,p_nth_information14 in VARCHAR2 DEFAULT NULL
283 ,p_customer_id in NUMBER DEFAULT NULL
284 ,p_organization_id in NUMBER DEFAULT NULL
285 ,p_some_warning out nocopy NUMBER
286 ,p_message out nocopy VARCHAR2
287 ,p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE
288 ,p_item_key IN WF_ITEMS.ITEM_TYPE%TYPE
289
290 );
291
292
293
294 -- ----------------------------------------------------------------------------
295 -- |-----------------------------< update_add_training >--------------------------|
296 -- ----------------------------------------------------------------------------
297 -- {Start Of Comments}
298 --
299 -- Description:
300 -- This package is used by self service application to update additional training records.
301 --
302 -- Prerequisites:
303 --
304 -- In Parameters:
305 --
306 -- Post Success:
307 -- Additional Training data will be updated.
308 --
309 -- Post Failure:
310 -- Status will be passed to the caller and the caller will raise a notification.
311 --
312 -- Developer Implementation Notes:
313 -- The attrbute in parameters should be modified as to the business process
314 -- requirements.
315 --
316 -- Access Status:
317 -- Internal Development Use Only.
318 --
319 -- {End Of Comments}
320 -- ----------------------------------------------------------------------------
321
322 Procedure update_add_training
323 (p_effective_date in date
324 ,p_nota_history_id in NUMBER
325 ,p_person_id in NUMBER
326 ,p_contact_id in NUMBER DEFAULT hr_api.g_NUMBER
327 ,p_trng_title in VARCHAR2
328 ,p_provider in VARCHAR2
329 ,p_type in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
330 ,p_centre in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
331 ,p_completion_date in date
332 ,p_award in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
333 ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
334 ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER
335 ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
336 ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER
337 ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
338 ,p_verified_by_id in NUMBER DEFAULT hr_api.g_NUMBER
339 ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
340 ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
341 ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
342 ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
343 ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
344 ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
345 ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
346 ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
347 ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
348 ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
349 ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
350 ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
351 ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
355 ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
352 ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
353 ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
354 ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
356 ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
357 ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
358 ,p_nth_information19 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
359 ,p_nth_information20 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
360 ,p_org_id in NUMBER DEFAULT hr_api.g_NUMBER
361 ,p_old_object_version_NUMBER in NUMBER
362 ,p_business_group_id in NUMBER
363 ,p_customer_id in NUMBER DEFAULT hr_api.g_NUMBER
364 ,p_organization_id in NUMBER DEFAULT hr_api.g_NUMBER
365 ,p_some_warning out nocopy NUMBER
366 ,p_message out nocopy VARCHAR2
367 ,p_new_object_version_NUMBER out nocopy NUMBER
368 ,p_item_type IN WF_ITEMS.ITEM_TYPE%TYPE
369 ,p_item_key IN WF_ITEMS.ITEM_TYPE%TYPE
370 );
371
372
373 -- ----------------------------------------------------------------------------
374 -- |-----------------------------<additional_training_notify>--------------------------|
375 -- ----------------------------------------------------------------------------
376 -- {Start Of Comments}
377 --
378 -- Description:
379 -- This procedure is used by self service application to identify which notification (insert or update)
380 -- to send on commiting a transaction in the table.
381 -- Prerequisites:
382 --
383 -- In Parameters:
384 --
385 -- Post Success:
386 --
387 --
388 -- Post Failure:
389 --
390 --
391 -- Developer Implementation Notes:
392 --
393 --
394 -- Access Status:
395 -- Internal Development Use Only.
396 --
397 -- {End Of Comments}
398 -- ----------------------------------------------------------------------------
399 Procedure additional_training_notify
400 (itemtype IN WF_ITEMS.ITEM_TYPE%TYPE,
401 itemkey IN WF_ITEMS.ITEM_KEY%TYPE,
402 actid IN NUMBER,
403 funcmode IN VARCHAR2,
404 resultout OUT NOCOPY VARCHAR2 );
405
406 -- ----------------------------------------------------------------------------
407 -- |-----------------------------<validate_add_training>--------------------------|
408 -- ----------------------------------------------------------------------------
409 -- {Start Of Comments}
410 --
411 -- Description:
412 -- This procedure is used by self service application to validate the data (with approval mode on)
413 -- entered by user.
414 -- Prerequisites:
415 --
416 -- In Parameters:
417 --
418 -- Post Success:
419 --
420 --
421 -- Post Failure:
422 --
423 --
424 -- Developer Implementation Notes:
425 --
426 --
427 -- Access Status:
428 -- Internal Development Use Only.
429 --
430 -- {End Of Comments}
431 -- ----------------------------------------------------------------------------
432
433
434 Procedure validate_add_training
435 (p_item_type in varchar2,
436 p_item_key in varchar2,
437 p_message out nocopy varchar2);
438
439
440
441 -- ----------------------------------------------------------------------------
442 -- |-----------------------------<get_internal_contact_name >--------------------------|
443 -- ----------------------------------------------------------------------------
444 -- {Start Of Comments}
445 --
446 -- Description:
447 -- This function is used by self service application to get the contact person name.
448 -- Prerequisites:
449 --
450 -- In Parameters:
451 --
452 -- Post Success:
453 --
454 --
455 -- Post Failure:
456 --
457 --
458 -- Developer Implementation Notes:
459 --
460 --
461 -- Access Status:
462 -- Internal Development Use Only.
463 --
464 -- {End Of Comments}
465 -- ----------------------------------------------------------------------------
466 Function get_internal_contact_name
467 ( Person_id IN per_all_people_f.person_id%TYPE) RETURN per_all_people_f.full_name%TYPE;
468
469
470 -- ----------------------------------------------------------------------------
471 -- |-----------------------------< check_changes >--------------------------|
472 -- ----------------------------------------------------------------------------
473 -- {Start Of Comments}
474 --
475 -- Description:
476 -- This procedure is used by self service application to find out whether in 'update'
477 -- mode any changes are made or not by comparing it with data from database.
478 -- Prerequisites:
479 --
480 -- In Parameters:
481 --
482 -- Post Success:
483 --
484 --
485 -- Post Failure:
486 --
487 --
488 -- Developer Implementation Notes:
489 --
490 --
491 -- Access Status:
492 -- Internal Development Use Only.
493 --
494 -- {End Of Comments}
495 -- ----------------------------------------------------------------------------
496
497 Procedure check_changes
498 (p_nota_history_id in NUMBER
499 ,p_contact_id in NUMBER DEFAULT hr_api.g_NUMBER
500 ,p_trng_title in VARCHAR2
501 ,p_provider in VARCHAR2
502 ,p_type in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
503 ,p_centre in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
504 ,p_completion_date in date
505 ,p_award in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
506 ,p_rating in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
507 ,p_duration in NUMBER DEFAULT hr_api.g_NUMBER
508 ,p_duration_units in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
509 ,p_activity_version_id in NUMBER DEFAULT hr_api.g_NUMBER
510 ,p_status in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
511 ,p_nth_information_category in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
512 ,p_nth_information1 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
513 ,p_nth_information2 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
514 ,p_nth_information3 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
515 ,p_nth_information4 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
516 ,p_nth_information5 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
517 ,p_nth_information6 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
518 ,p_nth_information7 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
519 ,p_nth_information8 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
520 ,p_nth_information9 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
521 ,p_nth_information10 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
522 ,p_nth_information11 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
523 ,p_nth_information12 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
524 ,p_nth_information13 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
525 ,p_nth_information14 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
526 ,p_nth_information15 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
527 ,p_nth_information16 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
528 ,p_nth_information17 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
529 ,p_nth_information18 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
530 ,p_nth_information19 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
531 ,p_nth_information20 in VARCHAR2 DEFAULT hr_api.g_VARCHAR2
532 ,p_result out nocopy NUMBER
533 );
534
535 Procedure chk_pending_approval
536 (p_nota_history_id in VARCHAR2
537 ,p_person_id in number );
538 -- ----------------------------------------------------------------------------
539 -- |-----------------------------< get_learner_name >--------------------------|
540 -- ----------------------------------------------------------------------------
541 -- {Start Of Comments}
542 -- Description:
543 -- This function is used by self service application to get the contact person name.
544 -- The above implementation assumes that the contact would be found in the
545 -- per_all_poople_f table. It is ignoring the possiblity of the contact being
546 -- that of a customer. This function considers that.
547 -- In Parameters:
548 -- Contact_Id - person_id/contact id of employee/customer
549 -- Organization_Id - this parameter is used to decide if the per_all_people_f
550 -- or the ra_contacts needs to be queried. If this is null, then the incoming
551 -- person_id belongs to a Customers' contact and ra_contacts is queried.
552 -- {End Of Comments}
553 -- ----------------------------------------------------------------------------
554 Function get_learner_name
555 ( Person_id IN ota_notrng_histories.contact_id%TYPE
556 ,Organization_id IN ota_notrng_histories.organization_id%TYPE ) RETURN VARCHAR2;
557
558
559 -- ----------------------------------------------------------------------------
560 -- |-----------------------------< get_custorg_name >--------------------------|
561 -- ----------------------------------------------------------------------------
562 -- {Start Of Comments}
563 -- Description:
564 -- This function is used by self service application to get the name of the
565 -- customer or the organization depending on the not null id.
566 -- In Parameters:
567 -- Customer_Id - customer_id of the Customer
568 -- {End Of Comments}
569 -- ----------------------------------------------------------------------------
570 FUNCTION get_custorg_name(p_customer_id OTA_NOTRNG_HISTORIES.CUSTOMER_ID%TYPE,
571 p_organization_id OTA_NOTRNG_HISTORIES.ORGANIZATION_ID%TYPE)
572 RETURN VARCHAR2;
573
574
575 END ota_add_training_ss ;