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 463: dbms_sql.bind_variable( cursor_name, ':customer_class_code', p_customer_class_code) ;

459: --------------------------------------------------------------------------*/
460:
461:
462: IF ( p_customer_class_code is not null ) THEN
463: dbms_sql.bind_variable( cursor_name, ':customer_class_code', p_customer_class_code) ;
464: END IF;
465:
466: IF ( p_org_id is not null ) THEN
467: dbms_sql.bind_variable( cursor_name, ':org_id', p_org_id) ;

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

463: dbms_sql.bind_variable( cursor_name, ':customer_class_code', p_customer_class_code) ;
464: END IF;
465:
466: IF ( p_org_id is not null ) THEN
467: dbms_sql.bind_variable( cursor_name, ':org_id', p_org_id) ;
468: END IF;
469:
470: IF ( p_customer_name_low is not null and p_customer_name_high is null )THEN
471: dbms_sql.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);

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

467: dbms_sql.bind_variable( cursor_name, ':org_id', p_org_id) ;
468: END IF;
469:
470: IF ( p_customer_name_low is not null and p_customer_name_high is null )THEN
471: dbms_sql.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
472: ELSIF ( (p_customer_name_high is not null) and (p_customer_name_low is null ) ) THEN
473: dbms_sql.bind_variable( cursor_name, ':customer_name_high', p_customer_name_high );
474: ELSIF ( (p_customer_name_high is not null) and (p_customer_name_low is not null) ) THEN
475: dbms_sql.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);

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

469:
470: IF ( p_customer_name_low is not null and p_customer_name_high is null )THEN
471: dbms_sql.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
472: ELSIF ( (p_customer_name_high is not null) and (p_customer_name_low is null ) ) THEN
473: dbms_sql.bind_variable( cursor_name, ':customer_name_high', p_customer_name_high );
474: ELSIF ( (p_customer_name_high is not null) and (p_customer_name_low is not null) ) THEN
475: dbms_sql.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
476: dbms_sql.bind_variable( cursor_name,':customer_name_high', p_customer_name_high);
477: END IF;

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

471: dbms_sql.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
472: ELSIF ( (p_customer_name_high is not null) and (p_customer_name_low is null ) ) THEN
473: dbms_sql.bind_variable( cursor_name, ':customer_name_high', p_customer_name_high );
474: ELSIF ( (p_customer_name_high is not null) and (p_customer_name_low is not null) ) THEN
475: dbms_sql.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
476: dbms_sql.bind_variable( cursor_name,':customer_name_high', p_customer_name_high);
477: END IF;
478:
479: IF ( (p_customer_no_low is not null) and (p_customer_no_high is null) ) THEN

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

472: ELSIF ( (p_customer_name_high is not null) and (p_customer_name_low is null ) ) THEN
473: dbms_sql.bind_variable( cursor_name, ':customer_name_high', p_customer_name_high );
474: ELSIF ( (p_customer_name_high is not null) and (p_customer_name_low is not null) ) THEN
475: dbms_sql.bind_variable( cursor_name, ':customer_name_low', p_customer_name_low);
476: dbms_sql.bind_variable( cursor_name,':customer_name_high', p_customer_name_high);
477: END IF;
478:
479: IF ( (p_customer_no_low is not null) and (p_customer_no_high is null) ) THEN
480: dbms_sql.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;

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

476: dbms_sql.bind_variable( cursor_name,':customer_name_high', p_customer_name_high);
477: END IF;
478:
479: IF ( (p_customer_no_low is not null) and (p_customer_no_high is null) ) THEN
480: dbms_sql.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
481: ELSIF ( (p_customer_no_high is not null) and (p_customer_no_low is null) ) THEN
482: dbms_sql.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high );
483: ELSIF ( (p_customer_no_high is not null) and (p_customer_no_low is not null) ) THEN
484: dbms_sql.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;

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

478:
479: IF ( (p_customer_no_low is not null) and (p_customer_no_high is null) ) THEN
480: dbms_sql.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
481: ELSIF ( (p_customer_no_high is not null) and (p_customer_no_low is null) ) THEN
482: dbms_sql.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high );
483: ELSIF ( (p_customer_no_high is not null) and (p_customer_no_low is not null) ) THEN
484: dbms_sql.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
485: dbms_sql.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high ) ;
486: END IF;

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

480: dbms_sql.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
481: ELSIF ( (p_customer_no_high is not null) and (p_customer_no_low is null) ) THEN
482: dbms_sql.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high );
483: ELSIF ( (p_customer_no_high is not null) and (p_customer_no_low is not null) ) THEN
484: dbms_sql.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
485: dbms_sql.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high ) ;
486: END IF;
487:
488: IF ( p_cust_trx_class is not null ) THEN

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

