47: -- default is false. The validation is controlled by a savepoint and
48: -- rollback mechanism. The savepoint is issued at the beginning of the
49: -- process and is rollbacked at the end of the process
50: -- when all the processing has been completed. The rollback is controlled
51: -- by raising and handling the exception hr_api.validate_enabled. We use
52: -- the exception because, by raising the exception with the
53: -- process, we can exit successfully without having any of the 'OUT'
54: -- parameters being set.
55: --
121: -- ----------------------------------------------------------------------------
122: Procedure upd
123: (
124: p_pd_routing_history_id in number,
125: p_initiator_flag in varchar2 default hr_api.g_varchar2,
126: p_requester_flag in varchar2 default hr_api.g_varchar2,
127: p_approver_flag in varchar2 default hr_api.g_varchar2,
128: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
129: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
122: Procedure upd
123: (
124: p_pd_routing_history_id in number,
125: p_initiator_flag in varchar2 default hr_api.g_varchar2,
126: p_requester_flag in varchar2 default hr_api.g_varchar2,
127: p_approver_flag in varchar2 default hr_api.g_varchar2,
128: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
129: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
130: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
123: (
124: p_pd_routing_history_id in number,
125: p_initiator_flag in varchar2 default hr_api.g_varchar2,
126: p_requester_flag in varchar2 default hr_api.g_varchar2,
127: p_approver_flag in varchar2 default hr_api.g_varchar2,
128: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
129: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
130: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
131: p_approved_flag in varchar2 default hr_api.g_varchar2,
124: p_pd_routing_history_id in number,
125: p_initiator_flag in varchar2 default hr_api.g_varchar2,
126: p_requester_flag in varchar2 default hr_api.g_varchar2,
127: p_approver_flag in varchar2 default hr_api.g_varchar2,
128: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
129: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
130: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
131: p_approved_flag in varchar2 default hr_api.g_varchar2,
132: p_user_name in varchar2 default hr_api.g_varchar2,
125: p_initiator_flag in varchar2 default hr_api.g_varchar2,
126: p_requester_flag in varchar2 default hr_api.g_varchar2,
127: p_approver_flag in varchar2 default hr_api.g_varchar2,
128: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
129: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
130: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
131: p_approved_flag in varchar2 default hr_api.g_varchar2,
132: p_user_name in varchar2 default hr_api.g_varchar2,
133: p_user_name_employee_id in number default hr_api.g_number,
126: p_requester_flag in varchar2 default hr_api.g_varchar2,
127: p_approver_flag in varchar2 default hr_api.g_varchar2,
128: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
129: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
130: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
131: p_approved_flag in varchar2 default hr_api.g_varchar2,
132: p_user_name in varchar2 default hr_api.g_varchar2,
133: p_user_name_employee_id in number default hr_api.g_number,
134: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
127: p_approver_flag in varchar2 default hr_api.g_varchar2,
128: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
129: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
130: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
131: p_approved_flag in varchar2 default hr_api.g_varchar2,
132: p_user_name in varchar2 default hr_api.g_varchar2,
133: p_user_name_employee_id in number default hr_api.g_number,
134: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
135: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
128: p_reviewer_flag in varchar2 default hr_api.g_varchar2,
129: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
130: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
131: p_approved_flag in varchar2 default hr_api.g_varchar2,
132: p_user_name in varchar2 default hr_api.g_varchar2,
133: p_user_name_employee_id in number default hr_api.g_number,
134: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
135: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
136: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
129: p_authorizer_flag in varchar2 default hr_api.g_varchar2,
130: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
131: p_approved_flag in varchar2 default hr_api.g_varchar2,
132: p_user_name in varchar2 default hr_api.g_varchar2,
133: p_user_name_employee_id in number default hr_api.g_number,
134: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
135: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
136: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
137: p_action_taken in varchar2 default hr_api.g_varchar2,
130: p_personnelist_flag in varchar2 default hr_api.g_varchar2,
131: p_approved_flag in varchar2 default hr_api.g_varchar2,
132: p_user_name in varchar2 default hr_api.g_varchar2,
133: p_user_name_employee_id in number default hr_api.g_number,
134: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
135: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
136: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
137: p_action_taken in varchar2 default hr_api.g_varchar2,
138: p_date_notification_sent in date default hr_api.g_date,
131: p_approved_flag in varchar2 default hr_api.g_varchar2,
132: p_user_name in varchar2 default hr_api.g_varchar2,
133: p_user_name_employee_id in number default hr_api.g_number,
134: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
135: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
136: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
137: p_action_taken in varchar2 default hr_api.g_varchar2,
138: p_date_notification_sent in date default hr_api.g_date,
139: p_object_version_number in out NOCOPY number,
132: p_user_name in varchar2 default hr_api.g_varchar2,
133: p_user_name_employee_id in number default hr_api.g_number,
134: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
135: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
136: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
137: p_action_taken in varchar2 default hr_api.g_varchar2,
138: p_date_notification_sent in date default hr_api.g_date,
139: p_object_version_number in out NOCOPY number,
140: p_item_key in varchar2 default hr_api.g_varchar2,
133: p_user_name_employee_id in number default hr_api.g_number,
134: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
135: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
136: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
137: p_action_taken in varchar2 default hr_api.g_varchar2,
138: p_date_notification_sent in date default hr_api.g_date,
139: p_object_version_number in out NOCOPY number,
140: p_item_key in varchar2 default hr_api.g_varchar2,
141: p_validate in boolean default false
134: p_user_name_emp_first_name in varchar2 default hr_api.g_varchar2,
135: p_user_name_emp_last_name in varchar2 default hr_api.g_varchar2,
136: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
137: p_action_taken in varchar2 default hr_api.g_varchar2,
138: p_date_notification_sent in date default hr_api.g_date,
139: p_object_version_number in out NOCOPY number,
140: p_item_key in varchar2 default hr_api.g_varchar2,
141: p_validate in boolean default false
142: );
136: p_user_name_emp_middle_names in varchar2 default hr_api.g_varchar2,
137: p_action_taken in varchar2 default hr_api.g_varchar2,
138: p_date_notification_sent in date default hr_api.g_date,
139: p_object_version_number in out NOCOPY number,
140: p_item_key in varchar2 default hr_api.g_varchar2,
141: p_validate in boolean default false
142: );
143: --
144: end ghr_pdh_upd;