eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HRI_STRUCT_SUMMARY dependencies on HRI_GEN_HRCHY_SUMMARY

Line 61: -- TABLE: HRI_GEN_HRCHY_SUMMARY

57: --------------------------------------------------------------------------------
58: --------------------------------------------------------------------------------
59: -- GENERIC HIERARCHY FUNCTIONS
60: --
61: -- TABLE: HRI_GEN_HRCHY_SUMMARY
62: --------------------------------------------------------------------------------
63: --------------------------------------------------------------------------------
64:
65: --------------------------------------------------------------------------------

Line 292: output('Truncate Table HRI_GEN_HRCHY_SUMMARY');

288: l_schema VARCHAR2(400);
289:
290: BEGIN
291:
292: output('Truncate Table HRI_GEN_HRCHY_SUMMARY');
293:
294: --Clear the table
295: IF fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema) THEN
296: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_GEN_HRCHY_SUMMARY';

Line 296: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_GEN_HRCHY_SUMMARY';

292: output('Truncate Table HRI_GEN_HRCHY_SUMMARY');
293:
294: --Clear the table
295: IF fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema) THEN
296: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_GEN_HRCHY_SUMMARY';
297: EXECUTE IMMEDIATE(l_sql_stmt);
298: END IF;
299:
300:

Line 342: HRI_GEN_HRCHY_SUMMARY

338: -- below itself in the collection table.
339:
340: --Insert into table
341: INSERT INTO
342: HRI_GEN_HRCHY_SUMMARY
343: (hierarchy_id
344: ,hierarchy_version_id
345: ,business_group_id
346: ,hierarchy_node_id

Line 355: /* -- This done by trigger HRI_GEN_HRCHY_SUMMARY_WHO

351: ,sub_hierarchy_node_id
352: ,sub_entity_id
353: ,sub_entity_level
354: ,sub_node_type
355: /* -- This done by trigger HRI_GEN_HRCHY_SUMMARY_WHO
356: ,created_by
357: ,creation_date
358: ,last_updated_by
359: ,last_update_login

Line 375: /* -- This done by trigger HRI_GEN_HRCHY_SUMMARY_WHO

371: ,l_entity_child_rec.hierarchy_node_id
372: ,l_entity_child_rec.entity_id
373: ,l_gen_parent_rec.entity_level + l_entity_child_rec.entity_level
374: ,l_entity_child_rec.node_type
375: /* -- This done by trigger HRI_GEN_HRCHY_SUMMARY_WHO
376: ,-1 --created_by
377: ,sysdate
378: ,-1 --last_updated_by
379: ,-1 --last_update_login