APPS.EDW_APPS_INT dependencies on EDW_SV_FLEX_ASSIGNMENTS

Line 94: delete from edw_sv_flex_assignments

90: Procedure removeFlexAssignments(p_object_name IN VARCHAR2, p_version IN VARCHAR2) IS
91: BEGIN
92:
93: IF (p_version <> 'ALL') THEN
94: delete from edw_sv_flex_assignments
95: where upper(object_name) = upper(p_object_name)
96: and upper(version) = upper(p_version);
97: ELSE
98: delete from edw_sv_flex_assignments

Line 98: delete from edw_sv_flex_assignments

94: delete from edw_sv_flex_assignments
95: where upper(object_name) = upper(p_object_name)
96: and upper(version) = upper(p_version);
97: ELSE
98: delete from edw_sv_flex_assignments
99: where upper(object_name) = upper(p_object_name);
100: END IF;
101: EXCEPTION
102: WHEN no_data_found THEN

Line 135: select count(*) into l_count from edw_sv_flex_assignments

131: return;
132: END IF;
133:
134: IF (upper(p_version) <> 'ALL') THEN
135: select count(*) into l_count from edw_sv_flex_assignments
136: where upper(object_name) = upper(p_object_name) and
137: version = p_version and upper(flex_field_code)=upper(p_flex_field_code)
138: and upper(flex_field_prefix) = upper(p_flex_field_prefix)
139: and upper(flex_view_name) = upper(p_flex_view_name);

Line 156: v_sql_stmt := 'INSERT INTO EDW_SV_FLEX_ASSIGNMENTS ' ||

152: p_flex_field_prefix, p_application_id, p_application_short_name ,
153: p_flex_field_type, p_flex_field_name, '11i' );
154: END IF;
155:
156: v_sql_stmt := 'INSERT INTO EDW_SV_FLEX_ASSIGNMENTS ' ||
157: '(object_name, flex_view_name, flex_field_code, flex_field_prefix,
158: application_id, application_short_name, flex_field_type, flex_field_name,version,
159: last_update_date, last_updated_by, last_update_login, created_by, creation_date)
160: values (:xobject, :xflexview, :xflexcode, :xprefix,