DBA Data[Home] [Help]

PACKAGE: APPS.OTA_OFFERING_SWI

Source


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;