1 PACKAGE OTA_OFFERING_SWI As
2 /* $Header: otoffswi.pkh 120.0.12000000.2 2007/02/06 15:22:47 vkkolla noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------------< create_offering >---------------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: ota_offering_api.create_offering
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_offering
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_business_group_id in number
30 ,p_name in varchar2
31 ,p_start_date in date
32 ,p_activity_version_id in number default null
33 ,p_end_date in date default null
34 ,p_owner_id in number default null
35 ,p_delivery_mode_id in number default null
36 ,p_language_id in number default null
37 ,p_duration in number default null
38 ,p_duration_units in varchar2 default null
39 ,p_learning_object_id in number default null
40 ,p_player_toolbar_flag in varchar2 default null
41 ,p_player_toolbar_bitset in number default null
42 ,p_player_new_window_flag in varchar2 default null
43 ,p_maximum_attendees in number default null
44 ,p_maximum_internal_attendees in number default null
45 ,p_minimum_attendees in number default null
46 ,p_actual_cost in number default null
47 ,p_budget_cost in number default null
48 ,p_budget_currency_code in varchar2 default null
49 ,p_price_basis in varchar2 default null
50 ,p_currency_code in varchar2 default null
51 ,p_standard_price in number default null
52 ,p_attribute_category in varchar2 default null
53 ,p_attribute1 in varchar2 default null
54 ,p_attribute2 in varchar2 default null
55 ,p_attribute3 in varchar2 default null
56 ,p_attribute4 in varchar2 default null
57 ,p_attribute5 in varchar2 default null
58 ,p_attribute6 in varchar2 default null
59 ,p_attribute7 in varchar2 default null
60 ,p_attribute8 in varchar2 default null
61 ,p_attribute9 in varchar2 default null
62 ,p_attribute10 in varchar2 default null
63 ,p_attribute11 in varchar2 default null
64 ,p_attribute12 in varchar2 default null
65 ,p_attribute13 in varchar2 default null
66 ,p_attribute14 in varchar2 default null
67 ,p_attribute15 in varchar2 default null
68 ,p_attribute16 in varchar2 default null
69 ,p_attribute17 in varchar2 default null
70 ,p_attribute18 in varchar2 default null
71 ,p_attribute19 in varchar2 default null
72 ,p_attribute20 in varchar2 default null
73 ,p_offering_id in number
74 ,p_object_version_number out nocopy number
75 ,p_return_status out nocopy varchar2
76 ,p_data_source in varchar2 default null
77 ,p_vendor_id in number default null
78 ,p_description in varchar2 default null
79 ,p_competency_update_level in varchar2 default null
80 ,p_language_code in varchar2 default null
81 );
82 -- ----------------------------------------------------------------------------
83 -- |----------------------------< delete_offering >---------------------------|
84 -- ----------------------------------------------------------------------------
85 -- {Start of comments}
86 --
87 -- Description:
88 -- This procedure is the self-service wrapper procedure to the following
89 -- API: ota_offering_api.delete_offering
90 --
91 -- Pre-requisites
92 -- All 'IN' parameters to this procedure have been appropriately derived.
93 --
94 -- Post Success:
95 -- p_return_status will return value indicating success.
96 --
97 -- Post Failure:
98 -- p_return_status will return value indication failure.
99 --
100 -- Access Status:
101 -- Internal Development use only.
102 --
103 -- {End of comments}
104 -- ----------------------------------------------------------------------------
105 PROCEDURE delete_offering
106 (p_validate in number default hr_api.g_false_num
107 ,p_offering_id in number
108 ,p_object_version_number in number
109 ,p_return_status out nocopy varchar2
110 );
111 -- ----------------------------------------------------------------------------
112 -- |----------------------------< update_offering >---------------------------|
113 -- ----------------------------------------------------------------------------
114 -- {Start of comments}
115 --
116 -- Description:
117 -- This procedure is the self-service wrapper procedure to the following
118 -- API: ota_offering_api.update_offering
119 --
120 -- Pre-requisites
121 -- All 'IN' parameters to this procedure have been appropriately derived.
122 --
123 -- Post Success:
124 -- p_return_status will return value indicating success.
125 --
126 -- Post Failure:
127 -- p_return_status will return value indication failure.
128 --
129 -- Access Status:
130 -- Internal Development use only.
131 --
132 -- {End of comments}
133 -- ----------------------------------------------------------------------------
134 PROCEDURE update_offering
135 (p_validate in number default hr_api.g_false_num
136 ,p_effective_date in date
137 ,p_offering_id in number
138 ,p_object_version_number in out nocopy number
139 ,p_business_group_id in number default hr_api.g_number
140 ,p_name in varchar2 default hr_api.g_varchar2
141 ,p_start_date in date default hr_api.g_date
142 ,p_activity_version_id in number default hr_api.g_number
143 ,p_end_date in date default hr_api.g_date
144 ,p_owner_id in number default hr_api.g_number
145 ,p_delivery_mode_id in number default hr_api.g_number
146 ,p_language_id in number default hr_api.g_number
147 ,p_duration in number default hr_api.g_number
148 ,p_duration_units in varchar2 default hr_api.g_varchar2
149 ,p_learning_object_id in number default hr_api.g_number
150 ,p_player_toolbar_flag in varchar2 default hr_api.g_varchar2
151 ,p_player_toolbar_bitset in number default hr_api.g_number
152 ,p_player_new_window_flag in varchar2 default hr_api.g_varchar2
153 ,p_maximum_attendees in number default hr_api.g_number
154 ,p_maximum_internal_attendees in number default hr_api.g_number
155 ,p_minimum_attendees in number default hr_api.g_number
156 ,p_actual_cost in number default hr_api.g_number
157 ,p_budget_cost in number default hr_api.g_number
158 ,p_budget_currency_code in varchar2 default hr_api.g_varchar2
159 ,p_price_basis in varchar2 default hr_api.g_varchar2
160 ,p_currency_code in varchar2 default hr_api.g_varchar2
161 ,p_standard_price in number default hr_api.g_number
162 ,p_attribute_category in varchar2 default hr_api.g_varchar2
163 ,p_attribute1 in varchar2 default hr_api.g_varchar2
164 ,p_attribute2 in varchar2 default hr_api.g_varchar2
165 ,p_attribute3 in varchar2 default hr_api.g_varchar2
166 ,p_attribute4 in varchar2 default hr_api.g_varchar2
167 ,p_attribute5 in varchar2 default hr_api.g_varchar2
168 ,p_attribute6 in varchar2 default hr_api.g_varchar2
169 ,p_attribute7 in varchar2 default hr_api.g_varchar2
170 ,p_attribute8 in varchar2 default hr_api.g_varchar2
171 ,p_attribute9 in varchar2 default hr_api.g_varchar2
172 ,p_attribute10 in varchar2 default hr_api.g_varchar2
173 ,p_attribute11 in varchar2 default hr_api.g_varchar2
174 ,p_attribute12 in varchar2 default hr_api.g_varchar2
175 ,p_attribute13 in varchar2 default hr_api.g_varchar2
176 ,p_attribute14 in varchar2 default hr_api.g_varchar2
177 ,p_attribute15 in varchar2 default hr_api.g_varchar2
178 ,p_attribute16 in varchar2 default hr_api.g_varchar2
179 ,p_attribute17 in varchar2 default hr_api.g_varchar2
180 ,p_attribute18 in varchar2 default hr_api.g_varchar2
181 ,p_attribute19 in varchar2 default hr_api.g_varchar2
182 ,p_attribute20 in varchar2 default hr_api.g_varchar2
183 ,p_return_status out nocopy varchar2
184 ,p_data_source in varchar2 default hr_api.g_varchar2
185 ,p_vendor_id in number default hr_api.g_number
186 ,p_description in varchar2 default hr_api.g_varchar2
187 ,p_competency_update_level in varchar2 default hr_api.g_varchar2
188 ,p_language_code in varchar2 default hr_api.g_varchar2
189 );
190 end ota_offering_swi;