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.QLTSMENB dependencies on DBMS_SQL

Line 115: source_cursor := dbms_sql.open_cursor;

111: end if;
112: end if;
113:
114: -- run the statement
115: source_cursor := dbms_sql.open_cursor;
116: dbms_sql.parse(source_cursor, v_sql_statement, dbms_sql.v7);
117: if V_DATATYPE = 1 then
118: dbms_sql.define_column(source_cursor, 1, return_value_char, 1500);
119: elsif V_DATATYPE = 2 then

Line 116: dbms_sql.parse(source_cursor, v_sql_statement, dbms_sql.v7);

112: end if;
113:
114: -- run the statement
115: source_cursor := dbms_sql.open_cursor;
116: dbms_sql.parse(source_cursor, v_sql_statement, dbms_sql.v7);
117: if V_DATATYPE = 1 then
118: dbms_sql.define_column(source_cursor, 1, return_value_char, 1500);
119: elsif V_DATATYPE = 2 then
120: dbms_sql.define_column(source_cursor, 1, return_value_num);

Line 118: dbms_sql.define_column(source_cursor, 1, return_value_char, 1500);

114: -- run the statement
115: source_cursor := dbms_sql.open_cursor;
116: dbms_sql.parse(source_cursor, v_sql_statement, dbms_sql.v7);
117: if V_DATATYPE = 1 then
118: dbms_sql.define_column(source_cursor, 1, return_value_char, 1500);
119: elsif V_DATATYPE = 2 then
120: dbms_sql.define_column(source_cursor, 1, return_value_num);
121: else
122: dbms_sql.define_column(source_cursor, 1, return_value_date);

Line 120: dbms_sql.define_column(source_cursor, 1, return_value_num);

116: dbms_sql.parse(source_cursor, v_sql_statement, dbms_sql.v7);
117: if V_DATATYPE = 1 then
118: dbms_sql.define_column(source_cursor, 1, return_value_char, 1500);
119: elsif V_DATATYPE = 2 then
120: dbms_sql.define_column(source_cursor, 1, return_value_num);
121: else
122: dbms_sql.define_column(source_cursor, 1, return_value_date);
123: end if;
124: ignore := dbms_sql.execute(source_cursor);

Line 122: dbms_sql.define_column(source_cursor, 1, return_value_date);

118: dbms_sql.define_column(source_cursor, 1, return_value_char, 1500);
119: elsif V_DATATYPE = 2 then
120: dbms_sql.define_column(source_cursor, 1, return_value_num);
121: else
122: dbms_sql.define_column(source_cursor, 1, return_value_date);
123: end if;
124: ignore := dbms_sql.execute(source_cursor);
125:
126: -- now get the value and return it

Line 124: ignore := dbms_sql.execute(source_cursor);

120: dbms_sql.define_column(source_cursor, 1, return_value_num);
121: else
122: dbms_sql.define_column(source_cursor, 1, return_value_date);
123: end if;
124: ignore := dbms_sql.execute(source_cursor);
125:
126: -- now get the value and return it
127:
128: -- For Bug2243760. Added Close_cursor statement in

Line 131: if dbms_sql.fetch_rows(source_cursor)>0 then

127:
128: -- For Bug2243760. Added Close_cursor statement in
129: -- below three cases.
130:
131: if dbms_sql.fetch_rows(source_cursor)>0 then
132: if V_DATATYPE = 1 then
133: dbms_sql.column_value(source_cursor,1, return_value_char);
134: dbms_sql.close_cursor(source_cursor);
135: RETURN(return_value_char);

Line 133: dbms_sql.column_value(source_cursor,1, return_value_char);

129: -- below three cases.
130:
131: if dbms_sql.fetch_rows(source_cursor)>0 then
132: if V_DATATYPE = 1 then
133: dbms_sql.column_value(source_cursor,1, return_value_char);
134: dbms_sql.close_cursor(source_cursor);
135: RETURN(return_value_char);
136: elsif V_DATATYPE = 2 then
137: dbms_sql.column_value(source_cursor,1, return_value_num);

Line 134: dbms_sql.close_cursor(source_cursor);

130:
131: if dbms_sql.fetch_rows(source_cursor)>0 then
132: if V_DATATYPE = 1 then
133: dbms_sql.column_value(source_cursor,1, return_value_char);
134: dbms_sql.close_cursor(source_cursor);
135: RETURN(return_value_char);
136: elsif V_DATATYPE = 2 then
137: dbms_sql.column_value(source_cursor,1, return_value_num);
138: dbms_sql.close_cursor(source_cursor);

Line 137: dbms_sql.column_value(source_cursor,1, return_value_num);

133: dbms_sql.column_value(source_cursor,1, return_value_char);
134: dbms_sql.close_cursor(source_cursor);
135: RETURN(return_value_char);
136: elsif V_DATATYPE = 2 then
137: dbms_sql.column_value(source_cursor,1, return_value_num);
138: dbms_sql.close_cursor(source_cursor);
139: RETURN(to_char(return_value_num));
140: else
141: dbms_sql.column_value(source_cursor,1, return_value_date);

Line 138: dbms_sql.close_cursor(source_cursor);

134: dbms_sql.close_cursor(source_cursor);
135: RETURN(return_value_char);
136: elsif V_DATATYPE = 2 then
137: dbms_sql.column_value(source_cursor,1, return_value_num);
138: dbms_sql.close_cursor(source_cursor);
139: RETURN(to_char(return_value_num));
140: else
141: dbms_sql.column_value(source_cursor,1, return_value_date);
142: dbms_sql.close_cursor(source_cursor);

Line 141: dbms_sql.column_value(source_cursor,1, return_value_date);

137: dbms_sql.column_value(source_cursor,1, return_value_num);
138: dbms_sql.close_cursor(source_cursor);
139: RETURN(to_char(return_value_num));
140: else
141: dbms_sql.column_value(source_cursor,1, return_value_date);
142: dbms_sql.close_cursor(source_cursor);
143: RETURN(to_char(return_value_date));
144: end if;
145: end if;

Line 142: dbms_sql.close_cursor(source_cursor);

138: dbms_sql.close_cursor(source_cursor);
139: RETURN(to_char(return_value_num));
140: else
141: dbms_sql.column_value(source_cursor,1, return_value_date);
142: dbms_sql.close_cursor(source_cursor);
143: RETURN(to_char(return_value_date));
144: end if;
145: end if;
146: