APPS.CSM_LOBS_PKG dependencies on DBMS_SQL

Line 339: l_cursorid := DBMS_SQL.open_cursor;

335: || ' AND clid$$cs = ''' || p_record.clid$$cs || '''';
336:
337: END IF;
338:
339: l_cursorid := DBMS_SQL.open_cursor;
340: --parse and execute the sql
341: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);
342: l_result := DBMS_SQL.execute(l_cursorid);
343: DBMS_SQL.close_cursor (l_cursorid);

Line 341: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);

337: END IF;
338:
339: l_cursorid := DBMS_SQL.open_cursor;
340: --parse and execute the sql
341: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);
342: l_result := DBMS_SQL.execute(l_cursorid);
343: DBMS_SQL.close_cursor (l_cursorid);
344:
345:

Line 342: l_result := DBMS_SQL.execute(l_cursorid);

338:
339: l_cursorid := DBMS_SQL.open_cursor;
340: --parse and execute the sql
341: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);
342: l_result := DBMS_SQL.execute(l_cursorid);
343: DBMS_SQL.close_cursor (l_cursorid);
344:
345:
346:

Line 343: DBMS_SQL.close_cursor (l_cursorid);

339: l_cursorid := DBMS_SQL.open_cursor;
340: --parse and execute the sql
341: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);
342: l_result := DBMS_SQL.execute(l_cursorid);
343: DBMS_SQL.close_cursor (l_cursorid);
344:
345:
346:
347: EXCEPTION