101: procedure update_ext_where_clause
102: (
103: p_validate in boolean default false
104: ,p_ext_where_clause_id in number
105: ,p_seq_num in number default hr_api.g_number
106: ,p_oper_cd in varchar2 default hr_api.g_varchar2
107: ,p_val in varchar2 default hr_api.g_varchar2
108: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
109: ,p_ext_data_elmt_id in number default hr_api.g_number
102: (
103: p_validate in boolean default false
104: ,p_ext_where_clause_id in number
105: ,p_seq_num in number default hr_api.g_number
106: ,p_oper_cd in varchar2 default hr_api.g_varchar2
107: ,p_val in varchar2 default hr_api.g_varchar2
108: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
109: ,p_ext_data_elmt_id in number default hr_api.g_number
110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
103: p_validate in boolean default false
104: ,p_ext_where_clause_id in number
105: ,p_seq_num in number default hr_api.g_number
106: ,p_oper_cd in varchar2 default hr_api.g_varchar2
107: ,p_val in varchar2 default hr_api.g_varchar2
108: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
109: ,p_ext_data_elmt_id in number default hr_api.g_number
110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
111: ,p_ext_rcd_in_file_id in number default hr_api.g_number
104: ,p_ext_where_clause_id in number
105: ,p_seq_num in number default hr_api.g_number
106: ,p_oper_cd in varchar2 default hr_api.g_varchar2
107: ,p_val in varchar2 default hr_api.g_varchar2
108: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
109: ,p_ext_data_elmt_id in number default hr_api.g_number
110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
111: ,p_ext_rcd_in_file_id in number default hr_api.g_number
112: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
105: ,p_seq_num in number default hr_api.g_number
106: ,p_oper_cd in varchar2 default hr_api.g_varchar2
107: ,p_val in varchar2 default hr_api.g_varchar2
108: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
109: ,p_ext_data_elmt_id in number default hr_api.g_number
110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
111: ,p_ext_rcd_in_file_id in number default hr_api.g_number
112: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
113: ,p_business_group_id in number default hr_api.g_number
106: ,p_oper_cd in varchar2 default hr_api.g_varchar2
107: ,p_val in varchar2 default hr_api.g_varchar2
108: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
109: ,p_ext_data_elmt_id in number default hr_api.g_number
110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
111: ,p_ext_rcd_in_file_id in number default hr_api.g_number
112: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
113: ,p_business_group_id in number default hr_api.g_number
114: ,p_legislation_code in varchar2 default hr_api.g_varchar2
107: ,p_val in varchar2 default hr_api.g_varchar2
108: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
109: ,p_ext_data_elmt_id in number default hr_api.g_number
110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
111: ,p_ext_rcd_in_file_id in number default hr_api.g_number
112: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
113: ,p_business_group_id in number default hr_api.g_number
114: ,p_legislation_code in varchar2 default hr_api.g_varchar2
115: ,p_object_version_number in out nocopy number
108: ,p_and_or_cd in varchar2 default hr_api.g_varchar2
109: ,p_ext_data_elmt_id in number default hr_api.g_number
110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
111: ,p_ext_rcd_in_file_id in number default hr_api.g_number
112: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
113: ,p_business_group_id in number default hr_api.g_number
114: ,p_legislation_code in varchar2 default hr_api.g_varchar2
115: ,p_object_version_number in out nocopy number
116: ,p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number
109: ,p_ext_data_elmt_id in number default hr_api.g_number
110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
111: ,p_ext_rcd_in_file_id in number default hr_api.g_number
112: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
113: ,p_business_group_id in number default hr_api.g_number
114: ,p_legislation_code in varchar2 default hr_api.g_varchar2
115: ,p_object_version_number in out nocopy number
116: ,p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number
117: ,p_effective_date in date
110: ,p_cond_ext_data_elmt_id in number default hr_api.g_number
111: ,p_ext_rcd_in_file_id in number default hr_api.g_number
112: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
113: ,p_business_group_id in number default hr_api.g_number
114: ,p_legislation_code in varchar2 default hr_api.g_varchar2
115: ,p_object_version_number in out nocopy number
116: ,p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number
117: ,p_effective_date in date
118: );
112: ,p_ext_data_elmt_in_rcd_id in number default hr_api.g_number
113: ,p_business_group_id in number default hr_api.g_number
114: ,p_legislation_code in varchar2 default hr_api.g_varchar2
115: ,p_object_version_number in out nocopy number
116: ,p_cond_ext_data_elmt_in_rcd_id in number default hr_api.g_number
117: ,p_effective_date in date
118: );
119: --
120: -- ----------------------------------------------------------------------------