APPS.CSI_MIG_SLABS_PKG dependencies on DBMS_SQL

Line 10: l_cursor_handle := dbms_sql.open_cursor;

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

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

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

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

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

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

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

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

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

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

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

Line 26: DBMS_SQL.close_cursor(l_cursor_handle);

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