46: -- default is false. The validation is controlled by a savepoint and
47: -- rollback mechanism. The savepoint is issued at the beginning of the
48: -- business process and is rollbacked at the end of the business process
49: -- when all the processing has been completed. The rollback is controlled
50: -- by raising and handling the exception hr_api.validate_enabled. We use
51: -- the exception because, by raising the exception with the business
52: -- process, we can exit successfully without having any of the 'OUT'
53: -- arguments being set.
54: --
133: -- ----------------------------------------------------------------------------
134: Procedure upd
135: (
136: p_booking_id in number,
137: p_booking_status_type_id in number default hr_api.g_number,
138: p_delegate_person_id in number default hr_api.g_number,
139: p_contact_id in number default hr_api.g_number,
140: p_business_group_id in number default hr_api.g_number,
141: p_event_id in number default hr_api.g_number,
134: Procedure upd
135: (
136: p_booking_id in number,
137: p_booking_status_type_id in number default hr_api.g_number,
138: p_delegate_person_id in number default hr_api.g_number,
139: p_contact_id in number default hr_api.g_number,
140: p_business_group_id in number default hr_api.g_number,
141: p_event_id in number default hr_api.g_number,
142: p_customer_id in number default hr_api.g_number,
135: (
136: p_booking_id in number,
137: p_booking_status_type_id in number default hr_api.g_number,
138: p_delegate_person_id in number default hr_api.g_number,
139: p_contact_id in number default hr_api.g_number,
140: p_business_group_id in number default hr_api.g_number,
141: p_event_id in number default hr_api.g_number,
142: p_customer_id in number default hr_api.g_number,
143: p_authorizer_person_id in number default hr_api.g_number,
136: p_booking_id in number,
137: p_booking_status_type_id in number default hr_api.g_number,
138: p_delegate_person_id in number default hr_api.g_number,
139: p_contact_id in number default hr_api.g_number,
140: p_business_group_id in number default hr_api.g_number,
141: p_event_id in number default hr_api.g_number,
142: p_customer_id in number default hr_api.g_number,
143: p_authorizer_person_id in number default hr_api.g_number,
144: p_date_booking_placed in date default hr_api.g_date,
137: p_booking_status_type_id in number default hr_api.g_number,
138: p_delegate_person_id in number default hr_api.g_number,
139: p_contact_id in number default hr_api.g_number,
140: p_business_group_id in number default hr_api.g_number,
141: p_event_id in number default hr_api.g_number,
142: p_customer_id in number default hr_api.g_number,
143: p_authorizer_person_id in number default hr_api.g_number,
144: p_date_booking_placed in date default hr_api.g_date,
145: p_corespondent in varchar2 default hr_api.g_varchar2,
138: p_delegate_person_id in number default hr_api.g_number,
139: p_contact_id in number default hr_api.g_number,
140: p_business_group_id in number default hr_api.g_number,
141: p_event_id in number default hr_api.g_number,
142: p_customer_id in number default hr_api.g_number,
143: p_authorizer_person_id in number default hr_api.g_number,
144: p_date_booking_placed in date default hr_api.g_date,
145: p_corespondent in varchar2 default hr_api.g_varchar2,
146: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
139: p_contact_id in number default hr_api.g_number,
140: p_business_group_id in number default hr_api.g_number,
141: p_event_id in number default hr_api.g_number,
142: p_customer_id in number default hr_api.g_number,
143: p_authorizer_person_id in number default hr_api.g_number,
144: p_date_booking_placed in date default hr_api.g_date,
145: p_corespondent in varchar2 default hr_api.g_varchar2,
146: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
147: p_number_of_places in number default hr_api.g_number,
140: p_business_group_id in number default hr_api.g_number,
141: p_event_id in number default hr_api.g_number,
142: p_customer_id in number default hr_api.g_number,
143: p_authorizer_person_id in number default hr_api.g_number,
144: p_date_booking_placed in date default hr_api.g_date,
145: p_corespondent in varchar2 default hr_api.g_varchar2,
146: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
147: p_number_of_places in number default hr_api.g_number,
148: p_object_version_number in out nocopy number,
141: p_event_id in number default hr_api.g_number,
142: p_customer_id in number default hr_api.g_number,
143: p_authorizer_person_id in number default hr_api.g_number,
144: p_date_booking_placed in date default hr_api.g_date,
145: p_corespondent in varchar2 default hr_api.g_varchar2,
146: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
147: p_number_of_places in number default hr_api.g_number,
148: p_object_version_number in out nocopy number,
149: p_administrator in number default hr_api.g_number,
142: p_customer_id in number default hr_api.g_number,
143: p_authorizer_person_id in number default hr_api.g_number,
144: p_date_booking_placed in date default hr_api.g_date,
145: p_corespondent in varchar2 default hr_api.g_varchar2,
146: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
147: p_number_of_places in number default hr_api.g_number,
148: p_object_version_number in out nocopy number,
149: p_administrator in number default hr_api.g_number,
150: p_booking_priority in varchar2 default hr_api.g_varchar2,
143: p_authorizer_person_id in number default hr_api.g_number,
144: p_date_booking_placed in date default hr_api.g_date,
145: p_corespondent in varchar2 default hr_api.g_varchar2,
146: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
147: p_number_of_places in number default hr_api.g_number,
148: p_object_version_number in out nocopy number,
149: p_administrator in number default hr_api.g_number,
150: p_booking_priority in varchar2 default hr_api.g_varchar2,
151: p_comments in varchar2 default hr_api.g_varchar2,
145: p_corespondent in varchar2 default hr_api.g_varchar2,
146: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
147: p_number_of_places in number default hr_api.g_number,
148: p_object_version_number in out nocopy number,
149: p_administrator in number default hr_api.g_number,
150: p_booking_priority in varchar2 default hr_api.g_varchar2,
151: p_comments in varchar2 default hr_api.g_varchar2,
152: p_contact_address_id in number default hr_api.g_number,
153: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
146: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,
147: p_number_of_places in number default hr_api.g_number,
148: p_object_version_number in out nocopy number,
149: p_administrator in number default hr_api.g_number,
150: p_booking_priority in varchar2 default hr_api.g_varchar2,
151: p_comments in varchar2 default hr_api.g_varchar2,
152: p_contact_address_id in number default hr_api.g_number,
153: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
154: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
147: p_number_of_places in number default hr_api.g_number,
148: p_object_version_number in out nocopy number,
149: p_administrator in number default hr_api.g_number,
150: p_booking_priority in varchar2 default hr_api.g_varchar2,
151: p_comments in varchar2 default hr_api.g_varchar2,
152: p_contact_address_id in number default hr_api.g_number,
153: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
154: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
155: p_third_party_customer_id in number default hr_api.g_number,
148: p_object_version_number in out nocopy number,
149: p_administrator in number default hr_api.g_number,
150: p_booking_priority in varchar2 default hr_api.g_varchar2,
151: p_comments in varchar2 default hr_api.g_varchar2,
152: p_contact_address_id in number default hr_api.g_number,
153: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
154: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
155: p_third_party_customer_id in number default hr_api.g_number,
156: p_third_party_contact_id in number default hr_api.g_number,
149: p_administrator in number default hr_api.g_number,
150: p_booking_priority in varchar2 default hr_api.g_varchar2,
151: p_comments in varchar2 default hr_api.g_varchar2,
152: p_contact_address_id in number default hr_api.g_number,
153: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
154: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
155: p_third_party_customer_id in number default hr_api.g_number,
156: p_third_party_contact_id in number default hr_api.g_number,
157: p_third_party_address_id in number default hr_api.g_number,
150: p_booking_priority in varchar2 default hr_api.g_varchar2,
151: p_comments in varchar2 default hr_api.g_varchar2,
152: p_contact_address_id in number default hr_api.g_number,
153: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
154: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
155: p_third_party_customer_id in number default hr_api.g_number,
156: p_third_party_contact_id in number default hr_api.g_number,
157: p_third_party_address_id in number default hr_api.g_number,
158: p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
151: p_comments in varchar2 default hr_api.g_varchar2,
152: p_contact_address_id in number default hr_api.g_number,
153: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
154: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
155: p_third_party_customer_id in number default hr_api.g_number,
156: p_third_party_contact_id in number default hr_api.g_number,
157: p_third_party_address_id in number default hr_api.g_number,
158: p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
159: p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
152: p_contact_address_id in number default hr_api.g_number,
153: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
154: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
155: p_third_party_customer_id in number default hr_api.g_number,
156: p_third_party_contact_id in number default hr_api.g_number,
157: p_third_party_address_id in number default hr_api.g_number,
158: p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
159: p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
160: p_date_status_changed in date default hr_api.g_date,
153: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,
154: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
155: p_third_party_customer_id in number default hr_api.g_number,
156: p_third_party_contact_id in number default hr_api.g_number,
157: p_third_party_address_id in number default hr_api.g_number,
158: p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
159: p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
160: p_date_status_changed in date default hr_api.g_date,
161: p_status_change_comments in varchar2 default hr_api.g_varchar2,
154: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,
155: p_third_party_customer_id in number default hr_api.g_number,
156: p_third_party_contact_id in number default hr_api.g_number,
157: p_third_party_address_id in number default hr_api.g_number,
158: p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
159: p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
160: p_date_status_changed in date default hr_api.g_date,
161: p_status_change_comments in varchar2 default hr_api.g_varchar2,
162: p_failure_reason in varchar2 default hr_api.g_varchar2,
155: p_third_party_customer_id in number default hr_api.g_number,
156: p_third_party_contact_id in number default hr_api.g_number,
157: p_third_party_address_id in number default hr_api.g_number,
158: p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
159: p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
160: p_date_status_changed in date default hr_api.g_date,
161: p_status_change_comments in varchar2 default hr_api.g_varchar2,
162: p_failure_reason in varchar2 default hr_api.g_varchar2,
163: p_attendance_result in varchar2 default hr_api.g_varchar2,
156: p_third_party_contact_id in number default hr_api.g_number,
157: p_third_party_address_id in number default hr_api.g_number,
158: p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
159: p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
160: p_date_status_changed in date default hr_api.g_date,
161: p_status_change_comments in varchar2 default hr_api.g_varchar2,
162: p_failure_reason in varchar2 default hr_api.g_varchar2,
163: p_attendance_result in varchar2 default hr_api.g_varchar2,
164: p_language_id in number default hr_api.g_number,
157: p_third_party_address_id in number default hr_api.g_number,
158: p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
159: p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
160: p_date_status_changed in date default hr_api.g_date,
161: p_status_change_comments in varchar2 default hr_api.g_varchar2,
162: p_failure_reason in varchar2 default hr_api.g_varchar2,
163: p_attendance_result in varchar2 default hr_api.g_varchar2,
164: p_language_id in number default hr_api.g_number,
165: p_source_of_booking in varchar2 default hr_api.g_varchar2,
158: p_third_party_contact_phone in varchar2 default hr_api.g_varchar2,
159: p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
160: p_date_status_changed in date default hr_api.g_date,
161: p_status_change_comments in varchar2 default hr_api.g_varchar2,
162: p_failure_reason in varchar2 default hr_api.g_varchar2,
163: p_attendance_result in varchar2 default hr_api.g_varchar2,
164: p_language_id in number default hr_api.g_number,
165: p_source_of_booking in varchar2 default hr_api.g_varchar2,
166: p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
159: p_third_party_contact_fax in varchar2 default hr_api.g_varchar2,
160: p_date_status_changed in date default hr_api.g_date,
161: p_status_change_comments in varchar2 default hr_api.g_varchar2,
162: p_failure_reason in varchar2 default hr_api.g_varchar2,
163: p_attendance_result in varchar2 default hr_api.g_varchar2,
164: p_language_id in number default hr_api.g_number,
165: p_source_of_booking in varchar2 default hr_api.g_varchar2,
166: p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
167: p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
160: p_date_status_changed in date default hr_api.g_date,
161: p_status_change_comments in varchar2 default hr_api.g_varchar2,
162: p_failure_reason in varchar2 default hr_api.g_varchar2,
163: p_attendance_result in varchar2 default hr_api.g_varchar2,
164: p_language_id in number default hr_api.g_number,
165: p_source_of_booking in varchar2 default hr_api.g_varchar2,
166: p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
167: p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
168: p_tdb_information_category in varchar2 default hr_api.g_varchar2,
161: p_status_change_comments in varchar2 default hr_api.g_varchar2,
162: p_failure_reason in varchar2 default hr_api.g_varchar2,
163: p_attendance_result in varchar2 default hr_api.g_varchar2,
164: p_language_id in number default hr_api.g_number,
165: p_source_of_booking in varchar2 default hr_api.g_varchar2,
166: p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
167: p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
168: p_tdb_information_category in varchar2 default hr_api.g_varchar2,
169: p_tdb_information1 in varchar2 default hr_api.g_varchar2,
162: p_failure_reason in varchar2 default hr_api.g_varchar2,
163: p_attendance_result in varchar2 default hr_api.g_varchar2,
164: p_language_id in number default hr_api.g_number,
165: p_source_of_booking in varchar2 default hr_api.g_varchar2,
166: p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
167: p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
168: p_tdb_information_category in varchar2 default hr_api.g_varchar2,
169: p_tdb_information1 in varchar2 default hr_api.g_varchar2,
170: p_tdb_information2 in varchar2 default hr_api.g_varchar2,
163: p_attendance_result in varchar2 default hr_api.g_varchar2,
164: p_language_id in number default hr_api.g_number,
165: p_source_of_booking in varchar2 default hr_api.g_varchar2,
166: p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
167: p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
168: p_tdb_information_category in varchar2 default hr_api.g_varchar2,
169: p_tdb_information1 in varchar2 default hr_api.g_varchar2,
170: p_tdb_information2 in varchar2 default hr_api.g_varchar2,
171: p_tdb_information3 in varchar2 default hr_api.g_varchar2,
164: p_language_id in number default hr_api.g_number,
165: p_source_of_booking in varchar2 default hr_api.g_varchar2,
166: p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
167: p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
168: p_tdb_information_category in varchar2 default hr_api.g_varchar2,
169: p_tdb_information1 in varchar2 default hr_api.g_varchar2,
170: p_tdb_information2 in varchar2 default hr_api.g_varchar2,
171: p_tdb_information3 in varchar2 default hr_api.g_varchar2,
172: p_tdb_information4 in varchar2 default hr_api.g_varchar2,
165: p_source_of_booking in varchar2 default hr_api.g_varchar2,
166: p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
167: p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
168: p_tdb_information_category in varchar2 default hr_api.g_varchar2,
169: p_tdb_information1 in varchar2 default hr_api.g_varchar2,
170: p_tdb_information2 in varchar2 default hr_api.g_varchar2,
171: p_tdb_information3 in varchar2 default hr_api.g_varchar2,
172: p_tdb_information4 in varchar2 default hr_api.g_varchar2,
173: p_tdb_information5 in varchar2 default hr_api.g_varchar2,
166: p_special_booking_instructions in varchar2 default hr_api.g_varchar2,
167: p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
168: p_tdb_information_category in varchar2 default hr_api.g_varchar2,
169: p_tdb_information1 in varchar2 default hr_api.g_varchar2,
170: p_tdb_information2 in varchar2 default hr_api.g_varchar2,
171: p_tdb_information3 in varchar2 default hr_api.g_varchar2,
172: p_tdb_information4 in varchar2 default hr_api.g_varchar2,
173: p_tdb_information5 in varchar2 default hr_api.g_varchar2,
174: p_tdb_information6 in varchar2 default hr_api.g_varchar2,
167: p_successful_attendance_flag in varchar2 default hr_api.g_varchar2,
168: p_tdb_information_category in varchar2 default hr_api.g_varchar2,
169: p_tdb_information1 in varchar2 default hr_api.g_varchar2,
170: p_tdb_information2 in varchar2 default hr_api.g_varchar2,
171: p_tdb_information3 in varchar2 default hr_api.g_varchar2,
172: p_tdb_information4 in varchar2 default hr_api.g_varchar2,
173: p_tdb_information5 in varchar2 default hr_api.g_varchar2,
174: p_tdb_information6 in varchar2 default hr_api.g_varchar2,
175: p_tdb_information7 in varchar2 default hr_api.g_varchar2,
168: p_tdb_information_category in varchar2 default hr_api.g_varchar2,
169: p_tdb_information1 in varchar2 default hr_api.g_varchar2,
170: p_tdb_information2 in varchar2 default hr_api.g_varchar2,
171: p_tdb_information3 in varchar2 default hr_api.g_varchar2,
172: p_tdb_information4 in varchar2 default hr_api.g_varchar2,
173: p_tdb_information5 in varchar2 default hr_api.g_varchar2,
174: p_tdb_information6 in varchar2 default hr_api.g_varchar2,
175: p_tdb_information7 in varchar2 default hr_api.g_varchar2,
176: p_tdb_information8 in varchar2 default hr_api.g_varchar2,
169: p_tdb_information1 in varchar2 default hr_api.g_varchar2,
170: p_tdb_information2 in varchar2 default hr_api.g_varchar2,
171: p_tdb_information3 in varchar2 default hr_api.g_varchar2,
172: p_tdb_information4 in varchar2 default hr_api.g_varchar2,
173: p_tdb_information5 in varchar2 default hr_api.g_varchar2,
174: p_tdb_information6 in varchar2 default hr_api.g_varchar2,
175: p_tdb_information7 in varchar2 default hr_api.g_varchar2,
176: p_tdb_information8 in varchar2 default hr_api.g_varchar2,
177: p_tdb_information9 in varchar2 default hr_api.g_varchar2,
170: p_tdb_information2 in varchar2 default hr_api.g_varchar2,
171: p_tdb_information3 in varchar2 default hr_api.g_varchar2,
172: p_tdb_information4 in varchar2 default hr_api.g_varchar2,
173: p_tdb_information5 in varchar2 default hr_api.g_varchar2,
174: p_tdb_information6 in varchar2 default hr_api.g_varchar2,
175: p_tdb_information7 in varchar2 default hr_api.g_varchar2,
176: p_tdb_information8 in varchar2 default hr_api.g_varchar2,
177: p_tdb_information9 in varchar2 default hr_api.g_varchar2,
178: p_tdb_information10 in varchar2 default hr_api.g_varchar2,
171: p_tdb_information3 in varchar2 default hr_api.g_varchar2,
172: p_tdb_information4 in varchar2 default hr_api.g_varchar2,
173: p_tdb_information5 in varchar2 default hr_api.g_varchar2,
174: p_tdb_information6 in varchar2 default hr_api.g_varchar2,
175: p_tdb_information7 in varchar2 default hr_api.g_varchar2,
176: p_tdb_information8 in varchar2 default hr_api.g_varchar2,
177: p_tdb_information9 in varchar2 default hr_api.g_varchar2,
178: p_tdb_information10 in varchar2 default hr_api.g_varchar2,
179: p_tdb_information11 in varchar2 default hr_api.g_varchar2,
172: p_tdb_information4 in varchar2 default hr_api.g_varchar2,
173: p_tdb_information5 in varchar2 default hr_api.g_varchar2,
174: p_tdb_information6 in varchar2 default hr_api.g_varchar2,
175: p_tdb_information7 in varchar2 default hr_api.g_varchar2,
176: p_tdb_information8 in varchar2 default hr_api.g_varchar2,
177: p_tdb_information9 in varchar2 default hr_api.g_varchar2,
178: p_tdb_information10 in varchar2 default hr_api.g_varchar2,
179: p_tdb_information11 in varchar2 default hr_api.g_varchar2,
180: p_tdb_information12 in varchar2 default hr_api.g_varchar2,
173: p_tdb_information5 in varchar2 default hr_api.g_varchar2,
174: p_tdb_information6 in varchar2 default hr_api.g_varchar2,
175: p_tdb_information7 in varchar2 default hr_api.g_varchar2,
176: p_tdb_information8 in varchar2 default hr_api.g_varchar2,
177: p_tdb_information9 in varchar2 default hr_api.g_varchar2,
178: p_tdb_information10 in varchar2 default hr_api.g_varchar2,
179: p_tdb_information11 in varchar2 default hr_api.g_varchar2,
180: p_tdb_information12 in varchar2 default hr_api.g_varchar2,
181: p_tdb_information13 in varchar2 default hr_api.g_varchar2,
174: p_tdb_information6 in varchar2 default hr_api.g_varchar2,
175: p_tdb_information7 in varchar2 default hr_api.g_varchar2,
176: p_tdb_information8 in varchar2 default hr_api.g_varchar2,
177: p_tdb_information9 in varchar2 default hr_api.g_varchar2,
178: p_tdb_information10 in varchar2 default hr_api.g_varchar2,
179: p_tdb_information11 in varchar2 default hr_api.g_varchar2,
180: p_tdb_information12 in varchar2 default hr_api.g_varchar2,
181: p_tdb_information13 in varchar2 default hr_api.g_varchar2,
182: p_tdb_information14 in varchar2 default hr_api.g_varchar2,
175: p_tdb_information7 in varchar2 default hr_api.g_varchar2,
176: p_tdb_information8 in varchar2 default hr_api.g_varchar2,
177: p_tdb_information9 in varchar2 default hr_api.g_varchar2,
178: p_tdb_information10 in varchar2 default hr_api.g_varchar2,
179: p_tdb_information11 in varchar2 default hr_api.g_varchar2,
180: p_tdb_information12 in varchar2 default hr_api.g_varchar2,
181: p_tdb_information13 in varchar2 default hr_api.g_varchar2,
182: p_tdb_information14 in varchar2 default hr_api.g_varchar2,
183: p_tdb_information15 in varchar2 default hr_api.g_varchar2,
176: p_tdb_information8 in varchar2 default hr_api.g_varchar2,
177: p_tdb_information9 in varchar2 default hr_api.g_varchar2,
178: p_tdb_information10 in varchar2 default hr_api.g_varchar2,
179: p_tdb_information11 in varchar2 default hr_api.g_varchar2,
180: p_tdb_information12 in varchar2 default hr_api.g_varchar2,
181: p_tdb_information13 in varchar2 default hr_api.g_varchar2,
182: p_tdb_information14 in varchar2 default hr_api.g_varchar2,
183: p_tdb_information15 in varchar2 default hr_api.g_varchar2,
184: p_tdb_information16 in varchar2 default hr_api.g_varchar2,
177: p_tdb_information9 in varchar2 default hr_api.g_varchar2,
178: p_tdb_information10 in varchar2 default hr_api.g_varchar2,
179: p_tdb_information11 in varchar2 default hr_api.g_varchar2,
180: p_tdb_information12 in varchar2 default hr_api.g_varchar2,
181: p_tdb_information13 in varchar2 default hr_api.g_varchar2,
182: p_tdb_information14 in varchar2 default hr_api.g_varchar2,
183: p_tdb_information15 in varchar2 default hr_api.g_varchar2,
184: p_tdb_information16 in varchar2 default hr_api.g_varchar2,
185: p_tdb_information17 in varchar2 default hr_api.g_varchar2,
178: p_tdb_information10 in varchar2 default hr_api.g_varchar2,
179: p_tdb_information11 in varchar2 default hr_api.g_varchar2,
180: p_tdb_information12 in varchar2 default hr_api.g_varchar2,
181: p_tdb_information13 in varchar2 default hr_api.g_varchar2,
182: p_tdb_information14 in varchar2 default hr_api.g_varchar2,
183: p_tdb_information15 in varchar2 default hr_api.g_varchar2,
184: p_tdb_information16 in varchar2 default hr_api.g_varchar2,
185: p_tdb_information17 in varchar2 default hr_api.g_varchar2,
186: p_tdb_information18 in varchar2 default hr_api.g_varchar2,
179: p_tdb_information11 in varchar2 default hr_api.g_varchar2,
180: p_tdb_information12 in varchar2 default hr_api.g_varchar2,
181: p_tdb_information13 in varchar2 default hr_api.g_varchar2,
182: p_tdb_information14 in varchar2 default hr_api.g_varchar2,
183: p_tdb_information15 in varchar2 default hr_api.g_varchar2,
184: p_tdb_information16 in varchar2 default hr_api.g_varchar2,
185: p_tdb_information17 in varchar2 default hr_api.g_varchar2,
186: p_tdb_information18 in varchar2 default hr_api.g_varchar2,
187: p_tdb_information19 in varchar2 default hr_api.g_varchar2,
180: p_tdb_information12 in varchar2 default hr_api.g_varchar2,
181: p_tdb_information13 in varchar2 default hr_api.g_varchar2,
182: p_tdb_information14 in varchar2 default hr_api.g_varchar2,
183: p_tdb_information15 in varchar2 default hr_api.g_varchar2,
184: p_tdb_information16 in varchar2 default hr_api.g_varchar2,
185: p_tdb_information17 in varchar2 default hr_api.g_varchar2,
186: p_tdb_information18 in varchar2 default hr_api.g_varchar2,
187: p_tdb_information19 in varchar2 default hr_api.g_varchar2,
188: p_tdb_information20 in varchar2 default hr_api.g_varchar2,
181: p_tdb_information13 in varchar2 default hr_api.g_varchar2,
182: p_tdb_information14 in varchar2 default hr_api.g_varchar2,
183: p_tdb_information15 in varchar2 default hr_api.g_varchar2,
184: p_tdb_information16 in varchar2 default hr_api.g_varchar2,
185: p_tdb_information17 in varchar2 default hr_api.g_varchar2,
186: p_tdb_information18 in varchar2 default hr_api.g_varchar2,
187: p_tdb_information19 in varchar2 default hr_api.g_varchar2,
188: p_tdb_information20 in varchar2 default hr_api.g_varchar2,
189: p_update_finance_line in varchar2 default 'N',
182: p_tdb_information14 in varchar2 default hr_api.g_varchar2,
183: p_tdb_information15 in varchar2 default hr_api.g_varchar2,
184: p_tdb_information16 in varchar2 default hr_api.g_varchar2,
185: p_tdb_information17 in varchar2 default hr_api.g_varchar2,
186: p_tdb_information18 in varchar2 default hr_api.g_varchar2,
187: p_tdb_information19 in varchar2 default hr_api.g_varchar2,
188: p_tdb_information20 in varchar2 default hr_api.g_varchar2,
189: p_update_finance_line in varchar2 default 'N',
190: p_tfl_object_version_number in out nocopy number,
183: p_tdb_information15 in varchar2 default hr_api.g_varchar2,
184: p_tdb_information16 in varchar2 default hr_api.g_varchar2,
185: p_tdb_information17 in varchar2 default hr_api.g_varchar2,
186: p_tdb_information18 in varchar2 default hr_api.g_varchar2,
187: p_tdb_information19 in varchar2 default hr_api.g_varchar2,
188: p_tdb_information20 in varchar2 default hr_api.g_varchar2,
189: p_update_finance_line in varchar2 default 'N',
190: p_tfl_object_version_number in out nocopy number,
191: p_finance_header_id in number default hr_api.g_number,
184: p_tdb_information16 in varchar2 default hr_api.g_varchar2,
185: p_tdb_information17 in varchar2 default hr_api.g_varchar2,
186: p_tdb_information18 in varchar2 default hr_api.g_varchar2,
187: p_tdb_information19 in varchar2 default hr_api.g_varchar2,
188: p_tdb_information20 in varchar2 default hr_api.g_varchar2,
189: p_update_finance_line in varchar2 default 'N',
190: p_tfl_object_version_number in out nocopy number,
191: p_finance_header_id in number default hr_api.g_number,
192: p_finance_line_id in out nocopy number,
187: p_tdb_information19 in varchar2 default hr_api.g_varchar2,
188: p_tdb_information20 in varchar2 default hr_api.g_varchar2,
189: p_update_finance_line in varchar2 default 'N',
190: p_tfl_object_version_number in out nocopy number,
191: p_finance_header_id in number default hr_api.g_number,
192: p_finance_line_id in out nocopy number,
193: p_standard_amount in number default hr_api.g_number,
194: p_unitary_amount in number default hr_api.g_number,
195: p_money_amount in number default hr_api.g_number,
189: p_update_finance_line in varchar2 default 'N',
190: p_tfl_object_version_number in out nocopy number,
191: p_finance_header_id in number default hr_api.g_number,
192: p_finance_line_id in out nocopy number,
193: p_standard_amount in number default hr_api.g_number,
194: p_unitary_amount in number default hr_api.g_number,
195: p_money_amount in number default hr_api.g_number,
196: p_currency_code in varchar2 default hr_api.g_varchar2,
197: p_booking_deal_type in varchar2 default hr_api.g_varchar2,
190: p_tfl_object_version_number in out nocopy number,
191: p_finance_header_id in number default hr_api.g_number,
192: p_finance_line_id in out nocopy number,
193: p_standard_amount in number default hr_api.g_number,
194: p_unitary_amount in number default hr_api.g_number,
195: p_money_amount in number default hr_api.g_number,
196: p_currency_code in varchar2 default hr_api.g_varchar2,
197: p_booking_deal_type in varchar2 default hr_api.g_varchar2,
198: p_booking_deal_id in number default hr_api.g_number,
191: p_finance_header_id in number default hr_api.g_number,
192: p_finance_line_id in out nocopy number,
193: p_standard_amount in number default hr_api.g_number,
194: p_unitary_amount in number default hr_api.g_number,
195: p_money_amount in number default hr_api.g_number,
196: p_currency_code in varchar2 default hr_api.g_varchar2,
197: p_booking_deal_type in varchar2 default hr_api.g_varchar2,
198: p_booking_deal_id in number default hr_api.g_number,
199: p_enrollment_type in varchar2 default hr_api.g_varchar2,
192: p_finance_line_id in out nocopy number,
193: p_standard_amount in number default hr_api.g_number,
194: p_unitary_amount in number default hr_api.g_number,
195: p_money_amount in number default hr_api.g_number,
196: p_currency_code in varchar2 default hr_api.g_varchar2,
197: p_booking_deal_type in varchar2 default hr_api.g_varchar2,
198: p_booking_deal_id in number default hr_api.g_number,
199: p_enrollment_type in varchar2 default hr_api.g_varchar2,
200: p_validate in boolean default false,
193: p_standard_amount in number default hr_api.g_number,
194: p_unitary_amount in number default hr_api.g_number,
195: p_money_amount in number default hr_api.g_number,
196: p_currency_code in varchar2 default hr_api.g_varchar2,
197: p_booking_deal_type in varchar2 default hr_api.g_varchar2,
198: p_booking_deal_id in number default hr_api.g_number,
199: p_enrollment_type in varchar2 default hr_api.g_varchar2,
200: p_validate in boolean default false,
201: p_organization_id in number default hr_api.g_number,
194: p_unitary_amount in number default hr_api.g_number,
195: p_money_amount in number default hr_api.g_number,
196: p_currency_code in varchar2 default hr_api.g_varchar2,
197: p_booking_deal_type in varchar2 default hr_api.g_varchar2,
198: p_booking_deal_id in number default hr_api.g_number,
199: p_enrollment_type in varchar2 default hr_api.g_varchar2,
200: p_validate in boolean default false,
201: p_organization_id in number default hr_api.g_number,
202: p_sponsor_person_id in number default hr_api.g_number,
195: p_money_amount in number default hr_api.g_number,
196: p_currency_code in varchar2 default hr_api.g_varchar2,
197: p_booking_deal_type in varchar2 default hr_api.g_varchar2,
198: p_booking_deal_id in number default hr_api.g_number,
199: p_enrollment_type in varchar2 default hr_api.g_varchar2,
200: p_validate in boolean default false,
201: p_organization_id in number default hr_api.g_number,
202: p_sponsor_person_id in number default hr_api.g_number,
203: p_sponsor_assignment_id in number default hr_api.g_number,
197: p_booking_deal_type in varchar2 default hr_api.g_varchar2,
198: p_booking_deal_id in number default hr_api.g_number,
199: p_enrollment_type in varchar2 default hr_api.g_varchar2,
200: p_validate in boolean default false,
201: p_organization_id in number default hr_api.g_number,
202: p_sponsor_person_id in number default hr_api.g_number,
203: p_sponsor_assignment_id in number default hr_api.g_number,
204: p_person_address_id in number default hr_api.g_number,
205: p_delegate_assignment_id in number default hr_api.g_number,
198: p_booking_deal_id in number default hr_api.g_number,
199: p_enrollment_type in varchar2 default hr_api.g_varchar2,
200: p_validate in boolean default false,
201: p_organization_id in number default hr_api.g_number,
202: p_sponsor_person_id in number default hr_api.g_number,
203: p_sponsor_assignment_id in number default hr_api.g_number,
204: p_person_address_id in number default hr_api.g_number,
205: p_delegate_assignment_id in number default hr_api.g_number,
206: p_delegate_contact_id in number default hr_api.g_number,
199: p_enrollment_type in varchar2 default hr_api.g_varchar2,
200: p_validate in boolean default false,
201: p_organization_id in number default hr_api.g_number,
202: p_sponsor_person_id in number default hr_api.g_number,
203: p_sponsor_assignment_id in number default hr_api.g_number,
204: p_person_address_id in number default hr_api.g_number,
205: p_delegate_assignment_id in number default hr_api.g_number,
206: p_delegate_contact_id in number default hr_api.g_number,
207: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
200: p_validate in boolean default false,
201: p_organization_id in number default hr_api.g_number,
202: p_sponsor_person_id in number default hr_api.g_number,
203: p_sponsor_assignment_id in number default hr_api.g_number,
204: p_person_address_id in number default hr_api.g_number,
205: p_delegate_assignment_id in number default hr_api.g_number,
206: p_delegate_contact_id in number default hr_api.g_number,
207: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
208: p_third_party_email in varchar2 default hr_api.g_varchar2,
201: p_organization_id in number default hr_api.g_number,
202: p_sponsor_person_id in number default hr_api.g_number,
203: p_sponsor_assignment_id in number default hr_api.g_number,
204: p_person_address_id in number default hr_api.g_number,
205: p_delegate_assignment_id in number default hr_api.g_number,
206: p_delegate_contact_id in number default hr_api.g_number,
207: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
208: p_third_party_email in varchar2 default hr_api.g_varchar2,
209: p_person_address_type in varchar2 default hr_api.g_varchar2,
202: p_sponsor_person_id in number default hr_api.g_number,
203: p_sponsor_assignment_id in number default hr_api.g_number,
204: p_person_address_id in number default hr_api.g_number,
205: p_delegate_assignment_id in number default hr_api.g_number,
206: p_delegate_contact_id in number default hr_api.g_number,
207: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
208: p_third_party_email in varchar2 default hr_api.g_varchar2,
209: p_person_address_type in varchar2 default hr_api.g_varchar2,
210: p_line_id in number default hr_api.g_number,
203: p_sponsor_assignment_id in number default hr_api.g_number,
204: p_person_address_id in number default hr_api.g_number,
205: p_delegate_assignment_id in number default hr_api.g_number,
206: p_delegate_contact_id in number default hr_api.g_number,
207: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
208: p_third_party_email in varchar2 default hr_api.g_varchar2,
209: p_person_address_type in varchar2 default hr_api.g_varchar2,
210: p_line_id in number default hr_api.g_number,
211: p_org_id in number default hr_api.g_number,
204: p_person_address_id in number default hr_api.g_number,
205: p_delegate_assignment_id in number default hr_api.g_number,
206: p_delegate_contact_id in number default hr_api.g_number,
207: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
208: p_third_party_email in varchar2 default hr_api.g_varchar2,
209: p_person_address_type in varchar2 default hr_api.g_varchar2,
210: p_line_id in number default hr_api.g_number,
211: p_org_id in number default hr_api.g_number,
212: p_daemon_flag in varchar2 default hr_api.g_varchar2,
205: p_delegate_assignment_id in number default hr_api.g_number,
206: p_delegate_contact_id in number default hr_api.g_number,
207: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
208: p_third_party_email in varchar2 default hr_api.g_varchar2,
209: p_person_address_type in varchar2 default hr_api.g_varchar2,
210: p_line_id in number default hr_api.g_number,
211: p_org_id in number default hr_api.g_number,
212: p_daemon_flag in varchar2 default hr_api.g_varchar2,
213: p_daemon_type in varchar2 default hr_api.g_varchar2,
206: p_delegate_contact_id in number default hr_api.g_number,
207: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
208: p_third_party_email in varchar2 default hr_api.g_varchar2,
209: p_person_address_type in varchar2 default hr_api.g_varchar2,
210: p_line_id in number default hr_api.g_number,
211: p_org_id in number default hr_api.g_number,
212: p_daemon_flag in varchar2 default hr_api.g_varchar2,
213: p_daemon_type in varchar2 default hr_api.g_varchar2,
214: p_old_event_id in number default hr_api.g_number,
207: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,
208: p_third_party_email in varchar2 default hr_api.g_varchar2,
209: p_person_address_type in varchar2 default hr_api.g_varchar2,
210: p_line_id in number default hr_api.g_number,
211: p_org_id in number default hr_api.g_number,
212: p_daemon_flag in varchar2 default hr_api.g_varchar2,
213: p_daemon_type in varchar2 default hr_api.g_varchar2,
214: p_old_event_id in number default hr_api.g_number,
215: p_quote_line_id in number default hr_api.g_number,
208: p_third_party_email in varchar2 default hr_api.g_varchar2,
209: p_person_address_type in varchar2 default hr_api.g_varchar2,
210: p_line_id in number default hr_api.g_number,
211: p_org_id in number default hr_api.g_number,
212: p_daemon_flag in varchar2 default hr_api.g_varchar2,
213: p_daemon_type in varchar2 default hr_api.g_varchar2,
214: p_old_event_id in number default hr_api.g_number,
215: p_quote_line_id in number default hr_api.g_number,
216: p_interface_source in varchar2 default hr_api.g_varchar2,
209: p_person_address_type in varchar2 default hr_api.g_varchar2,
210: p_line_id in number default hr_api.g_number,
211: p_org_id in number default hr_api.g_number,
212: p_daemon_flag in varchar2 default hr_api.g_varchar2,
213: p_daemon_type in varchar2 default hr_api.g_varchar2,
214: p_old_event_id in number default hr_api.g_number,
215: p_quote_line_id in number default hr_api.g_number,
216: p_interface_source in varchar2 default hr_api.g_varchar2,
217: p_total_training_time in varchar2 default hr_api.g_varchar2,
210: p_line_id in number default hr_api.g_number,
211: p_org_id in number default hr_api.g_number,
212: p_daemon_flag in varchar2 default hr_api.g_varchar2,
213: p_daemon_type in varchar2 default hr_api.g_varchar2,
214: p_old_event_id in number default hr_api.g_number,
215: p_quote_line_id in number default hr_api.g_number,
216: p_interface_source in varchar2 default hr_api.g_varchar2,
217: p_total_training_time in varchar2 default hr_api.g_varchar2,
218: p_content_player_status in varchar2 default hr_api.g_varchar2,
211: p_org_id in number default hr_api.g_number,
212: p_daemon_flag in varchar2 default hr_api.g_varchar2,
213: p_daemon_type in varchar2 default hr_api.g_varchar2,
214: p_old_event_id in number default hr_api.g_number,
215: p_quote_line_id in number default hr_api.g_number,
216: p_interface_source in varchar2 default hr_api.g_varchar2,
217: p_total_training_time in varchar2 default hr_api.g_varchar2,
218: p_content_player_status in varchar2 default hr_api.g_varchar2,
219: p_score in number default hr_api.g_number,
212: p_daemon_flag in varchar2 default hr_api.g_varchar2,
213: p_daemon_type in varchar2 default hr_api.g_varchar2,
214: p_old_event_id in number default hr_api.g_number,
215: p_quote_line_id in number default hr_api.g_number,
216: p_interface_source in varchar2 default hr_api.g_varchar2,
217: p_total_training_time in varchar2 default hr_api.g_varchar2,
218: p_content_player_status in varchar2 default hr_api.g_varchar2,
219: p_score in number default hr_api.g_number,
220: p_completed_content in number default hr_api.g_number,
213: p_daemon_type in varchar2 default hr_api.g_varchar2,
214: p_old_event_id in number default hr_api.g_number,
215: p_quote_line_id in number default hr_api.g_number,
216: p_interface_source in varchar2 default hr_api.g_varchar2,
217: p_total_training_time in varchar2 default hr_api.g_varchar2,
218: p_content_player_status in varchar2 default hr_api.g_varchar2,
219: p_score in number default hr_api.g_number,
220: p_completed_content in number default hr_api.g_number,
221: p_total_content in number default hr_api.g_number ,
214: p_old_event_id in number default hr_api.g_number,
215: p_quote_line_id in number default hr_api.g_number,
216: p_interface_source in varchar2 default hr_api.g_varchar2,
217: p_total_training_time in varchar2 default hr_api.g_varchar2,
218: p_content_player_status in varchar2 default hr_api.g_varchar2,
219: p_score in number default hr_api.g_number,
220: p_completed_content in number default hr_api.g_number,
221: p_total_content in number default hr_api.g_number ,
222: p_booking_justification_id in number default hr_api.g_number ,
215: p_quote_line_id in number default hr_api.g_number,
216: p_interface_source in varchar2 default hr_api.g_varchar2,
217: p_total_training_time in varchar2 default hr_api.g_varchar2,
218: p_content_player_status in varchar2 default hr_api.g_varchar2,
219: p_score in number default hr_api.g_number,
220: p_completed_content in number default hr_api.g_number,
221: p_total_content in number default hr_api.g_number ,
222: p_booking_justification_id in number default hr_api.g_number ,
223: p_is_history_flag in varchar2 default hr_api.g_varchar2,
216: p_interface_source in varchar2 default hr_api.g_varchar2,
217: p_total_training_time in varchar2 default hr_api.g_varchar2,
218: p_content_player_status in varchar2 default hr_api.g_varchar2,
219: p_score in number default hr_api.g_number,
220: p_completed_content in number default hr_api.g_number,
221: p_total_content in number default hr_api.g_number ,
222: p_booking_justification_id in number default hr_api.g_number ,
223: p_is_history_flag in varchar2 default hr_api.g_varchar2,
224: p_sign_eval_status in varchar2 default null
217: p_total_training_time in varchar2 default hr_api.g_varchar2,
218: p_content_player_status in varchar2 default hr_api.g_varchar2,
219: p_score in number default hr_api.g_number,
220: p_completed_content in number default hr_api.g_number,
221: p_total_content in number default hr_api.g_number ,
222: p_booking_justification_id in number default hr_api.g_number ,
223: p_is_history_flag in varchar2 default hr_api.g_varchar2,
224: p_sign_eval_status in varchar2 default null
225: );
218: p_content_player_status in varchar2 default hr_api.g_varchar2,
219: p_score in number default hr_api.g_number,
220: p_completed_content in number default hr_api.g_number,
221: p_total_content in number default hr_api.g_number ,
222: p_booking_justification_id in number default hr_api.g_number ,
223: p_is_history_flag in varchar2 default hr_api.g_varchar2,
224: p_sign_eval_status in varchar2 default null
225: );
226: --
219: p_score in number default hr_api.g_number,
220: p_completed_content in number default hr_api.g_number,
221: p_total_content in number default hr_api.g_number ,
222: p_booking_justification_id in number default hr_api.g_number ,
223: p_is_history_flag in varchar2 default hr_api.g_varchar2,
224: p_sign_eval_status in varchar2 default null
225: );
226: --
227: end ota_tdb_upd;