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

Line 475: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

471: --Bug 10266603
472: v_where_clause1 := v_select_statement;
473: v_select_statement := v_base_select_statement ||v_base_where_clause ||v_where_clause1;
474:
475: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
476:
477: DBMS_SQL.PARSE(l_cursor_id, v_select_statement, DBMS_SQL.V7);
478:
479: IF p_order_number_lo IS NOT NULL THEN

Line 477: DBMS_SQL.PARSE(l_cursor_id, v_select_statement, DBMS_SQL.V7);

473: v_select_statement := v_base_select_statement ||v_base_where_clause ||v_where_clause1;
474:
475: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
476:
477: DBMS_SQL.PARSE(l_cursor_id, v_select_statement, DBMS_SQL.V7);
478:
479: IF p_order_number_lo IS NOT NULL THEN
480: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_number_lo', p_order_number_lo);
481: END IF;

Line 480: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_number_lo', p_order_number_lo);

476:
477: DBMS_SQL.PARSE(l_cursor_id, v_select_statement, DBMS_SQL.V7);
478:
479: IF p_order_number_lo IS NOT NULL THEN
480: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_number_lo', p_order_number_lo);
481: END IF;
482:
483: IF p_order_number_hi IS NOT NULL THEN
484: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_number_hi', p_order_number_hi);

Line 484: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_number_hi', p_order_number_hi);

480: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_number_lo', p_order_number_lo);
481: END IF;
482:
483: IF p_order_number_hi IS NOT NULL THEN
484: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_number_hi', p_order_number_hi);
485: END IF;
486:
487: IF p_bill_to_customer_name_lo IS NOT NULL THEN
488: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_bill_to_customer_name_lo',

Line 488: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_bill_to_customer_name_lo',

484: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_number_hi', p_order_number_hi);
485: END IF;
486:
487: IF p_bill_to_customer_name_lo IS NOT NULL THEN
488: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_bill_to_customer_name_lo',
489: p_bill_to_customer_name_lo);
490: END IF;
491:
492: IF p_bill_to_customer_name_hi IS NOT NULL THEN

Line 493: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_bill_to_customer_name_hi',

489: p_bill_to_customer_name_lo);
490: END IF;
491:
492: IF p_bill_to_customer_name_hi IS NOT NULL THEN
493: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_bill_to_customer_name_hi',
494: p_bill_to_customer_name_hi);
495: END IF;
496:
497: IF p_ship_to_customer_name_lo IS NOT NULL THEN

Line 498: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_ship_to_customer_name_lo',

494: p_bill_to_customer_name_hi);
495: END IF;
496:
497: IF p_ship_to_customer_name_lo IS NOT NULL THEN
498: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_ship_to_customer_name_lo',
499: p_ship_to_customer_name_lo);
500: END IF;
501:
502: IF p_ship_to_customer_name_hi IS NOT NULL THEN

Line 503: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_ship_to_customer_name_hi',

499: p_ship_to_customer_name_lo);
500: END IF;
501:
502: IF p_ship_to_customer_name_hi IS NOT NULL THEN
503: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_ship_to_customer_name_hi',
504: p_ship_to_customer_name_hi);
505: END IF;
506:
507: IF p_del_to_customer_name_lo IS NOT NULL THEN

Line 508: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_del_to_customer_name_lo',

504: p_ship_to_customer_name_hi);
505: END IF;
506:
507: IF p_del_to_customer_name_lo IS NOT NULL THEN
508: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_del_to_customer_name_lo',
509: p_del_to_customer_name_lo);
510: END IF;
511:
512: IF p_del_to_customer_name_hi IS NOT NULL THEN

Line 513: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_del_to_customer_name_hi',

509: p_del_to_customer_name_lo);
510: END IF;
511:
512: IF p_del_to_customer_name_hi IS NOT NULL THEN
513: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_del_to_customer_name_hi',
514: p_del_to_customer_name_hi);
515: END IF;
516:
517: IF p_order_date_lo IS NOT NULL THEN

Line 518: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_date_lo',

514: p_del_to_customer_name_hi);
515: END IF;
516:
517: IF p_order_date_lo IS NOT NULL THEN
518: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_date_lo',
519: p_order_date_lo);
520: END IF;
521:
522: IF p_order_date_hi IS NOT NULL THEN

