100: Procedure upd
101: (
102: p_effective_date in date,
103: p_txn_category_attribute_id in number,
104: p_attribute_id in number default hr_api.g_number,
105: p_transaction_category_id in number default hr_api.g_number,
106: p_value_set_id in number default hr_api.g_number,
107: p_object_version_number in out nocopy number,
108: p_transaction_table_route_id in number default hr_api.g_number,
101: (
102: p_effective_date in date,
103: p_txn_category_attribute_id in number,
104: p_attribute_id in number default hr_api.g_number,
105: p_transaction_category_id in number default hr_api.g_number,
106: p_value_set_id in number default hr_api.g_number,
107: p_object_version_number in out nocopy number,
108: p_transaction_table_route_id in number default hr_api.g_number,
109: p_form_column_name in varchar2 default hr_api.g_varchar2,
102: p_effective_date in date,
103: p_txn_category_attribute_id in number,
104: p_attribute_id in number default hr_api.g_number,
105: p_transaction_category_id in number default hr_api.g_number,
106: p_value_set_id in number default hr_api.g_number,
107: p_object_version_number in out nocopy number,
108: p_transaction_table_route_id in number default hr_api.g_number,
109: p_form_column_name in varchar2 default hr_api.g_varchar2,
110: p_identifier_flag in varchar2 default hr_api.g_varchar2,
104: p_attribute_id in number default hr_api.g_number,
105: p_transaction_category_id in number default hr_api.g_number,
106: p_value_set_id in number default hr_api.g_number,
107: p_object_version_number in out nocopy number,
108: p_transaction_table_route_id in number default hr_api.g_number,
109: p_form_column_name in varchar2 default hr_api.g_varchar2,
110: p_identifier_flag in varchar2 default hr_api.g_varchar2,
111: p_list_identifying_flag in varchar2 default hr_api.g_varchar2,
112: p_member_identifying_flag in varchar2 default hr_api.g_varchar2,
105: p_transaction_category_id in number default hr_api.g_number,
106: p_value_set_id in number default hr_api.g_number,
107: p_object_version_number in out nocopy number,
108: p_transaction_table_route_id in number default hr_api.g_number,
109: p_form_column_name in varchar2 default hr_api.g_varchar2,
110: p_identifier_flag in varchar2 default hr_api.g_varchar2,
111: p_list_identifying_flag in varchar2 default hr_api.g_varchar2,
112: p_member_identifying_flag in varchar2 default hr_api.g_varchar2,
113: p_refresh_flag in varchar2 default hr_api.g_varchar2,
106: p_value_set_id in number default hr_api.g_number,
107: p_object_version_number in out nocopy number,
108: p_transaction_table_route_id in number default hr_api.g_number,
109: p_form_column_name in varchar2 default hr_api.g_varchar2,
110: p_identifier_flag in varchar2 default hr_api.g_varchar2,
111: p_list_identifying_flag in varchar2 default hr_api.g_varchar2,
112: p_member_identifying_flag in varchar2 default hr_api.g_varchar2,
113: p_refresh_flag in varchar2 default hr_api.g_varchar2,
114: p_select_flag in varchar2 default hr_api.g_varchar2,
107: p_object_version_number in out nocopy number,
108: p_transaction_table_route_id in number default hr_api.g_number,
109: p_form_column_name in varchar2 default hr_api.g_varchar2,
110: p_identifier_flag in varchar2 default hr_api.g_varchar2,
111: p_list_identifying_flag in varchar2 default hr_api.g_varchar2,
112: p_member_identifying_flag in varchar2 default hr_api.g_varchar2,
113: p_refresh_flag in varchar2 default hr_api.g_varchar2,
114: p_select_flag in varchar2 default hr_api.g_varchar2,
115: p_value_style_cd in varchar2 default hr_api.g_varchar2,
108: p_transaction_table_route_id in number default hr_api.g_number,
109: p_form_column_name in varchar2 default hr_api.g_varchar2,
110: p_identifier_flag in varchar2 default hr_api.g_varchar2,
111: p_list_identifying_flag in varchar2 default hr_api.g_varchar2,
112: p_member_identifying_flag in varchar2 default hr_api.g_varchar2,
113: p_refresh_flag in varchar2 default hr_api.g_varchar2,
114: p_select_flag in varchar2 default hr_api.g_varchar2,
115: p_value_style_cd in varchar2 default hr_api.g_varchar2,
116: p_delete_attr_ranges_flag in varchar2 default hr_api.g_varchar2
109: p_form_column_name in varchar2 default hr_api.g_varchar2,
110: p_identifier_flag in varchar2 default hr_api.g_varchar2,
111: p_list_identifying_flag in varchar2 default hr_api.g_varchar2,
112: p_member_identifying_flag in varchar2 default hr_api.g_varchar2,
113: p_refresh_flag in varchar2 default hr_api.g_varchar2,
114: p_select_flag in varchar2 default hr_api.g_varchar2,
115: p_value_style_cd in varchar2 default hr_api.g_varchar2,
116: p_delete_attr_ranges_flag in varchar2 default hr_api.g_varchar2
117: );
110: p_identifier_flag in varchar2 default hr_api.g_varchar2,
111: p_list_identifying_flag in varchar2 default hr_api.g_varchar2,
112: p_member_identifying_flag in varchar2 default hr_api.g_varchar2,
113: p_refresh_flag in varchar2 default hr_api.g_varchar2,
114: p_select_flag in varchar2 default hr_api.g_varchar2,
115: p_value_style_cd in varchar2 default hr_api.g_varchar2,
116: p_delete_attr_ranges_flag in varchar2 default hr_api.g_varchar2
117: );
118: --
111: p_list_identifying_flag in varchar2 default hr_api.g_varchar2,
112: p_member_identifying_flag in varchar2 default hr_api.g_varchar2,
113: p_refresh_flag in varchar2 default hr_api.g_varchar2,
114: p_select_flag in varchar2 default hr_api.g_varchar2,
115: p_value_style_cd in varchar2 default hr_api.g_varchar2,
116: p_delete_attr_ranges_flag in varchar2 default hr_api.g_varchar2
117: );
118: --
119: end pqh_tca_upd;
112: p_member_identifying_flag in varchar2 default hr_api.g_varchar2,
113: p_refresh_flag in varchar2 default hr_api.g_varchar2,
114: p_select_flag in varchar2 default hr_api.g_varchar2,
115: p_value_style_cd in varchar2 default hr_api.g_varchar2,
116: p_delete_attr_ranges_flag in varchar2 default hr_api.g_varchar2
117: );
118: --
119: end pqh_tca_upd;