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

Line 283: dbms_sql.bind_variable( cursor_name, ':org_id', p_org_id) ;

279:
280: BEGIN
281:
282: IF ( p_org_id is not null ) THEN
283: dbms_sql.bind_variable( cursor_name, ':org_id', p_org_id) ;
284: END IF;
285:
286: IF ( p_cust_num_low is not null ) THEN
287: dbms_sql.bind_variable( cursor_name, ':cust_num_low', p_cust_num_low ) ;

Line 287: dbms_sql.bind_variable( cursor_name, ':cust_num_low', p_cust_num_low ) ;

283: dbms_sql.bind_variable( cursor_name, ':org_id', p_org_id) ;
284: END IF;
285:
286: IF ( p_cust_num_low is not null ) THEN
287: dbms_sql.bind_variable( cursor_name, ':cust_num_low', p_cust_num_low ) ;
288: END IF;
289: IF ( p_cust_num_high is not null ) THEN
290: dbms_sql.bind_variable( cursor_name, ':cust_num_high', p_cust_num_high ) ;
291: END IF;

Line 290: dbms_sql.bind_variable( cursor_name, ':cust_num_high', p_cust_num_high ) ;

286: IF ( p_cust_num_low is not null ) THEN
287: dbms_sql.bind_variable( cursor_name, ':cust_num_low', p_cust_num_low ) ;
288: END IF;
289: IF ( p_cust_num_high is not null ) THEN
290: dbms_sql.bind_variable( cursor_name, ':cust_num_high', p_cust_num_high ) ;
291: END IF;
292:
293: IF ( p_bill_site_low is not null ) THEN
294: dbms_sql.bind_variable( cursor_name, ':bill_site_low', p_bill_site_low ) ;

Line 294: dbms_sql.bind_variable( cursor_name, ':bill_site_low', p_bill_site_low ) ;

290: dbms_sql.bind_variable( cursor_name, ':cust_num_high', p_cust_num_high ) ;
291: END IF;
292:
293: IF ( p_bill_site_low is not null ) THEN
294: dbms_sql.bind_variable( cursor_name, ':bill_site_low', p_bill_site_low ) ;
295: END IF;
296: IF ( p_bill_site_high is not null ) THEN
297: dbms_sql.bind_variable( cursor_name, ':bill_site_high', p_bill_site_high ) ;
298: END IF;

Line 297: dbms_sql.bind_variable( cursor_name, ':bill_site_high', p_bill_site_high ) ;

293: IF ( p_bill_site_low is not null ) THEN
294: dbms_sql.bind_variable( cursor_name, ':bill_site_low', p_bill_site_low ) ;
295: END IF;
296: IF ( p_bill_site_high is not null ) THEN
297: dbms_sql.bind_variable( cursor_name, ':bill_site_high', p_bill_site_high ) ;
298: END IF;
299:
300: dbms_sql.bind_variable( cursor_name, ':bill_date_low', p_bill_date_low ) ;
301: dbms_sql.bind_variable( cursor_name, ':bill_date_high', p_bill_date_high ) ;

Line 300: dbms_sql.bind_variable( cursor_name, ':bill_date_low', p_bill_date_low ) ;

296: IF ( p_bill_site_high is not null ) THEN
297: dbms_sql.bind_variable( cursor_name, ':bill_site_high', p_bill_site_high ) ;
298: END IF;
299:
300: dbms_sql.bind_variable( cursor_name, ':bill_date_low', p_bill_date_low ) ;
301: dbms_sql.bind_variable( cursor_name, ':bill_date_high', p_bill_date_high ) ;
302:
303: IF ( p_bill_num_low is not null ) THEN
304: dbms_sql.bind_variable( cursor_name, ':bill_num_low', p_bill_num_low ) ;

Line 301: dbms_sql.bind_variable( cursor_name, ':bill_date_high', p_bill_date_high ) ;

297: dbms_sql.bind_variable( cursor_name, ':bill_site_high', p_bill_site_high ) ;
298: END IF;
299:
300: dbms_sql.bind_variable( cursor_name, ':bill_date_low', p_bill_date_low ) ;
301: dbms_sql.bind_variable( cursor_name, ':bill_date_high', p_bill_date_high ) ;
302:
303: IF ( p_bill_num_low is not null ) THEN
304: dbms_sql.bind_variable( cursor_name, ':bill_num_low', p_bill_num_low ) ;
305: END IF;

Line 304: dbms_sql.bind_variable( cursor_name, ':bill_num_low', p_bill_num_low ) ;

