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_RC_UNAPP dependencies on DBMS_SQL

Line 626: dbms_sql.bind_variable(c, 'p_gl_date_from', var.p_gl_date_from);

622: begin
623: fa_rx_util_pkg.debug('arrx_rc_unapp.bind()+');
624:
625: IF var.p_gl_date_from IS NOT NULL THEN
626: dbms_sql.bind_variable(c, 'p_gl_date_from', var.p_gl_date_from);
627: END IF;
628: IF var.p_gl_date_to IS NOT NULL THEN
629: dbms_sql.bind_variable(c, 'p_gl_date_to', var.p_gl_date_to);
630: END IF;

Line 629: dbms_sql.bind_variable(c, 'p_gl_date_to', var.p_gl_date_to);

625: IF var.p_gl_date_from IS NOT NULL THEN
626: dbms_sql.bind_variable(c, 'p_gl_date_from', var.p_gl_date_from);
627: END IF;
628: IF var.p_gl_date_to IS NOT NULL THEN
629: dbms_sql.bind_variable(c, 'p_gl_date_to', var.p_gl_date_to);
630: END IF;
631:
632: IF var.p_reporting_entity_id IS NOT NULL AND var.p_reporting_level = '3000' THEN
633: dbms_sql.bind_variable(c, 'p_reporting_entity_id', var.p_reporting_entity_id);

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

629: dbms_sql.bind_variable(c, 'p_gl_date_to', var.p_gl_date_to);
630: END IF;
631:
632: IF var.p_reporting_entity_id IS NOT NULL AND var.p_reporting_level = '3000' THEN
633: dbms_sql.bind_variable(c, 'p_reporting_entity_id', var.p_reporting_entity_id);
634: END IF;
635: IF var.p_batch_name_low IS NOT NULL THEN
636: dbms_sql.bind_variable(c, 'p_batch_name_low',var.p_batch_name_low);
637: END IF;

Line 636: dbms_sql.bind_variable(c, 'p_batch_name_low',var.p_batch_name_low);

632: IF var.p_reporting_entity_id IS NOT NULL AND var.p_reporting_level = '3000' THEN
633: dbms_sql.bind_variable(c, 'p_reporting_entity_id', var.p_reporting_entity_id);
634: END IF;
635: IF var.p_batch_name_low IS NOT NULL THEN
636: dbms_sql.bind_variable(c, 'p_batch_name_low',var.p_batch_name_low);
637: END IF;
638: IF var.p_batch_name_high IS NOT NULL THEN
639: dbms_sql.bind_variable(c, 'p_batch_name_high',var.p_batch_name_high);
640: END IF;

Line 639: dbms_sql.bind_variable(c, 'p_batch_name_high',var.p_batch_name_high);

635: IF var.p_batch_name_low IS NOT NULL THEN
636: dbms_sql.bind_variable(c, 'p_batch_name_low',var.p_batch_name_low);
637: END IF;
638: IF var.p_batch_name_high IS NOT NULL THEN
639: dbms_sql.bind_variable(c, 'p_batch_name_high',var.p_batch_name_high);
640: END IF;
641: IF var.p_batch_src_low IS NOT NULL THEN
642: dbms_sql.bind_variable(c, 'p_batch_src_low',var.p_batch_src_low);
643: END IF;

Line 642: dbms_sql.bind_variable(c, 'p_batch_src_low',var.p_batch_src_low);

638: IF var.p_batch_name_high IS NOT NULL THEN
639: dbms_sql.bind_variable(c, 'p_batch_name_high',var.p_batch_name_high);
640: END IF;
641: IF var.p_batch_src_low IS NOT NULL THEN
642: dbms_sql.bind_variable(c, 'p_batch_src_low',var.p_batch_src_low);
643: END IF;
644: IF var.p_batch_src_high IS NOT NULL THEN
645: dbms_sql.bind_variable(c, 'p_batch_src_high',var.p_batch_src_high);
646: END IF;

Line 645: dbms_sql.bind_variable(c, 'p_batch_src_high',var.p_batch_src_high);

641: IF var.p_batch_src_low IS NOT NULL THEN
642: dbms_sql.bind_variable(c, 'p_batch_src_low',var.p_batch_src_low);
643: END IF;
644: IF var.p_batch_src_high IS NOT NULL THEN
645: dbms_sql.bind_variable(c, 'p_batch_src_high',var.p_batch_src_high);
646: END IF;
647: IF var.p_customer_name_low IS NOT NULL THEN
648: dbms_sql.bind_variable(c, 'p_customer_name_low',var.p_customer_name_low);
649: END IF;

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

644: IF var.p_batch_src_high IS NOT NULL THEN
645: dbms_sql.bind_variable(c, 'p_batch_src_high',var.p_batch_src_high);
646: END IF;
647: IF var.p_customer_name_low IS NOT NULL THEN
648: dbms_sql.bind_variable(c, 'p_customer_name_low',var.p_customer_name_low);
649: END IF;
650: IF var.p_customer_name_high IS NOT NULL THEN
651: dbms_sql.bind_variable(c, 'p_customer_name_high',var.p_customer_name_high);
652: END IF;

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

