APPS.HRI_OPL_SUP_WRKFC_ASG dependencies on HRI_UTL_STAGE_TABLE

Line 1512: l_table_name := hri_utl_stage_table.get_staging_table_name

1508: -- Set up dynamic sql for redo reduction
1509: --
1510: IF (g_redo_reduction = 'Y') THEN
1511: l_hint := '/*+ APPEND */ ';
1512: l_table_name := hri_utl_stage_table.get_staging_table_name
1513: (p_master_table_name => 'HRI_MAP_SUP_WRKFC_ASG');
1514: l_partition_clause := 'PARTITION (p' || g_worker_id || ') ';
1515: l_partition_column := l_rtn || ' ,worker_id';
1516: l_part_col_value := l_rtn || ' ,' || to_char(g_worker_id);

Line 1902: hri_utl_stage_table.set_up

1898: --
1899: -- Set up staging table for redo reduction
1900: --
1901: IF (g_redo_reduction = 'Y') THEN
1902: hri_utl_stage_table.set_up
1903: (p_owner => l_schema,
1904: p_master_table_name => 'HRI_MAP_SUP_WRKFC_ASG');
1905: END IF;
1906: --

Line 2050: hri_utl_stage_table.clean_up

2046: --
2047: -- Redo reduction: Move data to master table and purge staging table
2048: --
2049: IF (g_redo_reduction = 'Y') THEN
2050: hri_utl_stage_table.clean_up
2051: (p_owner => l_schema,
2052: p_master_table_name => 'HRI_MAP_SUP_WRKFC_ASG');
2053: END IF;
2054: --