481: ELSIF ( (p_customer_no_high is not null) and (p_customer_no_low is null) ) THEN
482: dbms_sql.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high );
483: ELSIF ( (p_customer_no_high is not null) and (p_customer_no_low is not null) ) THEN
484: dbms_sql.bind_variable( cursor_name, ':customer_no_low', p_customer_no_low ) ;
485: dbms_sql.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high ) ;
486: END IF;
487:
488: IF ( p_cust_trx_class is not null ) THEN
489: dbms_sql.bind_variable( cursor_name, ':cust_trx_class', p_cust_trx_class );

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

485: dbms_sql.bind_variable( cursor_name, ':customer_no_high', p_customer_no_high ) ;
486: END IF;
487:
488: IF ( p_cust_trx_class is not null ) THEN
489: dbms_sql.bind_variable( cursor_name, ':cust_trx_class', p_cust_trx_class );
490: END IF;
491:
492: IF ( p_trx_type_id is not null ) THEN
493: dbms_sql.bind_variable( cursor_name, ':trx_type_id', p_trx_type_id ) ;

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

489: dbms_sql.bind_variable( cursor_name, ':cust_trx_class', p_cust_trx_class );
490: END IF;
491:
492: IF ( p_trx_type_id is not null ) THEN
493: dbms_sql.bind_variable( cursor_name, ':trx_type_id', p_trx_type_id ) ;
494: END IF;
495:
496: IF ( (p_trx_number_low is not null) and (p_trx_number_high is null )) THEN
497: dbms_sql.bind_variable( cursor_name, ':trx_number_low', p_trx_number_low);

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

493: dbms_sql.bind_variable( cursor_name, ':trx_type_id', p_trx_type_id ) ;
494: END IF;
495:
496: IF ( (p_trx_number_low is not null) and (p_trx_number_high is null )) THEN
497: dbms_sql.bind_variable( cursor_name, ':trx_number_low', p_trx_number_low);
498: ELSIF ( (p_trx_number_high is not null) and (p_trx_number_low is null) ) THEN
499: dbms_sql.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
500: ELSIF ( (p_trx_number_high is not null ) and (p_trx_number_low is not null) ) THEN
501: dbms_sql.bind_variable( cursor_name, ':trx_number_low' , p_trx_number_low);

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

495:
496: IF ( (p_trx_number_low is not null) and (p_trx_number_high is null )) THEN
497: dbms_sql.bind_variable( cursor_name, ':trx_number_low', p_trx_number_low);
498: ELSIF ( (p_trx_number_high is not null) and (p_trx_number_low is null) ) THEN
499: dbms_sql.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
500: ELSIF ( (p_trx_number_high is not null ) and (p_trx_number_low is not null) ) THEN
501: dbms_sql.bind_variable( cursor_name, ':trx_number_low' , p_trx_number_low);
502: dbms_sql.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
503: END IF;

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

497: dbms_sql.bind_variable( cursor_name, ':trx_number_low', p_trx_number_low);
498: ELSIF ( (p_trx_number_high is not null) and (p_trx_number_low is null) ) THEN
499: dbms_sql.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
500: ELSIF ( (p_trx_number_high is not null ) and (p_trx_number_low is not null) ) THEN
501: dbms_sql.bind_variable( cursor_name, ':trx_number_low' , p_trx_number_low);
502: dbms_sql.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
503: END IF;
504:
505: IF ( (p_installment_no is not null) ) THEN

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

498: ELSIF ( (p_trx_number_high is not null) and (p_trx_number_low is null) ) THEN
499: dbms_sql.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
500: ELSIF ( (p_trx_number_high is not null ) and (p_trx_number_low is not null) ) THEN
501: dbms_sql.bind_variable( cursor_name, ':trx_number_low' , p_trx_number_low);
502: dbms_sql.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
503: END IF;
504:
505: IF ( (p_installment_no is not null) ) THEN
506: dbms_sql.bind_variable( cursor_name, ':installment_no', p_installment_no) ;

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

502: dbms_sql.bind_variable( cursor_name, ':trx_number_high', p_trx_number_high);
503: END IF;
504:
505: IF ( (p_installment_no is not null) ) THEN
506: dbms_sql.bind_variable( cursor_name, ':installment_no', p_installment_no) ;
507: END IF;
508:
509:
510: IF ( p_batch_id is not null ) THEN

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