300: dbms_sql.bind_variable( cursor_name, ':bill_date_low', p_bill_date_low ) ;
301: dbms_sql.bind_variable( cursor_name, ':bill_date_high', p_bill_date_high ) ;
302:
303: IF ( p_bill_num_low is not null ) THEN
304: dbms_sql.bind_variable( cursor_name, ':bill_num_low', p_bill_num_low ) ;
305: END IF;
306: IF ( p_bill_num_high is not null ) THEN
307: dbms_sql.bind_variable( cursor_name, ':bill_num_high', p_bill_num_high ) ;
308: END IF;

Line 307: dbms_sql.bind_variable( cursor_name, ':bill_num_high', p_bill_num_high ) ;

303: IF ( p_bill_num_low is not null ) THEN
304: dbms_sql.bind_variable( cursor_name, ':bill_num_low', p_bill_num_low ) ;
305: END IF;
306: IF ( p_bill_num_high is not null ) THEN
307: dbms_sql.bind_variable( cursor_name, ':bill_num_high', p_bill_num_high ) ;
308: END IF;
309:
310: IF ( p_request_id is not null ) THEN
311: dbms_sql.bind_variable( cursor_name, ':concurrent_request_id', p_request_id ) ;

Line 311: dbms_sql.bind_variable( cursor_name, ':concurrent_request_id', p_request_id ) ;

307: dbms_sql.bind_variable( cursor_name, ':bill_num_high', p_bill_num_high ) ;
308: END IF;
309:
310: IF ( p_request_id is not null ) THEN
311: dbms_sql.bind_variable( cursor_name, ':concurrent_request_id', p_request_id ) ;
312: END IF;
313:
314: END BIND_VARIABLES;
315:

Line 483: sql_stmt_c:= dbms_sql.open_cursor;

479: ------------------------------------------------
480: -- Parse sql stmts
481: ------------------------------------------------
482:
483: sql_stmt_c:= dbms_sql.open_cursor;
484:
485: dbms_sql.parse( sql_stmt_c, sql_stmt , dbms_sql.v7 );
486: bind_variables(
487: p_org_id,

Line 485: dbms_sql.parse( sql_stmt_c, sql_stmt , dbms_sql.v7 );

481: ------------------------------------------------
482:
483: sql_stmt_c:= dbms_sql.open_cursor;
484:
485: dbms_sql.parse( sql_stmt_c, sql_stmt , dbms_sql.v7 );
486: bind_variables(
487: p_org_id,
488: p_cust_num_low ,
489: p_cust_num_high ,

Line 499: dbms_sql.define_column( sql_stmt_c, 1, sql_stmt_rec.language, 4);

495: p_bill_num_high,
496: p_request_id,
497: sql_stmt_c);
498:
499: dbms_sql.define_column( sql_stmt_c, 1, sql_stmt_rec.language, 4);
500:
501: l_ignore := dbms_sql.execute( sql_stmt_c);
502:
503: LOOP

Line 501: l_ignore := dbms_sql.execute( sql_stmt_c);

497: sql_stmt_c);
498:
499: dbms_sql.define_column( sql_stmt_c, 1, sql_stmt_rec.language, 4);
500:
501: l_ignore := dbms_sql.execute( sql_stmt_c);
502:
503: LOOP
504: IF (dbms_sql.fetch_rows( sql_stmt_c) > 0)
505: THEN

Line 504: IF (dbms_sql.fetch_rows( sql_stmt_c) > 0)

500:
501: l_ignore := dbms_sql.execute( sql_stmt_c);
502:
503: LOOP
504: IF (dbms_sql.fetch_rows( sql_stmt_c) > 0)
505: THEN
506:
507: ------------------------------------------------------
508: -- Get column values

Line 510: dbms_sql.column_value( sql_stmt_c, 1, sql_stmt_rec.language );

506:
507: ------------------------------------------------------
508: -- Get column values
509: ------------------------------------------------------
510: dbms_sql.column_value( sql_stmt_c, 1, sql_stmt_rec.language );
511:
512: IF (lang_str is null) THEN
513: lang_str := sql_stmt_rec.language;
514: ELSE

Line 666: sql_stmt_c:= dbms_sql.open_cursor;

