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: -- process and is rollbacked at the end of the 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
52: -- process, we can exit successfully without having any of the 'OUT'
53: -- parameters being set.
54: --
120: -- ----------------------------------------------------------------------------
121: Procedure upd
122: (
123: p_transaction_value_id in number,
124: p_transaction_step_id in number default hr_api.g_number,
125: p_datatype in varchar2 default hr_api.g_varchar2,
126: p_name in varchar2 default hr_api.g_varchar2,
127: p_varchar2_value in varchar2 default hr_api.g_varchar2,
128: p_number_value in number default hr_api.g_number,
121: Procedure upd
122: (
123: p_transaction_value_id in number,
124: p_transaction_step_id in number default hr_api.g_number,
125: p_datatype in varchar2 default hr_api.g_varchar2,
126: p_name in varchar2 default hr_api.g_varchar2,
127: p_varchar2_value in varchar2 default hr_api.g_varchar2,
128: p_number_value in number default hr_api.g_number,
129: p_date_value in date default hr_api.g_date,
122: (
123: p_transaction_value_id in number,
124: p_transaction_step_id in number default hr_api.g_number,
125: p_datatype in varchar2 default hr_api.g_varchar2,
126: p_name in varchar2 default hr_api.g_varchar2,
127: p_varchar2_value in varchar2 default hr_api.g_varchar2,
128: p_number_value in number default hr_api.g_number,
129: p_date_value in date default hr_api.g_date,
130: p_original_varchar2_value in varchar2 default hr_api.g_varchar2,
123: p_transaction_value_id in number,
124: p_transaction_step_id in number default hr_api.g_number,
125: p_datatype in varchar2 default hr_api.g_varchar2,
126: p_name in varchar2 default hr_api.g_varchar2,
127: p_varchar2_value in varchar2 default hr_api.g_varchar2,
128: p_number_value in number default hr_api.g_number,
129: p_date_value in date default hr_api.g_date,
130: p_original_varchar2_value in varchar2 default hr_api.g_varchar2,
131: p_original_number_value in number default hr_api.g_number,
124: p_transaction_step_id in number default hr_api.g_number,
125: p_datatype in varchar2 default hr_api.g_varchar2,
126: p_name in varchar2 default hr_api.g_varchar2,
127: p_varchar2_value in varchar2 default hr_api.g_varchar2,
128: p_number_value in number default hr_api.g_number,
129: p_date_value in date default hr_api.g_date,
130: p_original_varchar2_value in varchar2 default hr_api.g_varchar2,
131: p_original_number_value in number default hr_api.g_number,
132: p_original_date_value in date default hr_api.g_date,
125: p_datatype in varchar2 default hr_api.g_varchar2,
126: p_name in varchar2 default hr_api.g_varchar2,
127: p_varchar2_value in varchar2 default hr_api.g_varchar2,
128: p_number_value in number default hr_api.g_number,
129: p_date_value in date default hr_api.g_date,
130: p_original_varchar2_value in varchar2 default hr_api.g_varchar2,
131: p_original_number_value in number default hr_api.g_number,
132: p_original_date_value in date default hr_api.g_date,
133: p_validate in boolean default false
126: p_name in varchar2 default hr_api.g_varchar2,
127: p_varchar2_value in varchar2 default hr_api.g_varchar2,
128: p_number_value in number default hr_api.g_number,
129: p_date_value in date default hr_api.g_date,
130: p_original_varchar2_value in varchar2 default hr_api.g_varchar2,
131: p_original_number_value in number default hr_api.g_number,
132: p_original_date_value in date default hr_api.g_date,
133: p_validate in boolean default false
134: );
127: p_varchar2_value in varchar2 default hr_api.g_varchar2,
128: p_number_value in number default hr_api.g_number,
129: p_date_value in date default hr_api.g_date,
130: p_original_varchar2_value in varchar2 default hr_api.g_varchar2,
131: p_original_number_value in number default hr_api.g_number,
132: p_original_date_value in date default hr_api.g_date,
133: p_validate in boolean default false
134: );
135: --
128: p_number_value in number default hr_api.g_number,
129: p_date_value in date default hr_api.g_date,
130: p_original_varchar2_value in varchar2 default hr_api.g_varchar2,
131: p_original_number_value in number default hr_api.g_number,
132: p_original_date_value in date default hr_api.g_date,
133: p_validate in boolean default false
134: );
135: --
136: end hr_trv_upd;