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_ROUNDING dependencies on DBMS_SQL

Line 4819: dbms_sql.column_value( p_select_sql_c, 1,

4815: IF PG_DEBUG in ('Y', 'C') THEN
4816: arp_standard.debug( 'arp_rounding.get_select_column_values()+' );
4817: END IF;
4818:
4819: dbms_sql.column_value( p_select_sql_c, 1,
4820: p_select_rec.rec_customer_trx_id);
4821: dbms_sql.column_value( p_select_sql_c, 2,
4822: p_select_rec.rec_code_combination_id);
4823: dbms_sql.column_value( p_select_sql_c, 3,

Line 4821: dbms_sql.column_value( p_select_sql_c, 2,

4817: END IF;
4818:
4819: dbms_sql.column_value( p_select_sql_c, 1,
4820: p_select_rec.rec_customer_trx_id);
4821: dbms_sql.column_value( p_select_sql_c, 2,
4822: p_select_rec.rec_code_combination_id);
4823: dbms_sql.column_value( p_select_sql_c, 3,
4824: p_select_rec.round_customer_trx_id);
4825:

Line 4823: dbms_sql.column_value( p_select_sql_c, 3,

4819: dbms_sql.column_value( p_select_sql_c, 1,
4820: p_select_rec.rec_customer_trx_id);
4821: dbms_sql.column_value( p_select_sql_c, 2,
4822: p_select_rec.rec_code_combination_id);
4823: dbms_sql.column_value( p_select_sql_c, 3,
4824: p_select_rec.round_customer_trx_id);
4825:
4826: IF PG_DEBUG in ('Y', 'C') THEN
4827: arp_standard.debug( 'arp_rounding.get_select_column_values()-' );

Line 4873: dbms_sql.define_column( p_select_sql_c, 1,

4869: -- Define columns
4870: ------------------------------------------------------------
4871: arp_standard.debug( ' Defining columns for select_sql_c');
4872:
4873: dbms_sql.define_column( p_select_sql_c, 1,
4874: p_select_rec.rec_customer_trx_id );
4875: dbms_sql.define_column( p_select_sql_c, 2,
4876: p_select_rec.rec_code_combination_id );
4877: dbms_sql.define_column( p_select_sql_c, 3,

Line 4875: dbms_sql.define_column( p_select_sql_c, 2,

4871: arp_standard.debug( ' Defining columns for select_sql_c');
4872:
4873: dbms_sql.define_column( p_select_sql_c, 1,
4874: p_select_rec.rec_customer_trx_id );
4875: dbms_sql.define_column( p_select_sql_c, 2,
4876: p_select_rec.rec_code_combination_id );
4877: dbms_sql.define_column( p_select_sql_c, 3,
4878: p_select_rec.round_customer_trx_id );
4879:

Line 4877: dbms_sql.define_column( p_select_sql_c, 3,

4873: dbms_sql.define_column( p_select_sql_c, 1,
4874: p_select_rec.rec_customer_trx_id );
4875: dbms_sql.define_column( p_select_sql_c, 2,
4876: p_select_rec.rec_code_combination_id );
4877: dbms_sql.define_column( p_select_sql_c, 3,
4878: p_select_rec.round_customer_trx_id );
4879:
4880: arp_standard.debug( 'arp_rounding.define_columns()-' );
4881:

Line 4950: p_select_sql_c := dbms_sql.open_cursor;

4946: IF PG_DEBUG in ('Y', 'C') THEN
4947: arp_standard.debug('Parsing select stmt');
4948: END IF;
4949:
4950: p_select_sql_c := dbms_sql.open_cursor;
4951: dbms_sql.parse( p_select_sql_c, l_select_sql, dbms_sql.v7 );
4952:
4953: IF ( p_customer_trx_id IS NOT NULL ) THEN
4954: ----------------------------------------------------

Line 4951: dbms_sql.parse( p_select_sql_c, l_select_sql, dbms_sql.v7 );

4947: arp_standard.debug('Parsing select stmt');
4948: END IF;
4949:
4950: p_select_sql_c := dbms_sql.open_cursor;
4951: dbms_sql.parse( p_select_sql_c, l_select_sql, dbms_sql.v7 );
4952:
4953: IF ( p_customer_trx_id IS NOT NULL ) THEN
4954: ----------------------------------------------------
4955: -- Passed customer_trx_id

Line 4957: dbms_sql.bind_variable(p_select_sql_c, ':p_customer_trx_id', p_customer_trx_id);

4953: IF ( p_customer_trx_id IS NOT NULL ) THEN
4954: ----------------------------------------------------
4955: -- Passed customer_trx_id
4956: ----------------------------------------------------
4957: dbms_sql.bind_variable(p_select_sql_c, ':p_customer_trx_id', p_customer_trx_id);
4958:
4959: ELSE
4960:
4961: dbms_sql.bind_variable(p_select_sql_c, ':p_request_id', p_request_id);

Line 4961: dbms_sql.bind_variable(p_select_sql_c, ':p_request_id', p_request_id);

4957: dbms_sql.bind_variable(p_select_sql_c, ':p_customer_trx_id', p_customer_trx_id);
4958:
4959: ELSE
4960:
4961: dbms_sql.bind_variable(p_select_sql_c, ':p_request_id', p_request_id);
4962:
4963: END IF;
4964:
4965: EXCEPTION

Line 5083: l_ignore := dbms_sql.execute( select_sql_c );

5079: arp_standard.debug(' Executing select sql' );
5080: END IF;
5081:
5082: BEGIN
5083: l_ignore := dbms_sql.execute( select_sql_c );
5084:
5085: EXCEPTION
5086: WHEN OTHERS THEN
5087: IF PG_DEBUG in ('Y', 'C') THEN

Line 5102: if (dbms_sql.fetch_rows( select_sql_c ) > 0)

5098: END IF;
5099:
5100: begin
5101: loop
5102: if (dbms_sql.fetch_rows( select_sql_c ) > 0)
5103: then
5104:
5105: IF PG_DEBUG in ('Y', 'C') THEN
5106: arp_standard.debug(' fetched a row' );

Line 5169: dbms_sql.close_cursor(select_sql_c);

5165: end if;
5166: end loop;
5167: --Bug 1777081:Close the cursor to avoid the maximum cursor exceeding error.
5168:
5169: dbms_sql.close_cursor(select_sql_c);
5170: end;
5171:
5172: IF PG_DEBUG in ('Y', 'C') THEN
5173: arp_standard.debug( 'arp_rounding.do_header_level_rounding()- ' ||