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 4831: dbms_sql.column_value( p_select_sql_c, 1,

4827: IF PG_DEBUG in ('Y', 'C') THEN
4828: arp_standard.debug( 'arp_rounding.get_select_column_values()+' );
4829: END IF;
4830:
4831: dbms_sql.column_value( p_select_sql_c, 1,
4832: p_select_rec.rec_customer_trx_id);
4833: dbms_sql.column_value( p_select_sql_c, 2,
4834: p_select_rec.rec_code_combination_id);
4835: dbms_sql.column_value( p_select_sql_c, 3,

Line 4833: dbms_sql.column_value( p_select_sql_c, 2,

4829: END IF;
4830:
4831: dbms_sql.column_value( p_select_sql_c, 1,
4832: p_select_rec.rec_customer_trx_id);
4833: dbms_sql.column_value( p_select_sql_c, 2,
4834: p_select_rec.rec_code_combination_id);
4835: dbms_sql.column_value( p_select_sql_c, 3,
4836: p_select_rec.round_customer_trx_id);
4837:

Line 4835: dbms_sql.column_value( p_select_sql_c, 3,

4831: dbms_sql.column_value( p_select_sql_c, 1,
4832: p_select_rec.rec_customer_trx_id);
4833: dbms_sql.column_value( p_select_sql_c, 2,
4834: p_select_rec.rec_code_combination_id);
4835: dbms_sql.column_value( p_select_sql_c, 3,
4836: p_select_rec.round_customer_trx_id);
4837:
4838: IF PG_DEBUG in ('Y', 'C') THEN
4839: arp_standard.debug( 'arp_rounding.get_select_column_values()-' );

Line 4885: dbms_sql.define_column( p_select_sql_c, 1,

4881: -- Define columns
4882: ------------------------------------------------------------
4883: arp_standard.debug( ' Defining columns for select_sql_c');
4884:
4885: dbms_sql.define_column( p_select_sql_c, 1,
4886: p_select_rec.rec_customer_trx_id );
4887: dbms_sql.define_column( p_select_sql_c, 2,
4888: p_select_rec.rec_code_combination_id );
4889: dbms_sql.define_column( p_select_sql_c, 3,

Line 4887: dbms_sql.define_column( p_select_sql_c, 2,

4883: arp_standard.debug( ' Defining columns for select_sql_c');
4884:
4885: dbms_sql.define_column( p_select_sql_c, 1,
4886: p_select_rec.rec_customer_trx_id );
4887: dbms_sql.define_column( p_select_sql_c, 2,
4888: p_select_rec.rec_code_combination_id );
4889: dbms_sql.define_column( p_select_sql_c, 3,
4890: p_select_rec.round_customer_trx_id );
4891:

Line 4889: dbms_sql.define_column( p_select_sql_c, 3,

4885: dbms_sql.define_column( p_select_sql_c, 1,
4886: p_select_rec.rec_customer_trx_id );
4887: dbms_sql.define_column( p_select_sql_c, 2,
4888: p_select_rec.rec_code_combination_id );
4889: dbms_sql.define_column( p_select_sql_c, 3,
4890: p_select_rec.round_customer_trx_id );
4891:
4892: arp_standard.debug( 'arp_rounding.define_columns()-' );
4893:

Line 4962: p_select_sql_c := dbms_sql.open_cursor;

4958: IF PG_DEBUG in ('Y', 'C') THEN
4959: arp_standard.debug('Parsing select stmt');
4960: END IF;
4961:
4962: p_select_sql_c := dbms_sql.open_cursor;
4963: dbms_sql.parse( p_select_sql_c, l_select_sql, dbms_sql.v7 );
4964:
4965: IF ( p_customer_trx_id IS NOT NULL ) THEN
4966: ----------------------------------------------------

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

4959: arp_standard.debug('Parsing select stmt');
4960: END IF;
4961:
4962: p_select_sql_c := dbms_sql.open_cursor;
4963: dbms_sql.parse( p_select_sql_c, l_select_sql, dbms_sql.v7 );
4964:
4965: IF ( p_customer_trx_id IS NOT NULL ) THEN
4966: ----------------------------------------------------
4967: -- Passed customer_trx_id

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

4965: IF ( p_customer_trx_id IS NOT NULL ) THEN
4966: ----------------------------------------------------
4967: -- Passed customer_trx_id
4968: ----------------------------------------------------
4969: dbms_sql.bind_variable(p_select_sql_c, ':p_customer_trx_id', p_customer_trx_id);
4970:
4971: ELSE
4972:
4973: dbms_sql.bind_variable(p_select_sql_c, ':p_request_id', p_request_id);

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

4969: dbms_sql.bind_variable(p_select_sql_c, ':p_customer_trx_id', p_customer_trx_id);
4970:
4971: ELSE
4972:
4973: dbms_sql.bind_variable(p_select_sql_c, ':p_request_id', p_request_id);
4974:
4975: END IF;
4976:
4977: EXCEPTION

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

5091: arp_standard.debug(' Executing select sql' );
5092: END IF;
5093:
5094: BEGIN
5095: l_ignore := dbms_sql.execute( select_sql_c );
5096:
5097: EXCEPTION
5098: WHEN OTHERS THEN
5099: IF PG_DEBUG in ('Y', 'C') THEN

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

5110: END IF;
5111:
5112: begin
5113: loop
5114: if (dbms_sql.fetch_rows( select_sql_c ) > 0)
5115: then
5116:
5117: IF PG_DEBUG in ('Y', 'C') THEN
5118: arp_standard.debug(' fetched a row' );

Line 5181: dbms_sql.close_cursor(select_sql_c);

5177: end if;
5178: end loop;
5179: --Bug 1777081:Close the cursor to avoid the maximum cursor exceeding error.
5180:
5181: dbms_sql.close_cursor(select_sql_c);
5182: end;
5183:
5184: IF PG_DEBUG in ('Y', 'C') THEN
5185: arp_standard.debug( 'arp_rounding.do_header_level_rounding()- ' ||