198: l_text varchar2(80);
199: l_number integer;
200: --
201: BEGIN
202: hr_utility.set_location('Adding to hr_api_user_hook_reports',99);
203: --
204: hr_utility.set_location('Adding for line: '||to_char(g_number),1);
205: --
206: IF p_constraint = 'HEADER' and p_table = 'HEADER' THEN
200: --
201: BEGIN
202: hr_utility.set_location('Adding to hr_api_user_hook_reports',99);
203: --
204: hr_utility.set_location('Adding for line: '||to_char(g_number),1);
205: --
206: IF p_constraint = 'HEADER' and p_table = 'HEADER' THEN
207: l_text :=
208: 'TABLE CONSTRAINT CODE STATUS';