APPS.HRI_OPL_POSH dependencies on HRI_CS_POSH

Line 130: INSERT INTO hri_cs_posh

126:
127: -- Trap unique constraint errors
128: BEGIN
129:
130: INSERT INTO hri_cs_posh
131: (position_structure_id
132: ,primary_hierarchy_flag_code
133: ,pos_structure_version_id
134: ,version_number

Line 186: INSERT INTO hri_cs_posh

182:
183: BEGIN
184: -- insert chunk of rows
185: FORALL i IN 1..g_stored_rows_to_insert
186: INSERT INTO hri_cs_posh
187: (position_structure_id
188: ,primary_hierarchy_flag_code
189: ,pos_structure_version_id
190: ,version_number

Line 448: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_CS_POSH';

444: /* Get HRI schema name - get_app_info populates l_schema */
445: IF fnd_installation.get_app_info('HRI',l_dummy1, l_dummy2, l_schema) THEN
446:
447: /* Empty out position hierarchy table */
448: l_sql_stmt := 'TRUNCATE TABLE ' || l_schema || '.HRI_CS_POSH';
449: EXECUTE IMMEDIATE(l_sql_stmt);
450:
451: /* Write timing information to log */
452: output('Truncated Position Hierarchy table: ' ||

Line 463: fnd_stats.gather_table_stats(l_schema, 'HRI_CS_POSH');

459: output('Re-populated Position Hierarchy table: ' ||
460: to_char(sysdate,'HH24:MI:SS'));
461:
462: /* Gather index stats */
463: fnd_stats.gather_table_stats(l_schema, 'HRI_CS_POSH');
464:
465: /* Write timing information to log */
466: output('Gathered stats: ' ||
467: to_char(sysdate,'HH24:MI:SS'));