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

Line 478: dbms_sql.bind_variable( cursor_name, ':customer_class_code', p_customer_class_code) ;

474: --------------------------------------------------------------------------*/
475:
476:
477: IF ( p_customer_class_code is not null ) THEN
478: dbms_sql.bind_variable( cursor_name, ':customer_class_code', p_customer_class_code) ;
479: END IF;
480:
481: IF ( p_org_id is not null ) THEN
482: dbms_sql.bind_variable( cursor_name, ':org_id', p_org_id) ;

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

478: dbms_sql.bind_variable( cursor_name, ':customer_class_code', p_customer_class_code) ;
479: END IF;
480:
481: IF ( p_org_id is not null ) THEN
482: dbms_sql.bind_variable( cursor_name, ':org_id', p_org_id) ;
483: END IF;
484:
485: IF ( p_customer_name_low is not null and p_customer_name_high is null )THEN
486: dbms_sql.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);

Line 486: dbms_sql.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);

482: dbms_sql.bind_variable( cursor_name, ':org_id', p_org_id) ;
483: END IF;
484:
485: IF ( p_customer_name_low is not null and p_customer_name_high is null )THEN
486: dbms_sql.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
487: ELSIF ( (p_customer_name_high is not null) and (p_customer_name_low is null ) ) THEN
488: dbms_sql.bind_variable( cursor_name, ':customer_name_high', p_customer_name_high );
489: ELSIF ( (p_customer_name_high is not null) and (p_customer_name_low is not null) ) THEN
490: dbms_sql.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);

Line 488: dbms_sql.bind_variable( cursor_name, ':customer_name_high', p_customer_name_high );

484:
485: IF ( p_customer_name_low is not null and p_customer_name_high is null )THEN
486: dbms_sql.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
487: ELSIF ( (p_customer_name_high is not null) and (p_customer_name_low is null ) ) THEN
488: dbms_sql.bind_variable( cursor_name, ':customer_name_high', p_customer_name_high );
489: ELSIF ( (p_customer_name_high is not null) and (p_customer_name_low is not null) ) THEN
490: dbms_sql.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
491: dbms_sql.bind_variable( cursor_name,':customer_name_high', p_customer_name_high);
492: END IF;

Line 490: dbms_sql.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);

486: dbms_sql.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
487: ELSIF ( (p_customer_name_high is not null) and (p_customer_name_low is null ) ) THEN
488: dbms_sql.bind_variable( cursor_name, ':customer_name_high', p_customer_name_high );
489: ELSIF ( (p_customer_name_high is not null) and (p_customer_name_low is not null) ) THEN
490: dbms_sql.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
491: dbms_sql.bind_variable( cursor_name,':customer_name_high', p_customer_name_high);
492: END IF;
493:
494: IF ( (p_customer_no_low is not null) and (p_customer_no_high is null) ) THEN

Line 491: dbms_sql.bind_variable( cursor_name,':customer_name_high', p_customer_name_high);

487: ELSIF ( (p_customer_name_high is not null) and (p_customer_name_low is null ) ) THEN
488: dbms_sql.bind_variable( cursor_name, ':customer_name_high', p_customer_name_high );
489: ELSIF ( (p_customer_name_high is not null) and (p_customer_name_low is not null) ) THEN
490: dbms_sql.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
491: dbms_sql.bind_variable( cursor_name,':customer_name_high', p_customer_name_high);
492: END IF;
493:
494: IF ( (p_customer_no_low is not null) and (p_customer_no_high is null) ) THEN
495: dbms_sql.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;

Line 495: dbms_sql.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;

491: dbms_sql.bind_variable( cursor_name,':customer_name_high', p_customer_name_high);
492: END IF;
493:
494: IF ( (p_customer_no_low is not null) and (p_customer_no_high is null) ) THEN
495: dbms_sql.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
496: ELSIF ( (p_customer_no_high is not null) and (p_customer_no_low is null) ) THEN
497: dbms_sql.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high );
498: ELSIF ( (p_customer_no_high is not null) and (p_customer_no_low is not null) ) THEN
499: dbms_sql.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;

