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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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: ) ;
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 >----------------------|
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: ) ;