647: IF var.p_customer_name_low IS NOT NULL THEN
648: dbms_sql.bind_variable(c, 'p_customer_name_low',var.p_customer_name_low);
649: END IF;
650: IF var.p_customer_name_high IS NOT NULL THEN
651: dbms_sql.bind_variable(c, 'p_customer_name_high',var.p_customer_name_high);
652: END IF;
653: IF var.p_customer_number_low IS NOT NULL THEN
654: dbms_sql.bind_variable(c, 'p_customer_number_low',var.p_customer_number_low);
655: END IF;

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

650: IF var.p_customer_name_high IS NOT NULL THEN
651: dbms_sql.bind_variable(c, 'p_customer_name_high',var.p_customer_name_high);
652: END IF;
653: IF var.p_customer_number_low IS NOT NULL THEN
654: dbms_sql.bind_variable(c, 'p_customer_number_low',var.p_customer_number_low);
655: END IF;
656: IF var.p_customer_number_high IS NOT NULL THEN
657: dbms_sql.bind_variable(c, 'p_customer_number_high',var.p_customer_number_high);
658: END IF;

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

653: IF var.p_customer_number_low IS NOT NULL THEN
654: dbms_sql.bind_variable(c, 'p_customer_number_low',var.p_customer_number_low);
655: END IF;
656: IF var.p_customer_number_high IS NOT NULL THEN
657: dbms_sql.bind_variable(c, 'p_customer_number_high',var.p_customer_number_high);
658: END IF;
659: IF var.p_receipt_number_low IS NOT NULL THEN
660: dbms_sql.bind_variable(c, 'p_receipt_number_low',var.p_receipt_number_low);
661: END IF;

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

656: IF var.p_customer_number_high IS NOT NULL THEN
657: dbms_sql.bind_variable(c, 'p_customer_number_high',var.p_customer_number_high);
658: END IF;
659: IF var.p_receipt_number_low IS NOT NULL THEN
660: dbms_sql.bind_variable(c, 'p_receipt_number_low',var.p_receipt_number_low);
661: END IF;
662: IF var.p_receipt_number_high IS NOT NULL THEN
663: dbms_sql.bind_variable(c, 'p_receipt_number_high',var.p_receipt_number_high);
664: END IF;

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

659: IF var.p_receipt_number_low IS NOT NULL THEN
660: dbms_sql.bind_variable(c, 'p_receipt_number_low',var.p_receipt_number_low);
661: END IF;
662: IF var.p_receipt_number_high IS NOT NULL THEN
663: dbms_sql.bind_variable(c, 'p_receipt_number_high',var.p_receipt_number_high);
664: END IF;
665:
666: dbms_sql.bind_variable(c, 'P_ENTERED_CURRENCY',var.p_entered_currency);
667: dbms_sql.bind_variable(c, 'P_FUNCTIONAL_CURRENCY',var.functional_currency_code);

Line 666: dbms_sql.bind_variable(c, 'P_ENTERED_CURRENCY',var.p_entered_currency);

662: IF var.p_receipt_number_high IS NOT NULL THEN
663: dbms_sql.bind_variable(c, 'p_receipt_number_high',var.p_receipt_number_high);
664: END IF;
665:
666: dbms_sql.bind_variable(c, 'P_ENTERED_CURRENCY',var.p_entered_currency);
667: dbms_sql.bind_variable(c, 'P_FUNCTIONAL_CURRENCY',var.functional_currency_code);
668:
669: select MEANING into l_app from ar_lookups
670: where lookup_type='CHECK_STATUS' and lookup_code='APP';

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

663: dbms_sql.bind_variable(c, 'p_receipt_number_high',var.p_receipt_number_high);
664: END IF;
665:
666: dbms_sql.bind_variable(c, 'P_ENTERED_CURRENCY',var.p_entered_currency);
667: dbms_sql.bind_variable(c, 'P_FUNCTIONAL_CURRENCY',var.functional_currency_code);
668:
669: select MEANING into l_app from ar_lookups
670: where lookup_type='CHECK_STATUS' and lookup_code='APP';
671: select MEANING into l_nsf from ar_lookups

Line 681: dbms_sql.bind_variable(c, 'L_APP' , l_app);

677: select MEANING into l_unapp from ar_lookups
678: where lookup_type='CHECK_STATUS' and lookup_code='UNAPP';
679: select MEANING into l_unid from ar_lookups
680: where lookup_type='CHECK_STATUS' and lookup_code='UNID';
681: dbms_sql.bind_variable(c, 'L_APP' , l_app);
682: dbms_sql.bind_variable(c, 'L_NSF' , l_nsf);
683: dbms_sql.bind_variable(c, 'L_REV' , l_rev);
684: dbms_sql.bind_variable(c, 'L_STOP' , l_stop);
685: dbms_sql.bind_variable(c, 'L_UNAPP', l_unapp);

Line 682: dbms_sql.bind_variable(c, 'L_NSF' , l_nsf);

