DBA Data[Home] [Help]

APPS.OTA_TDB_UPD dependencies on HR_API

Line 50: -- by raising and handling the exception hr_api.validate_enabled. We use

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

Line 137: p_booking_status_type_id in number default hr_api.g_number,

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,

Line 138: p_delegate_person_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,

Line 139: p_contact_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,

Line 140: p_business_group_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,

Line 141: p_event_id in number default hr_api.g_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,
145: p_corespondent in varchar2 default hr_api.g_varchar2,

Line 142: p_customer_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,
146: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,

Line 143: p_authorizer_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,
147: p_number_of_places in number default hr_api.g_number,

Line 144: p_date_booking_placed in date default hr_api.g_date,

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,

Line 145: p_corespondent in varchar2 default hr_api.g_varchar2,

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,

Line 146: p_internal_booking_flag in varchar2 default hr_api.g_varchar2,

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,

Line 147: p_number_of_places 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,
151: p_comments in varchar2 default hr_api.g_varchar2,

Line 149: p_administrator in number default hr_api.g_number,

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,

Line 150: p_booking_priority 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,

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

Line 152: p_contact_address_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,

Line 153: p_delegate_contact_phone in varchar2 default hr_api.g_varchar2,

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,

Line 154: p_delegate_contact_fax in varchar2 default hr_api.g_varchar2,

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,

Line 155: p_third_party_customer_id in number default hr_api.g_number,

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,

Line 156: p_third_party_contact_id in number default hr_api.g_number,

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,

Line 157: p_third_party_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,
161: p_status_change_comments in varchar2 default hr_api.g_varchar2,

Line 158: p_third_party_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,
162: p_failure_reason in varchar2 default hr_api.g_varchar2,

Line 159: p_third_party_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,
163: p_attendance_result in varchar2 default hr_api.g_varchar2,

Line 160: p_date_status_changed in date default hr_api.g_date,

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,

Line 161: p_status_change_comments in varchar2 default hr_api.g_varchar2,

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,

Line 162: p_failure_reason 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,

Line 163: p_attendance_result 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,

Line 164: p_language_id in number default hr_api.g_number,

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,

Line 165: p_source_of_booking 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,

Line 166: p_special_booking_instructions 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,

Line 167: p_successful_attendance_flag 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,

Line 168: p_tdb_information_category 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,

Line 169: p_tdb_information1 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,

Line 170: p_tdb_information2 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,

Line 171: p_tdb_information3 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,

Line 172: p_tdb_information4 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,

Line 173: p_tdb_information5 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,

Line 174: p_tdb_information6 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,

Line 175: p_tdb_information7 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,

Line 176: p_tdb_information8 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,

Line 177: p_tdb_information9 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,

Line 178: p_tdb_information10 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,

Line 179: p_tdb_information11 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,

Line 180: p_tdb_information12 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,

Line 181: p_tdb_information13 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,

Line 182: p_tdb_information14 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,

Line 183: p_tdb_information15 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,

Line 184: p_tdb_information16 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,

Line 185: p_tdb_information17 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',

Line 186: p_tdb_information18 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',
190: p_tfl_object_version_number in out nocopy number,

Line 187: p_tdb_information19 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,
191: p_finance_header_id in number default hr_api.g_number,

Line 188: p_tdb_information20 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,
192: p_finance_line_id in out nocopy number,

Line 191: p_finance_header_id in number default hr_api.g_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,

Line 193: p_standard_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,

Line 194: p_unitary_amount in number default hr_api.g_number,

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,

Line 195: p_money_amount 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,

Line 196: p_currency_code 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,

Line 197: p_booking_deal_type in varchar2 default hr_api.g_varchar2,

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,

Line 198: p_booking_deal_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,

Line 199: p_enrollment_type in varchar2 default hr_api.g_varchar2,

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,

Line 201: p_organization_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,

Line 202: p_sponsor_person_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,

Line 203: p_sponsor_assignment_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,

Line 204: p_person_address_id in number default hr_api.g_number,

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,

Line 205: p_delegate_assignment_id in number default hr_api.g_number,

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,

Line 206: p_delegate_contact_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,
210: p_line_id in number default hr_api.g_number,

Line 207: p_delegate_contact_email in varchar2 default hr_api.g_varchar2,

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,

Line 208: p_third_party_email in varchar2 default hr_api.g_varchar2,

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,

Line 209: p_person_address_type 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,

Line 210: p_line_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,
214: p_old_event_id in number default hr_api.g_number,

Line 211: p_org_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,

Line 212: p_daemon_flag 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,
216: p_interface_source in varchar2 default hr_api.g_varchar2,

Line 213: p_daemon_type 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,

Line 214: p_old_event_id in number default hr_api.g_number,

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,

Line 215: p_quote_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,
219: p_score in number default hr_api.g_number,

Line 216: p_interface_source in varchar2 default hr_api.g_varchar2,

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,

Line 217: p_total_training_time 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,
221: p_total_content in number default hr_api.g_number ,

Line 218: p_content_player_status 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 ,
222: p_booking_justification_id in number default hr_api.g_number ,

Line 219: p_score 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,

Line 220: p_completed_content 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,
224: p_sign_eval_status in varchar2 default null

Line 221: p_total_content in number default hr_api.g_number ,

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

Line 222: p_booking_justification_id in number default hr_api.g_number ,

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

Line 223: p_is_history_flag 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: --
227: end ota_tdb_upd;