DBA Data[Home] [Help]

PACKAGE: APPS.OTA_TRB_RKU

Source


1 Package ota_trb_rku as
2 /* $Header: ottrbrhi.pkh 120.3.12000000.1 2007/01/18 05:24:38 appldev noship $ */
3 --
4 -- ----------------------------------------------------------------------------
5 -- |----------------------------< after_update >------------------------------|
6 -- ----------------------------------------------------------------------------
7 --
8 procedure after_update
9   (p_effective_date               in date
10   ,p_resource_booking_id          in number
11   ,p_supplied_resource_id         in number
12   ,p_event_id                     in number
13   ,p_date_booking_placed          in date
14   ,p_object_version_number        in number
15   ,p_status                       in varchar2
16   ,p_absolute_price               in number
17   ,p_booking_person_id            in number
18   ,p_comments                     in varchar2
19   ,p_contact_name                 in varchar2
20   ,p_contact_phone_number         in varchar2
21   ,p_delegates_per_unit           in number
22   ,p_quantity                     in number
23   ,p_required_date_from           in date
24   ,p_required_date_to             in date
25   ,p_required_end_time            in varchar2
26   ,p_required_start_time          in varchar2
27   ,p_deliver_to                   in varchar2
28   ,p_primary_venue_flag           in varchar2
29   ,p_role_to_play                 in varchar2
30   ,p_trb_information_category     in varchar2
31   ,p_trb_information1             in varchar2
32   ,p_trb_information2             in varchar2
33   ,p_trb_information3             in varchar2
34   ,p_trb_information4             in varchar2
35   ,p_trb_information5             in varchar2
36   ,p_trb_information6             in varchar2
37   ,p_trb_information7             in varchar2
38   ,p_trb_information8             in varchar2
39   ,p_trb_information9             in varchar2
40   ,p_trb_information10            in varchar2
41   ,p_trb_information11            in varchar2
42   ,p_trb_information12            in varchar2
43   ,p_trb_information13            in varchar2
44   ,p_trb_information14            in varchar2
45   ,p_trb_information15            in varchar2
46   ,p_trb_information16            in varchar2
47   ,p_trb_information17            in varchar2
48   ,p_trb_information18            in varchar2
49   ,p_trb_information19            in varchar2
50   ,p_trb_information20            in varchar2
51   ,p_display_to_learner_flag      in     varchar2
52   ,p_book_entire_period_flag    in     varchar2
53 --  ,p_unbook_request_flag    in     varchar2
54   ,p_chat_id                      in number
55   ,p_forum_id                     in number
56   ,p_timezone_code                IN VARCHAR2
57   ,p_supplied_resource_id_o       in number
58   ,p_event_id_o                   in number
59   ,p_date_booking_placed_o        in date
60   ,p_object_version_number_o      in number
61   ,p_status_o                     in varchar2
62   ,p_absolute_price_o             in number
63   ,p_booking_person_id_o          in number
64   ,p_comments_o                   in varchar2
65   ,p_contact_name_o               in varchar2
66   ,p_contact_phone_number_o       in varchar2
67   ,p_delegates_per_unit_o         in number
68   ,p_quantity_o                   in number
69   ,p_required_date_from_o         in date
70   ,p_required_date_to_o           in date
71   ,p_required_end_time_o          in varchar2
72   ,p_required_start_time_o        in varchar2
73   ,p_deliver_to_o                 in varchar2
74   ,p_primary_venue_flag_o         in varchar2
75   ,p_role_to_play_o               in varchar2
76   ,p_trb_information_category_o   in varchar2
77   ,p_trb_information1_o           in varchar2
78   ,p_trb_information2_o           in varchar2
79   ,p_trb_information3_o           in varchar2
80   ,p_trb_information4_o           in varchar2
81   ,p_trb_information5_o           in varchar2
82   ,p_trb_information6_o           in varchar2
83   ,p_trb_information7_o           in varchar2
84   ,p_trb_information8_o           in varchar2
85   ,p_trb_information9_o           in varchar2
86   ,p_trb_information10_o          in varchar2
87   ,p_trb_information11_o          in varchar2
88   ,p_trb_information12_o          in varchar2
89   ,p_trb_information13_o          in varchar2
90   ,p_trb_information14_o          in varchar2
91   ,p_trb_information15_o          in varchar2
92   ,p_trb_information16_o          in varchar2
93   ,p_trb_information17_o          in varchar2
94   ,p_trb_information18_o          in varchar2
95   ,p_trb_information19_o          in varchar2
96   ,p_trb_information20_o          in varchar2
97   ,p_display_to_learner_flag_o      in     varchar2
98   ,p_book_entire_period_flag_o    in     varchar2
99 --  ,p_unbook_request_flag_o    in     varchar2
100   ,p_chat_id_o                    in number
101   ,p_forum_id_o                   in number
102   ,p_timezone_code_o              IN VARCHAR2
103   );
104 --
105 end ota_trb_rku;