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 277: dbms_sql.bind_variable( cursor_name, ':org_id', p_org_id) ;

273:
274: BEGIN
275:
276: IF ( p_org_id is not null ) THEN
277: dbms_sql.bind_variable( cursor_name, ':org_id', p_org_id) ;
278: END IF;
279:
280: IF ( p_cust_num_low is not null ) THEN
281: dbms_sql.bind_variable( cursor_name, ':cust_num_low', p_cust_num_low ) ;

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

277: dbms_sql.bind_variable( cursor_name, ':org_id', p_org_id) ;
278: END IF;
279:
280: IF ( p_cust_num_low is not null ) THEN
281: dbms_sql.bind_variable( cursor_name, ':cust_num_low', p_cust_num_low ) ;
282: END IF;
283: IF ( p_cust_num_high is not null ) THEN
284: dbms_sql.bind_variable( cursor_name, ':cust_num_high', p_cust_num_high ) ;
285: END IF;

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

280: IF ( p_cust_num_low is not null ) THEN
281: dbms_sql.bind_variable( cursor_name, ':cust_num_low', p_cust_num_low ) ;
282: END IF;
283: IF ( p_cust_num_high is not null ) THEN
284: dbms_sql.bind_variable( cursor_name, ':cust_num_high', p_cust_num_high ) ;
285: END IF;
286:
287: IF ( p_bill_site_low is not null ) THEN
288: dbms_sql.bind_variable( cursor_name, ':bill_site_low', p_bill_site_low ) ;

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

284: dbms_sql.bind_variable( cursor_name, ':cust_num_high', p_cust_num_high ) ;
285: END IF;
286:
287: IF ( p_bill_site_low is not null ) THEN
288: dbms_sql.bind_variable( cursor_name, ':bill_site_low', p_bill_site_low ) ;
289: END IF;
290: IF ( p_bill_site_high is not null ) THEN
291: dbms_sql.bind_variable( cursor_name, ':bill_site_high', p_bill_site_high ) ;
292: END IF;

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

287: IF ( p_bill_site_low is not null ) THEN
288: dbms_sql.bind_variable( cursor_name, ':bill_site_low', p_bill_site_low ) ;
289: END IF;
290: IF ( p_bill_site_high is not null ) THEN
291: dbms_sql.bind_variable( cursor_name, ':bill_site_high', p_bill_site_high ) ;
292: END IF;
293:
294: dbms_sql.bind_variable( cursor_name, ':bill_date_low', p_bill_date_low ) ;
295: dbms_sql.bind_variable( cursor_name, ':bill_date_high', p_bill_date_high ) ;

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

290: IF ( p_bill_site_high is not null ) THEN
291: dbms_sql.bind_variable( cursor_name, ':bill_site_high', p_bill_site_high ) ;
292: END IF;
293:
294: dbms_sql.bind_variable( cursor_name, ':bill_date_low', p_bill_date_low ) ;
295: dbms_sql.bind_variable( cursor_name, ':bill_date_high', p_bill_date_high ) ;
296:
297: IF ( p_bill_num_low is not null ) THEN
298: dbms_sql.bind_variable( cursor_name, ':bill_num_low', p_bill_num_low ) ;

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

291: dbms_sql.bind_variable( cursor_name, ':bill_site_high', p_bill_site_high ) ;
292: END IF;
293:
294: dbms_sql.bind_variable( cursor_name, ':bill_date_low', p_bill_date_low ) ;
295: dbms_sql.bind_variable( cursor_name, ':bill_date_high', p_bill_date_high ) ;
296:
297: IF ( p_bill_num_low is not null ) THEN
298: dbms_sql.bind_variable( cursor_name, ':bill_num_low', p_bill_num_low ) ;
299: END IF;

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

