77: ,p_business_group_id in number default null
78: ,p_setup_type_cd in varchar2 default null
79: ,p_master_table_route_id in number default null
80: ,p_effective_date in date
81: ,p_language_code in varchar2 default hr_api.userenv_lang
82: );
83: --
84: -- ----------------------------------------------------------------------------
85: -- |---------------------------< update_tran_category >-----------------------|
155: * applicable during the start to end active date range. This date does not
156: * determine when the changes take effect.
157: * @param p_language_code Specifies to which language the translation values
158: * apply. You can set to the base or any installed language. The default value
159: * of hr_api.userenv_lang is equivalent to the RDBMS userenv('LANG') function
160: * value.
161: * @rep:displayname Update Transaction Category
162: * @rep:category BUSINESS_ENTITY PQH_POS_CTRL_ROUTING
163: * @rep:category MISC_EXTENSIONS HR_USER_HOOKS
171: procedure update_TRAN_CATEGORY
172: (
173: p_validate in boolean default false
174: ,p_transaction_category_id in number
175: ,p_custom_wf_process_name in varchar2 default hr_api.g_varchar2
176: ,p_custom_workflow_name in varchar2 default hr_api.g_varchar2
177: ,p_form_name in varchar2 default hr_api.g_varchar2
178: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
179: ,p_future_action_cd in varchar2 default hr_api.g_varchar2
172: (
173: p_validate in boolean default false
174: ,p_transaction_category_id in number
175: ,p_custom_wf_process_name in varchar2 default hr_api.g_varchar2
176: ,p_custom_workflow_name in varchar2 default hr_api.g_varchar2
177: ,p_form_name in varchar2 default hr_api.g_varchar2
178: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
179: ,p_future_action_cd in varchar2 default hr_api.g_varchar2
180: ,p_member_cd in varchar2 default hr_api.g_varchar2
173: p_validate in boolean default false
174: ,p_transaction_category_id in number
175: ,p_custom_wf_process_name in varchar2 default hr_api.g_varchar2
176: ,p_custom_workflow_name in varchar2 default hr_api.g_varchar2
177: ,p_form_name in varchar2 default hr_api.g_varchar2
178: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
179: ,p_future_action_cd in varchar2 default hr_api.g_varchar2
180: ,p_member_cd in varchar2 default hr_api.g_varchar2
181: ,p_name in varchar2 default hr_api.g_varchar2
174: ,p_transaction_category_id in number
175: ,p_custom_wf_process_name in varchar2 default hr_api.g_varchar2
176: ,p_custom_workflow_name in varchar2 default hr_api.g_varchar2
177: ,p_form_name in varchar2 default hr_api.g_varchar2
178: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
179: ,p_future_action_cd in varchar2 default hr_api.g_varchar2
180: ,p_member_cd in varchar2 default hr_api.g_varchar2
181: ,p_name in varchar2 default hr_api.g_varchar2
182: ,p_short_name in varchar2 default hr_api.g_varchar2
175: ,p_custom_wf_process_name in varchar2 default hr_api.g_varchar2
176: ,p_custom_workflow_name in varchar2 default hr_api.g_varchar2
177: ,p_form_name in varchar2 default hr_api.g_varchar2
178: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
179: ,p_future_action_cd in varchar2 default hr_api.g_varchar2
180: ,p_member_cd in varchar2 default hr_api.g_varchar2
181: ,p_name in varchar2 default hr_api.g_varchar2
182: ,p_short_name in varchar2 default hr_api.g_varchar2
183: ,p_post_style_cd in varchar2 default hr_api.g_varchar2
176: ,p_custom_workflow_name in varchar2 default hr_api.g_varchar2
177: ,p_form_name in varchar2 default hr_api.g_varchar2
178: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
179: ,p_future_action_cd in varchar2 default hr_api.g_varchar2
180: ,p_member_cd in varchar2 default hr_api.g_varchar2
181: ,p_name in varchar2 default hr_api.g_varchar2
182: ,p_short_name in varchar2 default hr_api.g_varchar2
183: ,p_post_style_cd in varchar2 default hr_api.g_varchar2
184: ,p_post_txn_function in varchar2 default hr_api.g_varchar2
177: ,p_form_name in varchar2 default hr_api.g_varchar2
178: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
179: ,p_future_action_cd in varchar2 default hr_api.g_varchar2
180: ,p_member_cd in varchar2 default hr_api.g_varchar2
181: ,p_name in varchar2 default hr_api.g_varchar2
182: ,p_short_name in varchar2 default hr_api.g_varchar2
183: ,p_post_style_cd in varchar2 default hr_api.g_varchar2
184: ,p_post_txn_function in varchar2 default hr_api.g_varchar2
185: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2
178: ,p_freeze_status_cd in varchar2 default hr_api.g_varchar2
179: ,p_future_action_cd in varchar2 default hr_api.g_varchar2
180: ,p_member_cd in varchar2 default hr_api.g_varchar2
181: ,p_name in varchar2 default hr_api.g_varchar2
182: ,p_short_name in varchar2 default hr_api.g_varchar2
183: ,p_post_style_cd in varchar2 default hr_api.g_varchar2
184: ,p_post_txn_function in varchar2 default hr_api.g_varchar2
185: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2
186: ,p_prevent_approver_skip in varchar2 default hr_api.g_varchar2
179: ,p_future_action_cd in varchar2 default hr_api.g_varchar2
180: ,p_member_cd in varchar2 default hr_api.g_varchar2
181: ,p_name in varchar2 default hr_api.g_varchar2
182: ,p_short_name in varchar2 default hr_api.g_varchar2
183: ,p_post_style_cd in varchar2 default hr_api.g_varchar2
184: ,p_post_txn_function in varchar2 default hr_api.g_varchar2
185: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2
186: ,p_prevent_approver_skip in varchar2 default hr_api.g_varchar2
187: ,p_workflow_enable_flag in varchar2 default hr_api.g_varchar2
180: ,p_member_cd in varchar2 default hr_api.g_varchar2
181: ,p_name in varchar2 default hr_api.g_varchar2
182: ,p_short_name in varchar2 default hr_api.g_varchar2
183: ,p_post_style_cd in varchar2 default hr_api.g_varchar2
184: ,p_post_txn_function in varchar2 default hr_api.g_varchar2
185: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2
186: ,p_prevent_approver_skip in varchar2 default hr_api.g_varchar2
187: ,p_workflow_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_enable_flag in varchar2 default hr_api.g_varchar2
181: ,p_name in varchar2 default hr_api.g_varchar2
182: ,p_short_name in varchar2 default hr_api.g_varchar2
183: ,p_post_style_cd in varchar2 default hr_api.g_varchar2
184: ,p_post_txn_function in varchar2 default hr_api.g_varchar2
185: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2
186: ,p_prevent_approver_skip in varchar2 default hr_api.g_varchar2
187: ,p_workflow_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_enable_flag in varchar2 default hr_api.g_varchar2
189: ,p_timeout_days in number default hr_api.g_number
182: ,p_short_name in varchar2 default hr_api.g_varchar2
183: ,p_post_style_cd in varchar2 default hr_api.g_varchar2
184: ,p_post_txn_function in varchar2 default hr_api.g_varchar2
185: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2
186: ,p_prevent_approver_skip in varchar2 default hr_api.g_varchar2
187: ,p_workflow_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_enable_flag in varchar2 default hr_api.g_varchar2
189: ,p_timeout_days in number default hr_api.g_number
190: ,p_object_version_number in out nocopy number
183: ,p_post_style_cd in varchar2 default hr_api.g_varchar2
184: ,p_post_txn_function in varchar2 default hr_api.g_varchar2
185: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2
186: ,p_prevent_approver_skip in varchar2 default hr_api.g_varchar2
187: ,p_workflow_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_enable_flag in varchar2 default hr_api.g_varchar2
189: ,p_timeout_days in number default hr_api.g_number
190: ,p_object_version_number in out nocopy number
191: ,p_consolidated_table_route_id in number default hr_api.g_number
184: ,p_post_txn_function in varchar2 default hr_api.g_varchar2
185: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2
186: ,p_prevent_approver_skip in varchar2 default hr_api.g_varchar2
187: ,p_workflow_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_enable_flag in varchar2 default hr_api.g_varchar2
189: ,p_timeout_days in number default hr_api.g_number
190: ,p_object_version_number in out nocopy number
191: ,p_consolidated_table_route_id in number default hr_api.g_number
192: ,p_business_group_id in number default hr_api.g_number
185: ,p_route_validated_txn_flag in varchar2 default hr_api.g_varchar2
186: ,p_prevent_approver_skip in varchar2 default hr_api.g_varchar2
187: ,p_workflow_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_enable_flag in varchar2 default hr_api.g_varchar2
189: ,p_timeout_days in number default hr_api.g_number
190: ,p_object_version_number in out nocopy number
191: ,p_consolidated_table_route_id in number default hr_api.g_number
192: ,p_business_group_id in number default hr_api.g_number
193: ,p_setup_type_cd in varchar2 default hr_api.g_varchar2
187: ,p_workflow_enable_flag in varchar2 default hr_api.g_varchar2
188: ,p_enable_flag in varchar2 default hr_api.g_varchar2
189: ,p_timeout_days in number default hr_api.g_number
190: ,p_object_version_number in out nocopy number
191: ,p_consolidated_table_route_id in number default hr_api.g_number
192: ,p_business_group_id in number default hr_api.g_number
193: ,p_setup_type_cd in varchar2 default hr_api.g_varchar2
194: ,p_master_table_route_id in number default hr_api.g_number
195: ,p_effective_date in date
188: ,p_enable_flag in varchar2 default hr_api.g_varchar2
189: ,p_timeout_days in number default hr_api.g_number
190: ,p_object_version_number in out nocopy number
191: ,p_consolidated_table_route_id in number default hr_api.g_number
192: ,p_business_group_id in number default hr_api.g_number
193: ,p_setup_type_cd in varchar2 default hr_api.g_varchar2
194: ,p_master_table_route_id in number default hr_api.g_number
195: ,p_effective_date in date
196: ,p_language_code in varchar2 default hr_api.userenv_lang
189: ,p_timeout_days in number default hr_api.g_number
190: ,p_object_version_number in out nocopy number
191: ,p_consolidated_table_route_id in number default hr_api.g_number
192: ,p_business_group_id in number default hr_api.g_number
193: ,p_setup_type_cd in varchar2 default hr_api.g_varchar2
194: ,p_master_table_route_id in number default hr_api.g_number
195: ,p_effective_date in date
196: ,p_language_code in varchar2 default hr_api.userenv_lang
197: );
190: ,p_object_version_number in out nocopy number
191: ,p_consolidated_table_route_id in number default hr_api.g_number
192: ,p_business_group_id in number default hr_api.g_number
193: ,p_setup_type_cd in varchar2 default hr_api.g_varchar2
194: ,p_master_table_route_id in number default hr_api.g_number
195: ,p_effective_date in date
196: ,p_language_code in varchar2 default hr_api.userenv_lang
197: );
198: --
192: ,p_business_group_id in number default hr_api.g_number
193: ,p_setup_type_cd in varchar2 default hr_api.g_varchar2
194: ,p_master_table_route_id in number default hr_api.g_number
195: ,p_effective_date in date
196: ,p_language_code in varchar2 default hr_api.userenv_lang
197: );
198: --
199: -- ----------------------------------------------------------------------------
200: -- |------------------------< delete_TRAN_CATEGORY >------------------------|