APPS.HRI_OPL_SUP_WRKFC dependencies on HRI_UTL_STAGE_TABLE

Line 192: l_table_name := hri_utl_stage_table.get_staging_table_name

188: -- Set up dynamic sql for redo reduction
189: --
190: IF (g_redo_reduction = 'Y') THEN
191: l_hint := '/*+ APPEND */ ';
192: l_table_name := hri_utl_stage_table.get_staging_table_name
193: (p_master_table_name => 'HRI_MAP_SUP_WRKFC');
194: l_partition_clause := 'PARTITION (p' || g_worker_id || ') ';
195: l_partition_column := l_rtn || ' ,worker_id';
196: l_part_col_value := l_rtn || ' ,' || to_char(g_worker_id);

Line 858: hri_utl_stage_table.set_up

854: --
855: -- Set up staging table for redo reduction
856: --
857: IF (g_redo_reduction = 'Y') THEN
858: hri_utl_stage_table.set_up
859: (p_owner => l_schema,
860: p_master_table_name => 'HRI_MAP_SUP_WRKFC');
861: END IF;
862: --

Line 1003: hri_utl_stage_table.clean_up

999: --
1000: -- Redo reduction: Move data to master table and purge staging table
1001: --
1002: IF (g_redo_reduction = 'Y') THEN
1003: hri_utl_stage_table.clean_up
1004: (p_owner => l_schema,
1005: p_master_table_name => 'HRI_MAP_SUP_WRKFC');
1006: END IF;
1007: --