APPS.HR_INDEX_CHECK dependencies on HR_API_USER_HOOK_REPORTS

Line 183: insert into hr_api_user_hook_reports

179: -- |--------------------------< insert_line >--------------------------------|
180: -- ---------------------------------------------------------------------------
181: PROCEDURE insert_line(p_line IN varchar2) IS
182: BEGIN
183: insert into hr_api_user_hook_reports
184: (session_id,
185: line,
186: text)
187: values

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

266: l_text varchar2(80);
267: l_number integer;
268: --
269: BEGIN
270: hr_utility.set_location('Adding to hr_api_user_hook_reports',99);
271: --
272: hr_utility.set_location('Adding for line: '||to_char(g_number),1);
273: --
274: IF p_index = 'HEADER' and p_table = 'HEADER' THEN

Line 280: insert into hr_api_user_hook_reports

276: l_text :=
277: 'TABLE INDEX CODE STATUS';
278: --
279: -- Insert report header
280: insert into hr_api_user_hook_reports
281: (session_id,
282: line,
283: text)
284: values

Line 292: insert into hr_api_user_hook_reports

288: -- Increment line counter
289: g_number := g_number + 1;
290: l_text :=
291: '-----------------------------------------------------------------------------';
292: insert into hr_api_user_hook_reports
293: (session_id,
294: line,
295: text)
296: values

Line 304: insert into hr_api_user_hook_reports

300: -- Increment line counter
301: ELSIF p_index = 'FOOTER' and p_table = 'FOOTER' THEN
302: l_text :=
303: 'End of Report ';
304: insert into hr_api_user_hook_reports
305: (session_id,
306: line,
307: text)
308: values

Line 313: insert into hr_api_user_hook_reports

309: (userenv('SESSIONID'),
310: g_number,
311: l_text);
312: g_number := g_number + 1;
313: insert into hr_api_user_hook_reports
314: (session_id,
315: line,
316: text)
317: values

Line 333: insert into hr_api_user_hook_reports

329: l_text := l_text || '1 Not in DB';
330: END IF;
331: -- Insert values into results table
332: --
333: insert into hr_api_user_hook_reports
334: (session_id,
335: line,
336: text)
337: values

Line 476: insert into hr_api_user_hook_reports

472: --
473: l_line := rpad('TABLE',30) || ' ' || rpad('INDEX',30)
474: || ' ' || 'CODE STATUS';
475: --
476: insert into hr_api_user_hook_reports
477: (session_id,
478: line,
479: text)
480: values

Line 489: insert into hr_api_user_hook_reports

485: g_number := g_number + 1;
486: --
487: l_line := '-----------------------------------------------------------------------------';
488: --
489: insert into hr_api_user_hook_reports
490: (session_id,
491: line,
492: text)
493: values