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

Line 506: dbms_sql.bind_variable(c, 'p_reporting_entity_id', var.p_reporting_entity_id);

502: -- Binding vars that appear in SELECT statement depending on input params
503: --
504: IF var.p_reporting_level = 3000 THEN
505: IF var.p_reporting_entity_id IS NOT NULL THEN
506: dbms_sql.bind_variable(c, 'p_reporting_entity_id', var.p_reporting_entity_id);
507: END IF;
508: END IF;
509:
510: IF var.p_currency_code IS NOT NULL THEN

Line 511: dbms_sql.bind_variable(c, 'p_currency_code', var.p_currency_code);

507: END IF;
508: END IF;
509:
510: IF var.p_currency_code IS NOT NULL THEN
511: dbms_sql.bind_variable(c, 'p_currency_code', var.p_currency_code);
512: END IF;
513:
514: IF var.p_gl_date_low IS NOT NULL THEN
515: dbms_sql.bind_variable(c, 'p_gl_date_low', var.p_gl_date_low);

Line 515: dbms_sql.bind_variable(c, 'p_gl_date_low', var.p_gl_date_low);

511: dbms_sql.bind_variable(c, 'p_currency_code', var.p_currency_code);
512: END IF;
513:
514: IF var.p_gl_date_low IS NOT NULL THEN
515: dbms_sql.bind_variable(c, 'p_gl_date_low', var.p_gl_date_low);
516: END IF;
517:
518: IF var.p_gl_date_high IS NOT NULL THEN
519: dbms_sql.bind_variable(c, 'p_gl_date_high', var.p_gl_date_high);

Line 519: dbms_sql.bind_variable(c, 'p_gl_date_high', var.p_gl_date_high);

515: dbms_sql.bind_variable(c, 'p_gl_date_low', var.p_gl_date_low);
516: END IF;
517:
518: IF var.p_gl_date_high IS NOT NULL THEN
519: dbms_sql.bind_variable(c, 'p_gl_date_high', var.p_gl_date_high);
520: END IF;
521:
522: IF var.p_customer_name_low IS NOT NULL THEN
523: dbms_sql.bind_variable(c, 'p_customer_name_low', var.p_customer_name_low);

Line 523: dbms_sql.bind_variable(c, 'p_customer_name_low', var.p_customer_name_low);

519: dbms_sql.bind_variable(c, 'p_gl_date_high', var.p_gl_date_high);
520: END IF;
521:
522: IF var.p_customer_name_low IS NOT NULL THEN
523: dbms_sql.bind_variable(c, 'p_customer_name_low', var.p_customer_name_low);
524: END IF;
525:
526: IF var.p_customer_name_high IS NOT NULL THEN
527: dbms_sql.bind_variable(c, 'p_customer_name_high', var.p_customer_name_high);

Line 527: dbms_sql.bind_variable(c, 'p_customer_name_high', var.p_customer_name_high);

523: dbms_sql.bind_variable(c, 'p_customer_name_low', var.p_customer_name_low);
524: END IF;
525:
526: IF var.p_customer_name_high IS NOT NULL THEN
527: dbms_sql.bind_variable(c, 'p_customer_name_high', var.p_customer_name_high);
528: END IF;
529:
530: IF var.p_customer_number_low IS NOT NULL THEN
531: dbms_sql.bind_variable(c, 'p_customer_number_low', var.p_customer_number_low);

Line 531: dbms_sql.bind_variable(c, 'p_customer_number_low', var.p_customer_number_low);

527: dbms_sql.bind_variable(c, 'p_customer_name_high', var.p_customer_name_high);
528: END IF;
529:
530: IF var.p_customer_number_low IS NOT NULL THEN
531: dbms_sql.bind_variable(c, 'p_customer_number_low', var.p_customer_number_low);
532: END IF;
533:
534: IF var.p_customer_number_high IS NOT NULL THEN
535: dbms_sql.bind_variable(c, 'p_customer_number_high', var.p_customer_number_high);

Line 535: dbms_sql.bind_variable(c, 'p_customer_number_high', var.p_customer_number_high);