294: dbms_sql.bind_variable( cursor_name, ':bill_date_low', p_bill_date_low ) ;
295: dbms_sql.bind_variable( cursor_name, ':bill_date_high', p_bill_date_high ) ;
296:
297: IF ( p_bill_num_low is not null ) THEN
298: dbms_sql.bind_variable( cursor_name, ':bill_num_low', p_bill_num_low ) ;
299: END IF;
300: IF ( p_bill_num_high is not null ) THEN
301: dbms_sql.bind_variable( cursor_name, ':bill_num_high', p_bill_num_high ) ;
302: END IF;

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

297: IF ( p_bill_num_low is not null ) THEN
298: dbms_sql.bind_variable( cursor_name, ':bill_num_low', p_bill_num_low ) ;
299: END IF;
300: IF ( p_bill_num_high is not null ) THEN
301: dbms_sql.bind_variable( cursor_name, ':bill_num_high', p_bill_num_high ) ;
302: END IF;
303:
304: IF ( p_request_id is not null ) THEN
305: dbms_sql.bind_variable( cursor_name, ':concurrent_request_id', p_request_id ) ;

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

301: dbms_sql.bind_variable( cursor_name, ':bill_num_high', p_bill_num_high ) ;
302: END IF;
303:
304: IF ( p_request_id is not null ) THEN
305: dbms_sql.bind_variable( cursor_name, ':concurrent_request_id', p_request_id ) ;
306: END IF;
307:
308: END BIND_VARIABLES;
309:

Line 474: sql_stmt_c:= dbms_sql.open_cursor;

470: ------------------------------------------------
471: -- Parse sql stmts
472: ------------------------------------------------
473:
474: sql_stmt_c:= dbms_sql.open_cursor;
475:
476: dbms_sql.parse( sql_stmt_c, sql_stmt , dbms_sql.v7 );
477: bind_variables(
478: p_org_id,

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

472: ------------------------------------------------
473:
474: sql_stmt_c:= dbms_sql.open_cursor;
475:
476: dbms_sql.parse( sql_stmt_c, sql_stmt , dbms_sql.v7 );
477: bind_variables(
478: p_org_id,
479: p_cust_num_low ,
480: p_cust_num_high ,

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

486: p_bill_num_high,
487: p_request_id,
488: sql_stmt_c);
489:
490: dbms_sql.define_column( sql_stmt_c, 1, sql_stmt_rec.language, 4);
491:
492: l_ignore := dbms_sql.execute( sql_stmt_c);
493:
494: LOOP

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

488: sql_stmt_c);
489:
490: dbms_sql.define_column( sql_stmt_c, 1, sql_stmt_rec.language, 4);
491:
492: l_ignore := dbms_sql.execute( sql_stmt_c);
493:
494: LOOP
495: IF (dbms_sql.fetch_rows( sql_stmt_c) > 0)
496: THEN

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

491:
492: l_ignore := dbms_sql.execute( sql_stmt_c);
493:
494: LOOP
495: IF (dbms_sql.fetch_rows( sql_stmt_c) > 0)
496: THEN
497:
498: ------------------------------------------------------
499: -- Get column values

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

497:
498: ------------------------------------------------------
499: -- Get column values
500: ------------------------------------------------------
501: dbms_sql.column_value( sql_stmt_c, 1, sql_stmt_rec.language );
502:
503: IF (lang_str is null) THEN
504: lang_str := sql_stmt_rec.language;
505: ELSE

Line 654: sql_stmt_c:= dbms_sql.open_cursor;

