APPS.FEM_MV_REFRESH_PVT dependencies on FEM_MV_REFRESH_OBJECTS

Line 105: MERGE INTO fem_mv_refresh_objects s

101: -- End validating input parameters.
102: --
103:
104: -- We will take an UPSERT approach to update MV repository table.
105: MERGE INTO fem_mv_refresh_objects s
106: USING ( SELECT p_mv_name mv_name ,
107: p_base_table_name base_table_name ,
108: p_refresh_group_sequence refresh_group_sequence
109: FROM dual ) t

Line 202: DELETE fem_mv_refresh_objects

198: END IF ;
199: x_return_status := FND_API.G_RET_STS_SUCCESS ;
200:
201: -- Remove the MV from the repository table.
202: DELETE fem_mv_refresh_objects
203: WHERE mv_name = p_mv_name ;
204:
205: IF SQL%ROWCOUNT <= 0 THEN
206: FND_MESSAGE.Set_Name('FND', 'FEM_MV_INVALID_MV_NAME') ;

Line 356: FROM fem_mv_refresh_objects

352: --
353: FOR l_mv_rec IN
354: (
355: SELECT mv_name, refresh_group_sequence
356: FROM fem_mv_refresh_objects
357: WHERE base_table_name = NVL(p_base_table_name, base_table_name)
358: ORDER BY refresh_group_sequence
359: )
360: LOOP