Line 497: dbms_sql.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high );

493:
494: IF ( (p_customer_no_low is not null) and (p_customer_no_high is null) ) THEN
495: dbms_sql.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
496: ELSIF ( (p_customer_no_high is not null) and (p_customer_no_low is null) ) THEN
497: dbms_sql.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high );
498: ELSIF ( (p_customer_no_high is not null) and (p_customer_no_low is not null) ) THEN
499: dbms_sql.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
500: dbms_sql.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high ) ;
501: END IF;

Line 499: dbms_sql.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;

495: dbms_sql.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
496: ELSIF ( (p_customer_no_high is not null) and (p_customer_no_low is null) ) THEN
497: dbms_sql.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high );
498: ELSIF ( (p_customer_no_high is not null) and (p_customer_no_low is not null) ) THEN
499: dbms_sql.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
500: dbms_sql.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high ) ;
501: END IF;
502:
503: IF ( p_cust_trx_class is not null ) THEN

Line 500: dbms_sql.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high ) ;

496: ELSIF ( (p_customer_no_high is not null) and (p_customer_no_low is null) ) THEN
497: dbms_sql.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high );
498: ELSIF ( (p_customer_no_high is not null) and (p_customer_no_low is not null) ) THEN
499: dbms_sql.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
500: dbms_sql.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high ) ;
501: END IF;
502:
503: IF ( p_cust_trx_class is not null ) THEN
504: dbms_sql.bind_variable( cursor_name, ':cust_trx_class', p_cust_trx_class );

Line 504: dbms_sql.bind_variable( cursor_name, ':cust_trx_class', p_cust_trx_class );

500: dbms_sql.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high ) ;
501: END IF;
502:
503: IF ( p_cust_trx_class is not null ) THEN
504: dbms_sql.bind_variable( cursor_name, ':cust_trx_class', p_cust_trx_class );
505: END IF;
506:
507: IF ( p_trx_type_id is not null ) THEN
508: dbms_sql.bind_variable( cursor_name, ':trx_type_id', p_trx_type_id ) ;

Line 508: dbms_sql.bind_variable( cursor_name, ':trx_type_id', p_trx_type_id ) ;

504: dbms_sql.bind_variable( cursor_name, ':cust_trx_class', p_cust_trx_class );
505: END IF;
506:
507: IF ( p_trx_type_id is not null ) THEN
508: dbms_sql.bind_variable( cursor_name, ':trx_type_id', p_trx_type_id ) ;
509: END IF;
510:
511: IF ( (p_trx_number_low is not null) and (p_trx_number_high is null )) THEN
512: dbms_sql.bind_variable( cursor_name, ':trx_number_low', p_trx_number_low);

Line 512: dbms_sql.bind_variable( cursor_name, ':trx_number_low', p_trx_number_low);

508: dbms_sql.bind_variable( cursor_name, ':trx_type_id', p_trx_type_id ) ;
509: END IF;
510:
511: IF ( (p_trx_number_low is not null) and (p_trx_number_high is null )) THEN
512: dbms_sql.bind_variable( cursor_name, ':trx_number_low', p_trx_number_low);
513: ELSIF ( (p_trx_number_high is not null) and (p_trx_number_low is null) ) THEN
514: dbms_sql.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
515: ELSIF ( (p_trx_number_high is not null ) and (p_trx_number_low is not null) ) THEN
516: dbms_sql.bind_variable( cursor_name, ':trx_number_low' , p_trx_number_low);

Line 514: dbms_sql.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);

