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

Line 2379: c := dbms_sql.open_cursor;

2375: ',:P_CODE_COMBINATION_ID ' ||
2376: ',:P_SET_OF_BOOKS_ID ' ||
2377: ',:P_PERIOD_NET_DR ' ||
2378: ',:P_PERIOD_NET_CR ); end; ';
2379: c := dbms_sql.open_cursor;
2380:
2381: /* Parse SQL Statement, returning the exception: NO_DATA_FOUND if the GL */
2382: /* Server procedure: gl_balances.get_activity has not been installed */
2383: /* Any other error, generated by this call will also return NO_DATA_FOUND */

Line 2386: dbms_sql.parse(c, statement, dbms_sql.native);

2382: /* Server procedure: gl_balances.get_activity has not been installed */
2383: /* Any other error, generated by this call will also return NO_DATA_FOUND */
2384:
2385: begin
2386: dbms_sql.parse(c, statement, dbms_sql.native);
2387:
2388: dbms_sql.bind_variable( c, 'p_period_from', p_period_from );
2389: dbms_sql.bind_variable( c, 'p_period_to', p_period_to );
2390: dbms_sql.bind_variable( c, 'p_code_combination_id', p_code_combination_id );

Line 2388: dbms_sql.bind_variable( c, 'p_period_from', p_period_from );

2384:
2385: begin
2386: dbms_sql.parse(c, statement, dbms_sql.native);
2387:
2388: dbms_sql.bind_variable( c, 'p_period_from', p_period_from );
2389: dbms_sql.bind_variable( c, 'p_period_to', p_period_to );
2390: dbms_sql.bind_variable( c, 'p_code_combination_id', p_code_combination_id );
2391: dbms_sql.bind_variable( c, 'p_set_of_books_id', p_set_of_books_id );
2392: dbms_sql.bind_variable( c, 'p_period_net_dr', dr );

Line 2389: dbms_sql.bind_variable( c, 'p_period_to', p_period_to );

2385: begin
2386: dbms_sql.parse(c, statement, dbms_sql.native);
2387:
2388: dbms_sql.bind_variable( c, 'p_period_from', p_period_from );
2389: dbms_sql.bind_variable( c, 'p_period_to', p_period_to );
2390: dbms_sql.bind_variable( c, 'p_code_combination_id', p_code_combination_id );
2391: dbms_sql.bind_variable( c, 'p_set_of_books_id', p_set_of_books_id );
2392: dbms_sql.bind_variable( c, 'p_period_net_dr', dr );
2393: dbms_sql.bind_variable( c, 'p_period_net_cr', cr );

Line 2390: dbms_sql.bind_variable( c, 'p_code_combination_id', p_code_combination_id );

2386: dbms_sql.parse(c, statement, dbms_sql.native);
2387:
2388: dbms_sql.bind_variable( c, 'p_period_from', p_period_from );
2389: dbms_sql.bind_variable( c, 'p_period_to', p_period_to );
2390: dbms_sql.bind_variable( c, 'p_code_combination_id', p_code_combination_id );
2391: dbms_sql.bind_variable( c, 'p_set_of_books_id', p_set_of_books_id );
2392: dbms_sql.bind_variable( c, 'p_period_net_dr', dr );
2393: dbms_sql.bind_variable( c, 'p_period_net_cr', cr );
2394: rows := dbms_sql.execute(c);

Line 2391: dbms_sql.bind_variable( c, 'p_set_of_books_id', p_set_of_books_id );

2387:
2388: dbms_sql.bind_variable( c, 'p_period_from', p_period_from );
2389: dbms_sql.bind_variable( c, 'p_period_to', p_period_to );
2390: dbms_sql.bind_variable( c, 'p_code_combination_id', p_code_combination_id );
2391: dbms_sql.bind_variable( c, 'p_set_of_books_id', p_set_of_books_id );
2392: dbms_sql.bind_variable( c, 'p_period_net_dr', dr );
2393: dbms_sql.bind_variable( c, 'p_period_net_cr', cr );
2394: rows := dbms_sql.execute(c);
2395: dbms_sql.variable_value( c, 'p_period_net_dr', dr );

Line 2392: dbms_sql.bind_variable( c, 'p_period_net_dr', dr );