531: dbms_sql.bind_variable(c, 'p_customer_number_low', var.p_customer_number_low);
532: END IF;
533:
534: IF var.p_customer_number_high IS NOT NULL THEN
535: dbms_sql.bind_variable(c, 'p_customer_number_high', var.p_customer_number_high);
536: END IF;
537:
538: IF var.p_receipt_date_low IS NOT NULL THEN
539: dbms_sql.bind_variable(c, 'p_receipt_date_low', var.p_receipt_date_low);

Line 539: dbms_sql.bind_variable(c, 'p_receipt_date_low', var.p_receipt_date_low);

535: dbms_sql.bind_variable(c, 'p_customer_number_high', var.p_customer_number_high);
536: END IF;
537:
538: IF var.p_receipt_date_low IS NOT NULL THEN
539: dbms_sql.bind_variable(c, 'p_receipt_date_low', var.p_receipt_date_low);
540: END IF;
541:
542: IF var.p_receipt_date_high IS NOT NULL THEN
543: dbms_sql.bind_variable(c, 'p_receipt_date_high', var.p_receipt_date_high);

Line 543: dbms_sql.bind_variable(c, 'p_receipt_date_high', var.p_receipt_date_high);

539: dbms_sql.bind_variable(c, 'p_receipt_date_low', var.p_receipt_date_low);
540: END IF;
541:
542: IF var.p_receipt_date_high IS NOT NULL THEN
543: dbms_sql.bind_variable(c, 'p_receipt_date_high', var.p_receipt_date_high);
544: END IF;
545:
546: IF var.p_apply_date_low IS NOT NULL THEN
547: dbms_sql.bind_variable(c, 'p_apply_date_low', var.p_apply_date_low);

Line 547: dbms_sql.bind_variable(c, 'p_apply_date_low', var.p_apply_date_low);

543: dbms_sql.bind_variable(c, 'p_receipt_date_high', var.p_receipt_date_high);
544: END IF;
545:
546: IF var.p_apply_date_low IS NOT NULL THEN
547: dbms_sql.bind_variable(c, 'p_apply_date_low', var.p_apply_date_low);
548: END IF;
549:
550: IF var.p_apply_date_high IS NOT NULL THEN
551: dbms_sql.bind_variable(c, 'p_apply_date_high', var.p_apply_date_high);

Line 551: dbms_sql.bind_variable(c, 'p_apply_date_high', var.p_apply_date_high);

547: dbms_sql.bind_variable(c, 'p_apply_date_low', var.p_apply_date_low);
548: END IF;
549:
550: IF var.p_apply_date_high IS NOT NULL THEN
551: dbms_sql.bind_variable(c, 'p_apply_date_high', var.p_apply_date_high);
552: END IF;
553:
554: IF var.p_remit_batch_low IS NOT NULL THEN
555: dbms_sql.bind_variable(c, 'p_remit_batch_low', var.p_remit_batch_low);

Line 555: dbms_sql.bind_variable(c, 'p_remit_batch_low', var.p_remit_batch_low);

551: dbms_sql.bind_variable(c, 'p_apply_date_high', var.p_apply_date_high);
552: END IF;
553:
554: IF var.p_remit_batch_low IS NOT NULL THEN
555: dbms_sql.bind_variable(c, 'p_remit_batch_low', var.p_remit_batch_low);
556: END IF;
557:
558: IF var.p_remit_batch_high IS NOT NULL THEN
559: dbms_sql.bind_variable(c, 'p_remit_batch_high', var.p_remit_batch_high);

Line 559: dbms_sql.bind_variable(c, 'p_remit_batch_high', var.p_remit_batch_high);

555: dbms_sql.bind_variable(c, 'p_remit_batch_low', var.p_remit_batch_low);
556: END IF;
557:
558: IF var.p_remit_batch_high IS NOT NULL THEN
559: dbms_sql.bind_variable(c, 'p_remit_batch_high', var.p_remit_batch_high);
560: END IF;
561:
562: IF var.p_receipt_batch_low IS NOT NULL THEN
563: dbms_sql.bind_variable(c, 'p_receipt_batch_low', var.p_receipt_batch_low);

