APPS.EDW_APPS_INT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 27

  select count(*) into l_count from edw_source_views
  where upper(object_name) = upper(p_object_name) and
	nvl(upper(level_name), '000') = nvl(upper(p_level_name), '000') and
	upper(version) = upper(p_version) ;

Line: 35

 ELSIF (upper(p_version) = 'ALL') THEN /* insert all versions */
	registerSourceViews(p_flex_view_name, p_generated_view_name, p_collection_view_name,
		p_Interface_table_name, p_object_name, p_level_name, '10.7');

Line: 45

  v_sql_stmt := 'INSERT INTO EDW_SOURCE_VIEWS ' ||
    '(flex_view_name, generated_view_name, collection_view_name,
	Interface_table_name, object_name, level_name, version,
	last_update_date, last_updated_by, last_update_login,
	created_by, creation_date)
    values (:xflex, :xgen, :xcoll, :xit, :xobj, :xlvl, :xver, sysdate,
	0, 1, 1, sysdate) ';

Line: 75

	DELETE FROM edw_source_views
	WHERE upper(object_name) = upper(p_object_name)
	AND upper(version) = upper(p_version);

Line: 79

	DELETE FROM edw_source_views
        WHERE upper(object_name) = upper(p_object_name);

Line: 94

	delete from edw_sv_flex_assignments
	where upper(object_name) = upper(p_object_name)
	and upper(version) = upper(p_version);

Line: 98

	delete from edw_sv_flex_assignments
        where upper(object_name) = upper(p_object_name);

Line: 135

  select count(*) into l_count from edw_sv_flex_assignments
  where upper(object_name) = upper(p_object_name) and
        version = p_version and upper(flex_field_code)=upper(p_flex_field_code)
	and upper(flex_field_prefix) = upper(p_flex_field_prefix)
	and upper(flex_view_name) = upper(p_flex_view_name);

Line: 144

 ELSIF (upper(p_version) = 'ALL') THEN /* insert all versions */
	registerFlexAssignments ( p_object_name, p_flex_view_name, p_flex_field_code,
		p_flex_field_prefix, p_application_id, p_application_short_name ,
		p_flex_field_type, p_flex_field_name, '10.7' );

Line: 156

  v_sql_stmt := 'INSERT INTO EDW_SV_FLEX_ASSIGNMENTS ' ||
    '(object_name, flex_view_name, flex_field_code, flex_field_prefix,
	application_id, application_short_name, flex_field_type, flex_field_name,version,
        last_update_date, last_updated_by, last_update_login, created_by, creation_date)
    values (:xobject, :xflexview, :xflexcode, :xprefix,
	:xappid, :xappname, :xflextype, :xflexname, :xversion,
	sysdate, 1, 1, 1, sysdate) ';