APPS.CSD_RULES_ENGINE_PVT dependencies on DBMS_SQL

Line 1855: l_cursor := DBMS_SQL.OPEN_CURSOR;

1851: --** debug starts!!
1852: --dbms_output.put_line('~~~ GET_DEFAULT_VALUE , G_VALUE_TYPE_PLSQL, l_sql_stmt ' || l_sql_stmt);
1853: --** debug ends!!
1854:
1855: l_cursor := DBMS_SQL.OPEN_CURSOR;
1856:
1857: --* Parse the query with a dynamic WHERE clause
1858: DBMS_SQL.PARSE (l_cursor, l_sql_stmt, DBMS_SQL.NATIVE);
1859:

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

1854:
1855: l_cursor := DBMS_SQL.OPEN_CURSOR;
1856:
1857: --* Parse the query with a dynamic WHERE clause
1858: DBMS_SQL.PARSE (l_cursor, l_sql_stmt, DBMS_SQL.NATIVE);
1859:
1860: --* Define the columns in the cursor for this query
1861: DBMS_SQL.DEFINE_COLUMN (l_cursor, 1, l_return_val,150);
1862:

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

1857: --* Parse the query with a dynamic WHERE clause
1858: DBMS_SQL.PARSE (l_cursor, l_sql_stmt, DBMS_SQL.NATIVE);
1859:
1860: --* Define the columns in the cursor for this query
1861: DBMS_SQL.DEFINE_COLUMN (l_cursor, 1, l_return_val,150);
1862:
1863:
1864: --* Now I can execute the query
1865: l_fdbk:= DBMS_SQL.EXECUTE (l_cursor);

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

1861: DBMS_SQL.DEFINE_COLUMN (l_cursor, 1, l_return_val,150);
1862:
1863:
1864: --* Now I can execute the query
1865: l_fdbk:= DBMS_SQL.EXECUTE (l_cursor);
1866: LOOP
1867: --* Try to fetch next row. If done, then exit the loop.
1868: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
1869:

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

1864: --* Now I can execute the query
1865: l_fdbk:= DBMS_SQL.EXECUTE (l_cursor);
1866: LOOP
1867: --* Try to fetch next row. If done, then exit the loop.
1868: EXIT WHEN DBMS_SQL.FETCH_ROWS (l_cursor) = 0;
1869:
1870: --* Retrieve data via calls to COLUMN_VALUE and place those
1871: --* values in a new record in the block.
1872:

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

1869:
1870: --* Retrieve data via calls to COLUMN_VALUE and place those
1871: --* values in a new record in the block.
1872:
1873: DBMS_SQL.COLUMN_VALUE (l_cursor, 1, l_return_val);
1874:
1875: END LOOP;
1876:
1877: /* Clean up the cursor */

Line 1878: DBMS_SQL.CLOSE_CURSOR (l_cursor);

1874:
1875: END LOOP;
1876:
1877: /* Clean up the cursor */
1878: DBMS_SQL.CLOSE_CURSOR (l_cursor);
1879:
1880: ELSE --* unrecognized type, so return null
1881: l_return_val := NULL;
1882: END IF; --* end IF (p_value_type = G_VALUE_TYPE_ATTRIBUTE) *--