Line 563: dbms_sql.bind_variable(c, 'p_receipt_batch_low', var.p_receipt_batch_low);

559: dbms_sql.bind_variable(c, 'p_remit_batch_high', var.p_remit_batch_high);
560: END IF;
561:
562: IF var.p_receipt_batch_low IS NOT NULL THEN
563: dbms_sql.bind_variable(c, 'p_receipt_batch_low', var.p_receipt_batch_low);
564: END IF;
565:
566: IF var.p_receipt_batch_high IS NOT NULL THEN
567: dbms_sql.bind_variable(c, 'p_receipt_batch_high', var.p_receipt_batch_high);

Line 567: dbms_sql.bind_variable(c, 'p_receipt_batch_high', var.p_receipt_batch_high);

563: dbms_sql.bind_variable(c, 'p_receipt_batch_low', var.p_receipt_batch_low);
564: END IF;
565:
566: IF var.p_receipt_batch_high IS NOT NULL THEN
567: dbms_sql.bind_variable(c, 'p_receipt_batch_high', var.p_receipt_batch_high);
568: END IF;
569:
570: IF var.p_receipt_number_low IS NOT NULL THEN
571: dbms_sql.bind_variable(c, 'p_receipt_number_low', var.p_receipt_number_low);

Line 571: dbms_sql.bind_variable(c, 'p_receipt_number_low', var.p_receipt_number_low);

567: dbms_sql.bind_variable(c, 'p_receipt_batch_high', var.p_receipt_batch_high);
568: END IF;
569:
570: IF var.p_receipt_number_low IS NOT NULL THEN
571: dbms_sql.bind_variable(c, 'p_receipt_number_low', var.p_receipt_number_low);
572: END IF;
573:
574: IF var.p_receipt_number_high IS NOT NULL THEN
575: dbms_sql.bind_variable(c, 'p_receipt_number_high', var.p_receipt_number_high);

Line 575: dbms_sql.bind_variable(c, 'p_receipt_number_high', var.p_receipt_number_high);

571: dbms_sql.bind_variable(c, 'p_receipt_number_low', var.p_receipt_number_low);
572: END IF;
573:
574: IF var.p_receipt_number_high IS NOT NULL THEN
575: dbms_sql.bind_variable(c, 'p_receipt_number_high', var.p_receipt_number_high);
576: END IF;
577:
578: IF var.p_app_type IS NOT NULL THEN
579: dbms_sql.bind_variable(c, 'p_app_type', var.p_app_type);

Line 579: dbms_sql.bind_variable(c, 'p_app_type', var.p_app_type);

575: dbms_sql.bind_variable(c, 'p_receipt_number_high', var.p_receipt_number_high);
576: END IF;
577:
578: IF var.p_app_type IS NOT NULL THEN
579: dbms_sql.bind_variable(c, 'p_app_type', var.p_app_type);
580: END IF;
581:
582: dbms_sql.bind_variable(c, 'P_ENTERED_CURRENCY',var.p_currency_code);
583: dbms_sql.bind_variable(c, 'P_FUNCTIONAL_CURRENCY',var.functional_currency_code);

Line 582: dbms_sql.bind_variable(c, 'P_ENTERED_CURRENCY',var.p_currency_code);

578: IF var.p_app_type IS NOT NULL THEN
579: dbms_sql.bind_variable(c, 'p_app_type', var.p_app_type);
580: END IF;
581:
582: dbms_sql.bind_variable(c, 'P_ENTERED_CURRENCY',var.p_currency_code);
583: dbms_sql.bind_variable(c, 'P_FUNCTIONAL_CURRENCY',var.functional_currency_code);
584:
585: end bind;
586:

Line 583: dbms_sql.bind_variable(c, 'P_FUNCTIONAL_CURRENCY',var.functional_currency_code);

579: dbms_sql.bind_variable(c, 'p_app_type', var.p_app_type);
580: END IF;
581:
582: dbms_sql.bind_variable(c, 'P_ENTERED_CURRENCY',var.p_currency_code);
583: dbms_sql.bind_variable(c, 'P_FUNCTIONAL_CURRENCY',var.functional_currency_code);
584:
585: end bind;
586:
587: --