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 437: l_cursor_id := DBMS_SQL.OPEN_CURSOR;

433: IF p_created_by IS NOT NULL THEN
434: v_select_statement := v_select_statement||' AND u.user_name = :p_created_by';
435: END IF;
436:
437: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
438:
439: DBMS_SQL.PARSE(l_cursor_id, v_select_statement, DBMS_SQL.V7);
440:
441: IF p_order_number_lo IS NOT NULL THEN

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

435: END IF;
436:
437: l_cursor_id := DBMS_SQL.OPEN_CURSOR;
438:
439: DBMS_SQL.PARSE(l_cursor_id, v_select_statement, DBMS_SQL.V7);
440:
441: IF p_order_number_lo IS NOT NULL THEN
442: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_number_lo', p_order_number_lo);
443: END IF;

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

438:
439: DBMS_SQL.PARSE(l_cursor_id, v_select_statement, DBMS_SQL.V7);
440:
441: IF p_order_number_lo IS NOT NULL THEN
442: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_number_lo', p_order_number_lo);
443: END IF;
444:
445: IF p_order_number_hi IS NOT NULL THEN
446: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_number_hi', p_order_number_hi);

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

442: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_number_lo', p_order_number_lo);
443: END IF;
444:
445: IF p_order_number_hi IS NOT NULL THEN
446: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_number_hi', p_order_number_hi);
447: END IF;
448:
449: IF p_bill_to_customer_name_lo IS NOT NULL THEN
450: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_bill_to_customer_name_lo',

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

446: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_number_hi', p_order_number_hi);
447: END IF;
448:
449: IF p_bill_to_customer_name_lo IS NOT NULL THEN
450: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_bill_to_customer_name_lo',
451: p_bill_to_customer_name_lo);
452: END IF;
453:
454: IF p_bill_to_customer_name_hi IS NOT NULL THEN

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

451: p_bill_to_customer_name_lo);
452: END IF;
453:
454: IF p_bill_to_customer_name_hi IS NOT NULL THEN
455: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_bill_to_customer_name_hi',
456: p_bill_to_customer_name_hi);
457: END IF;
458:
459: IF p_ship_to_customer_name_lo IS NOT NULL THEN

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

456: p_bill_to_customer_name_hi);
457: END IF;
458:
459: IF p_ship_to_customer_name_lo IS NOT NULL THEN
460: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_ship_to_customer_name_lo',
461: p_ship_to_customer_name_lo);
462: END IF;
463:
464: IF p_ship_to_customer_name_hi IS NOT NULL THEN

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

461: p_ship_to_customer_name_lo);
462: END IF;
463:
464: IF p_ship_to_customer_name_hi IS NOT NULL THEN
465: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_ship_to_customer_name_hi',
466: p_ship_to_customer_name_hi);
467: END IF;
468:
469: IF p_del_to_customer_name_lo IS NOT NULL THEN

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

466: p_ship_to_customer_name_hi);
467: END IF;
468:
469: IF p_del_to_customer_name_lo IS NOT NULL THEN
470: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_del_to_customer_name_lo',
471: p_del_to_customer_name_lo);
472: END IF;
473:
474: IF p_del_to_customer_name_hi IS NOT NULL THEN

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

471: p_del_to_customer_name_lo);
472: END IF;
473:
474: IF p_del_to_customer_name_hi IS NOT NULL THEN
475: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_del_to_customer_name_hi',
476: p_del_to_customer_name_hi);
477: END IF;
478:
479: IF p_order_date_lo IS NOT NULL THEN

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

476: p_del_to_customer_name_hi);
477: END IF;
478:
479: IF p_order_date_lo IS NOT NULL THEN
480: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_date_lo',
481: p_order_date_lo);
482: END IF;
483:
484: IF p_order_date_hi IS NOT NULL THEN

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

481: p_order_date_lo);
482: END IF;
483:
484: IF p_order_date_hi IS NOT NULL THEN
485: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_date_hi',
486: p_order_date_hi);
487: END IF;
488:
489: IF p_schedule_date_lo IS NOT NULL THEN

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

