71: --
72: --
73: -- Parameter validation
74: --
75: hr_api.mandatory_arg_error(p_api_name => l_proc,
76: p_argument => 'event',
77: p_argument_value => p_event);
78: --
79: hr_api.mandatory_arg_error(p_api_name => l_proc,
75: hr_api.mandatory_arg_error(p_api_name => l_proc,
76: p_argument => 'event',
77: p_argument_value => p_event);
78: --
79: hr_api.mandatory_arg_error(p_api_name => l_proc,
80: p_argument => 'table_name',
81: p_argument_value => p_table_name);
82: --
83: hr_api.mandatory_arg_error(p_api_name => l_proc,
79: hr_api.mandatory_arg_error(p_api_name => l_proc,
80: p_argument => 'table_name',
81: p_argument_value => p_table_name);
82: --
83: hr_api.mandatory_arg_error(p_api_name => l_proc,
84: p_argument => 'column name',
85: p_argument_value => p_col_name);
86: --
87: hr_api.mandatory_arg_error(p_api_name => l_proc,
83: hr_api.mandatory_arg_error(p_api_name => l_proc,
84: p_argument => 'column name',
85: p_argument_value => p_col_name);
86: --
87: hr_api.mandatory_arg_error(p_api_name => l_proc,
88: p_argument => 'column_id',
89: p_argument_value => p_col_id);
90:
91: -- Bug 3431740 Parameter p_oracle_schema added to cursor c1, the value is got by the
205: --
206: --
207: -- Parameter validation
208: --
209: hr_api.mandatory_arg_error(p_api_name => l_proc,
210: p_argument => 'event',
211: p_argument_value => p_event);
212: hr_api.mandatory_arg_error(p_api_name => l_proc,
213: p_argument => 'eligy prfl id',
208: --
209: hr_api.mandatory_arg_error(p_api_name => l_proc,
210: p_argument => 'event',
211: p_argument_value => p_event);
212: hr_api.mandatory_arg_error(p_api_name => l_proc,
213: p_argument => 'eligy prfl id',
214: p_argument_value => p_eligy_prfl_id);
215: --
216: if p_event not in ('CREATE','DELETE') then