66: --
67: --
68: -- Parameter validation
69: --
70: hr_api.mandatory_arg_error(p_api_name => l_proc,
71: p_argument => 'event',
72: p_argument_value => p_event);
73: --
74: hr_api.mandatory_arg_error(p_api_name => l_proc,
70: hr_api.mandatory_arg_error(p_api_name => l_proc,
71: p_argument => 'event',
72: p_argument_value => p_event);
73: --
74: hr_api.mandatory_arg_error(p_api_name => l_proc,
75: p_argument => 'table_name',
76: p_argument_value => p_table_name);
77: --
78: hr_api.mandatory_arg_error(p_api_name => l_proc,
74: hr_api.mandatory_arg_error(p_api_name => l_proc,
75: p_argument => 'table_name',
76: p_argument_value => p_table_name);
77: --
78: hr_api.mandatory_arg_error(p_api_name => l_proc,
79: p_argument => 'column name',
80: p_argument_value => p_col_name);
81: --
82: hr_api.mandatory_arg_error(p_api_name => l_proc,
78: hr_api.mandatory_arg_error(p_api_name => l_proc,
79: p_argument => 'column name',
80: p_argument_value => p_col_name);
81: --
82: hr_api.mandatory_arg_error(p_api_name => l_proc,
83: p_argument => 'column_id',
84: p_argument_value => p_col_id);
85:
86: -- Bug 3431740 Parameter p_oracle_schema added to cursor c1, the value is got by the
200: --
201: --
202: -- Parameter validation
203: --
204: hr_api.mandatory_arg_error(p_api_name => l_proc,
205: p_argument => 'event',
206: p_argument_value => p_event);
207: hr_api.mandatory_arg_error(p_api_name => l_proc,
208: p_argument => 'eligy prfl id',
203: --
204: hr_api.mandatory_arg_error(p_api_name => l_proc,
205: p_argument => 'event',
206: p_argument_value => p_event);
207: hr_api.mandatory_arg_error(p_api_name => l_proc,
208: p_argument => 'eligy prfl id',
209: p_argument_value => p_eligy_prfl_id);
210: --
211: if p_event not in ('CREATE','DELETE') then