1 PACKAGE pqp_riw_offering_wrapper AUTHID CURRENT_USER As
2 /* $Header: pqpriwofwr.pkh 120.0.12010000.3 2008/12/04 10:55:15 psengupt noship $ */
3
4 -- =============================================================================
5 -- InsUpd_Offering: This procedure is called by the web-adi spreadsheet
6 -- to create an Offering in Oracle Learning Management from data
7 -- entered in the spreadsheet.
8 -- =============================================================================
9 PROCEDURE InsUpd_Offering
10 (p_validate in number default hr_api.g_false_num
11 ,p_effective_date in date
12 ,p_business_group_id in number
13 ,p_name in varchar2
14 ,p_start_date in date
15 ,p_activity_version_id in number default null
16 ,p_end_date in date default null
17 ,p_owner_id in number default null
18 ,p_delivery_mode_id in number default null
19 ,p_language_id in number default null
20 ,p_duration in number default null
21 ,p_duration_units in varchar2 default null
22 ,p_learning_object_id in number default null
23 ,p_player_toolbar_flag in varchar2 default null
24 ,p_player_exit_flag in varchar2 default null
25 ,p_player_next_flag in varchar2 default null
26 ,p_player_previous_flag in varchar2 default null
27 ,p_player_outline_flag in varchar2 default null
28 ,p_player_new_window_flag in varchar2 default null
29 ,p_maximum_attendees in number default null
30 ,p_maximum_internal_attendees in number default null
31 ,p_minimum_attendees in number default null
32 ,p_actual_cost in number default null
33 ,p_budget_cost in number default null
34 ,p_budget_currency_code in varchar2 default null
35 ,p_price_basis in varchar2 default null
36 ,p_currency_code in varchar2 default null
37 ,p_standard_price in number default null
38 ,p_attribute_category in varchar2 default null
39 ,p_attribute1 in varchar2 default null
40 ,p_attribute2 in varchar2 default null
41 ,p_attribute3 in varchar2 default null
42 ,p_attribute4 in varchar2 default null
43 ,p_attribute5 in varchar2 default null
44 ,p_attribute6 in varchar2 default null
45 ,p_attribute7 in varchar2 default null
46 ,p_attribute8 in varchar2 default null
47 ,p_attribute9 in varchar2 default null
48 ,p_attribute10 in varchar2 default null
49 ,p_attribute11 in varchar2 default null
50 ,p_attribute12 in varchar2 default null
51 ,p_attribute13 in varchar2 default null
52 ,p_attribute14 in varchar2 default null
53 ,p_attribute15 in varchar2 default null
54 ,p_attribute16 in varchar2 default null
55 ,p_attribute17 in varchar2 default null
56 ,p_attribute18 in varchar2 default null
57 ,p_attribute19 in varchar2 default null
58 ,p_attribute20 in varchar2 default null
59 ,p_offering_id in number default null
60 ,p_object_version_number in number
61 ,p_return_status out nocopy varchar2
62 ,p_data_source in varchar2 default null
63 ,p_vendor_id in number default null
64 ,p_description in varchar2 default null
65 ,p_competency_update_level in varchar2 default null
66 ,p_language_code in varchar2 default null
67 ,P_CRT_UPD in varchar2 default null
68 );
69
70 end pqp_riw_offering_wrapper;
71
72