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

629: begin
630: fa_rx_util_pkg.debug('arrx_rc_unapp.bind()+');
631:
632: IF var.p_gl_date_from IS NOT NULL THEN
633: dbms_sql.bind_variable(c, 'p_gl_date_from', var.p_gl_date_from);
634: END IF;
635: IF var.p_gl_date_to IS NOT NULL THEN
636: dbms_sql.bind_variable(c, 'p_gl_date_to', var.p_gl_date_to);
637: END IF;

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

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

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

636: dbms_sql.bind_variable(c, 'p_gl_date_to', var.p_gl_date_to);
637: END IF;
638:
639: IF var.p_reporting_entity_id IS NOT NULL AND var.p_reporting_level = '3000' THEN
640: dbms_sql.bind_variable(c, 'p_reporting_entity_id', var.p_reporting_entity_id);
641: END IF;
642: IF var.p_batch_name_low IS NOT NULL THEN
643: dbms_sql.bind_variable(c, 'p_batch_name_low',var.p_batch_name_low);
644: END IF;

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

639: IF var.p_reporting_entity_id IS NOT NULL AND var.p_reporting_level = '3000' THEN
640: dbms_sql.bind_variable(c, 'p_reporting_entity_id', var.p_reporting_entity_id);
641: END IF;
642: IF var.p_batch_name_low IS NOT NULL THEN
643: dbms_sql.bind_variable(c, 'p_batch_name_low',var.p_batch_name_low);
644: END IF;
645: IF var.p_batch_name_high IS NOT NULL THEN
646: dbms_sql.bind_variable(c, 'p_batch_name_high',var.p_batch_name_high);
647: END IF;

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

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

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

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

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

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

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

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

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

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

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

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

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

660: IF var.p_customer_number_low IS NOT NULL THEN
661: dbms_sql.bind_variable(c, 'p_customer_number_low',var.p_customer_number_low);
662: END IF;
663: IF var.p_customer_number_high IS NOT NULL THEN
664: dbms_sql.bind_variable(c, 'p_customer_number_high',var.p_customer_number_high);
665: END IF;
666: IF var.p_receipt_number_low IS NOT NULL THEN
667: dbms_sql.bind_variable(c, 'p_receipt_number_low',var.p_receipt_number_low);
668: END IF;

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

663: IF var.p_customer_number_high IS NOT NULL THEN
664: dbms_sql.bind_variable(c, 'p_customer_number_high',var.p_customer_number_high);
665: END IF;
666: IF var.p_receipt_number_low IS NOT NULL THEN
667: dbms_sql.bind_variable(c, 'p_receipt_number_low',var.p_receipt_number_low);
668: END IF;
669: IF var.p_receipt_number_high IS NOT NULL THEN
670: dbms_sql.bind_variable(c, 'p_receipt_number_high',var.p_receipt_number_high);
671: END IF;

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

666: IF var.p_receipt_number_low IS NOT NULL THEN
667: dbms_sql.bind_variable(c, 'p_receipt_number_low',var.p_receipt_number_low);
668: END IF;
669: IF var.p_receipt_number_high IS NOT NULL THEN
670: dbms_sql.bind_variable(c, 'p_receipt_number_high',var.p_receipt_number_high);
671: END IF;
672:
673: dbms_sql.bind_variable(c, 'P_ENTERED_CURRENCY',var.p_entered_currency);
674: dbms_sql.bind_variable(c, 'P_FUNCTIONAL_CURRENCY',var.functional_currency_code);

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

669: IF var.p_receipt_number_high IS NOT NULL THEN
670: dbms_sql.bind_variable(c, 'p_receipt_number_high',var.p_receipt_number_high);
671: END IF;
672:
673: dbms_sql.bind_variable(c, 'P_ENTERED_CURRENCY',var.p_entered_currency);
674: dbms_sql.bind_variable(c, 'P_FUNCTIONAL_CURRENCY',var.functional_currency_code);
675:
676: select MEANING into l_app from ar_lookups
677: where lookup_type='CHECK_STATUS' and lookup_code='APP';

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

670: dbms_sql.bind_variable(c, 'p_receipt_number_high',var.p_receipt_number_high);
671: END IF;
672:
673: dbms_sql.bind_variable(c, 'P_ENTERED_CURRENCY',var.p_entered_currency);
674: dbms_sql.bind_variable(c, 'P_FUNCTIONAL_CURRENCY',var.functional_currency_code);
675:
676: select MEANING into l_app from ar_lookups
677: where lookup_type='CHECK_STATUS' and lookup_code='APP';
678: select MEANING into l_nsf from ar_lookups

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

684: select MEANING into l_unapp from ar_lookups
685: where lookup_type='CHECK_STATUS' and lookup_code='UNAPP';
686: select MEANING into l_unid from ar_lookups
687: where lookup_type='CHECK_STATUS' and lookup_code='UNID';
688: dbms_sql.bind_variable(c, 'L_APP' , l_app);
689: dbms_sql.bind_variable(c, 'L_NSF' , l_nsf);
690: dbms_sql.bind_variable(c, 'L_REV' , l_rev);
691: dbms_sql.bind_variable(c, 'L_STOP' , l_stop);
692: dbms_sql.bind_variable(c, 'L_UNAPP', l_unapp);

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

