1 package OTA_ILEARNING2 AUTHID CURRENT_USER as
2 /* $Header: otilnprf.pkh 115.1 2002/11/26 12:47:24 arkashya noship $ */
3 /*
4 ===========================================================================
5 | Copyright (c) 1996 Oracle Corporation |
6 | All rights reserved. |
7 ===========================================================================
8 Name
9 General Oracle iLearning utilities
10 Purpose
11 To provide procedures/functions for iLearning integration
12 History
13 15-Jan-02 HDSHAH Created
14 26-Nov-02 ARKASHYA 2684733 Included the NOCOPY directive in the
15 115.1 OUT and IN OUT parameters.
16 */
17 --------------------------------------------------------------------------------
18 --
19 --
20 -- ----------------------------------------------------------------------------
21 -- |------------------------< update_history >----------------------------|
22 -- ----------------------------------------------------------------------------
23 --
24 -- PUBLIC
25 --
26 -- Description : Update History based on input data.
27 --
28 Procedure upd_history
29 (
30 p_person_id in number
31 ,p_rco_id in number
32 ,p_isroot in varchar2
33 ,p_status in varchar2
34 ,p_score in number
35 ,p_time in varchar2
36 ,p_complete in number
37 ,p_total in number
38 ,p_business_group_id in number
39 ,p_history_status out nocopy varchar2
40 ,p_message out nocopy varchar2
41 );
42
43
44
45
46 Procedure history_import
47 (
48 p_array in OTA_HISTORY_STRUCT_TAB
49 ,p_business_group_id in varchar2
50 );
51
52
53
54
55 end OTA_ILEARNING2;