486: p_order_date_hi);
487: END IF;
488:
489: IF p_schedule_date_lo IS NOT NULL THEN
490: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_schedule_date_lo',
491: p_schedule_date_lo);
492: END IF;
493:
494: IF p_schedule_date_hi IS NOT NULL THEN

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

491: p_schedule_date_lo);
492: END IF;
493:
494: IF p_schedule_date_hi IS NOT NULL THEN
495: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_schedule_date_hi',
496: p_schedule_date_hi);
497: END IF;
498:
499: IF p_request_date_lo IS NOT NULL THEN

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

496: p_schedule_date_hi);
497: END IF;
498:
499: IF p_request_date_lo IS NOT NULL THEN
500: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_request_date_lo',
501: p_request_date_lo);
502: END IF;
503:
504: IF p_request_date_hi IS NOT NULL THEN

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

501: p_request_date_lo);
502: END IF;
503:
504: IF p_request_date_hi IS NOT NULL THEN
505: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_request_date_hi',
506: p_request_date_hi);
507: END IF;
508:
509: IF p_promise_date_lo IS NOT NULL THEN

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

506: p_request_date_hi);
507: END IF;
508:
509: IF p_promise_date_lo IS NOT NULL THEN
510: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_promise_date_lo',
511: p_promise_date_lo);
512: END IF;
513:
514: IF p_promise_date_hi IS NOT NULL THEN

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

511: p_promise_date_lo);
512: END IF;
513:
514: IF p_promise_date_hi IS NOT NULL THEN
515: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_promise_date_hi',
516: p_promise_date_hi);
517: END IF;
518:
519: IF p_order_type IS NOT NULL THEN

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

516: p_promise_date_hi);
517: END IF;
518:
519: IF p_order_type IS NOT NULL THEN
520: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_order_type',
521: p_order_type);
522: END IF;
523:
524: IF p_salesrep IS NOT NULL THEN

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

521: p_order_type);
522: END IF;
523:
524: IF p_salesrep IS NOT NULL THEN
525: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_salesrep',
526: p_salesrep);
527: END IF;
528:
529: IF p_created_by IS NOT NULL THEN

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

526: p_salesrep);
527: END IF;
528:
529: IF p_created_by IS NOT NULL THEN
530: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_created_by',
531: p_created_by);
532: END IF;
533:
534: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_lang,30);

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

530: DBMS_SQL.BIND_VARIABLE(l_cursor_id, ':p_created_by',
531: p_created_by);
532: END IF;
533:
534: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_lang,30);
535:
536: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
537:
538: LOOP

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

532: END IF;
533:
534: DBMS_SQL.DEFINE_COLUMN(l_cursor_id,1,l_lang,30);
535:
536: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
537:
538: LOOP
539: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
540: EXIT;

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

535:
536: l_dummy := DBMS_SQL.EXECUTE(l_cursor_id);
537:
538: LOOP
539: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
540: EXIT;
541: END IF;
542: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_lang);
543:

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

538: LOOP
539: IF DBMS_SQL.FETCH_ROWS(l_cursor_id) = 0 THEN
540: EXIT;
541: END IF;
542: DBMS_SQL.COLUMN_VALUE(l_cursor_id, 1, l_lang);
543:
544: IF (l_lang IS NOT NULL) THEN
545: IF (l_lang_str IS NULL) THEN
546: l_lang_str := l_lang;

Line 561: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

557: END IF;*/
558:
559: END LOOP;
560:
561: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
562: IF (l_lang_str IS NULL) THEN
563: l_lang_str := l_base_lang;
564: ELSE
565: IF instr(l_lang_str, l_lang) = 0 THEN

Line 573: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);

569: return (l_lang_str);
570:
571: EXCEPTION
572: WHEN OTHERS THEN
573: DBMS_SQL.CLOSE_CURSOR(l_cursor_id);
574: RAISE;
575: END GET_LANG;
576:
577: END OM_REPORTS_MLS_LANG;