685: where lookup_type='CHECK_STATUS' and lookup_code='UNAPP';
686: select MEANING into l_unid from ar_lookups
687: where lookup_type='CHECK_STATUS' and lookup_code='UNID';
688: dbms_sql.bind_variable(c, 'L_APP' , l_app);
689: dbms_sql.bind_variable(c, 'L_NSF' , l_nsf);
690: dbms_sql.bind_variable(c, 'L_REV' , l_rev);
691: dbms_sql.bind_variable(c, 'L_STOP' , l_stop);
692: dbms_sql.bind_variable(c, 'L_UNAPP', l_unapp);
693: dbms_sql.bind_variable(c, 'L_UNID' , l_unid);

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

686: select MEANING into l_unid from ar_lookups
687: where lookup_type='CHECK_STATUS' and lookup_code='UNID';
688: dbms_sql.bind_variable(c, 'L_APP' , l_app);
689: dbms_sql.bind_variable(c, 'L_NSF' , l_nsf);
690: dbms_sql.bind_variable(c, 'L_REV' , l_rev);
691: dbms_sql.bind_variable(c, 'L_STOP' , l_stop);
692: dbms_sql.bind_variable(c, 'L_UNAPP', l_unapp);
693: dbms_sql.bind_variable(c, 'L_UNID' , l_unid);
694:

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

687: where lookup_type='CHECK_STATUS' and lookup_code='UNID';
688: dbms_sql.bind_variable(c, 'L_APP' , l_app);
689: dbms_sql.bind_variable(c, 'L_NSF' , l_nsf);
690: dbms_sql.bind_variable(c, 'L_REV' , l_rev);
691: dbms_sql.bind_variable(c, 'L_STOP' , l_stop);
692: dbms_sql.bind_variable(c, 'L_UNAPP', l_unapp);
693: dbms_sql.bind_variable(c, 'L_UNID' , l_unid);
694:
695: select substr(MEANING,1,44) into l_unid_cust from ar_lookups

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

688: dbms_sql.bind_variable(c, 'L_APP' , l_app);
689: dbms_sql.bind_variable(c, 'L_NSF' , l_nsf);
690: dbms_sql.bind_variable(c, 'L_REV' , l_rev);
691: dbms_sql.bind_variable(c, 'L_STOP' , l_stop);
692: dbms_sql.bind_variable(c, 'L_UNAPP', l_unapp);
693: dbms_sql.bind_variable(c, 'L_UNID' , l_unid);
694:
695: select substr(MEANING,1,44) into l_unid_cust from ar_lookups
696: where lookup_type = 'SPECIAL_TYPES' and lookup_code = 'UNIDENTIFIED';

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

689: dbms_sql.bind_variable(c, 'L_NSF' , l_nsf);
690: dbms_sql.bind_variable(c, 'L_REV' , l_rev);
691: dbms_sql.bind_variable(c, 'L_STOP' , l_stop);
692: dbms_sql.bind_variable(c, 'L_UNAPP', l_unapp);
693: dbms_sql.bind_variable(c, 'L_UNID' , l_unid);
694:
695: select substr(MEANING,1,44) into l_unid_cust from ar_lookups
696: where lookup_type = 'SPECIAL_TYPES' and lookup_code = 'UNIDENTIFIED';
697: l_unid_cust := ' **** '||l_unid_cust;

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

694:
695: select substr(MEANING,1,44) into l_unid_cust from ar_lookups
696: where lookup_type = 'SPECIAL_TYPES' and lookup_code = 'UNIDENTIFIED';
697: l_unid_cust := ' **** '||l_unid_cust;
698: dbms_sql.bind_variable(c, 'L_UNID_CUST' , l_unid_cust);
699:
700: select MEANING into L_APPROVED from ar_lookups
701: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='APPROVED';
702: select MEANING into L_CLEARED from ar_lookups

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

706: select MEANING into L_REMITTED from ar_lookups
707: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REMITTED';
708: select MEANING into L_REVERSED from ar_lookups
709: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';
710: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
711: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
712: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
713: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
714: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);

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

707: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REMITTED';
708: select MEANING into L_REVERSED from ar_lookups
709: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';
710: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
711: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
712: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
713: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
714: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
715:

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

708: select MEANING into L_REVERSED from ar_lookups
709: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';
710: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
711: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
712: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
713: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
714: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
715:
716: fa_rx_util_pkg.debug('arrx_rc_unapp.bind()-');

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

709: where lookup_type='RECEIPT_CREATION_STATUS' and lookup_code='REVERSED';
710: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
711: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
712: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
713: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
714: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
715:
716: fa_rx_util_pkg.debug('arrx_rc_unapp.bind()-');
717:

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

710: dbms_sql.bind_variable(c, 'L_APPROVED' , L_APPROVED);
711: dbms_sql.bind_variable(c, 'L_CLEARED' , L_CLEARED);
712: dbms_sql.bind_variable(c, 'L_CONFIRMED' , L_CONFIRMED);
713: dbms_sql.bind_variable(c, 'L_REMITTED' , L_REMITTED);
714: dbms_sql.bind_variable(c, 'L_REVERSED' , L_REVERSED);
715:
716: fa_rx_util_pkg.debug('arrx_rc_unapp.bind()-');
717:
718: END bind;