APPS.HR_CONSTRAINT_CHECK dependencies on HR_API_USER_HOOK_REPORTS

Line 202: hr_utility.set_location('Adding to hr_api_user_hook_reports',99);

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

Line 211: insert into hr_api_user_hook_reports

207: l_text :=
208: 'TABLE CONSTRAINT CODE STATUS';
209: --
210: -- Insert report header
211: insert into hr_api_user_hook_reports
212: (session_id,
213: line,
214: text)
215: values

Line 223: insert into hr_api_user_hook_reports

219: -- Increment line counter
220: g_number := g_number + 1;
221: l_text :=
222: '-----------------------------------------------------------------------------';
223: insert into hr_api_user_hook_reports
224: (session_id,
225: line,
226: text)
227: values

Line 235: insert into hr_api_user_hook_reports

231: -- Increment line counter
232: ELSIF p_constraint = 'FOOTER' and p_table = 'FOOTER' THEN
233: l_text :=
234: 'End of Report ';
235: insert into hr_api_user_hook_reports
236: (session_id,
237: line,
238: text)
239: values

Line 244: insert into hr_api_user_hook_reports

240: (userenv('SESSIONID'),
241: g_number,
242: l_text);
243: g_number := g_number + 1;
244: insert into hr_api_user_hook_reports
245: (session_id,
246: line,
247: text)
248: values

Line 262: insert into hr_api_user_hook_reports

258: l_text := l_text || '1 Not in DB';
259: END IF;
260: -- Insert values into results table
261: --
262: insert into hr_api_user_hook_reports
263: (session_id,
264: line,
265: text)
266: values