510:
511: IF ( (p_trx_number_low is not null) and (p_trx_number_high is null )) THEN
512: dbms_sql.bind_variable( cursor_name, ':trx_number_low', p_trx_number_low);
513: ELSIF ( (p_trx_number_high is not null) and (p_trx_number_low is null) ) THEN
514: dbms_sql.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
515: ELSIF ( (p_trx_number_high is not null ) and (p_trx_number_low is not null) ) THEN
516: dbms_sql.bind_variable( cursor_name, ':trx_number_low' , p_trx_number_low);
517: dbms_sql.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
518: END IF;

Line 516: dbms_sql.bind_variable( cursor_name, ':trx_number_low' , p_trx_number_low);

512: dbms_sql.bind_variable( cursor_name, ':trx_number_low', p_trx_number_low);
513: ELSIF ( (p_trx_number_high is not null) and (p_trx_number_low is null) ) THEN
514: dbms_sql.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
515: ELSIF ( (p_trx_number_high is not null ) and (p_trx_number_low is not null) ) THEN
516: dbms_sql.bind_variable( cursor_name, ':trx_number_low' , p_trx_number_low);
517: dbms_sql.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
518: END IF;
519:
520: IF ( (p_installment_no is not null) ) THEN

Line 517: dbms_sql.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);

513: ELSIF ( (p_trx_number_high is not null) and (p_trx_number_low is null) ) THEN
514: dbms_sql.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
515: ELSIF ( (p_trx_number_high is not null ) and (p_trx_number_low is not null) ) THEN
516: dbms_sql.bind_variable( cursor_name, ':trx_number_low' , p_trx_number_low);
517: dbms_sql.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
518: END IF;
519:
520: IF ( (p_installment_no is not null) ) THEN
521: dbms_sql.bind_variable( cursor_name, ':installment_no', p_installment_no) ;

Line 521: dbms_sql.bind_variable( cursor_name, ':installment_no', p_installment_no) ;

517: dbms_sql.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
518: END IF;
519:
520: IF ( (p_installment_no is not null) ) THEN
521: dbms_sql.bind_variable( cursor_name, ':installment_no', p_installment_no) ;
522: END IF;
523:
524:
525: IF ( p_batch_id is not null ) THEN

Line 526: dbms_sql.bind_variable( cursor_name, ':batch_id', p_batch_id ) ;

522: END IF;
523:
524:
525: IF ( p_batch_id is not null ) THEN
526: dbms_sql.bind_variable( cursor_name, ':batch_id', p_batch_id ) ;
527: END IF;
528:
529:
530: /**********************************************************************************

Line 542: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,

538:
539: IF ( (p_print_date_low is not null) or (p_print_date_low is not null) ) THEN
540: IF ( p_union_flag = 'N' ) THEN
541: IF ( p_print_date_low is not null and p_print_date_high is not null ) THEN
542: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,
543: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
544: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,
545: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
546: ELSIF ( p_print_date_low is not null and p_print_date_high is null) THEN

Line 544: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,

540: IF ( p_union_flag = 'N' ) THEN
541: IF ( p_print_date_low is not null and p_print_date_high is not null ) THEN
542: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,
543: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
544: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,
545: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
546: ELSIF ( p_print_date_low is not null and p_print_date_high is null) THEN
547: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,
548: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));

Line 547: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,

543: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
544: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,
545: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
546: ELSIF ( p_print_date_low is not null and p_print_date_high is null) THEN
547: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,
548: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
549: ELSIF ( p_print_date_high is not null and p_print_date_low is null ) THEN
550: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,
551: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));

Line 550: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,

546: ELSIF ( p_print_date_low is not null and p_print_date_high is null) THEN
547: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,
548: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
549: ELSIF ( p_print_date_high is not null and p_print_date_low is null ) THEN
550: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,
551: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
552: END IF;
553: ELSE
554: IF ( p_print_date_low is not null and p_print_date_high is not null ) THEN

Line 555: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,

551: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
552: END IF;
553: ELSE
554: IF ( p_print_date_low is not null and p_print_date_high is not null ) THEN
555: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,
556: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
557: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,
558: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
559: ELSIF ( p_print_date_low is not null and p_print_date_high is null ) THEN

Line 557: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,

553: ELSE
554: IF ( p_print_date_low is not null and p_print_date_high is not null ) THEN
555: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,
556: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
557: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,
558: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
559: ELSIF ( p_print_date_low is not null and p_print_date_high is null ) THEN
560: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,
561: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));

Line 560: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,

556: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
557: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,
558: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
559: ELSIF ( p_print_date_low is not null and p_print_date_high is null ) THEN
560: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,
561: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
562: ELSIF ( p_print_date_high is not null and p_print_date_low is null ) THEN
563: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,
564: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));

Line 563: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,

559: ELSIF ( p_print_date_low is not null and p_print_date_high is null ) THEN
560: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,
561: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
562: ELSIF ( p_print_date_high is not null and p_print_date_low is null ) THEN
563: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,
564: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
565: END IF;
566: END IF;
567: END IF;

Line 845: sql_stmt_c:= dbms_sql.open_cursor;

841: ------------------------------------------------
842: -- Parse sql stmts
843: ------------------------------------------------
844:
845: sql_stmt_c:= dbms_sql.open_cursor;
846:
847: dbms_sql.parse( sql_stmt_c, sql_stmt , dbms_sql.v7 );
848: bind_variables(
849: p_org_id,

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

843: ------------------------------------------------
844:
845: sql_stmt_c:= dbms_sql.open_cursor;
846:
847: dbms_sql.parse( sql_stmt_c, sql_stmt , dbms_sql.v7 );
848: bind_variables(
849: p_org_id,
850: p_choice ,
851: p_batch_id ,

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

889: sql_stmt_c );
890: END IF;
891:
892:
893: dbms_sql.define_column( sql_stmt_c, 1, sql_stmt_rec.language, 4);
894:
895:
896: l_ignore := dbms_sql.execute( sql_stmt_c);
897:

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

892:
893: dbms_sql.define_column( sql_stmt_c, 1, sql_stmt_rec.language, 4);
894:
895:
896: l_ignore := dbms_sql.execute( sql_stmt_c);
897:
898: LOOP
899: IF (dbms_sql.fetch_rows( sql_stmt_c) > 0)
900: THEN

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

895:
896: l_ignore := dbms_sql.execute( sql_stmt_c);
897:
898: LOOP
899: IF (dbms_sql.fetch_rows( sql_stmt_c) > 0)
900: THEN
901:
902: ------------------------------------------------------
903: -- Get column values

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

901:
902: ------------------------------------------------------
903: -- Get column values
904: ------------------------------------------------------
905: dbms_sql.column_value( sql_stmt_c, 1, sql_stmt_rec.language );
906:
907: IF (lang_str is null) THEN
908: lang_str := sql_stmt_rec.language;
909: ELSE

Line 1124: sql_stmt_c:= dbms_sql.open_cursor;

1120: ------------------------------------------------
1121: -- Parse sql stmts
1122: ------------------------------------------------
1123:
1124: sql_stmt_c:= dbms_sql.open_cursor;
1125:
1126: dbms_sql.parse( sql_stmt_c, sql_stmt , dbms_sql.v7 );
1127:
1128: bind_variables(

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

1122: ------------------------------------------------
1123:
1124: sql_stmt_c:= dbms_sql.open_cursor;
1125:
1126: dbms_sql.parse( sql_stmt_c, sql_stmt , dbms_sql.v7 );
1127:
1128: bind_variables(
1129: p_org_id,
1130: p_choice ,

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

1169: sql_stmt_c );
1170: END IF;
1171:
1172:
1173: inserted_row_counts := dbms_sql.execute(sql_stmt_c);
1174: fnd_file.put_line( fnd_file.log, 'inserted row count: ' || inserted_row_counts);
1175:
1176: IF inserted_row_counts > 0 THEN
1177:

Line 1335: ps_id dbms_sql.number_table;

1331:
1332: select_stmt VARCHAR2(8096);
1333: select_cur INTEGER;
1334:
1335: ps_id dbms_sql.number_table;
1336:
1337: inserted_row_counts INTEGER;
1338: fetched_row_count INTEGER;
1339: ignore INTEGER;

Line 1397: select_cur := dbms_sql.open_cursor;

1393: ' AND nvl(a_bill_loc.language, ''' || base_lang ||''' ) = :lang_code ' || cr ||
1394: ' ORDER BY ps.trx_number ' ;
1395: END IF;
1396:
1397: select_cur := dbms_sql.open_cursor;
1398: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
1399:
1400: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
1401: dbms_sql.define_array(select_cur,1,ps_id,500,1 );

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

1394: ' ORDER BY ps.trx_number ' ;
1395: END IF;
1396:
1397: select_cur := dbms_sql.open_cursor;
1398: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
1399:
1400: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
1401: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
1402: ignore := dbms_sql.execute(select_cur);

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

1396:
1397: select_cur := dbms_sql.open_cursor;
1398: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
1399:
1400: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
1401: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
1402: ignore := dbms_sql.execute(select_cur);
1403:
1404: LOOP

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

1397: select_cur := dbms_sql.open_cursor;
1398: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
1399:
1400: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
1401: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
1402: ignore := dbms_sql.execute(select_cur);
1403:
1404: LOOP
1405: fetched_row_count := dbms_sql.fetch_rows(select_cur);

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

1398: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
1399:
1400: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
1401: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
1402: ignore := dbms_sql.execute(select_cur);
1403:
1404: LOOP
1405: fetched_row_count := dbms_sql.fetch_rows(select_cur);
1406: dbms_sql.column_value(select_cur,1,ps_id);

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

1401: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
1402: ignore := dbms_sql.execute(select_cur);
1403:
1404: LOOP
1405: fetched_row_count := dbms_sql.fetch_rows(select_cur);
1406: dbms_sql.column_value(select_cur,1,ps_id);
1407:
1408: EXIT WHEN fetched_row_count <> 500 ;
1409: END LOOP;

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

1402: ignore := dbms_sql.execute(select_cur);
1403:
1404: LOOP
1405: fetched_row_count := dbms_sql.fetch_rows(select_cur);
1406: dbms_sql.column_value(select_cur,1,ps_id);
1407:
1408: EXIT WHEN fetched_row_count <> 500 ;
1409: END LOOP;
1410: dbms_sql.close_cursor(select_cur);

Line 1410: dbms_sql.close_cursor(select_cur);

1406: dbms_sql.column_value(select_cur,1,ps_id);
1407:
1408: EXIT WHEN fetched_row_count <> 500 ;
1409: END LOOP;
1410: dbms_sql.close_cursor(select_cur);
1411:
1412: inserted_row_counts := ps_id.COUNT ;
1413:
1414:

Line 1481: IF dbms_sql.is_open(select_cur) THEN

1477:
1478: CLOSE lang_cv;
1479: EXCEPTION
1480: WHEN OTHERS THEN
1481: IF dbms_sql.is_open(select_cur) THEN
1482: dbms_sql.close_cursor(select_cur);
1483: END IF;
1484: IF lang_cv%ISOPEN THEN
1485: CLOSE lang_cv;

Line 1482: dbms_sql.close_cursor(select_cur);

1478: CLOSE lang_cv;
1479: EXCEPTION
1480: WHEN OTHERS THEN
1481: IF dbms_sql.is_open(select_cur) THEN
1482: dbms_sql.close_cursor(select_cur);
1483: END IF;
1484: IF lang_cv%ISOPEN THEN
1485: CLOSE lang_cv;
1486: END IF;

Line 1507: ps_id dbms_sql.number_table;

1503:
1504: l_id_list VARCHAR2(250);
1505:
1506: rows NUMBER;
1507: ps_id dbms_sql.number_table;
1508:
1509: BEGIN
1510: SELECT fnd_concurrent_requests_s.nextval
1511: INTO l_request_id