57: --------------------------------------------------------------------------------
58: --------------------------------------------------------------------------------
59: -- GENERIC HIERARCHY FUNCTIONS
60: --
61: -- TABLE: HRI_GEN_HRCHY_SUMMARY
62: --------------------------------------------------------------------------------
63: --------------------------------------------------------------------------------
64:
65: --------------------------------------------------------------------------------
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';
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:
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
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
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