APPS.QA_SS_CORE dependencies on DBMS_SQL

Line 1859: dyn_cur := dbms_sql.open_cursor;

1855: ss_where_clause);
1856: -- htp.p('Sql stmt returned is: ' || sql_st);
1857:
1858:
1859: dyn_cur := dbms_sql.open_cursor;
1860: dbms_sql.parse(dyn_cur, sql_st, dbms_sql.v7);
1861:
1862: FOR i IN 1..num_of_col+3 -- +3 is for createdby,collectionid and entry date
1863: -- standard columns

Line 1860: dbms_sql.parse(dyn_cur, sql_st, dbms_sql.v7);

1856: -- htp.p('Sql stmt returned is: ' || sql_st);
1857:
1858:
1859: dyn_cur := dbms_sql.open_cursor;
1860: dbms_sql.parse(dyn_cur, sql_st, dbms_sql.v7);
1861:
1862: FOR i IN 1..num_of_col+3 -- +3 is for createdby,collectionid and entry date
1863: -- standard columns
1864: Loop

Line 1865: Dbms_sql.define_column(dyn_cur, i, tempstr, 150);

1861:
1862: FOR i IN 1..num_of_col+3 -- +3 is for createdby,collectionid and entry date
1863: -- standard columns
1864: Loop
1865: Dbms_sql.define_column(dyn_cur, i, tempstr, 150);
1866: End Loop; --end for loop for define columns
1867:
1868: ignore := dbms_sql.execute(dyn_cur);
1869:

Line 1868: ignore := dbms_sql.execute(dyn_cur);

1864: Loop
1865: Dbms_sql.define_column(dyn_cur, i, tempstr, 150);
1866: End Loop; --end for loop for define columns
1867:
1868: ignore := dbms_sql.execute(dyn_cur);
1869:
1870: r_cnt := 0;
1871: more_records := TRUE;
1872: LOOP

Line 1873: If dbms_sql.fetch_rows(dyn_cur) > 0 Then

1869:
1870: r_cnt := 0;
1871: more_records := TRUE;
1872: LOOP
1873: If dbms_sql.fetch_rows(dyn_cur) > 0 Then
1874: r_cnt := r_cnt+1;
1875: if (r_cnt > end_row) then
1876: exit;
1877: end if;

Line 1889: Dbms_Sql.column_value(dyn_cur, i, tempstr);

1885: row_color := 'BLUE';
1886: end if; -- end if for row_color
1887: FOR i IN 1..num_of_col+3
1888: Loop
1889: Dbms_Sql.column_value(dyn_cur, i, tempstr);
1890: htp.tableData(NVL(tempstr, ' '));
1891: End Loop; -- End for loop inside of dyn cursor loop
1892: htp.tableRowClose;
1893:

Line 1945: DBMS_SQL.Close_Cursor(dyn_cur);

1941:
1942: htp.p('');
1943: htp.p('');
1944:
1945: DBMS_SQL.Close_Cursor(dyn_cur);
1946:
1947:
1948:
1949: end if; -- end icx session

Line 1954: IF DBMS_SQL.IS_OPEN(dyn_cur) Then

1950:
1951:
1952: EXCEPTION
1953: WHEN OTHERS THEN
1954: IF DBMS_SQL.IS_OPEN(dyn_cur) Then
1955: DBMS_SQL.CLOSE_CURSOR(dyn_cur);
1956: END IF;
1957: Raise;
1958: htp.p('Exception in procedure VQR');

Line 1955: DBMS_SQL.CLOSE_CURSOR(dyn_cur);

1951:
1952: EXCEPTION
1953: WHEN OTHERS THEN
1954: IF DBMS_SQL.IS_OPEN(dyn_cur) Then
1955: DBMS_SQL.CLOSE_CURSOR(dyn_cur);
1956: END IF;
1957: Raise;
1958: htp.p('Exception in procedure VQR');
1959: htp.p(''||SQLERRM||'');