77: --
78: --
79: -- Parameter validation
80: --
81: hr_api.mandatory_arg_error(p_api_name => l_proc,
82: p_argument => 'event',
83: p_argument_value => p_event);
84: --
85: hr_api.mandatory_arg_error(p_api_name => l_proc,
81: hr_api.mandatory_arg_error(p_api_name => l_proc,
82: p_argument => 'event',
83: p_argument_value => p_event);
84: --
85: hr_api.mandatory_arg_error(p_api_name => l_proc,
86: p_argument => 'table_name',
87: p_argument_value => p_table_name);
88: --
89: hr_api.mandatory_arg_error(p_api_name => l_proc,
85: hr_api.mandatory_arg_error(p_api_name => l_proc,
86: p_argument => 'table_name',
87: p_argument_value => p_table_name);
88: --
89: hr_api.mandatory_arg_error(p_api_name => l_proc,
90: p_argument => 'column name',
91: p_argument_value => p_col_name);
92: --
93: hr_api.mandatory_arg_error(p_api_name => l_proc,
89: hr_api.mandatory_arg_error(p_api_name => l_proc,
90: p_argument => 'column name',
91: p_argument_value => p_col_name);
92: --
93: hr_api.mandatory_arg_error(p_api_name => l_proc,
94: p_argument => 'column_id',
95: p_argument_value => p_col_id);
96: --
97: -- Bug 3431740 Parameter p_oracle_schema added to cursor c1, the value is got by the
512: hr_utility.set_location('Entering '||l_proc,10);
513: --
514: -- Parameter validation
515: --
516: hr_api.mandatory_arg_error(p_api_name => l_proc,
517: p_argument => 'event',
518: p_argument_value => p_event);
519: hr_api.mandatory_arg_error(p_api_name => l_proc,
520: p_argument => 'vrbl_rt prfl id',
515: --
516: hr_api.mandatory_arg_error(p_api_name => l_proc,
517: p_argument => 'event',
518: p_argument_value => p_event);
519: hr_api.mandatory_arg_error(p_api_name => l_proc,
520: p_argument => 'vrbl_rt prfl id',
521: p_argument_value => p_vrbl_rt_prfl_id);
522: --
523: if p_event not in ('CREATE','DELETE') then