APPS.EDW_APPS_INT dependencies on EDW_SOURCE_VIEWS

Line 27: select count(*) into l_count from edw_source_views

23: return;
24: END IF;
25:
26: IF (upper(p_version) <> 'ALL') THEN
27: select count(*) into l_count from edw_source_views
28: where upper(object_name) = upper(p_object_name) and
29: nvl(upper(level_name), '000') = nvl(upper(p_level_name), '000') and
30: upper(version) = upper(p_version) ;
31:

Line 45: v_sql_stmt := 'INSERT INTO EDW_SOURCE_VIEWS ' ||

41: p_Interface_table_name, p_object_name, p_level_name, '11i');
42: END IF;
43:
44:
45: v_sql_stmt := 'INSERT INTO EDW_SOURCE_VIEWS ' ||
46: '(flex_view_name, generated_view_name, collection_view_name,
47: Interface_table_name, object_name, level_name, version,
48: last_update_date, last_updated_by, last_update_login,
49: created_by, creation_date)

Line 75: DELETE FROM edw_source_views

71: Procedure removeSourceViews(p_object_name IN VARCHAR2, p_version IN VARCHAR2) IS
72: BEGIN
73:
74: IF (p_version <> 'ALL') THEN
75: DELETE FROM edw_source_views
76: WHERE upper(object_name) = upper(p_object_name)
77: AND upper(version) = upper(p_version);
78: ELSE
79: DELETE FROM edw_source_views

Line 79: DELETE FROM edw_source_views

75: DELETE FROM edw_source_views
76: WHERE upper(object_name) = upper(p_object_name)
77: AND upper(version) = upper(p_version);
78: ELSE
79: DELETE FROM edw_source_views
80: WHERE upper(object_name) = upper(p_object_name);
81: END IF;
82:
83: EXCEPTION