APPS.CSM_LOBS_PKG dependencies on DBMS_SQL

Line 328: l_cursorid := DBMS_SQL.open_cursor;

324: || ' AND clid$$cs = ''' || p_record.clid$$cs || '''';
325:
326: END IF;
327:
328: l_cursorid := DBMS_SQL.open_cursor;
329: --parse and execute the sql
330: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);
331: l_result := DBMS_SQL.execute(l_cursorid);
332: DBMS_SQL.close_cursor (l_cursorid);

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

326: END IF;
327:
328: l_cursorid := DBMS_SQL.open_cursor;
329: --parse and execute the sql
330: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);
331: l_result := DBMS_SQL.execute(l_cursorid);
332: DBMS_SQL.close_cursor (l_cursorid);
333:
334:

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

327:
328: l_cursorid := DBMS_SQL.open_cursor;
329: --parse and execute the sql
330: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);
331: l_result := DBMS_SQL.execute(l_cursorid);
332: DBMS_SQL.close_cursor (l_cursorid);
333:
334:
335:

Line 332: DBMS_SQL.close_cursor (l_cursorid);

328: l_cursorid := DBMS_SQL.open_cursor;
329: --parse and execute the sql
330: DBMS_SQL.parse(l_cursorid, l_dsql, DBMS_SQL.v7);
331: l_result := DBMS_SQL.execute(l_cursorid);
332: DBMS_SQL.close_cursor (l_cursorid);
333:
334:
335:
336: EXCEPTION