2388: dbms_sql.bind_variable( c, 'p_period_from', p_period_from );
2389: dbms_sql.bind_variable( c, 'p_period_to', p_period_to );
2390: dbms_sql.bind_variable( c, 'p_code_combination_id', p_code_combination_id );
2391: dbms_sql.bind_variable( c, 'p_set_of_books_id', p_set_of_books_id );
2392: dbms_sql.bind_variable( c, 'p_period_net_dr', dr );
2393: dbms_sql.bind_variable( c, 'p_period_net_cr', cr );
2394: rows := dbms_sql.execute(c);
2395: dbms_sql.variable_value( c, 'p_period_net_dr', dr );
2396: dbms_sql.variable_value( c, 'p_period_net_cr', cr );

Line 2393: dbms_sql.bind_variable( c, 'p_period_net_cr', cr );

2389: dbms_sql.bind_variable( c, 'p_period_to', p_period_to );
2390: dbms_sql.bind_variable( c, 'p_code_combination_id', p_code_combination_id );
2391: dbms_sql.bind_variable( c, 'p_set_of_books_id', p_set_of_books_id );
2392: dbms_sql.bind_variable( c, 'p_period_net_dr', dr );
2393: dbms_sql.bind_variable( c, 'p_period_net_cr', cr );
2394: rows := dbms_sql.execute(c);
2395: dbms_sql.variable_value( c, 'p_period_net_dr', dr );
2396: dbms_sql.variable_value( c, 'p_period_net_cr', cr );
2397: dbms_sql.close_cursor(c);

Line 2394: rows := dbms_sql.execute(c);

2390: dbms_sql.bind_variable( c, 'p_code_combination_id', p_code_combination_id );
2391: dbms_sql.bind_variable( c, 'p_set_of_books_id', p_set_of_books_id );
2392: dbms_sql.bind_variable( c, 'p_period_net_dr', dr );
2393: dbms_sql.bind_variable( c, 'p_period_net_cr', cr );
2394: rows := dbms_sql.execute(c);
2395: dbms_sql.variable_value( c, 'p_period_net_dr', dr );
2396: dbms_sql.variable_value( c, 'p_period_net_cr', cr );
2397: dbms_sql.close_cursor(c);
2398: exception

Line 2395: dbms_sql.variable_value( c, 'p_period_net_dr', dr );

2391: dbms_sql.bind_variable( c, 'p_set_of_books_id', p_set_of_books_id );
2392: dbms_sql.bind_variable( c, 'p_period_net_dr', dr );
2393: dbms_sql.bind_variable( c, 'p_period_net_cr', cr );
2394: rows := dbms_sql.execute(c);
2395: dbms_sql.variable_value( c, 'p_period_net_dr', dr );
2396: dbms_sql.variable_value( c, 'p_period_net_cr', cr );
2397: dbms_sql.close_cursor(c);
2398: exception
2399: when others then if dbms_sql.is_open(c) then dbms_sql.close_cursor(c); end if;

Line 2396: dbms_sql.variable_value( c, 'p_period_net_cr', cr );

2392: dbms_sql.bind_variable( c, 'p_period_net_dr', dr );
2393: dbms_sql.bind_variable( c, 'p_period_net_cr', cr );
2394: rows := dbms_sql.execute(c);
2395: dbms_sql.variable_value( c, 'p_period_net_dr', dr );
2396: dbms_sql.variable_value( c, 'p_period_net_cr', cr );
2397: dbms_sql.close_cursor(c);
2398: exception
2399: when others then if dbms_sql.is_open(c) then dbms_sql.close_cursor(c); end if;
2400: raise no_data_found;

Line 2397: dbms_sql.close_cursor(c);

2393: dbms_sql.bind_variable( c, 'p_period_net_cr', cr );
2394: rows := dbms_sql.execute(c);
2395: dbms_sql.variable_value( c, 'p_period_net_dr', dr );
2396: dbms_sql.variable_value( c, 'p_period_net_cr', cr );
2397: dbms_sql.close_cursor(c);
2398: exception
2399: when others then if dbms_sql.is_open(c) then dbms_sql.close_cursor(c); end if;
2400: raise no_data_found;
2401: end;

Line 2399: when others then if dbms_sql.is_open(c) then dbms_sql.close_cursor(c); end if;

2395: dbms_sql.variable_value( c, 'p_period_net_dr', dr );
2396: dbms_sql.variable_value( c, 'p_period_net_cr', cr );
2397: dbms_sql.close_cursor(c);
2398: exception
2399: when others then if dbms_sql.is_open(c) then dbms_sql.close_cursor(c); end if;
2400: raise no_data_found;
2401: end;
2402: p_period_net_dr := dr;
2403: p_period_net_cr := cr;