662: ------------------------------------------------
663: -- Parse sql stmts
664: ------------------------------------------------
665:
666: sql_stmt_c:= dbms_sql.open_cursor;
667:
668: dbms_sql.parse( sql_stmt_c, sql_stmt , dbms_sql.v7 );
669:
670: bind_variables(

Line 668: dbms_sql.parse( sql_stmt_c, sql_stmt , dbms_sql.v7 );

664: ------------------------------------------------
665:
666: sql_stmt_c:= dbms_sql.open_cursor;
667:
668: dbms_sql.parse( sql_stmt_c, sql_stmt , dbms_sql.v7 );
669:
670: bind_variables(
671: p_org_id,
672: p_cust_num_low ,

Line 683: inserted_row_counts := dbms_sql.execute(sql_stmt_c);

679: p_bill_num_high,
680: p_request_id,
681: sql_stmt_c);
682:
683: inserted_row_counts := dbms_sql.execute(sql_stmt_c);
684: fnd_file.put_line( fnd_file.log, 'inserted row count: ' || inserted_row_counts);
685:
686: IF inserted_row_counts > 0 THEN
687:

Line 829: ps_id dbms_sql.number_table;

825:
826: select_stmt VARCHAR2(1024);
827: select_cur INTEGER;
828:
829: ps_id dbms_sql.number_table;
830:
831: inserted_row_counts INTEGER;
832: fetched_row_count INTEGER;
833: ignore INTEGER;

Line 874: select_cur := dbms_sql.open_cursor;

870: select_stmt := ' SELECT to_number(cons.cons_billing_number) ' || cr || build_from_clause || cr ||
871: ' AND cons.cons_inv_id in ('|| p_id_list || ' ) ' || cr ||
872: ' AND nvl(a_bill.language, ''' || base_lang ||''' ) = :lang_code ';
873:
874: select_cur := dbms_sql.open_cursor;
875: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
876:
877: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
878: dbms_sql.define_array(select_cur,1,ps_id,500,1 );

Line 875: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );

871: ' AND cons.cons_inv_id in ('|| p_id_list || ' ) ' || cr ||
872: ' AND nvl(a_bill.language, ''' || base_lang ||''' ) = :lang_code ';
873:
874: select_cur := dbms_sql.open_cursor;
875: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
876:
877: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
878: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
879: ignore := dbms_sql.execute(select_cur);

Line 877: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );

873:
874: select_cur := dbms_sql.open_cursor;
875: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
876:
877: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
878: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
879: ignore := dbms_sql.execute(select_cur);
880:
881: LOOP

Line 878: dbms_sql.define_array(select_cur,1,ps_id,500,1 );

874: select_cur := dbms_sql.open_cursor;
875: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
876:
877: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
878: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
879: ignore := dbms_sql.execute(select_cur);
880:
881: LOOP
882: fetched_row_count := dbms_sql.fetch_rows(select_cur);

Line 879: ignore := dbms_sql.execute(select_cur);

875: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
876:
877: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
878: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
879: ignore := dbms_sql.execute(select_cur);
880:
881: LOOP
882: fetched_row_count := dbms_sql.fetch_rows(select_cur);
883: dbms_sql.column_value(select_cur,1,ps_id);

Line 882: fetched_row_count := dbms_sql.fetch_rows(select_cur);

878: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
879: ignore := dbms_sql.execute(select_cur);
880:
881: LOOP
882: fetched_row_count := dbms_sql.fetch_rows(select_cur);
883: dbms_sql.column_value(select_cur,1,ps_id);
884:
885: EXIT WHEN fetched_row_count <> 500 ;
886: END LOOP;

Line 883: dbms_sql.column_value(select_cur,1,ps_id);

879: ignore := dbms_sql.execute(select_cur);
880:
881: LOOP
882: fetched_row_count := dbms_sql.fetch_rows(select_cur);
883: dbms_sql.column_value(select_cur,1,ps_id);
884:
885: EXIT WHEN fetched_row_count <> 500 ;
886: END LOOP;
887: dbms_sql.close_cursor(select_cur);

Line 887: dbms_sql.close_cursor(select_cur);

883: dbms_sql.column_value(select_cur,1,ps_id);
884:
885: EXIT WHEN fetched_row_count <> 500 ;
886: END LOOP;
887: dbms_sql.close_cursor(select_cur);
888:
889: inserted_row_counts := ps_id.COUNT ;
890:
891: divided_worker_counts := ceil(inserted_row_counts/500);

Line 957: IF dbms_sql.is_open(select_cur) THEN

953:
954: CLOSE lang_cv;
955: EXCEPTION
956: WHEN OTHERS THEN
957: IF dbms_sql.is_open(select_cur) THEN
958: dbms_sql.close_cursor(select_cur);
959: END IF;
960: IF lang_cv%ISOPEN THEN
961: CLOSE lang_cv;

Line 958: dbms_sql.close_cursor(select_cur);

954: CLOSE lang_cv;
955: EXCEPTION
956: WHEN OTHERS THEN
957: IF dbms_sql.is_open(select_cur) THEN
958: dbms_sql.close_cursor(select_cur);
959: END IF;
960: IF lang_cv%ISOPEN THEN
961: CLOSE lang_cv;
962: END IF;