APPS.INV_GEN_LOC_KFV dependencies on DBMS_SQL

Line 136: l_sqlid := dbms_sql.open_cursor;

132: fnd_message.set_name('FND', 'AD_ZD_DISABLED_FEATURE');
133: raise_application_error ('-20000', fnd_message.get);
134: end if;
135:
136: l_sqlid := dbms_sql.open_cursor;
137: dbms_sql.parse(l_sqlid,l_view_text,dbms_sql.native);
138: --
139: l_execute := dbms_sql.execute(l_sqlid);
140: dbms_sql.close_cursor(l_sqlid);

Line 137: dbms_sql.parse(l_sqlid,l_view_text,dbms_sql.native);

133: raise_application_error ('-20000', fnd_message.get);
134: end if;
135:
136: l_sqlid := dbms_sql.open_cursor;
137: dbms_sql.parse(l_sqlid,l_view_text,dbms_sql.native);
138: --
139: l_execute := dbms_sql.execute(l_sqlid);
140: dbms_sql.close_cursor(l_sqlid);
141: --

Line 139: l_execute := dbms_sql.execute(l_sqlid);

135:
136: l_sqlid := dbms_sql.open_cursor;
137: dbms_sql.parse(l_sqlid,l_view_text,dbms_sql.native);
138: --
139: l_execute := dbms_sql.execute(l_sqlid);
140: dbms_sql.close_cursor(l_sqlid);
141: --
142: IF (l_debug = 1) THEN
143: inv_log_util.TRACE('Successfully Recompiled the View.', 'INVLOC', 9);

Line 140: dbms_sql.close_cursor(l_sqlid);

136: l_sqlid := dbms_sql.open_cursor;
137: dbms_sql.parse(l_sqlid,l_view_text,dbms_sql.native);
138: --
139: l_execute := dbms_sql.execute(l_sqlid);
140: dbms_sql.close_cursor(l_sqlid);
141: --
142: IF (l_debug = 1) THEN
143: inv_log_util.TRACE('Successfully Recompiled the View.', 'INVLOC', 9);
144: END IF;