1 PACKAGE pqp_riw_class_wrapper As
2 /* $Header: pqpriwclwr.pkh 120.0.12010000.3 2008/12/04 10:50:29 psengupt noship $ */
3
4 -- =============================================================================
5 -- InsUpd_Class: This procedure is called by the web-adi spreadsheet
6 -- to create a Class in Oracle Learning Management from data
7 -- entered in the spreadsheet.
8 -- =============================================================================
9 PROCEDURE InsUpd_Class
10 (p_effective_date in date default sysdate
11 ,p_event_id in number default null
12 ,p_vendor_id in number default null
13 ,p_activity_version_id in number default null
14 ,p_dummy_col_offering in varchar2
15 ,p_parent_offering_id in number
16 ,p_business_group_id in number
17 ,p_organization_id in number default null
18 ,p_event_type in varchar2
19 ,p_object_version_number in number
20 ,p_title in varchar2
21 ,p_budget_cost in number default null
22 ,p_actual_cost in number default null
23 ,p_budget_currency_code in varchar2 default null
24 ,p_centre in varchar2 default null
25 ,p_comments in varchar2 default null
26 ,p_course_end_date in date default null
27 ,p_course_end_time in varchar2 default null
28 ,p_course_start_date in date default null
29 ,p_course_start_time in varchar2 default null
30 ,p_duration in number default null
31 ,p_duration_units in varchar2 default null
32 ,p_enrolment_end_date in date default null
33 ,p_enrolment_start_date in date default null
34 ,p_language_id in number default null
35 ,p_user_status in varchar2 default null
36 ,p_development_event_type in varchar2 default null
37 ,p_event_status in varchar2 default null
38 ,p_price_basis in varchar2 default null
39 ,p_currency_code in varchar2 default null
40 ,p_maximum_attendees in number default null
41 ,p_maximum_internal_attendees in number default null
42 ,p_minimum_attendees in number default null
43 ,p_standard_price in number default null
44 ,p_category_code in varchar2 default null
45 ,p_parent_event_id in number default null
46 ,p_book_independent_flag in varchar2 default null
47 ,p_public_event_flag in varchar2 default null
48 ,p_secure_event_flag in varchar2 default null
49 ,p_evt_information_category in varchar2 default null
50 ,p_evt_information1 in varchar2 default null
51 ,p_evt_information2 in varchar2 default null
52 ,p_evt_information3 in varchar2 default null
53 ,p_evt_information4 in varchar2 default null
54 ,p_evt_information5 in varchar2 default null
55 ,p_evt_information6 in varchar2 default null
56 ,p_evt_information7 in varchar2 default null
57 ,p_evt_information8 in varchar2 default null
58 ,p_evt_information9 in varchar2 default null
59 ,p_evt_information10 in varchar2 default null
60 ,p_evt_information11 in varchar2 default null
61 ,p_evt_information12 in varchar2 default null
62 ,p_evt_information13 in varchar2 default null
63 ,p_evt_information14 in varchar2 default null
64 ,p_evt_information15 in varchar2 default null
65 ,p_evt_information16 in varchar2 default null
66 ,p_evt_information17 in varchar2 default null
67 ,p_evt_information18 in varchar2 default null
68 ,p_evt_information19 in varchar2 default null
69 ,p_evt_information20 in varchar2 default null
70 ,p_project_id in number default null
71 ,p_owner_id in number default null
72 ,p_line_id in number default null
73 ,p_org_id in number default null
74 ,p_training_center_id in number default null
75 ,p_location_id in number default null
76 ,p_offering_id in number default null
77 ,p_timezone in varchar2 default null
78 ,p_validate in number default hr_api.g_false_num
79 ,p_return_status out nocopy varchar2
80 ,p_data_source in varchar2 default null
81 ,P_CRT_UPD in varchar2 default null
82 ) ;
83 end pqp_riw_class_wrapper;