APPS.CSD_MIG_SLABS_PKG dependencies on DBMS_SQL

Line 11: l_cursor_handle := dbms_sql.open_cursor;

7: l_value NUMBER;
8: l_n_temp NUMBER;
9:
10: BEGIN
11: l_cursor_handle := dbms_sql.open_cursor;
12:
13: begin
14: dbms_sql.parse(l_cursor_handle,sqlstr,dbms_sql.native);
15: exception

Line 14: dbms_sql.parse(l_cursor_handle,sqlstr,dbms_sql.native);

10: BEGIN
11: l_cursor_handle := dbms_sql.open_cursor;
12:
13: begin
14: dbms_sql.parse(l_cursor_handle,sqlstr,dbms_sql.native);
15: exception
16: when others then
17: raise_application_error(-20001,'error while parsing sql:'||sqlerrm);
18: end;

Line 20: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_value);

16: when others then
17: raise_application_error(-20001,'error while parsing sql:'||sqlerrm);
18: end;
19:
20: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_value);
21: l_n_temp := dbms_sql.execute(l_cursor_handle);
22:
23: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
24: dbms_sql.column_value(l_cursor_handle,1,l_value);

Line 21: l_n_temp := dbms_sql.execute(l_cursor_handle);

17: raise_application_error(-20001,'error while parsing sql:'||sqlerrm);
18: end;
19:
20: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_value);
21: l_n_temp := dbms_sql.execute(l_cursor_handle);
22:
23: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
24: dbms_sql.column_value(l_cursor_handle,1,l_value);
25: END IF;

Line 23: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN

19:
20: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_value);
21: l_n_temp := dbms_sql.execute(l_cursor_handle);
22:
23: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
24: dbms_sql.column_value(l_cursor_handle,1,l_value);
25: END IF;
26: --Close cursor
27: DBMS_SQL.close_cursor(l_cursor_handle);

Line 24: dbms_sql.column_value(l_cursor_handle,1,l_value);

20: DBMS_SQL.DEFINE_COLUMN(l_cursor_handle,1,l_value);
21: l_n_temp := dbms_sql.execute(l_cursor_handle);
22:
23: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
24: dbms_sql.column_value(l_cursor_handle,1,l_value);
25: END IF;
26: --Close cursor
27: DBMS_SQL.close_cursor(l_cursor_handle);
28: return l_value;

Line 27: DBMS_SQL.close_cursor(l_cursor_handle);

23: IF dbms_sql.fetch_rows(l_cursor_handle) > 0 THEN
24: dbms_sql.column_value(l_cursor_handle,1,l_value);
25: END IF;
26: --Close cursor
27: DBMS_SQL.close_cursor(l_cursor_handle);
28: return l_value;
29:
30: END get_sql_value;
31: