1 PACKAGE pqp_riw_enroll_wrapper As
2 /* $Header: pqpriwenwr.pkh 120.0.12010000.3 2008/12/04 12:58:35 psengupt noship $ */
3
4 -- =============================================================================
5 -- InsUpd_Enroll: This procedure is called by the web-adi spreadsheet
6 -- to create/update an Enrollment in Oracle Learning Management
7 -- from data entered in the spreadsheet or downloaded from an external XML
8 -- =============================================================================
9 procedure InsUpd_Enroll
10 ( p_effective_date in date default null
11 ,p_booking_id in number default null
12 ,p_booking_status_type_id in number
13 ,p_delegate_person_id in number default null
14 ,p_contact_id in number default null
15 ,p_business_group_id in number
16 ,p_event_id in number
17 ,p_customer_id in number default null
18 ,p_authorizer_person_id in number default null
19 ,p_date_booking_placed in date
20 ,p_corespondent in varchar2 default null
21 ,p_internal_booking_flag in varchar2
22 ,p_number_of_places in number
23 ,p_object_version_number in number
24 ,p_administrator in number default null
25 ,p_booking_priority in varchar2 default null
26 ,p_comments in varchar2 default null
27 ,p_contact_address_id in number default null
28 ,p_delegate_contact_phone in varchar2 default null
29 ,p_delegate_contact_fax in varchar2 default null
30 ,p_third_party_customer_id in number default null
31 ,p_third_party_contact_id in number default null
32 ,p_third_party_address_id in number default null
33 ,p_third_party_contact_phone in varchar2 default null
34 ,p_third_party_contact_fax in varchar2 default null
35 ,p_date_status_changed in date default null
36 ,p_failure_reason in varchar2 default null
37 ,p_attendance_result in varchar2 default null
38 ,p_language_id in number default null
39 ,p_source_of_booking in varchar2 default null
40 ,p_special_booking_instructions in varchar2 default null
41 ,p_successful_attendance_flag in varchar2 default null
42 ,p_tdb_information_category in varchar2 default null
43 ,p_tdb_information1 in varchar2 default null
44 ,p_tdb_information2 in varchar2 default null
45 ,p_tdb_information3 in varchar2 default null
46 ,p_tdb_information4 in varchar2 default null
47 ,p_tdb_information5 in varchar2 default null
48 ,p_tdb_information6 in varchar2 default null
49 ,p_tdb_information7 in varchar2 default null
50 ,p_tdb_information8 in varchar2 default null
51 ,p_tdb_information9 in varchar2 default null
52 ,p_tdb_information10 in varchar2 default null
53 ,p_tdb_information11 in varchar2 default null
54 ,p_tdb_information12 in varchar2 default null
55 ,p_tdb_information13 in varchar2 default null
56 ,p_tdb_information14 in varchar2 default null
57 ,p_tdb_information15 in varchar2 default null
58 ,p_tdb_information16 in varchar2 default null
59 ,p_tdb_information17 in varchar2 default null
60 ,p_tdb_information18 in varchar2 default null
61 ,p_tdb_information19 in varchar2 default null
62 ,p_tdb_information20 in varchar2 default null
63 ,p_create_finance_line in varchar2 default null
64 ,p_finance_header_id in number default null
65 ,p_currency_code in varchar2 default null
66 ,p_standard_amount in number default null
67 ,p_unitary_amount in number default null
68 ,p_money_amount in number default null
69 ,p_booking_deal_id in number default null
70 ,p_booking_deal_type in varchar2 default null
71 ,p_finance_line_id in out nocopy number
72 ,p_enrollment_type in varchar2 default null
73 ,p_validate in number default hr_api.g_false_num
74 ,p_organization_id in number default null
75 ,p_sponsor_person_id in number default null
76 ,p_sponsor_assignment_id in number default null
77 ,p_person_address_id in number default null
78 ,p_delegate_assignment_id in number default null
79 ,p_delegate_contact_id in number default null
80 ,p_delegate_contact_email in varchar2 default null
81 ,p_third_party_email in varchar2 default null
82 ,p_person_address_type in varchar2 default null
83 ,p_line_id in number default null
84 ,p_org_id in number default null
85 ,p_daemon_flag in varchar2 default null
86 ,p_daemon_type in varchar2 default null
87 ,p_old_event_id in number default null
88 ,p_quote_line_id in number default null
89 ,p_interface_source in varchar2 default null
90 ,p_total_training_time in varchar2 default null
91 ,p_content_player_status in varchar2 default null
92 ,p_score in number default null
93 ,p_completed_content in number default null
94 ,p_total_content in number default null
95 ,p_return_status out nocopy varchar2
96 ,p_booking_justification_id in number default null
97 ,p_is_history_flag in varchar2 default 'N'
98 ,p_override_prerequisites in varchar2 default null
99 ,p_override_learner_access in varchar2 default null
100 ,P_CRT_UPD in varchar2 default null
101 ,p_status_change_comments in varchar2 default hr_api.g_varchar2
102 ,p_update_finance_line in varchar2 default hr_api.g_varchar2
103 ,p_tfl_object_version_number in number default null
104 ) ;
105
106 -- =============================================================================
107 -- create_delegate_booking: This procedure is called by the web-adi spreadsheet
108 -- to create an Enrollemnt in Oracle Learning Management from data
109 -- entered in the spreadsheet or downloaded from an external XML.
110 -- =============================================================================
111
112 PROCEDURE create_delegate_booking
113 (p_effective_date in date default null
114 ,p_booking_id in number
115 ,p_booking_status_type_id in number
116 ,p_delegate_person_id in number default null
117 ,p_contact_id in number
118 ,p_business_group_id in number
119 ,p_event_id in number
120 ,p_customer_id in number default null
121 ,p_authorizer_person_id in number default null
122 ,p_date_booking_placed in date
123 ,p_corespondent in varchar2 default null
124 ,p_internal_booking_flag in varchar2
125 ,p_number_of_places in number
126 ,p_object_version_number out nocopy number
127 ,p_administrator in number default null
128 ,p_booking_priority in varchar2 default null
129 ,p_comments in varchar2 default null
130 ,p_contact_address_id in number default null
131 ,p_delegate_contact_phone in varchar2 default null
132 ,p_delegate_contact_fax in varchar2 default null
133 ,p_third_party_customer_id in number default null
134 ,p_third_party_contact_id in number default null
135 ,p_third_party_address_id in number default null
136 ,p_third_party_contact_phone in varchar2 default null
137 ,p_third_party_contact_fax in varchar2 default null
138 ,p_date_status_changed in date default null
139 ,p_failure_reason in varchar2 default null
140 ,p_attendance_result in varchar2 default null
141 ,p_language_id in number default null
142 ,p_source_of_booking in varchar2 default null
143 ,p_special_booking_instructions in varchar2 default null
144 ,p_successful_attendance_flag in varchar2 default null
145 ,p_tdb_information_category in varchar2 default null
146 ,p_tdb_information1 in varchar2 default null
147 ,p_tdb_information2 in varchar2 default null
148 ,p_tdb_information3 in varchar2 default null
149 ,p_tdb_information4 in varchar2 default null
150 ,p_tdb_information5 in varchar2 default null
151 ,p_tdb_information6 in varchar2 default null
152 ,p_tdb_information7 in varchar2 default null
153 ,p_tdb_information8 in varchar2 default null
154 ,p_tdb_information9 in varchar2 default null
155 ,p_tdb_information10 in varchar2 default null
156 ,p_tdb_information11 in varchar2 default null
157 ,p_tdb_information12 in varchar2 default null
158 ,p_tdb_information13 in varchar2 default null
159 ,p_tdb_information14 in varchar2 default null
160 ,p_tdb_information15 in varchar2 default null
161 ,p_tdb_information16 in varchar2 default null
162 ,p_tdb_information17 in varchar2 default null
163 ,p_tdb_information18 in varchar2 default null
164 ,p_tdb_information19 in varchar2 default null
165 ,p_tdb_information20 in varchar2 default null
166 ,p_create_finance_line in varchar2 default null
167 ,p_finance_header_id in number default null
168 ,p_currency_code in varchar2 default null
169 ,p_standard_amount in number default null
170 ,p_unitary_amount in number default null
171 ,p_money_amount in number default null
172 ,p_booking_deal_id in number default null
173 ,p_booking_deal_type in varchar2 default null
174 ,p_finance_line_id in out nocopy number
175 ,p_enrollment_type in varchar2 default null
176 ,p_validate in number default hr_api.g_false_num
177 ,p_organization_id in number default null
178 ,p_sponsor_person_id in number default null
179 ,p_sponsor_assignment_id in number default null
180 ,p_person_address_id in number default null
181 ,p_delegate_assignment_id in number default null
182 ,p_delegate_contact_id in number default null
183 ,p_delegate_contact_email in varchar2 default null
184 ,p_third_party_email in varchar2 default null
185 ,p_person_address_type in varchar2 default null
186 ,p_line_id in number default null
187 ,p_org_id in number default null
188 ,p_daemon_flag in varchar2 default null
189 ,p_daemon_type in varchar2 default null
190 ,p_old_event_id in number default null
191 ,p_quote_line_id in number default null
192 ,p_interface_source in varchar2 default null
193 ,p_total_training_time in varchar2 default null
194 ,p_content_player_status in varchar2 default null
195 ,p_score in number default null
196 ,p_completed_content in number default null
197 ,p_total_content in number default null
198 ,p_return_status out nocopy varchar2
199 ,p_booking_justification_id in number default null
200 ,p_is_history_flag in varchar2 default 'N'
201 ,p_override_prerequisites in varchar2 default null
202 ,p_override_learner_access in varchar2
203 );
204
205 -- =============================================================================
206 -- update_delegate_booking: This procedure is called by the web-adi spreadsheet
207 -- to update an Enrollemnt in Oracle Learning Management from data
208 -- entered in the spreadsheet or downloaded from an external XML.
209 -- =============================================================================
210
211 PROCEDURE update_delegate_booking
212 (p_effective_date in date default null
213 ,p_booking_id in number
214 ,p_booking_status_type_id in number default hr_api.g_number
215 ,p_delegate_person_id in number default hr_api.g_number
216 ,p_contact_id in number default hr_api.g_number
217 ,p_business_group_id in number default hr_api.g_number
218 ,p_event_id in number default hr_api.g_number
219 ,p_customer_id in number default hr_api.g_number
220 ,p_authorizer_person_id in number default hr_api.g_number
221 ,p_date_booking_placed in date default hr_api.g_date
222 ,p_corespondent in varchar2 default hr_api.g_varchar2
223 ,p_internal_booking_flag in varchar2 default hr_api.g_varchar2
224 ,p_number_of_places in number default hr_api.g_number
225 ,p_object_version_number in out nocopy number
226 ,p_administrator in number default hr_api.g_number
227 ,p_booking_priority in varchar2 default hr_api.g_varchar2
228 ,p_comments in varchar2 default hr_api.g_varchar2
229 ,p_contact_address_id in number default hr_api.g_number
230 ,p_delegate_contact_phone in varchar2 default hr_api.g_varchar2
231 ,p_delegate_contact_fax in varchar2 default hr_api.g_varchar2
232 ,p_third_party_customer_id in number default hr_api.g_number
233 ,p_third_party_contact_id in number default hr_api.g_number
234 ,p_third_party_address_id in number default hr_api.g_number
235 ,p_third_party_contact_phone in varchar2 default hr_api.g_varchar2
236 ,p_third_party_contact_fax in varchar2 default hr_api.g_varchar2
237 ,p_date_status_changed in date default hr_api.g_date
238 ,p_status_change_comments in varchar2 default hr_api.g_varchar2
239 ,p_failure_reason in varchar2 default hr_api.g_varchar2
240 ,p_attendance_result in varchar2 default hr_api.g_varchar2
241 ,p_language_id in number default hr_api.g_number
242 ,p_source_of_booking in varchar2 default hr_api.g_varchar2
243 ,p_special_booking_instructions in varchar2 default hr_api.g_varchar2
244 ,p_successful_attendance_flag in varchar2 default hr_api.g_varchar2
245 ,p_tdb_information_category in varchar2 default hr_api.g_varchar2
246 ,p_tdb_information1 in varchar2 default hr_api.g_varchar2
247 ,p_tdb_information2 in varchar2 default hr_api.g_varchar2
248 ,p_tdb_information3 in varchar2 default hr_api.g_varchar2
249 ,p_tdb_information4 in varchar2 default hr_api.g_varchar2
250 ,p_tdb_information5 in varchar2 default hr_api.g_varchar2
251 ,p_tdb_information6 in varchar2 default hr_api.g_varchar2
252 ,p_tdb_information7 in varchar2 default hr_api.g_varchar2
253 ,p_tdb_information8 in varchar2 default hr_api.g_varchar2
254 ,p_tdb_information9 in varchar2 default hr_api.g_varchar2
255 ,p_tdb_information10 in varchar2 default hr_api.g_varchar2
256 ,p_tdb_information11 in varchar2 default hr_api.g_varchar2
257 ,p_tdb_information12 in varchar2 default hr_api.g_varchar2
258 ,p_tdb_information13 in varchar2 default hr_api.g_varchar2
259 ,p_tdb_information14 in varchar2 default hr_api.g_varchar2
260 ,p_tdb_information15 in varchar2 default hr_api.g_varchar2
261 ,p_tdb_information16 in varchar2 default hr_api.g_varchar2
262 ,p_tdb_information17 in varchar2 default hr_api.g_varchar2
263 ,p_tdb_information18 in varchar2 default hr_api.g_varchar2
264 ,p_tdb_information19 in varchar2 default hr_api.g_varchar2
265 ,p_tdb_information20 in varchar2 default hr_api.g_varchar2
266 ,p_update_finance_line in varchar2 default hr_api.g_varchar2
267 ,p_tfl_object_version_number in out nocopy number
268 ,p_finance_header_id in number default hr_api.g_number
269 ,p_finance_line_id in out nocopy number
270 ,p_standard_amount in number default hr_api.g_number
271 ,p_unitary_amount in number default hr_api.g_number
272 ,p_money_amount in number default hr_api.g_number
273 ,p_currency_code in varchar2 default hr_api.g_varchar2
274 ,p_booking_deal_type in varchar2 default hr_api.g_varchar2
275 ,p_booking_deal_id in number default hr_api.g_number
276 ,p_enrollment_type in varchar2 default hr_api.g_varchar2
277 ,p_validate in number default hr_api.g_false_num
278 ,p_organization_id in number default hr_api.g_number
279 ,p_sponsor_person_id in number default hr_api.g_number
280 ,p_sponsor_assignment_id in number default hr_api.g_number
281 ,p_person_address_id in number default hr_api.g_number
282 ,p_delegate_assignment_id in number default hr_api.g_number
283 ,p_delegate_contact_id in number default hr_api.g_number
284 ,p_delegate_contact_email in varchar2 default hr_api.g_varchar2
285 ,p_third_party_email in varchar2 default hr_api.g_varchar2
286 ,p_person_address_type in varchar2 default hr_api.g_varchar2
287 ,p_line_id in number default hr_api.g_number
288 ,p_org_id in number default hr_api.g_number
289 ,p_daemon_flag in varchar2 default hr_api.g_varchar2
290 ,p_daemon_type in varchar2 default hr_api.g_varchar2
291 ,p_old_event_id in number default hr_api.g_number
292 ,p_quote_line_id in number default hr_api.g_number
293 ,p_interface_source in varchar2 default hr_api.g_varchar2
294 ,p_total_training_time in varchar2 default hr_api.g_varchar2
295 ,p_content_player_status in varchar2 default hr_api.g_varchar2
296 ,p_score in number default hr_api.g_number
297 ,p_completed_content in number default hr_api.g_number
298 ,p_total_content in number default hr_api.g_number
299 ,p_return_status out nocopy varchar2
300 ,p_booking_justification_id in number default hr_api.g_number
301 ,p_is_history_flag in varchar2 default hr_api.g_varchar2
302 ,p_override_prerequisites in varchar2
303 ,p_override_learner_access in varchar2
304 );
305 end pqp_riw_enroll_wrapper;