APPS.OTA_BOOKING_STATUS_TYPE_SWI dependencies on HR_API

Line 27: (p_validate in number default hr_api.g_false_num

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

Line 87: (p_validate in number default hr_api.g_false_num

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

Line 90: ,p_active_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

Line 91: ,p_default_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

Line 92: ,p_name 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

Line 93: ,p_type 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

Line 94: ,p_place_used_flag 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

Line 95: ,p_comments 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

Line 96: ,p_description 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

Line 97: ,p_bst_information_category 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

Line 98: ,p_bst_information1 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

Line 99: ,p_bst_information2 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

Line 100: ,p_bst_information3 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

Line 101: ,p_bst_information4 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

Line 102: ,p_bst_information5 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

Line 103: ,p_bst_information6 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

Line 104: ,p_bst_information7 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

Line 105: ,p_bst_information8 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

Line 106: ,p_bst_information9 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

Line 107: ,p_bst_information10 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

Line 108: ,p_bst_information11 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

Line 109: ,p_bst_information12 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

Line 110: ,p_bst_information13 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

Line 111: ,p_bst_information14 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

Line 112: ,p_bst_information15 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

Line 113: ,p_bst_information16 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

Line 114: ,p_bst_information17 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

Line 115: ,p_bst_information18 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

Line 116: ,p_bst_information19 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

Line 117: ,p_bst_information20 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

Line 118: ,p_booking_status_type_id in number default hr_api.g_number

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

Line 120: -- ,p_data_source 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 >----------------------|

Line 147: (p_validate in number default hr_api.g_false_num

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