99: Procedure upd
100: (
101: p_effective_date in date,
102: p_attribute_range_id in number,
103: p_approver_flag in varchar2 default hr_api.g_varchar2,
104: p_enable_flag in varchar2 default hr_api.g_varchar2,
105: p_delete_flag in varchar2 default hr_api.g_varchar2,
106: p_assignment_id in number default hr_api.g_number,
107: p_attribute_id in number default hr_api.g_number,
100: (
101: p_effective_date in date,
102: p_attribute_range_id in number,
103: p_approver_flag in varchar2 default hr_api.g_varchar2,
104: p_enable_flag in varchar2 default hr_api.g_varchar2,
105: p_delete_flag in varchar2 default hr_api.g_varchar2,
106: p_assignment_id in number default hr_api.g_number,
107: p_attribute_id in number default hr_api.g_number,
108: p_from_char in varchar2 default hr_api.g_varchar2,
101: p_effective_date in date,
102: p_attribute_range_id in number,
103: p_approver_flag in varchar2 default hr_api.g_varchar2,
104: p_enable_flag in varchar2 default hr_api.g_varchar2,
105: p_delete_flag in varchar2 default hr_api.g_varchar2,
106: p_assignment_id in number default hr_api.g_number,
107: p_attribute_id in number default hr_api.g_number,
108: p_from_char in varchar2 default hr_api.g_varchar2,
109: p_from_date in date default hr_api.g_date,
102: p_attribute_range_id in number,
103: p_approver_flag in varchar2 default hr_api.g_varchar2,
104: p_enable_flag in varchar2 default hr_api.g_varchar2,
105: p_delete_flag in varchar2 default hr_api.g_varchar2,
106: p_assignment_id in number default hr_api.g_number,
107: p_attribute_id in number default hr_api.g_number,
108: p_from_char in varchar2 default hr_api.g_varchar2,
109: p_from_date in date default hr_api.g_date,
110: p_from_number in number default hr_api.g_number,
103: p_approver_flag in varchar2 default hr_api.g_varchar2,
104: p_enable_flag in varchar2 default hr_api.g_varchar2,
105: p_delete_flag in varchar2 default hr_api.g_varchar2,
106: p_assignment_id in number default hr_api.g_number,
107: p_attribute_id in number default hr_api.g_number,
108: p_from_char in varchar2 default hr_api.g_varchar2,
109: p_from_date in date default hr_api.g_date,
110: p_from_number in number default hr_api.g_number,
111: p_position_id in number default hr_api.g_number,
104: p_enable_flag in varchar2 default hr_api.g_varchar2,
105: p_delete_flag in varchar2 default hr_api.g_varchar2,
106: p_assignment_id in number default hr_api.g_number,
107: p_attribute_id in number default hr_api.g_number,
108: p_from_char in varchar2 default hr_api.g_varchar2,
109: p_from_date in date default hr_api.g_date,
110: p_from_number in number default hr_api.g_number,
111: p_position_id in number default hr_api.g_number,
112: p_range_name in varchar2 default hr_api.g_varchar2,
105: p_delete_flag in varchar2 default hr_api.g_varchar2,
106: p_assignment_id in number default hr_api.g_number,
107: p_attribute_id in number default hr_api.g_number,
108: p_from_char in varchar2 default hr_api.g_varchar2,
109: p_from_date in date default hr_api.g_date,
110: p_from_number in number default hr_api.g_number,
111: p_position_id in number default hr_api.g_number,
112: p_range_name in varchar2 default hr_api.g_varchar2,
113: p_routing_category_id in number default hr_api.g_number,
106: p_assignment_id in number default hr_api.g_number,
107: p_attribute_id in number default hr_api.g_number,
108: p_from_char in varchar2 default hr_api.g_varchar2,
109: p_from_date in date default hr_api.g_date,
110: p_from_number in number default hr_api.g_number,
111: p_position_id in number default hr_api.g_number,
112: p_range_name in varchar2 default hr_api.g_varchar2,
113: p_routing_category_id in number default hr_api.g_number,
114: p_routing_list_member_id in number default hr_api.g_number,
107: p_attribute_id in number default hr_api.g_number,
108: p_from_char in varchar2 default hr_api.g_varchar2,
109: p_from_date in date default hr_api.g_date,
110: p_from_number in number default hr_api.g_number,
111: p_position_id in number default hr_api.g_number,
112: p_range_name in varchar2 default hr_api.g_varchar2,
113: p_routing_category_id in number default hr_api.g_number,
114: p_routing_list_member_id in number default hr_api.g_number,
115: p_to_char in varchar2 default hr_api.g_varchar2,
108: p_from_char in varchar2 default hr_api.g_varchar2,
109: p_from_date in date default hr_api.g_date,
110: p_from_number in number default hr_api.g_number,
111: p_position_id in number default hr_api.g_number,
112: p_range_name in varchar2 default hr_api.g_varchar2,
113: p_routing_category_id in number default hr_api.g_number,
114: p_routing_list_member_id in number default hr_api.g_number,
115: p_to_char in varchar2 default hr_api.g_varchar2,
116: p_to_date in date default hr_api.g_date,
109: p_from_date in date default hr_api.g_date,
110: p_from_number in number default hr_api.g_number,
111: p_position_id in number default hr_api.g_number,
112: p_range_name in varchar2 default hr_api.g_varchar2,
113: p_routing_category_id in number default hr_api.g_number,
114: p_routing_list_member_id in number default hr_api.g_number,
115: p_to_char in varchar2 default hr_api.g_varchar2,
116: p_to_date in date default hr_api.g_date,
117: p_to_number in number default hr_api.g_number,
110: p_from_number in number default hr_api.g_number,
111: p_position_id in number default hr_api.g_number,
112: p_range_name in varchar2 default hr_api.g_varchar2,
113: p_routing_category_id in number default hr_api.g_number,
114: p_routing_list_member_id in number default hr_api.g_number,
115: p_to_char in varchar2 default hr_api.g_varchar2,
116: p_to_date in date default hr_api.g_date,
117: p_to_number in number default hr_api.g_number,
118: p_object_version_number in out nocopy number
111: p_position_id in number default hr_api.g_number,
112: p_range_name in varchar2 default hr_api.g_varchar2,
113: p_routing_category_id in number default hr_api.g_number,
114: p_routing_list_member_id in number default hr_api.g_number,
115: p_to_char in varchar2 default hr_api.g_varchar2,
116: p_to_date in date default hr_api.g_date,
117: p_to_number in number default hr_api.g_number,
118: p_object_version_number in out nocopy number
119: );
112: p_range_name in varchar2 default hr_api.g_varchar2,
113: p_routing_category_id in number default hr_api.g_number,
114: p_routing_list_member_id in number default hr_api.g_number,
115: p_to_char in varchar2 default hr_api.g_varchar2,
116: p_to_date in date default hr_api.g_date,
117: p_to_number in number default hr_api.g_number,
118: p_object_version_number in out nocopy number
119: );
120: --
113: p_routing_category_id in number default hr_api.g_number,
114: p_routing_list_member_id in number default hr_api.g_number,
115: p_to_char in varchar2 default hr_api.g_varchar2,
116: p_to_date in date default hr_api.g_date,
117: p_to_number in number default hr_api.g_number,
118: p_object_version_number in out nocopy number
119: );
120: --
121: end pqh_rng_upd;