4 Procedure ins
1 package ota_resource_booking AUTHID CURRENT_USER as
2 /* $Header: ottrb03t.pkh 120.2 2006/03/15 02:24:16 niarora noship $ */
3 --
5 (
6 p_resource_booking_id out nocopy number,
7 p_supplied_resource_id in number,
8 p_event_id in number default null,
9 p_date_booking_placed in date,
10 p_object_version_number out nocopy number,
11 p_status in varchar2,
12 p_absolute_price in number default null,
13 p_booking_person_id in number default null,
14 p_comments in varchar2 default null,
15 p_contact_name in varchar2 default null,
16 p_contact_phone_number in varchar2 default null,
17 p_delegates_per_unit in number default null,
18 p_quantity in number default null,
19 p_required_date_from in date default null,
20 p_required_date_to in date default null,
21 p_required_end_time in varchar2 default null,
22 p_required_start_time in varchar2 default null,
23 p_deliver_to in varchar2 default null,
24 p_primary_venue_flag in varchar2 default null,
25 p_role_to_play in varchar2 default null,
26 p_trb_information_category in varchar2 default null,
27 p_trb_information1 in varchar2 default null,
28 p_trb_information2 in varchar2 default null,
29 p_trb_information3 in varchar2 default null,
30 p_trb_information4 in varchar2 default null,
31 p_trb_information5 in varchar2 default null,
32 p_trb_information6 in varchar2 default null,
33 p_trb_information7 in varchar2 default null,
34 p_trb_information8 in varchar2 default null,
35 p_trb_information9 in varchar2 default null,
36 p_trb_information10 in varchar2 default null,
37 p_trb_information11 in varchar2 default null,
38 p_trb_information12 in varchar2 default null,
39 p_trb_information13 in varchar2 default null,
40 p_trb_information14 in varchar2 default null,
41 p_trb_information15 in varchar2 default null,
42 p_trb_information16 in varchar2 default null,
43 p_trb_information17 in varchar2 default null,
44 p_trb_information18 in varchar2 default null,
45 p_trb_information19 in varchar2 default null,
46 p_trb_information20 in varchar2 default null,
47 p_finance_header_id in number default null,
48 p_currency_code in varchar2 default null,
49 p_money_amount in number default null,
50 p_finance_line_id out nocopy number,
51 p_finance_line_ovn out nocopy number,
52 p_display_to_learner_flag in varchar2 default null,
53 p_book_entire_period_flag in varchar2 default null,
54 p_chat_id in number default null,
55 p_forum_id in number default null,
56 p_timezone_code in varchar2 default null
57 );
58 --
59 Procedure upd
60 (
61 p_resource_booking_id in number,
62 p_supplied_resource_id in number,
63 p_event_id in number default null,
64 p_date_booking_placed in date,
65 p_object_version_number in out nocopy number,
66 p_status in varchar2,
67 p_absolute_price in number default null,
68 p_booking_person_id in number default null,
69 p_comments in varchar2 default null,
70 p_contact_name in varchar2 default null,
71 p_contact_phone_number in varchar2 default null,
72 p_delegates_per_unit in number default null,
73 p_quantity in number default null,
74 p_required_date_from in date default null,
75 p_required_date_to in date default null,
76 p_required_end_time in varchar2 default null,
77 p_required_start_time in varchar2 default null,
78 p_deliver_to in varchar2 default null,
79 p_primary_venue_flag in varchar2 default null,
80 p_role_to_play in varchar2 default null,
81 p_trb_information_category in varchar2 default null,
82 p_trb_information1 in varchar2 default null,
83 p_trb_information2 in varchar2 default null,
84 p_trb_information3 in varchar2 default null,
85 p_trb_information4 in varchar2 default null,
86 p_trb_information5 in varchar2 default null,
87 p_trb_information6 in varchar2 default null,
88 p_trb_information7 in varchar2 default null,
89 p_trb_information8 in varchar2 default null,
90 p_trb_information9 in varchar2 default null,
91 p_trb_information10 in varchar2 default null,
92 p_trb_information11 in varchar2 default null,
93 p_trb_information12 in varchar2 default null,
94 p_trb_information13 in varchar2 default null,
95 p_trb_information14 in varchar2 default null,
96 p_trb_information15 in varchar2 default null,
97 p_trb_information16 in varchar2 default null,
98 p_trb_information17 in varchar2 default null,
99 p_trb_information18 in varchar2 default null,
100 p_trb_information19 in varchar2 default null,
101 p_trb_information20 in varchar2 default null,
102 p_finance_header_id in number default null,
103 p_currency_code in varchar2 default null,
104 p_money_amount in number default null,
105 p_finance_line_id in out nocopy number,
106 p_finance_line_transfer in varchar2 default null,
107 p_finance_line_ovn in out nocopy number,
108 p_cancel_finance_line in varchar2 default null,
109 p_finance_change_flag in varchar2 default 'N',
110 p_display_to_learner_flag in varchar2 default hr_api.g_varchar2,
111 p_book_entire_period_flag in varchar2 default hr_api.g_varchar2,
112 p_chat_id in number default null,
113 p_forum_id in number default null,
114 p_timezone_code in varchar2 default hr_api.g_varchar2
115 );
116 --
117 end ota_resource_booking;
[Home] [Help]