APPS.CSD_RULES_ENGINE_PVT dependencies on DBMS_SQL

Line 1283: l_cursor := DBMS_SQL.OPEN_CURSOR;

1279: --** debug starts!!
1280: --dbms_output.put_line('~~~ GET_DEFAULT_VALUE , G_VALUE_TYPE_PLSQL, l_sql_stmt ' || l_sql_stmt);
1281: --** debug ends!!
1282:
1283: l_cursor := DBMS_SQL.OPEN_CURSOR;
1284:
1285: --* Parse the query with a dynamic WHERE clause
1286: DBMS_SQL.PARSE (l_cursor, l_sql_stmt, DBMS_SQL.NATIVE);
1287:

Line 1286: DBMS_SQL.PARSE (l_cursor, l_sql_stmt, DBMS_SQL.NATIVE);

1282:
1283: l_cursor := DBMS_SQL.OPEN_CURSOR;
1284:
1285: --* Parse the query with a dynamic WHERE clause
1286: DBMS_SQL.PARSE (l_cursor, l_sql_stmt, DBMS_SQL.NATIVE);
1287:
1288: --* Define the columns in the cursor for this query
1289: DBMS_SQL.DEFINE_COLUMN (l_cursor, 1, l_return_val,150);
1290:

Line 1289: DBMS_SQL.DEFINE_COLUMN (l_cursor, 1, l_return_val,150);

1285: --* Parse the query with a dynamic WHERE clause
1286: DBMS_SQL.PARSE (l_cursor, l_sql_stmt, DBMS_SQL.NATIVE);
1287:
1288: --* Define the columns in the cursor for this query
1289: DBMS_SQL.DEFINE_COLUMN (l_cursor, 1, l_return_val,150);
1290:
1291:
1292: --* Now I can execute the query
1293: l_fdbk:= DBMS_SQL.EXECUTE (l_cursor);

Line 1293: l_fdbk:= DBMS_SQL.EXECUTE (l_cursor);

1289: DBMS_SQL.DEFINE_COLUMN (l_cursor, 1, l_return_val,150);
1290:
1291:
1292: --* Now I can execute the query
1293: l_fdbk:= DBMS_SQL.EXECUTE (l_cursor);
1294: LOOP
1295: --* Try to fetch next row. If done, then exit the loop.
1296: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
1297:

Line 1296: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;

1292: --* Now I can execute the query
1293: l_fdbk:= DBMS_SQL.EXECUTE (l_cursor);
1294: LOOP
1295: --* Try to fetch next row. If done, then exit the loop.
1296: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
1297:
1298: --* Retrieve data via calls to COLUMN_VALUE and place those
1299: --* values in a new record in the block.
1300:

Line 1301: DBMS_SQL.COLUMN_VALUE (l_cursor, 1, l_return_val);

1297:
1298: --* Retrieve data via calls to COLUMN_VALUE and place those
1299: --* values in a new record in the block.
1300:
1301: DBMS_SQL.COLUMN_VALUE (l_cursor, 1, l_return_val);
1302:
1303: END LOOP;
1304:
1305: /* Clean up the cursor */

Line 1306: DBMS_SQL.CLOSE_CURSOR (l_cursor);

1302:
1303: END LOOP;
1304:
1305: /* Clean up the cursor */
1306: DBMS_SQL.CLOSE_CURSOR (l_cursor);
1307:
1308: ELSE --* unrecognized type, so return null
1309: l_return_val := NULL;
1310: END IF; --* end IF (p_value_type = G_VALUE_TYPE_ATTRIBUTE) *--