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

Line 141: l_select_cursor := dbms_sql.open_cursor;

137: arp_standard.debug('where clause:' || p_where_clause );
138:
139: arp_standard.debug('Opening Cursor');
140:
141: l_select_cursor := dbms_sql.open_cursor;
142:
143: /*-----------------------------------------------------------------------+
144: |Call the Build and Bind routine to strip where clause from literals and|
145: |numeric constants and replace them with bind variables. |

Line 157: dbms_sql.parse(l_select_cursor,

153: +-----------------------------------------------------------------------*/
154: arp_standard.debug('Parsing statement ');
155: arp_standard.debug(l_out_where_clause);
156: --Bug 1563252 : modified the query string to add the from clause dynamically.
157: dbms_sql.parse(l_select_cursor,
158: 'select count( distinct invoice_currency_code ), sum(amount_due_remaining), sum(acctd_amount_due_remaining) from '||p_from_clause||' '||l_out_where_clause,
159: dbms_sql.v7);
160:
161: /*-----------------------------------------------------------------------+

Line 159: dbms_sql.v7);

155: arp_standard.debug(l_out_where_clause);
156: --Bug 1563252 : modified the query string to add the from clause dynamically.
157: dbms_sql.parse(l_select_cursor,
158: 'select count( distinct invoice_currency_code ), sum(amount_due_remaining), sum(acctd_amount_due_remaining) from '||p_from_clause||' '||l_out_where_clause,
159: dbms_sql.v7);
160:
161: /*-----------------------------------------------------------------------+
162: |Define columns for the select statement. |
163: +-----------------------------------------------------------------------*/

Line 166: dbms_sql.define_column(l_select_cursor, 1 , l_count);

162: |Define columns for the select statement. |
163: +-----------------------------------------------------------------------*/
164: arp_standard.debug('Defining Columns +');
165:
166: dbms_sql.define_column(l_select_cursor, 1 , l_count);
167: dbms_sql.define_column(l_select_cursor, 2 , l_amount);
168: dbms_sql.define_column(l_select_cursor, 3 , l_func_amount);
169:
170: arp_standard.debug('Defining Columns -');

Line 167: dbms_sql.define_column(l_select_cursor, 2 , l_amount);

163: +-----------------------------------------------------------------------*/
164: arp_standard.debug('Defining Columns +');
165:
166: dbms_sql.define_column(l_select_cursor, 1 , l_count);
167: dbms_sql.define_column(l_select_cursor, 2 , l_amount);
168: dbms_sql.define_column(l_select_cursor, 3 , l_func_amount);
169:
170: arp_standard.debug('Defining Columns -');
171:

Line 168: dbms_sql.define_column(l_select_cursor, 3 , l_func_amount);

164: arp_standard.debug('Defining Columns +');
165:
166: dbms_sql.define_column(l_select_cursor, 1 , l_count);
167: dbms_sql.define_column(l_select_cursor, 2 , l_amount);
168: dbms_sql.define_column(l_select_cursor, 3 , l_func_amount);
169:
170: arp_standard.debug('Defining Columns -');
171:
172: /*-----------------------------------------------------------------------+

Line 191: dbms_sql.bind_variable(l_select_cursor, l_actual_bind_var, l_literal_tbl(l_ctr).stripped_value);

187: l_actual_bind_var := rtrim(ltrim(l_literal_tbl(l_ctr).bind_var_name));
188:
189: arp_standard.debug('l_actual_bind_var = '||l_actual_bind_var);
190:
191: dbms_sql.bind_variable(l_select_cursor, l_actual_bind_var, l_literal_tbl(l_ctr).stripped_value);
192:
193: END LOOP;
194:
195: arp_standard.debug('Binding Variables -');

Line 205: l_ignore := dbms_sql.execute(l_select_cursor);

201: |amount totals. |
202: +-----------------------------------------------------------------------*/
203: arp_standard.debug('Executing Statement +');
204:
205: l_ignore := dbms_sql.execute(l_select_cursor);
206:
207: arp_standard.debug('Executing Statement -');
208:
209: IF dbms_sql.fetch_rows(l_select_cursor) > 0 then

Line 209: IF dbms_sql.fetch_rows(l_select_cursor) > 0 then

205: l_ignore := dbms_sql.execute(l_select_cursor);
206:
207: arp_standard.debug('Executing Statement -');
208:
209: IF dbms_sql.fetch_rows(l_select_cursor) > 0 then
210:
211: /*-----------------------------------------------------------------------+
212: |Fetch the column values, into actual variables |
213: +-----------------------------------------------------------------------*/

Line 216: dbms_sql.column_value(l_select_cursor, 1, l_count);

212: |Fetch the column values, into actual variables |
213: +-----------------------------------------------------------------------*/
214: arp_standard.debug('Fetching column values +');
215:
216: dbms_sql.column_value(l_select_cursor, 1, l_count);
217: dbms_sql.column_value(l_select_cursor, 2, l_amount);
218: dbms_sql.column_value(l_select_cursor, 3, l_func_amount);
219:
220: arp_standard.debug('l_count '||l_count);

Line 217: dbms_sql.column_value(l_select_cursor, 2, l_amount);

213: +-----------------------------------------------------------------------*/
214: arp_standard.debug('Fetching column values +');
215:
216: dbms_sql.column_value(l_select_cursor, 1, l_count);
217: dbms_sql.column_value(l_select_cursor, 2, l_amount);
218: dbms_sql.column_value(l_select_cursor, 3, l_func_amount);
219:
220: arp_standard.debug('l_count '||l_count);
221: arp_standard.debug('l_amount'||l_amount);

Line 218: dbms_sql.column_value(l_select_cursor, 3, l_func_amount);

214: arp_standard.debug('Fetching column values +');
215:
216: dbms_sql.column_value(l_select_cursor, 1, l_count);
217: dbms_sql.column_value(l_select_cursor, 2, l_amount);
218: dbms_sql.column_value(l_select_cursor, 3, l_func_amount);
219:
220: arp_standard.debug('l_count '||l_count);
221: arp_standard.debug('l_amount'||l_amount);
222: arp_standard.debug('l_func_amount'||l_func_amount);

Line 244: dbms_sql.close_cursor(l_select_cursor);

240: /*-----------------------------------------------------------------------+
241: |Finally close the cursor |
242: +-----------------------------------------------------------------------*/
243: arp_standard.debug('Closing Cursor');
244: dbms_sql.close_cursor(l_select_cursor);
245:
246: -- arp_standard.enable_debug;
247: EXCEPTION
248: WHEN OTHERS THEN