507: END IF;
508:
509:
510: IF ( p_batch_id is not null ) THEN
511: dbms_sql.bind_variable( cursor_name, ':batch_id', p_batch_id ) ;
512: END IF;
513:
514:
515: /**********************************************************************************

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

523:
524: IF ( (p_print_date_low is not null) or (p_print_date_low is not null) ) THEN
525: IF ( p_union_flag = 'N' ) THEN
526: IF ( p_print_date_low is not null and p_print_date_high is not null ) THEN
527: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,
528: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
529: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,
530: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
531: ELSIF ( p_print_date_low is not null and p_print_date_high is null) THEN

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

525: IF ( p_union_flag = 'N' ) THEN
526: IF ( p_print_date_low is not null and p_print_date_high is not null ) THEN
527: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,
528: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
529: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,
530: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
531: ELSIF ( p_print_date_low is not null and p_print_date_high is null) THEN
532: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,
533: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));

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

528: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
529: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,
530: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
531: ELSIF ( p_print_date_low is not null and p_print_date_high is null) THEN
532: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,
533: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
534: ELSIF ( p_print_date_high is not null and p_print_date_low is null ) THEN
535: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,
536: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));

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

531: ELSIF ( p_print_date_low is not null and p_print_date_high is null) THEN
532: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,
533: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
534: ELSIF ( p_print_date_high is not null and p_print_date_low is null ) THEN
535: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,
536: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
537: END IF;
538: ELSE
539: IF ( p_print_date_low is not null and p_print_date_high is not null ) THEN

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

536: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
537: END IF;
538: ELSE
539: IF ( p_print_date_low is not null and p_print_date_high is not null ) THEN
540: dbms_sql.bind_variable( cursor_name, ':print_date_low' ,
541: TO_CHAR(p_print_date_low ,'DD-MM-YYYY-HH24:MI:SS'));
542: dbms_sql.bind_variable( cursor_name, ':print_date_high' ,
543: TO_CHAR(p_print_date_high ,'DD-MM-YYYY-HH24:MI:SS'));
544: ELSIF ( p_print_date_low is not null and p_print_date_high is null ) THEN

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

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

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

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

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

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

Line 830: sql_stmt_c:= dbms_sql.open_cursor;

826: ------------------------------------------------
827: -- Parse sql stmts
828: ------------------------------------------------
829:
830: sql_stmt_c:= dbms_sql.open_cursor;
831:
832: dbms_sql.parse( sql_stmt_c, sql_stmt , dbms_sql.v7 );
833: bind_variables(
834: p_org_id,

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

828: ------------------------------------------------
829:
830: sql_stmt_c:= dbms_sql.open_cursor;
831:
832: dbms_sql.parse( sql_stmt_c, sql_stmt , dbms_sql.v7 );
833: bind_variables(
834: p_org_id,
835: p_choice ,
836: p_batch_id ,

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

874: sql_stmt_c );
875: END IF;
876:
877:
878: dbms_sql.define_column( sql_stmt_c, 1, sql_stmt_rec.language, 4);
879:
880:
881: l_ignore := dbms_sql.execute( sql_stmt_c);
882:

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

877:
878: dbms_sql.define_column( sql_stmt_c, 1, sql_stmt_rec.language, 4);
879:
880:
881: l_ignore := dbms_sql.execute( sql_stmt_c);
882:
883: LOOP
884: IF (dbms_sql.fetch_rows( sql_stmt_c) > 0)
885: THEN

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

880:
881: l_ignore := dbms_sql.execute( sql_stmt_c);
882:
883: LOOP
884: IF (dbms_sql.fetch_rows( sql_stmt_c) > 0)
885: THEN
886:
887: ------------------------------------------------------
888: -- Get column values

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

886:
887: ------------------------------------------------------
888: -- Get column values
889: ------------------------------------------------------
890: dbms_sql.column_value( sql_stmt_c, 1, sql_stmt_rec.language );
891:
892: IF (lang_str is null) THEN
893: lang_str := sql_stmt_rec.language;
894: ELSE

Line 1109: sql_stmt_c:= dbms_sql.open_cursor;

1105: ------------------------------------------------
1106: -- Parse sql stmts
1107: ------------------------------------------------
1108:
1109: sql_stmt_c:= dbms_sql.open_cursor;
1110:
1111: dbms_sql.parse( sql_stmt_c, sql_stmt , dbms_sql.v7 );
1112:
1113: bind_variables(

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

1107: ------------------------------------------------
1108:
1109: sql_stmt_c:= dbms_sql.open_cursor;
1110:
1111: dbms_sql.parse( sql_stmt_c, sql_stmt , dbms_sql.v7 );
1112:
1113: bind_variables(
1114: p_org_id,
1115: p_choice ,

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

1154: sql_stmt_c );
1155: END IF;
1156:
1157:
1158: inserted_row_counts := dbms_sql.execute(sql_stmt_c);
1159: fnd_file.put_line( fnd_file.log, 'inserted row count: ' || inserted_row_counts);
1160:
1161: IF inserted_row_counts > 0 THEN
1162:

Line 1320: ps_id dbms_sql.number_table;

1316:
1317: select_stmt VARCHAR2(8096);
1318: select_cur INTEGER;
1319:
1320: ps_id dbms_sql.number_table;
1321:
1322: inserted_row_counts INTEGER;
1323: fetched_row_count INTEGER;
1324: ignore INTEGER;

Line 1378: select_cur := dbms_sql.open_cursor;

1374: ' AND nvl(a_bill.language, ''' || base_lang ||''' ) = :lang_code ' || cr ||
1375: ' ORDER BY ps.trx_number ' ;
1376: END IF;
1377:
1378: select_cur := dbms_sql.open_cursor;
1379: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
1380:
1381: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
1382: dbms_sql.define_array(select_cur,1,ps_id,500,1 );

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

1375: ' ORDER BY ps.trx_number ' ;
1376: END IF;
1377:
1378: select_cur := dbms_sql.open_cursor;
1379: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
1380:
1381: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
1382: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
1383: ignore := dbms_sql.execute(select_cur);

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

1377:
1378: select_cur := dbms_sql.open_cursor;
1379: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
1380:
1381: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
1382: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
1383: ignore := dbms_sql.execute(select_cur);
1384:
1385: LOOP

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

1378: select_cur := dbms_sql.open_cursor;
1379: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
1380:
1381: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
1382: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
1383: ignore := dbms_sql.execute(select_cur);
1384:
1385: LOOP
1386: fetched_row_count := dbms_sql.fetch_rows(select_cur);

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

1379: dbms_sql.parse( select_cur, select_stmt, dbms_sql.native );
1380:
1381: dbms_sql.bind_variable(select_cur,':lang_code', lang_code );
1382: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
1383: ignore := dbms_sql.execute(select_cur);
1384:
1385: LOOP
1386: fetched_row_count := dbms_sql.fetch_rows(select_cur);
1387: dbms_sql.column_value(select_cur,1,ps_id);

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

1382: dbms_sql.define_array(select_cur,1,ps_id,500,1 );
1383: ignore := dbms_sql.execute(select_cur);
1384:
1385: LOOP
1386: fetched_row_count := dbms_sql.fetch_rows(select_cur);
1387: dbms_sql.column_value(select_cur,1,ps_id);
1388:
1389: EXIT WHEN fetched_row_count <> 500 ;
1390: END LOOP;

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

1383: ignore := dbms_sql.execute(select_cur);
1384:
1385: LOOP
1386: fetched_row_count := dbms_sql.fetch_rows(select_cur);
1387: dbms_sql.column_value(select_cur,1,ps_id);
1388:
1389: EXIT WHEN fetched_row_count <> 500 ;
1390: END LOOP;
1391: dbms_sql.close_cursor(select_cur);

Line 1391: dbms_sql.close_cursor(select_cur);

1387: dbms_sql.column_value(select_cur,1,ps_id);
1388:
1389: EXIT WHEN fetched_row_count <> 500 ;
1390: END LOOP;
1391: dbms_sql.close_cursor(select_cur);
1392:
1393: inserted_row_counts := ps_id.COUNT ;
1394:
1395:

Line 1462: IF dbms_sql.is_open(select_cur) THEN

1458:
1459: CLOSE lang_cv;
1460: EXCEPTION
1461: WHEN OTHERS THEN
1462: IF dbms_sql.is_open(select_cur) THEN
1463: dbms_sql.close_cursor(select_cur);
1464: END IF;
1465: IF lang_cv%ISOPEN THEN
1466: CLOSE lang_cv;

Line 1463: dbms_sql.close_cursor(select_cur);

1459: CLOSE lang_cv;
1460: EXCEPTION
1461: WHEN OTHERS THEN
1462: IF dbms_sql.is_open(select_cur) THEN
1463: dbms_sql.close_cursor(select_cur);
1464: END IF;
1465: IF lang_cv%ISOPEN THEN
1466: CLOSE lang_cv;
1467: END IF;

Line 1488: ps_id dbms_sql.number_table;

1484:
1485: l_id_list VARCHAR2(250);
1486:
1487: rows NUMBER;
1488: ps_id dbms_sql.number_table;
1489:
1490: BEGIN
1491: SELECT fnd_concurrent_requests_s.nextval
1492: INTO l_request_id