Line 523: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_date_hi',

519: p_order_date_lo);
520: END IF;
521:
522: IF p_order_date_hi IS NOT NULL THEN
523: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_date_hi',
524: p_order_date_hi);
525: END IF;
526:
527: IF p_schedule_date_lo IS NOT NULL THEN

Line 528: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_schedule_date_lo',

524: p_order_date_hi);
525: END IF;
526:
527: IF p_schedule_date_lo IS NOT NULL THEN
528: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_schedule_date_lo',
529: p_schedule_date_lo);
530: END IF;
531:
532: IF p_schedule_date_hi IS NOT NULL THEN

Line 533: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_schedule_date_hi',

529: p_schedule_date_lo);
530: END IF;
531:
532: IF p_schedule_date_hi IS NOT NULL THEN
533: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_schedule_date_hi',
534: p_schedule_date_hi);
535: END IF;
536:
537: IF p_request_date_lo IS NOT NULL THEN

Line 538: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_request_date_lo',

534: p_schedule_date_hi);
535: END IF;
536:
537: IF p_request_date_lo IS NOT NULL THEN
538: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_request_date_lo',
539: p_request_date_lo);
540: END IF;
541:
542: IF p_request_date_hi IS NOT NULL THEN

Line 543: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_request_date_hi',

539: p_request_date_lo);
540: END IF;
541:
542: IF p_request_date_hi IS NOT NULL THEN
543: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_request_date_hi',
544: p_request_date_hi);
545: END IF;
546:
547: IF p_promise_date_lo IS NOT NULL THEN

Line 548: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_promise_date_lo',

544: p_request_date_hi);
545: END IF;
546:
547: IF p_promise_date_lo IS NOT NULL THEN
548: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_promise_date_lo',
549: p_promise_date_lo);
550: END IF;
551:
552: IF p_promise_date_hi IS NOT NULL THEN

Line 553: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_promise_date_hi',

549: p_promise_date_lo);
550: END IF;
551:
552: IF p_promise_date_hi IS NOT NULL THEN
553: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_promise_date_hi',
554: p_promise_date_hi);
555: END IF;
556:
557: IF p_order_type IS NOT NULL THEN

Line 558: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_type',

554: p_promise_date_hi);
555: END IF;
556:
557: IF p_order_type IS NOT NULL THEN
558: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_type',
559: p_order_type);
560: END IF;
561:
562: IF p_salesrep IS NOT NULL THEN

Line 563: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_salesrep',

559: p_order_type);
560: END IF;
561:
562: IF p_salesrep IS NOT NULL THEN
563: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_salesrep',
564: p_salesrep);
565: END IF;
566:
567: IF p_created_by IS NOT NULL THEN

Line 568: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_created_by',

564: p_salesrep);
565: END IF;
566:
567: IF p_created_by IS NOT NULL THEN
568: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_created_by',
569: p_created_by);
570: END IF;
571:
572: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_lang,30);

Line 572: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_lang,30);

568: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_created_by',
569: p_created_by);
570: END IF;
571:
572: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_lang,30);
573:
574: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
575:
576: LOOP

Line 574: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);

570: END IF;
571:
572: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_lang,30);
573:
574: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
575:
576: LOOP
577: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
578: EXIT;

Line 577: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN

573:
574: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
575:
576: LOOP
577: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
578: EXIT;
579: END IF;
580: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_lang);
581:

Line 580: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_lang);

576: LOOP
577: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
578: EXIT;
579: END IF;
580: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_lang);
581:
582: IF (l_lang IS NOT NULL) THEN
583: IF (l_lang_str IS NULL) THEN
584: l_lang_str := l_lang;

Line 599: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

595: END IF;*/
596:
597: END LOOP;
598:
599: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
600: IF (l_lang_str IS NULL) THEN
601: l_lang_str := l_base_lang;
602: ELSE
603: IF instr(l_lang_str, l_lang) = 0 THEN

Line 611: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

607: return (l_lang_str);
608:
609: EXCEPTION
610: WHEN OTHERS THEN
611: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
612: RAISE;
613: END GET_LANG;
614:
615: END OM_REPORTS_MLS_LANG;