eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QA_SS_LOV dependencies on DBMS_SQL

Line 1598: cur := dbms_sql.open_cursor;

1594: WHERE CODE '||where_cond|| '''' || f_str || '''
1595: ORDER BY CODE';
1596: -- htp.p('Before Cursor open: '||sql_val_str);
1597:
1598: cur := dbms_sql.open_cursor;
1599: -- htp.p('before parse');
1600: dbms_sql.parse(cur, sql_val_str, DBMS_SQL.v7);
1601: -- htp.p('after parse');
1602: dbms_sql.define_column(cur, 1, code, 500);

Line 1600: dbms_sql.parse(cur, sql_val_str, DBMS_SQL.v7);

1596: -- htp.p('Before Cursor open: '||sql_val_str);
1597:
1598: cur := dbms_sql.open_cursor;
1599: -- htp.p('before parse');
1600: dbms_sql.parse(cur, sql_val_str, DBMS_SQL.v7);
1601: -- htp.p('after parse');
1602: dbms_sql.define_column(cur, 1, code, 500);
1603: dbms_sql.define_column(cur, 2, description, 500);
1604: ignore := dbms_sql.execute(cur);

Line 1602: dbms_sql.define_column(cur, 1, code, 500);

1598: cur := dbms_sql.open_cursor;
1599: -- htp.p('before parse');
1600: dbms_sql.parse(cur, sql_val_str, DBMS_SQL.v7);
1601: -- htp.p('after parse');
1602: dbms_sql.define_column(cur, 1, code, 500);
1603: dbms_sql.define_column(cur, 2, description, 500);
1604: ignore := dbms_sql.execute(cur);
1605:
1606: fld := 'p_col'||cnumb|| '[' || rnumb || ']';

Line 1603: dbms_sql.define_column(cur, 2, description, 500);

1599: -- htp.p('before parse');
1600: dbms_sql.parse(cur, sql_val_str, DBMS_SQL.v7);
1601: -- htp.p('after parse');
1602: dbms_sql.define_column(cur, 1, code, 500);
1603: dbms_sql.define_column(cur, 2, description, 500);
1604: ignore := dbms_sql.execute(cur);
1605:
1606: fld := 'p_col'||cnumb|| '[' || rnumb || ']';
1607: sbox := 'selectbox[' || rnumb || ']';

Line 1604: ignore := dbms_sql.execute(cur);

1600: dbms_sql.parse(cur, sql_val_str, DBMS_SQL.v7);
1601: -- htp.p('after parse');
1602: dbms_sql.define_column(cur, 1, code, 500);
1603: dbms_sql.define_column(cur, 2, description, 500);
1604: ignore := dbms_sql.execute(cur);
1605:
1606: fld := 'p_col'||cnumb|| '[' || rnumb || ']';
1607: sbox := 'selectbox[' || rnumb || ']';
1608: htp.htmlOpen;

Line 1641: IF DBMS_SQL.FETCH_ROWS(cur) > 0 THEN

1637:
1638: r_cnt := 0;
1639: more_records := TRUE;
1640: LOOP
1641: IF DBMS_SQL.FETCH_ROWS(cur) > 0 THEN
1642: r_cnt := r_cnt + 1;
1643: if (r_cnt > end_row) then
1644: exit;
1645: end if;

Line 1648: dbms_sql.column_value(cur, 1, code);

1644: exit;
1645: end if;
1646:
1647: if (r_cnt >= start_row) THEN
1648: dbms_sql.column_value(cur, 1, code);
1649: dbms_sql.column_value(cur, 2, description);
1650: if (row_color = 'BLUE') then
1651: htp.tableRowOpen(cattributes=>'BGCOLOR="#99ccff"');
1652: row_color := 'WHITE';

Line 1649: dbms_sql.column_value(cur, 2, description);

1645: end if;
1646:
1647: if (r_cnt >= start_row) THEN
1648: dbms_sql.column_value(cur, 1, code);
1649: dbms_sql.column_value(cur, 2, description);
1650: if (row_color = 'BLUE') then
1651: htp.tableRowOpen(cattributes=>'BGCOLOR="#99ccff"');
1652: row_color := 'WHITE';
1653: else

Line 1811: cur := dbms_sql.open_cursor;

1807: -- || ''' and Rownum = 1 ';
1808:
1809:
1810:
1811: cur := dbms_sql.open_cursor;
1812: dbms_sql.parse(cur, str, DBMS_SQL.v7);
1813: dbms_sql.define_column( cur, 1, id);
1814: ignore := dbms_sql.execute(cur);
1815:

Line 1812: dbms_sql.parse(cur, str, DBMS_SQL.v7);

1808:
1809:
1810:
1811: cur := dbms_sql.open_cursor;
1812: dbms_sql.parse(cur, str, DBMS_SQL.v7);
1813: dbms_sql.define_column( cur, 1, id);
1814: ignore := dbms_sql.execute(cur);
1815:
1816: if dbms_sql.fetch_rows(cur) > 0 Then

Line 1813: dbms_sql.define_column( cur, 1, id);

1809:
1810:
1811: cur := dbms_sql.open_cursor;
1812: dbms_sql.parse(cur, str, DBMS_SQL.v7);
1813: dbms_sql.define_column( cur, 1, id);
1814: ignore := dbms_sql.execute(cur);
1815:
1816: if dbms_sql.fetch_rows(cur) > 0 Then
1817: dbms_sql.column_value(cur, 1, id);

Line 1814: ignore := dbms_sql.execute(cur);

1810:
1811: cur := dbms_sql.open_cursor;
1812: dbms_sql.parse(cur, str, DBMS_SQL.v7);
1813: dbms_sql.define_column( cur, 1, id);
1814: ignore := dbms_sql.execute(cur);
1815:
1816: if dbms_sql.fetch_rows(cur) > 0 Then
1817: dbms_sql.column_value(cur, 1, id);
1818: end if;

Line 1816: if dbms_sql.fetch_rows(cur) > 0 Then

1812: dbms_sql.parse(cur, str, DBMS_SQL.v7);
1813: dbms_sql.define_column( cur, 1, id);
1814: ignore := dbms_sql.execute(cur);
1815:
1816: if dbms_sql.fetch_rows(cur) > 0 Then
1817: dbms_sql.column_value(cur, 1, id);
1818: end if;
1819: return id;
1820: ELSE

Line 1817: dbms_sql.column_value(cur, 1, id);

1813: dbms_sql.define_column( cur, 1, id);
1814: ignore := dbms_sql.execute(cur);
1815:
1816: if dbms_sql.fetch_rows(cur) > 0 Then
1817: dbms_sql.column_value(cur, 1, id);
1818: end if;
1819: return id;
1820: ELSE
1821: Return -1;