98: Procedure upd
99: (
100: p_effective_date in date,
101: p_input_value_id in number,
102: p_element_type_id in number default hr_api.g_number,
103: p_display_sequence in number default hr_api.g_number,
104: p_generate_db_items_flag in varchar2 default hr_api.g_varchar2,
105: p_hot_default_flag in varchar2 default hr_api.g_varchar2,
106: p_mandatory_flag in varchar2 default hr_api.g_varchar2,
99: (
100: p_effective_date in date,
101: p_input_value_id in number,
102: p_element_type_id in number default hr_api.g_number,
103: p_display_sequence in number default hr_api.g_number,
104: p_generate_db_items_flag in varchar2 default hr_api.g_varchar2,
105: p_hot_default_flag in varchar2 default hr_api.g_varchar2,
106: p_mandatory_flag in varchar2 default hr_api.g_varchar2,
107: p_name in varchar2 default hr_api.g_varchar2,
100: p_effective_date in date,
101: p_input_value_id in number,
102: p_element_type_id in number default hr_api.g_number,
103: p_display_sequence in number default hr_api.g_number,
104: p_generate_db_items_flag in varchar2 default hr_api.g_varchar2,
105: p_hot_default_flag in varchar2 default hr_api.g_varchar2,
106: p_mandatory_flag in varchar2 default hr_api.g_varchar2,
107: p_name in varchar2 default hr_api.g_varchar2,
108: p_uom in varchar2 default hr_api.g_varchar2,
101: p_input_value_id in number,
102: p_element_type_id in number default hr_api.g_number,
103: p_display_sequence in number default hr_api.g_number,
104: p_generate_db_items_flag in varchar2 default hr_api.g_varchar2,
105: p_hot_default_flag in varchar2 default hr_api.g_varchar2,
106: p_mandatory_flag in varchar2 default hr_api.g_varchar2,
107: p_name in varchar2 default hr_api.g_varchar2,
108: p_uom in varchar2 default hr_api.g_varchar2,
109: p_lookup_type in varchar2 default hr_api.g_varchar2,
102: p_element_type_id in number default hr_api.g_number,
103: p_display_sequence in number default hr_api.g_number,
104: p_generate_db_items_flag in varchar2 default hr_api.g_varchar2,
105: p_hot_default_flag in varchar2 default hr_api.g_varchar2,
106: p_mandatory_flag in varchar2 default hr_api.g_varchar2,
107: p_name in varchar2 default hr_api.g_varchar2,
108: p_uom in varchar2 default hr_api.g_varchar2,
109: p_lookup_type in varchar2 default hr_api.g_varchar2,
110: p_default_value in varchar2 default hr_api.g_varchar2,
103: p_display_sequence in number default hr_api.g_number,
104: p_generate_db_items_flag in varchar2 default hr_api.g_varchar2,
105: p_hot_default_flag in varchar2 default hr_api.g_varchar2,
106: p_mandatory_flag in varchar2 default hr_api.g_varchar2,
107: p_name in varchar2 default hr_api.g_varchar2,
108: p_uom in varchar2 default hr_api.g_varchar2,
109: p_lookup_type in varchar2 default hr_api.g_varchar2,
110: p_default_value in varchar2 default hr_api.g_varchar2,
111: p_max_value in varchar2 default hr_api.g_varchar2,
104: p_generate_db_items_flag in varchar2 default hr_api.g_varchar2,
105: p_hot_default_flag in varchar2 default hr_api.g_varchar2,
106: p_mandatory_flag in varchar2 default hr_api.g_varchar2,
107: p_name in varchar2 default hr_api.g_varchar2,
108: p_uom in varchar2 default hr_api.g_varchar2,
109: p_lookup_type in varchar2 default hr_api.g_varchar2,
110: p_default_value in varchar2 default hr_api.g_varchar2,
111: p_max_value in varchar2 default hr_api.g_varchar2,
112: p_min_value in varchar2 default hr_api.g_varchar2,
105: p_hot_default_flag in varchar2 default hr_api.g_varchar2,
106: p_mandatory_flag in varchar2 default hr_api.g_varchar2,
107: p_name in varchar2 default hr_api.g_varchar2,
108: p_uom in varchar2 default hr_api.g_varchar2,
109: p_lookup_type in varchar2 default hr_api.g_varchar2,
110: p_default_value in varchar2 default hr_api.g_varchar2,
111: p_max_value in varchar2 default hr_api.g_varchar2,
112: p_min_value in varchar2 default hr_api.g_varchar2,
113: p_warning_or_error in varchar2 default hr_api.g_varchar2,
106: p_mandatory_flag in varchar2 default hr_api.g_varchar2,
107: p_name in varchar2 default hr_api.g_varchar2,
108: p_uom in varchar2 default hr_api.g_varchar2,
109: p_lookup_type in varchar2 default hr_api.g_varchar2,
110: p_default_value in varchar2 default hr_api.g_varchar2,
111: p_max_value in varchar2 default hr_api.g_varchar2,
112: p_min_value in varchar2 default hr_api.g_varchar2,
113: p_warning_or_error in varchar2 default hr_api.g_varchar2,
114: p_default_value_column in varchar2 default hr_api.g_varchar2,
107: p_name in varchar2 default hr_api.g_varchar2,
108: p_uom in varchar2 default hr_api.g_varchar2,
109: p_lookup_type in varchar2 default hr_api.g_varchar2,
110: p_default_value in varchar2 default hr_api.g_varchar2,
111: p_max_value in varchar2 default hr_api.g_varchar2,
112: p_min_value in varchar2 default hr_api.g_varchar2,
113: p_warning_or_error in varchar2 default hr_api.g_varchar2,
114: p_default_value_column in varchar2 default hr_api.g_varchar2,
115: p_exclusion_rule_id in number default hr_api.g_number,
108: p_uom in varchar2 default hr_api.g_varchar2,
109: p_lookup_type in varchar2 default hr_api.g_varchar2,
110: p_default_value in varchar2 default hr_api.g_varchar2,
111: p_max_value in varchar2 default hr_api.g_varchar2,
112: p_min_value in varchar2 default hr_api.g_varchar2,
113: p_warning_or_error in varchar2 default hr_api.g_varchar2,
114: p_default_value_column in varchar2 default hr_api.g_varchar2,
115: p_exclusion_rule_id in number default hr_api.g_number,
116: p_formula_id in number default hr_api.g_number,
109: p_lookup_type in varchar2 default hr_api.g_varchar2,
110: p_default_value in varchar2 default hr_api.g_varchar2,
111: p_max_value in varchar2 default hr_api.g_varchar2,
112: p_min_value in varchar2 default hr_api.g_varchar2,
113: p_warning_or_error in varchar2 default hr_api.g_varchar2,
114: p_default_value_column in varchar2 default hr_api.g_varchar2,
115: p_exclusion_rule_id in number default hr_api.g_number,
116: p_formula_id in number default hr_api.g_number,
117: p_input_validation_formula in varchar2 default hr_api.g_varchar2,
110: p_default_value in varchar2 default hr_api.g_varchar2,
111: p_max_value in varchar2 default hr_api.g_varchar2,
112: p_min_value in varchar2 default hr_api.g_varchar2,
113: p_warning_or_error in varchar2 default hr_api.g_varchar2,
114: p_default_value_column in varchar2 default hr_api.g_varchar2,
115: p_exclusion_rule_id in number default hr_api.g_number,
116: p_formula_id in number default hr_api.g_number,
117: p_input_validation_formula in varchar2 default hr_api.g_varchar2,
118: p_object_version_number in out nocopy number
111: p_max_value in varchar2 default hr_api.g_varchar2,
112: p_min_value in varchar2 default hr_api.g_varchar2,
113: p_warning_or_error in varchar2 default hr_api.g_varchar2,
114: p_default_value_column in varchar2 default hr_api.g_varchar2,
115: p_exclusion_rule_id in number default hr_api.g_number,
116: p_formula_id in number default hr_api.g_number,
117: p_input_validation_formula in varchar2 default hr_api.g_varchar2,
118: p_object_version_number in out nocopy number
119: );
112: p_min_value in varchar2 default hr_api.g_varchar2,
113: p_warning_or_error in varchar2 default hr_api.g_varchar2,
114: p_default_value_column in varchar2 default hr_api.g_varchar2,
115: p_exclusion_rule_id in number default hr_api.g_number,
116: p_formula_id in number default hr_api.g_number,
117: p_input_validation_formula in varchar2 default hr_api.g_varchar2,
118: p_object_version_number in out nocopy number
119: );
120: --
113: p_warning_or_error in varchar2 default hr_api.g_varchar2,
114: p_default_value_column in varchar2 default hr_api.g_varchar2,
115: p_exclusion_rule_id in number default hr_api.g_number,
116: p_formula_id in number default hr_api.g_number,
117: p_input_validation_formula in varchar2 default hr_api.g_varchar2,
118: p_object_version_number in out nocopy number
119: );
120: --
121: end pay_siv_upd;