1 package OTA_ILEARNING AUTHID CURRENT_USER as
2 /* $Header: otilncnt.pkh 115.5 2002/11/26 12:17:30 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 04 Sep 01 115.0 HDSHAH Created
14 16 Jan 02 115.1 HDSHAH 2157271 Parameter Name changed back to p_activity_definition_name
15 from p_activity_id.
16 15 Feb 02 115.2 HDSHAH 2209467 changed p_start_date and p_end_date parameter as varchar2 in
17 crt_or_chk_xml_prcs_tbl and upd_xml_prcs_tbl procedure.
18 26 NOV 02 115.3 arkashya 2684733 Included the NOCOPY directive in OUT and IN OUT parameters
19 of the procedures.
20 */
21 --------------------------------------------------------------------------------
22 --
23 --
24 -- ----------------------------------------------------------------------------
25 -- |------------------------< create_or_update_activity_version >----------------------------|
26 -- ----------------------------------------------------------------------------
27 --
28 -- PUBLIC
29 --
30 -- Description : Create or update activity version based on input data.
31 --
32 Procedure crt_or_upd_activity
33 (
34 p_update in varchar2 default NULL
35 ,p_rco_id in number
36 ,p_language_code in varchar2
37 ,p_activity_version_name in varchar2
38 ,p_description in varchar2
39 ,p_objectives in varchar2
40 ,p_audience in varchar2
41 ,p_business_group_id in number
42 ,p_activity_definition_name in varchar2
43 ,p_activity_version_id out nocopy number
44 ,p_language_id out nocopy number
45 ,p_status out nocopy varchar2
46 ,p_message out nocopy varchar2
47 );
48
49 --
50 --
51 -- ----------------------------------------------------------------------------
52 -- |------------------------< create_or_update_event >----------------------------|
53 -- ----------------------------------------------------------------------------
54 --
55 -- PUBLIC
56 --
57 -- Description : Create or update events based on input data.
58 --
59
60 Procedure crt_or_upd_event
61 (
62 p_transaction in number default NULL
63 ,p_offering_title in varchar2
64 ,p_offering_id in number
65 ,p_offering_start_date in date
66 ,p_offering_end_date in date
67 ,p_offering_timezone in varchar2
68 ,p_enrollment_start_date in date
69 ,p_enrollment_end_date in date
70 ,p_offering_max_attendees in number
71 ,p_offering_type in varchar2
72 ,p_offering_ispublished in varchar2
73 ,p_language_id in number
74 ,p_activity_version_id in number
75 ,p_business_group_id in number
76 ,p_status out nocopy varchar2
77 ,p_message out nocopy varchar2
78 );
79
80 Procedure offering_rco_import
81 (
82 p_array in OTA_OFFERING_STRUCT_TAB
83 ,p_business_group_id in varchar2
84 ,p_activity_definition_name in varchar2
85 ,p_status out nocopy varchar2
86 );
87
88 Procedure rco_import
89 (
90 p_array in OTA_RCO_STRUCT_TAB
91 ,p_business_group_id in varchar2
92 ,p_activity_definition_name in varchar2
93 );
94
95 --Bug#2209467 p_start_date and p_end_date parameter changed to varchar2.
96 procedure crt_or_chk_xml_prcs_tbl (
97 p_site_id in varchar2
98 ,p_business_group_id in varchar2
99 ,p_process_name in varchar2
100 -- ,p_start_date in date
101 -- ,p_end_date in date
102 ,p_start_date in varchar2
103 ,p_end_date in varchar2
104 ,p_status out nocopy varchar2
105 ,p_process_type out nocopy varchar2
106 );
107
108
109 --Bug#2209467 p_start_date and p_end_date parameter changed to varchar2.
110 procedure upd_xml_prcs_tbl (
111 p_site_id in varchar2
112 ,p_business_group_id in varchar2
113 ,p_process_name in varchar2
114 -- ,p_start_date in date
115 -- ,p_end_date in date
116 ,p_start_date in varchar2
117 ,p_end_date in varchar2
118 ,p_status out nocopy varchar2
119 );
120
121
122 end OTA_ILEARNING;