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_price_list_id in number,
124: p_business_group_id in number default hr_api.g_number,
125: p_currency_code in varchar2 default hr_api.g_varchar2,
126: p_default_flag in varchar2 default hr_api.g_varchar2,
127: p_name in varchar2 default hr_api.g_varchar2,
128: p_object_version_number in out number,
121: Procedure upd
122: (
123: p_price_list_id in number,
124: p_business_group_id in number default hr_api.g_number,
125: p_currency_code in varchar2 default hr_api.g_varchar2,
126: p_default_flag in varchar2 default hr_api.g_varchar2,
127: p_name in varchar2 default hr_api.g_varchar2,
128: p_object_version_number in out number,
129: p_price_list_type in varchar2 default hr_api.g_varchar2,
122: (
123: p_price_list_id in number,
124: p_business_group_id in number default hr_api.g_number,
125: p_currency_code in varchar2 default hr_api.g_varchar2,
126: p_default_flag in varchar2 default hr_api.g_varchar2,
127: p_name in varchar2 default hr_api.g_varchar2,
128: p_object_version_number in out number,
129: p_price_list_type in varchar2 default hr_api.g_varchar2,
130: p_start_date in date default hr_api.g_date,
123: p_price_list_id in number,
124: p_business_group_id in number default hr_api.g_number,
125: p_currency_code in varchar2 default hr_api.g_varchar2,
126: p_default_flag in varchar2 default hr_api.g_varchar2,
127: p_name in varchar2 default hr_api.g_varchar2,
128: p_object_version_number in out number,
129: p_price_list_type in varchar2 default hr_api.g_varchar2,
130: p_start_date in date default hr_api.g_date,
131: p_comments in varchar2 default hr_api.g_varchar2,
125: p_currency_code in varchar2 default hr_api.g_varchar2,
126: p_default_flag in varchar2 default hr_api.g_varchar2,
127: p_name in varchar2 default hr_api.g_varchar2,
128: p_object_version_number in out number,
129: p_price_list_type in varchar2 default hr_api.g_varchar2,
130: p_start_date in date default hr_api.g_date,
131: p_comments in varchar2 default hr_api.g_varchar2,
132: p_description in varchar2 default hr_api.g_varchar2,
133: p_end_date in date default hr_api.g_date,
126: p_default_flag in varchar2 default hr_api.g_varchar2,
127: p_name in varchar2 default hr_api.g_varchar2,
128: p_object_version_number in out number,
129: p_price_list_type in varchar2 default hr_api.g_varchar2,
130: p_start_date in date default hr_api.g_date,
131: p_comments in varchar2 default hr_api.g_varchar2,
132: p_description in varchar2 default hr_api.g_varchar2,
133: p_end_date in date default hr_api.g_date,
134: p_single_unit_price in number default hr_api.g_number,
127: p_name in varchar2 default hr_api.g_varchar2,
128: p_object_version_number in out number,
129: p_price_list_type in varchar2 default hr_api.g_varchar2,
130: p_start_date in date default hr_api.g_date,
131: p_comments in varchar2 default hr_api.g_varchar2,
132: p_description in varchar2 default hr_api.g_varchar2,
133: p_end_date in date default hr_api.g_date,
134: p_single_unit_price in number default hr_api.g_number,
135: p_training_unit_type in varchar2 default hr_api.g_varchar2,
128: p_object_version_number in out number,
129: p_price_list_type in varchar2 default hr_api.g_varchar2,
130: p_start_date in date default hr_api.g_date,
131: p_comments in varchar2 default hr_api.g_varchar2,
132: p_description in varchar2 default hr_api.g_varchar2,
133: p_end_date in date default hr_api.g_date,
134: p_single_unit_price in number default hr_api.g_number,
135: p_training_unit_type in varchar2 default hr_api.g_varchar2,
136: p_tpl_information_category in varchar2 default hr_api.g_varchar2,
129: p_price_list_type in varchar2 default hr_api.g_varchar2,
130: p_start_date in date default hr_api.g_date,
131: p_comments in varchar2 default hr_api.g_varchar2,
132: p_description in varchar2 default hr_api.g_varchar2,
133: p_end_date in date default hr_api.g_date,
134: p_single_unit_price in number default hr_api.g_number,
135: p_training_unit_type in varchar2 default hr_api.g_varchar2,
136: p_tpl_information_category in varchar2 default hr_api.g_varchar2,
137: p_tpl_information1 in varchar2 default hr_api.g_varchar2,
130: p_start_date in date default hr_api.g_date,
131: p_comments in varchar2 default hr_api.g_varchar2,
132: p_description in varchar2 default hr_api.g_varchar2,
133: p_end_date in date default hr_api.g_date,
134: p_single_unit_price in number default hr_api.g_number,
135: p_training_unit_type in varchar2 default hr_api.g_varchar2,
136: p_tpl_information_category in varchar2 default hr_api.g_varchar2,
137: p_tpl_information1 in varchar2 default hr_api.g_varchar2,
138: p_tpl_information2 in varchar2 default hr_api.g_varchar2,
131: p_comments in varchar2 default hr_api.g_varchar2,
132: p_description in varchar2 default hr_api.g_varchar2,
133: p_end_date in date default hr_api.g_date,
134: p_single_unit_price in number default hr_api.g_number,
135: p_training_unit_type in varchar2 default hr_api.g_varchar2,
136: p_tpl_information_category in varchar2 default hr_api.g_varchar2,
137: p_tpl_information1 in varchar2 default hr_api.g_varchar2,
138: p_tpl_information2 in varchar2 default hr_api.g_varchar2,
139: p_tpl_information3 in varchar2 default hr_api.g_varchar2,
132: p_description in varchar2 default hr_api.g_varchar2,
133: p_end_date in date default hr_api.g_date,
134: p_single_unit_price in number default hr_api.g_number,
135: p_training_unit_type in varchar2 default hr_api.g_varchar2,
136: p_tpl_information_category in varchar2 default hr_api.g_varchar2,
137: p_tpl_information1 in varchar2 default hr_api.g_varchar2,
138: p_tpl_information2 in varchar2 default hr_api.g_varchar2,
139: p_tpl_information3 in varchar2 default hr_api.g_varchar2,
140: p_tpl_information4 in varchar2 default hr_api.g_varchar2,
133: p_end_date in date default hr_api.g_date,
134: p_single_unit_price in number default hr_api.g_number,
135: p_training_unit_type in varchar2 default hr_api.g_varchar2,
136: p_tpl_information_category in varchar2 default hr_api.g_varchar2,
137: p_tpl_information1 in varchar2 default hr_api.g_varchar2,
138: p_tpl_information2 in varchar2 default hr_api.g_varchar2,
139: p_tpl_information3 in varchar2 default hr_api.g_varchar2,
140: p_tpl_information4 in varchar2 default hr_api.g_varchar2,
141: p_tpl_information5 in varchar2 default hr_api.g_varchar2,
134: p_single_unit_price in number default hr_api.g_number,
135: p_training_unit_type in varchar2 default hr_api.g_varchar2,
136: p_tpl_information_category in varchar2 default hr_api.g_varchar2,
137: p_tpl_information1 in varchar2 default hr_api.g_varchar2,
138: p_tpl_information2 in varchar2 default hr_api.g_varchar2,
139: p_tpl_information3 in varchar2 default hr_api.g_varchar2,
140: p_tpl_information4 in varchar2 default hr_api.g_varchar2,
141: p_tpl_information5 in varchar2 default hr_api.g_varchar2,
142: p_tpl_information6 in varchar2 default hr_api.g_varchar2,
135: p_training_unit_type in varchar2 default hr_api.g_varchar2,
136: p_tpl_information_category in varchar2 default hr_api.g_varchar2,
137: p_tpl_information1 in varchar2 default hr_api.g_varchar2,
138: p_tpl_information2 in varchar2 default hr_api.g_varchar2,
139: p_tpl_information3 in varchar2 default hr_api.g_varchar2,
140: p_tpl_information4 in varchar2 default hr_api.g_varchar2,
141: p_tpl_information5 in varchar2 default hr_api.g_varchar2,
142: p_tpl_information6 in varchar2 default hr_api.g_varchar2,
143: p_tpl_information7 in varchar2 default hr_api.g_varchar2,
136: p_tpl_information_category in varchar2 default hr_api.g_varchar2,
137: p_tpl_information1 in varchar2 default hr_api.g_varchar2,
138: p_tpl_information2 in varchar2 default hr_api.g_varchar2,
139: p_tpl_information3 in varchar2 default hr_api.g_varchar2,
140: p_tpl_information4 in varchar2 default hr_api.g_varchar2,
141: p_tpl_information5 in varchar2 default hr_api.g_varchar2,
142: p_tpl_information6 in varchar2 default hr_api.g_varchar2,
143: p_tpl_information7 in varchar2 default hr_api.g_varchar2,
144: p_tpl_information8 in varchar2 default hr_api.g_varchar2,
137: p_tpl_information1 in varchar2 default hr_api.g_varchar2,
138: p_tpl_information2 in varchar2 default hr_api.g_varchar2,
139: p_tpl_information3 in varchar2 default hr_api.g_varchar2,
140: p_tpl_information4 in varchar2 default hr_api.g_varchar2,
141: p_tpl_information5 in varchar2 default hr_api.g_varchar2,
142: p_tpl_information6 in varchar2 default hr_api.g_varchar2,
143: p_tpl_information7 in varchar2 default hr_api.g_varchar2,
144: p_tpl_information8 in varchar2 default hr_api.g_varchar2,
145: p_tpl_information9 in varchar2 default hr_api.g_varchar2,
138: p_tpl_information2 in varchar2 default hr_api.g_varchar2,
139: p_tpl_information3 in varchar2 default hr_api.g_varchar2,
140: p_tpl_information4 in varchar2 default hr_api.g_varchar2,
141: p_tpl_information5 in varchar2 default hr_api.g_varchar2,
142: p_tpl_information6 in varchar2 default hr_api.g_varchar2,
143: p_tpl_information7 in varchar2 default hr_api.g_varchar2,
144: p_tpl_information8 in varchar2 default hr_api.g_varchar2,
145: p_tpl_information9 in varchar2 default hr_api.g_varchar2,
146: p_tpl_information10 in varchar2 default hr_api.g_varchar2,
139: p_tpl_information3 in varchar2 default hr_api.g_varchar2,
140: p_tpl_information4 in varchar2 default hr_api.g_varchar2,
141: p_tpl_information5 in varchar2 default hr_api.g_varchar2,
142: p_tpl_information6 in varchar2 default hr_api.g_varchar2,
143: p_tpl_information7 in varchar2 default hr_api.g_varchar2,
144: p_tpl_information8 in varchar2 default hr_api.g_varchar2,
145: p_tpl_information9 in varchar2 default hr_api.g_varchar2,
146: p_tpl_information10 in varchar2 default hr_api.g_varchar2,
147: p_tpl_information11 in varchar2 default hr_api.g_varchar2,
140: p_tpl_information4 in varchar2 default hr_api.g_varchar2,
141: p_tpl_information5 in varchar2 default hr_api.g_varchar2,
142: p_tpl_information6 in varchar2 default hr_api.g_varchar2,
143: p_tpl_information7 in varchar2 default hr_api.g_varchar2,
144: p_tpl_information8 in varchar2 default hr_api.g_varchar2,
145: p_tpl_information9 in varchar2 default hr_api.g_varchar2,
146: p_tpl_information10 in varchar2 default hr_api.g_varchar2,
147: p_tpl_information11 in varchar2 default hr_api.g_varchar2,
148: p_tpl_information12 in varchar2 default hr_api.g_varchar2,
141: p_tpl_information5 in varchar2 default hr_api.g_varchar2,
142: p_tpl_information6 in varchar2 default hr_api.g_varchar2,
143: p_tpl_information7 in varchar2 default hr_api.g_varchar2,
144: p_tpl_information8 in varchar2 default hr_api.g_varchar2,
145: p_tpl_information9 in varchar2 default hr_api.g_varchar2,
146: p_tpl_information10 in varchar2 default hr_api.g_varchar2,
147: p_tpl_information11 in varchar2 default hr_api.g_varchar2,
148: p_tpl_information12 in varchar2 default hr_api.g_varchar2,
149: p_tpl_information13 in varchar2 default hr_api.g_varchar2,
142: p_tpl_information6 in varchar2 default hr_api.g_varchar2,
143: p_tpl_information7 in varchar2 default hr_api.g_varchar2,
144: p_tpl_information8 in varchar2 default hr_api.g_varchar2,
145: p_tpl_information9 in varchar2 default hr_api.g_varchar2,
146: p_tpl_information10 in varchar2 default hr_api.g_varchar2,
147: p_tpl_information11 in varchar2 default hr_api.g_varchar2,
148: p_tpl_information12 in varchar2 default hr_api.g_varchar2,
149: p_tpl_information13 in varchar2 default hr_api.g_varchar2,
150: p_tpl_information14 in varchar2 default hr_api.g_varchar2,
143: p_tpl_information7 in varchar2 default hr_api.g_varchar2,
144: p_tpl_information8 in varchar2 default hr_api.g_varchar2,
145: p_tpl_information9 in varchar2 default hr_api.g_varchar2,
146: p_tpl_information10 in varchar2 default hr_api.g_varchar2,
147: p_tpl_information11 in varchar2 default hr_api.g_varchar2,
148: p_tpl_information12 in varchar2 default hr_api.g_varchar2,
149: p_tpl_information13 in varchar2 default hr_api.g_varchar2,
150: p_tpl_information14 in varchar2 default hr_api.g_varchar2,
151: p_tpl_information15 in varchar2 default hr_api.g_varchar2,
144: p_tpl_information8 in varchar2 default hr_api.g_varchar2,
145: p_tpl_information9 in varchar2 default hr_api.g_varchar2,
146: p_tpl_information10 in varchar2 default hr_api.g_varchar2,
147: p_tpl_information11 in varchar2 default hr_api.g_varchar2,
148: p_tpl_information12 in varchar2 default hr_api.g_varchar2,
149: p_tpl_information13 in varchar2 default hr_api.g_varchar2,
150: p_tpl_information14 in varchar2 default hr_api.g_varchar2,
151: p_tpl_information15 in varchar2 default hr_api.g_varchar2,
152: p_tpl_information16 in varchar2 default hr_api.g_varchar2,
145: p_tpl_information9 in varchar2 default hr_api.g_varchar2,
146: p_tpl_information10 in varchar2 default hr_api.g_varchar2,
147: p_tpl_information11 in varchar2 default hr_api.g_varchar2,
148: p_tpl_information12 in varchar2 default hr_api.g_varchar2,
149: p_tpl_information13 in varchar2 default hr_api.g_varchar2,
150: p_tpl_information14 in varchar2 default hr_api.g_varchar2,
151: p_tpl_information15 in varchar2 default hr_api.g_varchar2,
152: p_tpl_information16 in varchar2 default hr_api.g_varchar2,
153: p_tpl_information17 in varchar2 default hr_api.g_varchar2,
146: p_tpl_information10 in varchar2 default hr_api.g_varchar2,
147: p_tpl_information11 in varchar2 default hr_api.g_varchar2,
148: p_tpl_information12 in varchar2 default hr_api.g_varchar2,
149: p_tpl_information13 in varchar2 default hr_api.g_varchar2,
150: p_tpl_information14 in varchar2 default hr_api.g_varchar2,
151: p_tpl_information15 in varchar2 default hr_api.g_varchar2,
152: p_tpl_information16 in varchar2 default hr_api.g_varchar2,
153: p_tpl_information17 in varchar2 default hr_api.g_varchar2,
154: p_tpl_information18 in varchar2 default hr_api.g_varchar2,
147: p_tpl_information11 in varchar2 default hr_api.g_varchar2,
148: p_tpl_information12 in varchar2 default hr_api.g_varchar2,
149: p_tpl_information13 in varchar2 default hr_api.g_varchar2,
150: p_tpl_information14 in varchar2 default hr_api.g_varchar2,
151: p_tpl_information15 in varchar2 default hr_api.g_varchar2,
152: p_tpl_information16 in varchar2 default hr_api.g_varchar2,
153: p_tpl_information17 in varchar2 default hr_api.g_varchar2,
154: p_tpl_information18 in varchar2 default hr_api.g_varchar2,
155: p_tpl_information19 in varchar2 default hr_api.g_varchar2,
148: p_tpl_information12 in varchar2 default hr_api.g_varchar2,
149: p_tpl_information13 in varchar2 default hr_api.g_varchar2,
150: p_tpl_information14 in varchar2 default hr_api.g_varchar2,
151: p_tpl_information15 in varchar2 default hr_api.g_varchar2,
152: p_tpl_information16 in varchar2 default hr_api.g_varchar2,
153: p_tpl_information17 in varchar2 default hr_api.g_varchar2,
154: p_tpl_information18 in varchar2 default hr_api.g_varchar2,
155: p_tpl_information19 in varchar2 default hr_api.g_varchar2,
156: p_tpl_information20 in varchar2 default hr_api.g_varchar2,
149: p_tpl_information13 in varchar2 default hr_api.g_varchar2,
150: p_tpl_information14 in varchar2 default hr_api.g_varchar2,
151: p_tpl_information15 in varchar2 default hr_api.g_varchar2,
152: p_tpl_information16 in varchar2 default hr_api.g_varchar2,
153: p_tpl_information17 in varchar2 default hr_api.g_varchar2,
154: p_tpl_information18 in varchar2 default hr_api.g_varchar2,
155: p_tpl_information19 in varchar2 default hr_api.g_varchar2,
156: p_tpl_information20 in varchar2 default hr_api.g_varchar2,
157: p_validate in boolean default false
150: p_tpl_information14 in varchar2 default hr_api.g_varchar2,
151: p_tpl_information15 in varchar2 default hr_api.g_varchar2,
152: p_tpl_information16 in varchar2 default hr_api.g_varchar2,
153: p_tpl_information17 in varchar2 default hr_api.g_varchar2,
154: p_tpl_information18 in varchar2 default hr_api.g_varchar2,
155: p_tpl_information19 in varchar2 default hr_api.g_varchar2,
156: p_tpl_information20 in varchar2 default hr_api.g_varchar2,
157: p_validate in boolean default false
158: );
151: p_tpl_information15 in varchar2 default hr_api.g_varchar2,
152: p_tpl_information16 in varchar2 default hr_api.g_varchar2,
153: p_tpl_information17 in varchar2 default hr_api.g_varchar2,
154: p_tpl_information18 in varchar2 default hr_api.g_varchar2,
155: p_tpl_information19 in varchar2 default hr_api.g_varchar2,
156: p_tpl_information20 in varchar2 default hr_api.g_varchar2,
157: p_validate in boolean default false
158: );
159: --
152: p_tpl_information16 in varchar2 default hr_api.g_varchar2,
153: p_tpl_information17 in varchar2 default hr_api.g_varchar2,
154: p_tpl_information18 in varchar2 default hr_api.g_varchar2,
155: p_tpl_information19 in varchar2 default hr_api.g_varchar2,
156: p_tpl_information20 in varchar2 default hr_api.g_varchar2,
157: p_validate in boolean default false
158: );
159: --
160: end ota_tpl_upd;