678: where lookup_type='CHECK_STATUS' and lookup_code='UNAPP';
679: select MEANING into l_unid from ar_lookups
680: where lookup_type='CHECK_STATUS' and lookup_code='UNID';
681: dbms_sql.bind_variable(c, 'L_APP' , l_app);
682: dbms_sql.bind_variable(c, 'L_NSF' , l_nsf);
683: dbms_sql.bind_variable(c, 'L_REV' , l_rev);
684: dbms_sql.bind_variable(c, 'L_STOP' , l_stop);
685: dbms_sql.bind_variable(c, 'L_UNAPP', l_unapp);
686: dbms_sql.bind_variable(c, 'L_UNID' , l_unid);

Line 683: dbms_sql.bind_variable(c, 'L_REV' , l_rev);

679: select MEANING into l_unid from ar_lookups
680: where lookup_type='CHECK_STATUS' and lookup_code='UNID';
681: dbms_sql.bind_variable(c, 'L_APP' , l_app);
682: dbms_sql.bind_variable(c, 'L_NSF' , l_nsf);
683: dbms_sql.bind_variable(c, 'L_REV' , l_rev);
684: dbms_sql.bind_variable(c, 'L_STOP' , l_stop);
685: dbms_sql.bind_variable(c, 'L_UNAPP', l_unapp);
686: dbms_sql.bind_variable(c, 'L_UNID' , l_unid);
687:

Line 684: dbms_sql.bind_variable(c, 'L_STOP' , l_stop);

680: where lookup_type='CHECK_STATUS' and lookup_code='UNID';
681: dbms_sql.bind_variable(c, 'L_APP' , l_app);
682: dbms_sql.bind_variable(c, 'L_NSF' , l_nsf);
683: dbms_sql.bind_variable(c, 'L_REV' , l_rev);
684: dbms_sql.bind_variable(c, 'L_STOP' , l_stop);
685: dbms_sql.bind_variable(c, 'L_UNAPP', l_unapp);
686: dbms_sql.bind_variable(c, 'L_UNID' , l_unid);
687:
688: select substr(MEANING,1,44) into l_unid_cust from ar_lookups

Line 685: dbms_sql.bind_variable(c, 'L_UNAPP', l_unapp);

681: dbms_sql.bind_variable(c, 'L_APP' , l_app);
682: dbms_sql.bind_variable(c, 'L_NSF' , l_nsf);
683: dbms_sql.bind_variable(c, 'L_REV' , l_rev);
684: dbms_sql.bind_variable(c, 'L_STOP' , l_stop);
685: dbms_sql.bind_variable(c, 'L_UNAPP', l_unapp);
686: dbms_sql.bind_variable(c, 'L_UNID' , l_unid);
687:
688: select substr(MEANING,1,44) into l_unid_cust from ar_lookups
689: where lookup_type = 'SPECIAL_TYPES' and lookup_code = 'UNIDENTIFIED';

Line 686: dbms_sql.bind_variable(c, 'L_UNID' , l_unid);

682: dbms_sql.bind_variable(c, 'L_NSF' , l_nsf);
683: dbms_sql.bind_variable(c, 'L_REV' , l_rev);
684: dbms_sql.bind_variable(c, 'L_STOP' , l_stop);
685: dbms_sql.bind_variable(c, 'L_UNAPP', l_unapp);
686: dbms_sql.bind_variable(c, 'L_UNID' , l_unid);
687:
688: select substr(MEANING,1,44) into l_unid_cust from ar_lookups
689: where lookup_type = 'SPECIAL_TYPES' and lookup_code = 'UNIDENTIFIED';
690: l_unid_cust := ' **** '||l_unid_cust;

Line 691: dbms_sql.bind_variable(c, 'L_UNID_CUST' , l_unid_cust);

687:
688: select substr(MEANING,1,44) into l_unid_cust from ar_lookups
689: where lookup_type = 'SPECIAL_TYPES' and lookup_code = 'UNIDENTIFIED';
690: l_unid_cust := ' **** '||l_unid_cust;
691: dbms_sql.bind_variable(c, 'L_UNID_CUST' , l_unid_cust);
692:
693: select MEANING into L_APPROVED from ar_lookups
694: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='APPROVED';
695: select MEANING into L_CLEARED from ar_lookups

Line 703: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);

699: select MEANING into L_REMITTED from ar_lookups
700: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REMITTED';
701: select MEANING into L_REVERSED from ar_lookups
702: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';
703: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
704: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
705: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
706: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
707: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);

Line 704: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);

700: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REMITTED';
701: select MEANING into L_REVERSED from ar_lookups
702: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';
703: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
704: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
705: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
706: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
707: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
708:

Line 705: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);

701: select MEANING into L_REVERSED from ar_lookups
702: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';
703: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
704: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
705: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
706: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
707: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
708:
709: fa_rx_util_pkg.debug('arrx_rc_unapp.bind()-');

Line 706: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);

702: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';
703: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
704: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
705: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
706: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
707: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
708:
709: fa_rx_util_pkg.debug('arrx_rc_unapp.bind()-');
710:

Line 707: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);

703: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
704: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
705: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
706: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
707: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
708:
709: fa_rx_util_pkg.debug('arrx_rc_unapp.bind()-');
710:
711: END bind;