DBA Data[Home] [Help]

APPS.CSI_COUNTER_PVT dependencies on DBMS_SQL

Line 99: iSQLCur := DBMS_SQL.open_cursor;

95: iSQLCur number;
96: sSQL varchar2(2090);
97: BEGIN
98: sSQL := 'select ' || P_FORMULA_TEXT || ' from dual';
99: iSQLCur := DBMS_SQL.open_cursor;
100: dbms_sql.parse(iSQLCur,sSQL,2);
101: dbms_sql.close_cursor(iSQLCur);
102: return TRUE;
103: EXCEPTION

Line 100: dbms_sql.parse(iSQLCur,sSQL,2);

96: sSQL varchar2(2090);
97: BEGIN
98: sSQL := 'select ' || P_FORMULA_TEXT || ' from dual';
99: iSQLCur := DBMS_SQL.open_cursor;
100: dbms_sql.parse(iSQLCur,sSQL,2);
101: dbms_sql.close_cursor(iSQLCur);
102: return TRUE;
103: EXCEPTION
104: WHEN OTHERS THEN

Line 101: dbms_sql.close_cursor(iSQLCur);

97: BEGIN
98: sSQL := 'select ' || P_FORMULA_TEXT || ' from dual';
99: iSQLCur := DBMS_SQL.open_cursor;
100: dbms_sql.parse(iSQLCur,sSQL,2);
101: dbms_sql.close_cursor(iSQLCur);
102: return TRUE;
103: EXCEPTION
104: WHEN OTHERS THEN
105: return FALSE;