[Home] [Help]
PACKAGE: APPS.OTA_BOOKING_STATUS_TYPE_SWI
Source
1 Package ota_booking_status_type_swi As
2 /* $Header: otbstswi.pkh 120.0 2005/05/29 07:05 appldev noship $ */
3 -- ----------------------------------------------------------------------------
4 -- |----------------------< create_booking_status_type >----------------------|
5 -- ----------------------------------------------------------------------------
6 -- {Start of comments}
7 --
8 -- Description:
9 -- This procedure is the self-service wrapper procedure to the following
10 -- API: ota_booking_status_type_api.create_booking_status_type
11 --
12 -- Pre-requisites
13 -- All 'IN' parameters to this procedure have been appropriately derived.
14 --
15 -- Post Success:
16 -- p_return_status will return value indicating success.
17 --
18 -- Post Failure:
19 -- p_return_status will return value indication failure.
20 --
21 -- Access Status:
22 -- Internal Development use only.
23 --
24 -- {End of comments}
25 -- ----------------------------------------------------------------------------
26 PROCEDURE create_booking_status_type
27 (p_validate in number default hr_api.g_false_num
28 ,p_effective_date in date
29 ,p_business_group_id in number
30 ,p_active_flag in varchar2 default null
31 ,p_default_flag in varchar2 default null
32 ,p_name in varchar2 default null
33 ,p_type in varchar2 default null
34 ,p_place_used_flag in varchar2 default null
35 ,p_comments in varchar2 default null
36 ,p_description in varchar2 default null
37 ,p_bst_information_category in varchar2 default null
38 ,p_bst_information1 in varchar2 default null
39 ,p_bst_information2 in varchar2 default null
40 ,p_bst_information3 in varchar2 default null
41 ,p_bst_information4 in varchar2 default null
42 ,p_bst_information5 in varchar2 default null
43 ,p_bst_information6 in varchar2 default null
44 ,p_bst_information7 in varchar2 default null
45 ,p_bst_information8 in varchar2 default null
46 ,p_bst_information9 in varchar2 default null
47 ,p_bst_information10 in varchar2 default null
48 ,p_bst_information11 in varchar2 default null
49 ,p_bst_information12 in varchar2 default null
50 ,p_bst_information13 in varchar2 default null
51 ,p_bst_information14 in varchar2 default null
52 ,p_bst_information15 in varchar2 default null
53 ,p_bst_information16 in varchar2 default null
54 ,p_bst_information17 in varchar2 default null
55 ,p_bst_information18 in varchar2 default null
56 ,p_bst_information19 in varchar2 default null
57 ,p_bst_information20 in varchar2 default null
58 ,p_object_version_number out nocopy number
59 ,p_booking_status_type_id in number
60 -- ,p_data_source in varchar2 default null
61 ,p_return_status out nocopy varchar2
62 ) ;
63 -- ----------------------------------------------------------------------------
64 -- |----------------------< update_booking_status_type >----------------------|
65 -- ----------------------------------------------------------------------------
66 -- {Start of comments}
67 --
68 -- Description:
69 -- This procedure is the self-service wrapper procedure to the following
70 -- API: ota_booking_status_type_api.update_booking_status_type
71 --
72 -- Pre-requisites
73 -- All 'IN' parameters to this procedure have been appropriately derived.
74 --
75 -- Post Success:
76 -- p_return_status will return value indicating success.
77 --
78 -- Post Failure:
79 -- p_return_status will return value indication failure.
80 --
81 -- Access Status:
82 -- Internal Development use only.
83 --
84 -- {End of comments}
85 -- ----------------------------------------------------------------------------
86 PROCEDURE update_booking_status_type
87 (p_validate in number default hr_api.g_false_num
88 ,p_effective_date in date
89 ,p_business_group_id in number
90 ,p_active_flag in varchar2 default hr_api.g_varchar2
91 ,p_default_flag in varchar2 default hr_api.g_varchar2
92 ,p_name in varchar2 default hr_api.g_varchar2
93 ,p_type in varchar2 default hr_api.g_varchar2
94 ,p_place_used_flag in varchar2 default hr_api.g_varchar2
95 ,p_comments in varchar2 default hr_api.g_varchar2
96 ,p_description in varchar2 default hr_api.g_varchar2
97 ,p_bst_information_category in varchar2 default hr_api.g_varchar2
98 ,p_bst_information1 in varchar2 default hr_api.g_varchar2
99 ,p_bst_information2 in varchar2 default hr_api.g_varchar2
100 ,p_bst_information3 in varchar2 default hr_api.g_varchar2
101 ,p_bst_information4 in varchar2 default hr_api.g_varchar2
102 ,p_bst_information5 in varchar2 default hr_api.g_varchar2
103 ,p_bst_information6 in varchar2 default hr_api.g_varchar2
104 ,p_bst_information7 in varchar2 default hr_api.g_varchar2
105 ,p_bst_information8 in varchar2 default hr_api.g_varchar2
106 ,p_bst_information9 in varchar2 default hr_api.g_varchar2
107 ,p_bst_information10 in varchar2 default hr_api.g_varchar2
108 ,p_bst_information11 in varchar2 default hr_api.g_varchar2
109 ,p_bst_information12 in varchar2 default hr_api.g_varchar2
110 ,p_bst_information13 in varchar2 default hr_api.g_varchar2
111 ,p_bst_information14 in varchar2 default hr_api.g_varchar2
112 ,p_bst_information15 in varchar2 default hr_api.g_varchar2
113 ,p_bst_information16 in varchar2 default hr_api.g_varchar2
114 ,p_bst_information17 in varchar2 default hr_api.g_varchar2
115 ,p_bst_information18 in varchar2 default hr_api.g_varchar2
116 ,p_bst_information19 in varchar2 default hr_api.g_varchar2
117 ,p_bst_information20 in varchar2 default hr_api.g_varchar2
118 ,p_booking_status_type_id in number default hr_api.g_number
119 ,p_object_version_number in out nocopy number
120 -- ,p_data_source in varchar2 default hr_api.g_varchar2
121 ,p_return_status out nocopy varchar2
122 ) ;
123 -- ----------------------------------------------------------------------------
124 -- |----------------------< delete_booking_status_type >----------------------|
125 -- ----------------------------------------------------------------------------
126 -- {Start of comments}
127 --
128 -- Description:
129 -- This procedure is the self-service wrapper procedure to the following
130 -- API: ota_booking_status_type_api.delete_booking_status_type
131 --
132 -- Pre-requisites
133 -- All 'IN' parameters to this procedure have been appropriately derived.
134 --
135 -- Post Success:
136 -- p_return_status will return value indicating success.
137 --
138 -- Post Failure:
139 -- p_return_status will return value indication failure.
140 --
141 -- Access Status:
142 -- Internal Development use only.
143 --
144 -- {End of comments}
145 -- ----------------------------------------------------------------------------
146 PROCEDURE delete_booking_status_type
147 (p_validate in number default hr_api.g_false_num
148 ,p_booking_status_type_id in number
149 ,p_object_version_number in number
150 ,p_return_status out nocopy varchar2
151 ) ;
152 end ota_booking_status_type_swi;