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: --
120: -- ----------------------------------------------------------------------------
121: Procedure upd
122: (
123: p_event_id in number,
124: p_vendor_id in number default hr_api.g_number,
125: p_activity_version_id in number default hr_api.g_number,
126: p_business_group_id in number default hr_api.g_number,
127: p_organization_id in number default hr_api.g_number,
128: p_event_type in varchar2 default hr_api.g_varchar2,
121: Procedure upd
122: (
123: p_event_id in number,
124: p_vendor_id in number default hr_api.g_number,
125: p_activity_version_id in number default hr_api.g_number,
126: p_business_group_id in number default hr_api.g_number,
127: p_organization_id in number default hr_api.g_number,
128: p_event_type in varchar2 default hr_api.g_varchar2,
129: p_object_version_number in out nocopy number,
122: (
123: p_event_id in number,
124: p_vendor_id in number default hr_api.g_number,
125: p_activity_version_id in number default hr_api.g_number,
126: p_business_group_id in number default hr_api.g_number,
127: p_organization_id in number default hr_api.g_number,
128: p_event_type in varchar2 default hr_api.g_varchar2,
129: p_object_version_number in out nocopy number,
130: p_title in varchar2 default hr_api.g_varchar2,
123: p_event_id in number,
124: p_vendor_id in number default hr_api.g_number,
125: p_activity_version_id in number default hr_api.g_number,
126: p_business_group_id in number default hr_api.g_number,
127: p_organization_id in number default hr_api.g_number,
128: p_event_type in varchar2 default hr_api.g_varchar2,
129: p_object_version_number in out nocopy number,
130: p_title in varchar2 default hr_api.g_varchar2,
131: p_budget_cost in number default hr_api.g_number,
124: p_vendor_id in number default hr_api.g_number,
125: p_activity_version_id in number default hr_api.g_number,
126: p_business_group_id in number default hr_api.g_number,
127: p_organization_id in number default hr_api.g_number,
128: p_event_type in varchar2 default hr_api.g_varchar2,
129: p_object_version_number in out nocopy number,
130: p_title in varchar2 default hr_api.g_varchar2,
131: p_budget_cost in number default hr_api.g_number,
132: p_actual_cost in number default hr_api.g_number,
126: p_business_group_id in number default hr_api.g_number,
127: p_organization_id in number default hr_api.g_number,
128: p_event_type in varchar2 default hr_api.g_varchar2,
129: p_object_version_number in out nocopy number,
130: p_title in varchar2 default hr_api.g_varchar2,
131: p_budget_cost in number default hr_api.g_number,
132: p_actual_cost in number default hr_api.g_number,
133: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
134: p_centre in varchar2 default hr_api.g_varchar2,
127: p_organization_id in number default hr_api.g_number,
128: p_event_type in varchar2 default hr_api.g_varchar2,
129: p_object_version_number in out nocopy number,
130: p_title in varchar2 default hr_api.g_varchar2,
131: p_budget_cost in number default hr_api.g_number,
132: p_actual_cost in number default hr_api.g_number,
133: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
134: p_centre in varchar2 default hr_api.g_varchar2,
135: p_comments in varchar2 default hr_api.g_varchar2,
128: p_event_type in varchar2 default hr_api.g_varchar2,
129: p_object_version_number in out nocopy number,
130: p_title in varchar2 default hr_api.g_varchar2,
131: p_budget_cost in number default hr_api.g_number,
132: p_actual_cost in number default hr_api.g_number,
133: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
134: p_centre in varchar2 default hr_api.g_varchar2,
135: p_comments in varchar2 default hr_api.g_varchar2,
136: p_course_end_date in date default hr_api.g_date,
129: p_object_version_number in out nocopy number,
130: p_title in varchar2 default hr_api.g_varchar2,
131: p_budget_cost in number default hr_api.g_number,
132: p_actual_cost in number default hr_api.g_number,
133: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
134: p_centre in varchar2 default hr_api.g_varchar2,
135: p_comments in varchar2 default hr_api.g_varchar2,
136: p_course_end_date in date default hr_api.g_date,
137: p_course_end_time in varchar2 default hr_api.g_varchar2,
130: p_title in varchar2 default hr_api.g_varchar2,
131: p_budget_cost in number default hr_api.g_number,
132: p_actual_cost in number default hr_api.g_number,
133: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
134: p_centre in varchar2 default hr_api.g_varchar2,
135: p_comments in varchar2 default hr_api.g_varchar2,
136: p_course_end_date in date default hr_api.g_date,
137: p_course_end_time in varchar2 default hr_api.g_varchar2,
138: p_course_start_date in date default hr_api.g_date,
131: p_budget_cost in number default hr_api.g_number,
132: p_actual_cost in number default hr_api.g_number,
133: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
134: p_centre in varchar2 default hr_api.g_varchar2,
135: p_comments in varchar2 default hr_api.g_varchar2,
136: p_course_end_date in date default hr_api.g_date,
137: p_course_end_time in varchar2 default hr_api.g_varchar2,
138: p_course_start_date in date default hr_api.g_date,
139: p_course_start_time in varchar2 default hr_api.g_varchar2,
132: p_actual_cost in number default hr_api.g_number,
133: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
134: p_centre in varchar2 default hr_api.g_varchar2,
135: p_comments in varchar2 default hr_api.g_varchar2,
136: p_course_end_date in date default hr_api.g_date,
137: p_course_end_time in varchar2 default hr_api.g_varchar2,
138: p_course_start_date in date default hr_api.g_date,
139: p_course_start_time in varchar2 default hr_api.g_varchar2,
140: p_duration in number default hr_api.g_number,
133: p_budget_currency_code in varchar2 default hr_api.g_varchar2,
134: p_centre in varchar2 default hr_api.g_varchar2,
135: p_comments in varchar2 default hr_api.g_varchar2,
136: p_course_end_date in date default hr_api.g_date,
137: p_course_end_time in varchar2 default hr_api.g_varchar2,
138: p_course_start_date in date default hr_api.g_date,
139: p_course_start_time in varchar2 default hr_api.g_varchar2,
140: p_duration in number default hr_api.g_number,
141: p_duration_units in varchar2 default hr_api.g_varchar2,
134: p_centre in varchar2 default hr_api.g_varchar2,
135: p_comments in varchar2 default hr_api.g_varchar2,
136: p_course_end_date in date default hr_api.g_date,
137: p_course_end_time in varchar2 default hr_api.g_varchar2,
138: p_course_start_date in date default hr_api.g_date,
139: p_course_start_time in varchar2 default hr_api.g_varchar2,
140: p_duration in number default hr_api.g_number,
141: p_duration_units in varchar2 default hr_api.g_varchar2,
142: p_enrolment_end_date in date default hr_api.g_date,
135: p_comments in varchar2 default hr_api.g_varchar2,
136: p_course_end_date in date default hr_api.g_date,
137: p_course_end_time in varchar2 default hr_api.g_varchar2,
138: p_course_start_date in date default hr_api.g_date,
139: p_course_start_time in varchar2 default hr_api.g_varchar2,
140: p_duration in number default hr_api.g_number,
141: p_duration_units in varchar2 default hr_api.g_varchar2,
142: p_enrolment_end_date in date default hr_api.g_date,
143: p_enrolment_start_date in date default hr_api.g_date,
136: p_course_end_date in date default hr_api.g_date,
137: p_course_end_time in varchar2 default hr_api.g_varchar2,
138: p_course_start_date in date default hr_api.g_date,
139: p_course_start_time in varchar2 default hr_api.g_varchar2,
140: p_duration in number default hr_api.g_number,
141: p_duration_units in varchar2 default hr_api.g_varchar2,
142: p_enrolment_end_date in date default hr_api.g_date,
143: p_enrolment_start_date in date default hr_api.g_date,
144: p_language_id in number default hr_api.g_number,
137: p_course_end_time in varchar2 default hr_api.g_varchar2,
138: p_course_start_date in date default hr_api.g_date,
139: p_course_start_time in varchar2 default hr_api.g_varchar2,
140: p_duration in number default hr_api.g_number,
141: p_duration_units in varchar2 default hr_api.g_varchar2,
142: p_enrolment_end_date in date default hr_api.g_date,
143: p_enrolment_start_date in date default hr_api.g_date,
144: p_language_id in number default hr_api.g_number,
145: p_user_status in varchar2 default hr_api.g_varchar2,
138: p_course_start_date in date default hr_api.g_date,
139: p_course_start_time in varchar2 default hr_api.g_varchar2,
140: p_duration in number default hr_api.g_number,
141: p_duration_units in varchar2 default hr_api.g_varchar2,
142: p_enrolment_end_date in date default hr_api.g_date,
143: p_enrolment_start_date in date default hr_api.g_date,
144: p_language_id in number default hr_api.g_number,
145: p_user_status in varchar2 default hr_api.g_varchar2,
146: p_development_event_type in varchar2 default hr_api.g_varchar2,
139: p_course_start_time in varchar2 default hr_api.g_varchar2,
140: p_duration in number default hr_api.g_number,
141: p_duration_units in varchar2 default hr_api.g_varchar2,
142: p_enrolment_end_date in date default hr_api.g_date,
143: p_enrolment_start_date in date default hr_api.g_date,
144: p_language_id in number default hr_api.g_number,
145: p_user_status in varchar2 default hr_api.g_varchar2,
146: p_development_event_type in varchar2 default hr_api.g_varchar2,
147: p_event_status in varchar2 default hr_api.g_varchar2,
140: p_duration in number default hr_api.g_number,
141: p_duration_units in varchar2 default hr_api.g_varchar2,
142: p_enrolment_end_date in date default hr_api.g_date,
143: p_enrolment_start_date in date default hr_api.g_date,
144: p_language_id in number default hr_api.g_number,
145: p_user_status in varchar2 default hr_api.g_varchar2,
146: p_development_event_type in varchar2 default hr_api.g_varchar2,
147: p_event_status in varchar2 default hr_api.g_varchar2,
148: p_price_basis in varchar2 default hr_api.g_varchar2,
141: p_duration_units in varchar2 default hr_api.g_varchar2,
142: p_enrolment_end_date in date default hr_api.g_date,
143: p_enrolment_start_date in date default hr_api.g_date,
144: p_language_id in number default hr_api.g_number,
145: p_user_status in varchar2 default hr_api.g_varchar2,
146: p_development_event_type in varchar2 default hr_api.g_varchar2,
147: p_event_status in varchar2 default hr_api.g_varchar2,
148: p_price_basis in varchar2 default hr_api.g_varchar2,
149: p_currency_code in varchar2 default hr_api.g_varchar2,
142: p_enrolment_end_date in date default hr_api.g_date,
143: p_enrolment_start_date in date default hr_api.g_date,
144: p_language_id in number default hr_api.g_number,
145: p_user_status in varchar2 default hr_api.g_varchar2,
146: p_development_event_type in varchar2 default hr_api.g_varchar2,
147: p_event_status in varchar2 default hr_api.g_varchar2,
148: p_price_basis in varchar2 default hr_api.g_varchar2,
149: p_currency_code in varchar2 default hr_api.g_varchar2,
150: p_maximum_attendees in number default hr_api.g_number,
143: p_enrolment_start_date in date default hr_api.g_date,
144: p_language_id in number default hr_api.g_number,
145: p_user_status in varchar2 default hr_api.g_varchar2,
146: p_development_event_type in varchar2 default hr_api.g_varchar2,
147: p_event_status in varchar2 default hr_api.g_varchar2,
148: p_price_basis in varchar2 default hr_api.g_varchar2,
149: p_currency_code in varchar2 default hr_api.g_varchar2,
150: p_maximum_attendees in number default hr_api.g_number,
151: p_maximum_internal_attendees in number default hr_api.g_number,
144: p_language_id in number default hr_api.g_number,
145: p_user_status in varchar2 default hr_api.g_varchar2,
146: p_development_event_type in varchar2 default hr_api.g_varchar2,
147: p_event_status in varchar2 default hr_api.g_varchar2,
148: p_price_basis in varchar2 default hr_api.g_varchar2,
149: p_currency_code in varchar2 default hr_api.g_varchar2,
150: p_maximum_attendees in number default hr_api.g_number,
151: p_maximum_internal_attendees in number default hr_api.g_number,
152: p_minimum_attendees in number default hr_api.g_number,
145: p_user_status in varchar2 default hr_api.g_varchar2,
146: p_development_event_type in varchar2 default hr_api.g_varchar2,
147: p_event_status in varchar2 default hr_api.g_varchar2,
148: p_price_basis in varchar2 default hr_api.g_varchar2,
149: p_currency_code in varchar2 default hr_api.g_varchar2,
150: p_maximum_attendees in number default hr_api.g_number,
151: p_maximum_internal_attendees in number default hr_api.g_number,
152: p_minimum_attendees in number default hr_api.g_number,
153: p_standard_price in number default hr_api.g_number,
146: p_development_event_type in varchar2 default hr_api.g_varchar2,
147: p_event_status in varchar2 default hr_api.g_varchar2,
148: p_price_basis in varchar2 default hr_api.g_varchar2,
149: p_currency_code in varchar2 default hr_api.g_varchar2,
150: p_maximum_attendees in number default hr_api.g_number,
151: p_maximum_internal_attendees in number default hr_api.g_number,
152: p_minimum_attendees in number default hr_api.g_number,
153: p_standard_price in number default hr_api.g_number,
154: p_category_code in varchar2 default hr_api.g_varchar2,
147: p_event_status in varchar2 default hr_api.g_varchar2,
148: p_price_basis in varchar2 default hr_api.g_varchar2,
149: p_currency_code in varchar2 default hr_api.g_varchar2,
150: p_maximum_attendees in number default hr_api.g_number,
151: p_maximum_internal_attendees in number default hr_api.g_number,
152: p_minimum_attendees in number default hr_api.g_number,
153: p_standard_price in number default hr_api.g_number,
154: p_category_code in varchar2 default hr_api.g_varchar2,
155: p_parent_event_id in number default hr_api.g_number,
148: p_price_basis in varchar2 default hr_api.g_varchar2,
149: p_currency_code in varchar2 default hr_api.g_varchar2,
150: p_maximum_attendees in number default hr_api.g_number,
151: p_maximum_internal_attendees in number default hr_api.g_number,
152: p_minimum_attendees in number default hr_api.g_number,
153: p_standard_price in number default hr_api.g_number,
154: p_category_code in varchar2 default hr_api.g_varchar2,
155: p_parent_event_id in number default hr_api.g_number,
156: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
149: p_currency_code in varchar2 default hr_api.g_varchar2,
150: p_maximum_attendees in number default hr_api.g_number,
151: p_maximum_internal_attendees in number default hr_api.g_number,
152: p_minimum_attendees in number default hr_api.g_number,
153: p_standard_price in number default hr_api.g_number,
154: p_category_code in varchar2 default hr_api.g_varchar2,
155: p_parent_event_id in number default hr_api.g_number,
156: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
157: p_public_event_flag in varchar2 default hr_api.g_varchar2,
150: p_maximum_attendees in number default hr_api.g_number,
151: p_maximum_internal_attendees in number default hr_api.g_number,
152: p_minimum_attendees in number default hr_api.g_number,
153: p_standard_price in number default hr_api.g_number,
154: p_category_code in varchar2 default hr_api.g_varchar2,
155: p_parent_event_id in number default hr_api.g_number,
156: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
157: p_public_event_flag in varchar2 default hr_api.g_varchar2,
158: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
151: p_maximum_internal_attendees in number default hr_api.g_number,
152: p_minimum_attendees in number default hr_api.g_number,
153: p_standard_price in number default hr_api.g_number,
154: p_category_code in varchar2 default hr_api.g_varchar2,
155: p_parent_event_id in number default hr_api.g_number,
156: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
157: p_public_event_flag in varchar2 default hr_api.g_varchar2,
158: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
159: p_evt_information_category in varchar2 default hr_api.g_varchar2,
152: p_minimum_attendees in number default hr_api.g_number,
153: p_standard_price in number default hr_api.g_number,
154: p_category_code in varchar2 default hr_api.g_varchar2,
155: p_parent_event_id in number default hr_api.g_number,
156: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
157: p_public_event_flag in varchar2 default hr_api.g_varchar2,
158: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
159: p_evt_information_category in varchar2 default hr_api.g_varchar2,
160: p_evt_information1 in varchar2 default hr_api.g_varchar2,
153: p_standard_price in number default hr_api.g_number,
154: p_category_code in varchar2 default hr_api.g_varchar2,
155: p_parent_event_id in number default hr_api.g_number,
156: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
157: p_public_event_flag in varchar2 default hr_api.g_varchar2,
158: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
159: p_evt_information_category in varchar2 default hr_api.g_varchar2,
160: p_evt_information1 in varchar2 default hr_api.g_varchar2,
161: p_evt_information2 in varchar2 default hr_api.g_varchar2,
154: p_category_code in varchar2 default hr_api.g_varchar2,
155: p_parent_event_id in number default hr_api.g_number,
156: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
157: p_public_event_flag in varchar2 default hr_api.g_varchar2,
158: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
159: p_evt_information_category in varchar2 default hr_api.g_varchar2,
160: p_evt_information1 in varchar2 default hr_api.g_varchar2,
161: p_evt_information2 in varchar2 default hr_api.g_varchar2,
162: p_evt_information3 in varchar2 default hr_api.g_varchar2,
155: p_parent_event_id in number default hr_api.g_number,
156: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
157: p_public_event_flag in varchar2 default hr_api.g_varchar2,
158: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
159: p_evt_information_category in varchar2 default hr_api.g_varchar2,
160: p_evt_information1 in varchar2 default hr_api.g_varchar2,
161: p_evt_information2 in varchar2 default hr_api.g_varchar2,
162: p_evt_information3 in varchar2 default hr_api.g_varchar2,
163: p_evt_information4 in varchar2 default hr_api.g_varchar2,
156: p_book_independent_flag in varchar2 default hr_api.g_varchar2,
157: p_public_event_flag in varchar2 default hr_api.g_varchar2,
158: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
159: p_evt_information_category in varchar2 default hr_api.g_varchar2,
160: p_evt_information1 in varchar2 default hr_api.g_varchar2,
161: p_evt_information2 in varchar2 default hr_api.g_varchar2,
162: p_evt_information3 in varchar2 default hr_api.g_varchar2,
163: p_evt_information4 in varchar2 default hr_api.g_varchar2,
164: p_evt_information5 in varchar2 default hr_api.g_varchar2,
157: p_public_event_flag in varchar2 default hr_api.g_varchar2,
158: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
159: p_evt_information_category in varchar2 default hr_api.g_varchar2,
160: p_evt_information1 in varchar2 default hr_api.g_varchar2,
161: p_evt_information2 in varchar2 default hr_api.g_varchar2,
162: p_evt_information3 in varchar2 default hr_api.g_varchar2,
163: p_evt_information4 in varchar2 default hr_api.g_varchar2,
164: p_evt_information5 in varchar2 default hr_api.g_varchar2,
165: p_evt_information6 in varchar2 default hr_api.g_varchar2,
158: p_secure_event_flag in varchar2 default hr_api.g_varchar2,
159: p_evt_information_category in varchar2 default hr_api.g_varchar2,
160: p_evt_information1 in varchar2 default hr_api.g_varchar2,
161: p_evt_information2 in varchar2 default hr_api.g_varchar2,
162: p_evt_information3 in varchar2 default hr_api.g_varchar2,
163: p_evt_information4 in varchar2 default hr_api.g_varchar2,
164: p_evt_information5 in varchar2 default hr_api.g_varchar2,
165: p_evt_information6 in varchar2 default hr_api.g_varchar2,
166: p_evt_information7 in varchar2 default hr_api.g_varchar2,
159: p_evt_information_category in varchar2 default hr_api.g_varchar2,
160: p_evt_information1 in varchar2 default hr_api.g_varchar2,
161: p_evt_information2 in varchar2 default hr_api.g_varchar2,
162: p_evt_information3 in varchar2 default hr_api.g_varchar2,
163: p_evt_information4 in varchar2 default hr_api.g_varchar2,
164: p_evt_information5 in varchar2 default hr_api.g_varchar2,
165: p_evt_information6 in varchar2 default hr_api.g_varchar2,
166: p_evt_information7 in varchar2 default hr_api.g_varchar2,
167: p_evt_information8 in varchar2 default hr_api.g_varchar2,
160: p_evt_information1 in varchar2 default hr_api.g_varchar2,
161: p_evt_information2 in varchar2 default hr_api.g_varchar2,
162: p_evt_information3 in varchar2 default hr_api.g_varchar2,
163: p_evt_information4 in varchar2 default hr_api.g_varchar2,
164: p_evt_information5 in varchar2 default hr_api.g_varchar2,
165: p_evt_information6 in varchar2 default hr_api.g_varchar2,
166: p_evt_information7 in varchar2 default hr_api.g_varchar2,
167: p_evt_information8 in varchar2 default hr_api.g_varchar2,
168: p_evt_information9 in varchar2 default hr_api.g_varchar2,
161: p_evt_information2 in varchar2 default hr_api.g_varchar2,
162: p_evt_information3 in varchar2 default hr_api.g_varchar2,
163: p_evt_information4 in varchar2 default hr_api.g_varchar2,
164: p_evt_information5 in varchar2 default hr_api.g_varchar2,
165: p_evt_information6 in varchar2 default hr_api.g_varchar2,
166: p_evt_information7 in varchar2 default hr_api.g_varchar2,
167: p_evt_information8 in varchar2 default hr_api.g_varchar2,
168: p_evt_information9 in varchar2 default hr_api.g_varchar2,
169: p_evt_information10 in varchar2 default hr_api.g_varchar2,
162: p_evt_information3 in varchar2 default hr_api.g_varchar2,
163: p_evt_information4 in varchar2 default hr_api.g_varchar2,
164: p_evt_information5 in varchar2 default hr_api.g_varchar2,
165: p_evt_information6 in varchar2 default hr_api.g_varchar2,
166: p_evt_information7 in varchar2 default hr_api.g_varchar2,
167: p_evt_information8 in varchar2 default hr_api.g_varchar2,
168: p_evt_information9 in varchar2 default hr_api.g_varchar2,
169: p_evt_information10 in varchar2 default hr_api.g_varchar2,
170: p_evt_information11 in varchar2 default hr_api.g_varchar2,
163: p_evt_information4 in varchar2 default hr_api.g_varchar2,
164: p_evt_information5 in varchar2 default hr_api.g_varchar2,
165: p_evt_information6 in varchar2 default hr_api.g_varchar2,
166: p_evt_information7 in varchar2 default hr_api.g_varchar2,
167: p_evt_information8 in varchar2 default hr_api.g_varchar2,
168: p_evt_information9 in varchar2 default hr_api.g_varchar2,
169: p_evt_information10 in varchar2 default hr_api.g_varchar2,
170: p_evt_information11 in varchar2 default hr_api.g_varchar2,
171: p_evt_information12 in varchar2 default hr_api.g_varchar2,
164: p_evt_information5 in varchar2 default hr_api.g_varchar2,
165: p_evt_information6 in varchar2 default hr_api.g_varchar2,
166: p_evt_information7 in varchar2 default hr_api.g_varchar2,
167: p_evt_information8 in varchar2 default hr_api.g_varchar2,
168: p_evt_information9 in varchar2 default hr_api.g_varchar2,
169: p_evt_information10 in varchar2 default hr_api.g_varchar2,
170: p_evt_information11 in varchar2 default hr_api.g_varchar2,
171: p_evt_information12 in varchar2 default hr_api.g_varchar2,
172: p_evt_information13 in varchar2 default hr_api.g_varchar2,
165: p_evt_information6 in varchar2 default hr_api.g_varchar2,
166: p_evt_information7 in varchar2 default hr_api.g_varchar2,
167: p_evt_information8 in varchar2 default hr_api.g_varchar2,
168: p_evt_information9 in varchar2 default hr_api.g_varchar2,
169: p_evt_information10 in varchar2 default hr_api.g_varchar2,
170: p_evt_information11 in varchar2 default hr_api.g_varchar2,
171: p_evt_information12 in varchar2 default hr_api.g_varchar2,
172: p_evt_information13 in varchar2 default hr_api.g_varchar2,
173: p_evt_information14 in varchar2 default hr_api.g_varchar2,
166: p_evt_information7 in varchar2 default hr_api.g_varchar2,
167: p_evt_information8 in varchar2 default hr_api.g_varchar2,
168: p_evt_information9 in varchar2 default hr_api.g_varchar2,
169: p_evt_information10 in varchar2 default hr_api.g_varchar2,
170: p_evt_information11 in varchar2 default hr_api.g_varchar2,
171: p_evt_information12 in varchar2 default hr_api.g_varchar2,
172: p_evt_information13 in varchar2 default hr_api.g_varchar2,
173: p_evt_information14 in varchar2 default hr_api.g_varchar2,
174: p_evt_information15 in varchar2 default hr_api.g_varchar2,
167: p_evt_information8 in varchar2 default hr_api.g_varchar2,
168: p_evt_information9 in varchar2 default hr_api.g_varchar2,
169: p_evt_information10 in varchar2 default hr_api.g_varchar2,
170: p_evt_information11 in varchar2 default hr_api.g_varchar2,
171: p_evt_information12 in varchar2 default hr_api.g_varchar2,
172: p_evt_information13 in varchar2 default hr_api.g_varchar2,
173: p_evt_information14 in varchar2 default hr_api.g_varchar2,
174: p_evt_information15 in varchar2 default hr_api.g_varchar2,
175: p_evt_information16 in varchar2 default hr_api.g_varchar2,
168: p_evt_information9 in varchar2 default hr_api.g_varchar2,
169: p_evt_information10 in varchar2 default hr_api.g_varchar2,
170: p_evt_information11 in varchar2 default hr_api.g_varchar2,
171: p_evt_information12 in varchar2 default hr_api.g_varchar2,
172: p_evt_information13 in varchar2 default hr_api.g_varchar2,
173: p_evt_information14 in varchar2 default hr_api.g_varchar2,
174: p_evt_information15 in varchar2 default hr_api.g_varchar2,
175: p_evt_information16 in varchar2 default hr_api.g_varchar2,
176: p_evt_information17 in varchar2 default hr_api.g_varchar2,
169: p_evt_information10 in varchar2 default hr_api.g_varchar2,
170: p_evt_information11 in varchar2 default hr_api.g_varchar2,
171: p_evt_information12 in varchar2 default hr_api.g_varchar2,
172: p_evt_information13 in varchar2 default hr_api.g_varchar2,
173: p_evt_information14 in varchar2 default hr_api.g_varchar2,
174: p_evt_information15 in varchar2 default hr_api.g_varchar2,
175: p_evt_information16 in varchar2 default hr_api.g_varchar2,
176: p_evt_information17 in varchar2 default hr_api.g_varchar2,
177: p_evt_information18 in varchar2 default hr_api.g_varchar2,
170: p_evt_information11 in varchar2 default hr_api.g_varchar2,
171: p_evt_information12 in varchar2 default hr_api.g_varchar2,
172: p_evt_information13 in varchar2 default hr_api.g_varchar2,
173: p_evt_information14 in varchar2 default hr_api.g_varchar2,
174: p_evt_information15 in varchar2 default hr_api.g_varchar2,
175: p_evt_information16 in varchar2 default hr_api.g_varchar2,
176: p_evt_information17 in varchar2 default hr_api.g_varchar2,
177: p_evt_information18 in varchar2 default hr_api.g_varchar2,
178: p_evt_information19 in varchar2 default hr_api.g_varchar2,
171: p_evt_information12 in varchar2 default hr_api.g_varchar2,
172: p_evt_information13 in varchar2 default hr_api.g_varchar2,
173: p_evt_information14 in varchar2 default hr_api.g_varchar2,
174: p_evt_information15 in varchar2 default hr_api.g_varchar2,
175: p_evt_information16 in varchar2 default hr_api.g_varchar2,
176: p_evt_information17 in varchar2 default hr_api.g_varchar2,
177: p_evt_information18 in varchar2 default hr_api.g_varchar2,
178: p_evt_information19 in varchar2 default hr_api.g_varchar2,
179: p_evt_information20 in varchar2 default hr_api.g_varchar2,
172: p_evt_information13 in varchar2 default hr_api.g_varchar2,
173: p_evt_information14 in varchar2 default hr_api.g_varchar2,
174: p_evt_information15 in varchar2 default hr_api.g_varchar2,
175: p_evt_information16 in varchar2 default hr_api.g_varchar2,
176: p_evt_information17 in varchar2 default hr_api.g_varchar2,
177: p_evt_information18 in varchar2 default hr_api.g_varchar2,
178: p_evt_information19 in varchar2 default hr_api.g_varchar2,
179: p_evt_information20 in varchar2 default hr_api.g_varchar2,
180: p_project_id in number default hr_api.g_number,
173: p_evt_information14 in varchar2 default hr_api.g_varchar2,
174: p_evt_information15 in varchar2 default hr_api.g_varchar2,
175: p_evt_information16 in varchar2 default hr_api.g_varchar2,
176: p_evt_information17 in varchar2 default hr_api.g_varchar2,
177: p_evt_information18 in varchar2 default hr_api.g_varchar2,
178: p_evt_information19 in varchar2 default hr_api.g_varchar2,
179: p_evt_information20 in varchar2 default hr_api.g_varchar2,
180: p_project_id in number default hr_api.g_number,
181: p_owner_id in number default hr_api.g_number,
174: p_evt_information15 in varchar2 default hr_api.g_varchar2,
175: p_evt_information16 in varchar2 default hr_api.g_varchar2,
176: p_evt_information17 in varchar2 default hr_api.g_varchar2,
177: p_evt_information18 in varchar2 default hr_api.g_varchar2,
178: p_evt_information19 in varchar2 default hr_api.g_varchar2,
179: p_evt_information20 in varchar2 default hr_api.g_varchar2,
180: p_project_id in number default hr_api.g_number,
181: p_owner_id in number default hr_api.g_number,
182: p_line_id in number default hr_api.g_number,
175: p_evt_information16 in varchar2 default hr_api.g_varchar2,
176: p_evt_information17 in varchar2 default hr_api.g_varchar2,
177: p_evt_information18 in varchar2 default hr_api.g_varchar2,
178: p_evt_information19 in varchar2 default hr_api.g_varchar2,
179: p_evt_information20 in varchar2 default hr_api.g_varchar2,
180: p_project_id in number default hr_api.g_number,
181: p_owner_id in number default hr_api.g_number,
182: p_line_id in number default hr_api.g_number,
183: p_org_id in number default hr_api.g_number,
176: p_evt_information17 in varchar2 default hr_api.g_varchar2,
177: p_evt_information18 in varchar2 default hr_api.g_varchar2,
178: p_evt_information19 in varchar2 default hr_api.g_varchar2,
179: p_evt_information20 in varchar2 default hr_api.g_varchar2,
180: p_project_id in number default hr_api.g_number,
181: p_owner_id in number default hr_api.g_number,
182: p_line_id in number default hr_api.g_number,
183: p_org_id in number default hr_api.g_number,
184: p_training_center_id in number default hr_api.g_number,
177: p_evt_information18 in varchar2 default hr_api.g_varchar2,
178: p_evt_information19 in varchar2 default hr_api.g_varchar2,
179: p_evt_information20 in varchar2 default hr_api.g_varchar2,
180: p_project_id in number default hr_api.g_number,
181: p_owner_id in number default hr_api.g_number,
182: p_line_id in number default hr_api.g_number,
183: p_org_id in number default hr_api.g_number,
184: p_training_center_id in number default hr_api.g_number,
185: p_location_id in number default hr_api.g_number,
178: p_evt_information19 in varchar2 default hr_api.g_varchar2,
179: p_evt_information20 in varchar2 default hr_api.g_varchar2,
180: p_project_id in number default hr_api.g_number,
181: p_owner_id in number default hr_api.g_number,
182: p_line_id in number default hr_api.g_number,
183: p_org_id in number default hr_api.g_number,
184: p_training_center_id in number default hr_api.g_number,
185: p_location_id in number default hr_api.g_number,
186: p_offering_id in number default hr_api.g_number,
179: p_evt_information20 in varchar2 default hr_api.g_varchar2,
180: p_project_id in number default hr_api.g_number,
181: p_owner_id in number default hr_api.g_number,
182: p_line_id in number default hr_api.g_number,
183: p_org_id in number default hr_api.g_number,
184: p_training_center_id in number default hr_api.g_number,
185: p_location_id in number default hr_api.g_number,
186: p_offering_id in number default hr_api.g_number,
187: p_timezone in varchar2 default hr_api.g_varchar2,
180: p_project_id in number default hr_api.g_number,
181: p_owner_id in number default hr_api.g_number,
182: p_line_id in number default hr_api.g_number,
183: p_org_id in number default hr_api.g_number,
184: p_training_center_id in number default hr_api.g_number,
185: p_location_id in number default hr_api.g_number,
186: p_offering_id in number default hr_api.g_number,
187: p_timezone in varchar2 default hr_api.g_varchar2,
188: p_parent_offering_id in number default hr_api.g_number,
181: p_owner_id in number default hr_api.g_number,
182: p_line_id in number default hr_api.g_number,
183: p_org_id in number default hr_api.g_number,
184: p_training_center_id in number default hr_api.g_number,
185: p_location_id in number default hr_api.g_number,
186: p_offering_id in number default hr_api.g_number,
187: p_timezone in varchar2 default hr_api.g_varchar2,
188: p_parent_offering_id in number default hr_api.g_number,
189: p_data_source in varchar2 default hr_api.g_varchar2,
182: p_line_id in number default hr_api.g_number,
183: p_org_id in number default hr_api.g_number,
184: p_training_center_id in number default hr_api.g_number,
185: p_location_id in number default hr_api.g_number,
186: p_offering_id in number default hr_api.g_number,
187: p_timezone in varchar2 default hr_api.g_varchar2,
188: p_parent_offering_id in number default hr_api.g_number,
189: p_data_source in varchar2 default hr_api.g_varchar2,
190: p_validate in boolean default false
183: p_org_id in number default hr_api.g_number,
184: p_training_center_id in number default hr_api.g_number,
185: p_location_id in number default hr_api.g_number,
186: p_offering_id in number default hr_api.g_number,
187: p_timezone in varchar2 default hr_api.g_varchar2,
188: p_parent_offering_id in number default hr_api.g_number,
189: p_data_source in varchar2 default hr_api.g_varchar2,
190: p_validate in boolean default false
191: );
184: p_training_center_id in number default hr_api.g_number,
185: p_location_id in number default hr_api.g_number,
186: p_offering_id in number default hr_api.g_number,
187: p_timezone in varchar2 default hr_api.g_varchar2,
188: p_parent_offering_id in number default hr_api.g_number,
189: p_data_source in varchar2 default hr_api.g_varchar2,
190: p_validate in boolean default false
191: );
192:
185: p_location_id in number default hr_api.g_number,
186: p_offering_id in number default hr_api.g_number,
187: p_timezone in varchar2 default hr_api.g_varchar2,
188: p_parent_offering_id in number default hr_api.g_number,
189: p_data_source in varchar2 default hr_api.g_varchar2,
190: p_validate in boolean default false
191: );
192:
193: end ota_evt_upd;