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 504: dbms_sql.bind_variable(c, 'p_reporting_entity_id', var.p_reporting_entity_id);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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