650: ------------------------------------------------
651: -- Parse sql stmts
652: ------------------------------------------------
653:
654: sql_stmt_c:= dbms_sql.open_cursor;
655:
656: dbms_sql.parse( sql_stmt_c, sql_stmt , dbms_sql.v7 );
657:
658: bind_variables(

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

652: ------------------------------------------------
653:
654: sql_stmt_c:= dbms_sql.open_cursor;
655:
656: dbms_sql.parse( sql_stmt_c, sql_stmt , dbms_sql.v7 );
657:
658: bind_variables(
659: p_org_id,
660: p_cust_num_low ,

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

667: p_bill_num_high,
668: p_request_id,
669: sql_stmt_c);
670:
671: inserted_row_counts := dbms_sql.execute(sql_stmt_c);
672: fnd_file.put_line( fnd_file.log, 'inserted row count: ' || inserted_row_counts);
673:
674: IF inserted_row_counts > 0 THEN
675:

Line 817: ps_id dbms_sql.number_table;

813:
814: select_stmt VARCHAR2(1024);
815: select_cur INTEGER;
816:
817: ps_id dbms_sql.number_table;
818:
819: inserted_row_counts INTEGER;
820: fetched_row_count INTEGER;
821: ignore INTEGER;

Line 862: select_cur := dbms_sql.open_cursor;

858: select_stmt := ' SELECT to_number(cons.cons_billing_number) ' || cr || build_from_clause || cr ||
859: ' AND cons.cons_inv_id in ('|| p_id_list || ' ) ' || cr ||
860: ' AND nvl(a_bill.language, ''' || base_lang ||''' ) = :lang_code ';
861:
862: select_cur := dbms_sql.open_cursor;
863: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
864:
865: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
866: dbms_sql.define_array(select_cur,1,ps_id,500,1 );

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

859: ' AND cons.cons_inv_id in ('|| p_id_list || ' ) ' || cr ||
860: ' AND nvl(a_bill.language, ''' || base_lang ||''' ) = :lang_code ';
861:
862: select_cur := dbms_sql.open_cursor;
863: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
864:
865: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
866: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
867: ignore := dbms_sql.execute(select_cur);

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

861:
862: select_cur := dbms_sql.open_cursor;
863: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
864:
865: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
866: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
867: ignore := dbms_sql.execute(select_cur);
868:
869: LOOP

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

862: select_cur := dbms_sql.open_cursor;
863: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
864:
865: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
866: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
867: ignore := dbms_sql.execute(select_cur);
868:
869: LOOP
870: fetched_row_count := dbms_sql.fetch_rows(select_cur);

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

863: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
864:
865: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
866: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
867: ignore := dbms_sql.execute(select_cur);
868:
869: LOOP
870: fetched_row_count := dbms_sql.fetch_rows(select_cur);
871: dbms_sql.column_value(select_cur,1,ps_id);

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

866: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
867: ignore := dbms_sql.execute(select_cur);
868:
869: LOOP
870: fetched_row_count := dbms_sql.fetch_rows(select_cur);
871: dbms_sql.column_value(select_cur,1,ps_id);
872:
873: EXIT WHEN fetched_row_count <> 500 ;
874: END LOOP;

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

867: ignore := dbms_sql.execute(select_cur);
868:
869: LOOP
870: fetched_row_count := dbms_sql.fetch_rows(select_cur);
871: dbms_sql.column_value(select_cur,1,ps_id);
872:
873: EXIT WHEN fetched_row_count <> 500 ;
874: END LOOP;
875: dbms_sql.close_cursor(select_cur);

Line 875: dbms_sql.close_cursor(select_cur);

871: dbms_sql.column_value(select_cur,1,ps_id);
872:
873: EXIT WHEN fetched_row_count <> 500 ;
874: END LOOP;
875: dbms_sql.close_cursor(select_cur);
876:
877: inserted_row_counts := ps_id.COUNT ;
878:
879: divided_worker_counts := ceil(inserted_row_counts/500);

Line 945: IF dbms_sql.is_open(select_cur) THEN

941:
942: CLOSE lang_cv;
943: EXCEPTION
944: WHEN OTHERS THEN
945: IF dbms_sql.is_open(select_cur) THEN
946: dbms_sql.close_cursor(select_cur);
947: END IF;
948: IF lang_cv%ISOPEN THEN
949: CLOSE lang_cv;

Line 946: dbms_sql.close_cursor(select_cur);

942: CLOSE lang_cv;
943: EXCEPTION
944: WHEN OTHERS THEN
945: IF dbms_sql.is_open(select_cur) THEN
946: dbms_sql.close_cursor(select_cur);
947: END IF;
948: IF lang_cv%ISOPEN THEN
949: CLOSE lang_cv;
950: END IF;