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

Line 732: dbms_sql.bind_variable(c, 'start_gl_date', var.start_gl_date);

728: --
729: -- These bind variables(Date Type) were included in the WHERE clause
730: --
731: IF var.start_gl_date IS NOT NULL THEN
732: dbms_sql.bind_variable(c, 'start_gl_date', var.start_gl_date);
733: END IF;
734: IF var.end_gl_date IS NOT NULL THEN
735: dbms_sql.bind_variable(c, 'end_gl_date', var.end_gl_date);
736: END IF;

Line 735: dbms_sql.bind_variable(c, 'end_gl_date', var.end_gl_date);

731: IF var.start_gl_date IS NOT NULL THEN
732: dbms_sql.bind_variable(c, 'start_gl_date', var.start_gl_date);
733: END IF;
734: IF var.end_gl_date IS NOT NULL THEN
735: dbms_sql.bind_variable(c, 'end_gl_date', var.end_gl_date);
736: END IF;
737:
738: --begin for bug 1814839
739:

Line 743: dbms_sql.bind_variable(c, 'end_bill_to_customer_name', var.end_bill_to_customer_name);

739:
740: IF var.start_bill_to_customer_name IS NULL AND var.end_bill_to_customer_name IS NULL THEN
741: NULL;
742: ELSIF var.start_bill_to_customer_name IS NULL THEN
743: dbms_sql.bind_variable(c, 'end_bill_to_customer_name', var.end_bill_to_customer_name);
744: ELSIF var.end_bill_to_customer_name IS NULL THEN
745: dbms_sql.bind_variable(c, 'start_bill_to_customer_name', var.start_bill_to_customer_name);
746: ELSE
747: dbms_sql.bind_variable(c, 'end_bill_to_customer_name', var.end_bill_to_customer_name);

Line 745: dbms_sql.bind_variable(c, 'start_bill_to_customer_name', var.start_bill_to_customer_name);

741: NULL;
742: ELSIF var.start_bill_to_customer_name IS NULL THEN
743: dbms_sql.bind_variable(c, 'end_bill_to_customer_name', var.end_bill_to_customer_name);
744: ELSIF var.end_bill_to_customer_name IS NULL THEN
745: dbms_sql.bind_variable(c, 'start_bill_to_customer_name', var.start_bill_to_customer_name);
746: ELSE
747: dbms_sql.bind_variable(c, 'end_bill_to_customer_name', var.end_bill_to_customer_name);
748: dbms_sql.bind_variable(c, 'start_bill_to_customer_name', var.start_bill_to_customer_name);
749:

Line 747: dbms_sql.bind_variable(c, 'end_bill_to_customer_name', var.end_bill_to_customer_name);

743: dbms_sql.bind_variable(c, 'end_bill_to_customer_name', var.end_bill_to_customer_name);
744: ELSIF var.end_bill_to_customer_name IS NULL THEN
745: dbms_sql.bind_variable(c, 'start_bill_to_customer_name', var.start_bill_to_customer_name);
746: ELSE
747: dbms_sql.bind_variable(c, 'end_bill_to_customer_name', var.end_bill_to_customer_name);
748: dbms_sql.bind_variable(c, 'start_bill_to_customer_name', var.start_bill_to_customer_name);
749:
750: END IF;
751:

Line 748: dbms_sql.bind_variable(c, 'start_bill_to_customer_name', var.start_bill_to_customer_name);

744: ELSIF var.end_bill_to_customer_name IS NULL THEN
745: dbms_sql.bind_variable(c, 'start_bill_to_customer_name', var.start_bill_to_customer_name);
746: ELSE
747: dbms_sql.bind_variable(c, 'end_bill_to_customer_name', var.end_bill_to_customer_name);
748: dbms_sql.bind_variable(c, 'start_bill_to_customer_name', var.start_bill_to_customer_name);
749:
750: END IF;
751:
752: --end for bug 1814839

Line 755: dbms_sql.bind_variable(c, 'start_transaction_date', var.start_transaction_date);

751:
752: --end for bug 1814839
753:
754: IF var.start_transaction_date IS NOT NULL THEN
755: dbms_sql.bind_variable(c, 'start_transaction_date', var.start_transaction_date);
756: END IF;
757: IF var.end_transaction_date IS NOT NULL THEN
758: dbms_sql.bind_variable(c, 'end_transaction_date', var.end_transaction_date);
759: END IF;

Line 758: dbms_sql.bind_variable(c, 'end_transaction_date', var.end_transaction_date);

754: IF var.start_transaction_date IS NOT NULL THEN
755: dbms_sql.bind_variable(c, 'start_transaction_date', var.start_transaction_date);
756: END IF;
757: IF var.end_transaction_date IS NOT NULL THEN
758: dbms_sql.bind_variable(c, 'end_transaction_date', var.end_transaction_date);
759: END IF;
760:
761: select MEANING into YES_NO_Y from ar_lookups
762: where lookup_type = 'YES/NO' and LOOKUP_CODE = 'Y';

Line 765: dbms_sql.bind_variable(c, 'YES', YES_NO_Y);

761: select MEANING into YES_NO_Y from ar_lookups
762: where lookup_type = 'YES/NO' and LOOKUP_CODE = 'Y';
763: select MEANING into YES_NO_N from ar_lookups
764: where lookup_type = 'YES/NO' and LOOKUP_CODE = 'N';
765: dbms_sql.bind_variable(c, 'YES', YES_NO_Y);
766: dbms_sql.bind_variable(c, 'NO', YES_NO_N);
767:
768: -- Bug 1988421
769: IF var.start_transaction_type IS NOT NULL THEN

Line 766: dbms_sql.bind_variable(c, 'NO', YES_NO_N);

762: where lookup_type = 'YES/NO' and LOOKUP_CODE = 'Y';
763: select MEANING into YES_NO_N from ar_lookups
764: where lookup_type = 'YES/NO' and LOOKUP_CODE = 'N';
765: dbms_sql.bind_variable(c, 'YES', YES_NO_Y);
766: dbms_sql.bind_variable(c, 'NO', YES_NO_N);
767:
768: -- Bug 1988421
769: IF var.start_transaction_type IS NOT NULL THEN
770: dbms_sql.bind_variable(c, 'start_transaction_type', var.start_transaction_type);

Line 770: dbms_sql.bind_variable(c, 'start_transaction_type', var.start_transaction_type);

766: dbms_sql.bind_variable(c, 'NO', YES_NO_N);
767:
768: -- Bug 1988421
769: IF var.start_transaction_type IS NOT NULL THEN
770: dbms_sql.bind_variable(c, 'start_transaction_type', var.start_transaction_type);
771: END IF;
772: IF var.end_transaction_type IS NOT NULL THEN
773: dbms_sql.bind_variable(c, 'end_transaction_type', var.end_transaction_type);
774: END IF;

Line 773: dbms_sql.bind_variable(c, 'end_transaction_type', var.end_transaction_type);

769: IF var.start_transaction_type IS NOT NULL THEN
770: dbms_sql.bind_variable(c, 'start_transaction_type', var.start_transaction_type);
771: END IF;
772: IF var.end_transaction_type IS NOT NULL THEN
773: dbms_sql.bind_variable(c, 'end_transaction_type', var.end_transaction_type);
774: END IF;
775: IF var.start_transaction_class IS NOT NULL THEN
776: dbms_sql.bind_variable(c, 'start_transaction_class', var.start_transaction_class);
777: END IF;

Line 776: dbms_sql.bind_variable(c, 'start_transaction_class', var.start_transaction_class);

772: IF var.end_transaction_type IS NOT NULL THEN
773: dbms_sql.bind_variable(c, 'end_transaction_type', var.end_transaction_type);
774: END IF;
775: IF var.start_transaction_class IS NOT NULL THEN
776: dbms_sql.bind_variable(c, 'start_transaction_class', var.start_transaction_class);
777: END IF;
778: IF var.end_transaction_class IS NOT NULL THEN
779: dbms_sql.bind_variable(c, 'end_transaction_class', var.end_transaction_class);
780: END IF;

Line 779: dbms_sql.bind_variable(c, 'end_transaction_class', var.end_transaction_class);

775: IF var.start_transaction_class IS NOT NULL THEN
776: dbms_sql.bind_variable(c, 'start_transaction_class', var.start_transaction_class);
777: END IF;
778: IF var.end_transaction_class IS NOT NULL THEN
779: dbms_sql.bind_variable(c, 'end_transaction_class', var.end_transaction_class);
780: END IF;
781: IF var.start_bill_to_customer_number IS NOT NULL THEN
782: dbms_sql.bind_variable(c, 'start_bill_to_customer_number', var.start_bill_to_customer_number);
783: END IF;

Line 782: dbms_sql.bind_variable(c, 'start_bill_to_customer_number', var.start_bill_to_customer_number);

778: IF var.end_transaction_class IS NOT NULL THEN
779: dbms_sql.bind_variable(c, 'end_transaction_class', var.end_transaction_class);
780: END IF;
781: IF var.start_bill_to_customer_number IS NOT NULL THEN
782: dbms_sql.bind_variable(c, 'start_bill_to_customer_number', var.start_bill_to_customer_number);
783: END IF;
784: IF var.end_bill_to_customer_number IS NOT NULL THEN
785: dbms_sql.bind_variable(c, 'end_bill_to_customer_number', var.end_bill_to_customer_number);
786: END IF;

Line 785: dbms_sql.bind_variable(c, 'end_bill_to_customer_number', var.end_bill_to_customer_number);

781: IF var.start_bill_to_customer_number IS NOT NULL THEN
782: dbms_sql.bind_variable(c, 'start_bill_to_customer_number', var.start_bill_to_customer_number);
783: END IF;
784: IF var.end_bill_to_customer_number IS NOT NULL THEN
785: dbms_sql.bind_variable(c, 'end_bill_to_customer_number', var.end_bill_to_customer_number);
786: END IF;
787: IF var.start_currency IS NOT NULL THEN
788: dbms_sql.bind_variable(c, 'start_currency', var.start_currency);
789: END IF;

Line 788: dbms_sql.bind_variable(c, 'start_currency', var.start_currency);

784: IF var.end_bill_to_customer_number IS NOT NULL THEN
785: dbms_sql.bind_variable(c, 'end_bill_to_customer_number', var.end_bill_to_customer_number);
786: END IF;
787: IF var.start_currency IS NOT NULL THEN
788: dbms_sql.bind_variable(c, 'start_currency', var.start_currency);
789: END IF;
790: IF var.end_currency IS NOT NULL THEN
791: dbms_sql.bind_variable(c, 'end_currency', var.end_currency);
792: END IF;

Line 791: dbms_sql.bind_variable(c, 'end_currency', var.end_currency);

787: IF var.start_currency IS NOT NULL THEN
788: dbms_sql.bind_variable(c, 'start_currency', var.start_currency);
789: END IF;
790: IF var.end_currency IS NOT NULL THEN
791: dbms_sql.bind_variable(c, 'end_currency', var.end_currency);
792: END IF;
793: IF var.payment_method IS NOT NULL THEN
794: dbms_sql.bind_variable(c, 'payment_method', var.payment_method);
795: END IF;

Line 794: dbms_sql.bind_variable(c, 'payment_method', var.payment_method);

790: IF var.end_currency IS NOT NULL THEN
791: dbms_sql.bind_variable(c, 'end_currency', var.end_currency);
792: END IF;
793: IF var.payment_method IS NOT NULL THEN
794: dbms_sql.bind_variable(c, 'payment_method', var.payment_method);
795: END IF;
796: IF var.doc_sequence_name IS NOT NULL THEN
797: dbms_sql.bind_variable(c, 'doc_sequence_name', var.doc_sequence_name);
798: END IF;

Line 797: dbms_sql.bind_variable(c, 'doc_sequence_name', var.doc_sequence_name);

793: IF var.payment_method IS NOT NULL THEN
794: dbms_sql.bind_variable(c, 'payment_method', var.payment_method);
795: END IF;
796: IF var.doc_sequence_name IS NOT NULL THEN
797: dbms_sql.bind_variable(c, 'doc_sequence_name', var.doc_sequence_name);
798: END IF;
799: IF var.doc_sequence_number_from IS NOT NULL THEN
800: dbms_sql.bind_variable(c, 'doc_sequence_number_from', var.doc_sequence_number_from);
801: END IF;

Line 800: dbms_sql.bind_variable(c, 'doc_sequence_number_from', var.doc_sequence_number_from);

796: IF var.doc_sequence_name IS NOT NULL THEN
797: dbms_sql.bind_variable(c, 'doc_sequence_name', var.doc_sequence_name);
798: END IF;
799: IF var.doc_sequence_number_from IS NOT NULL THEN
800: dbms_sql.bind_variable(c, 'doc_sequence_number_from', var.doc_sequence_number_from);
801: END IF;
802: IF var.doc_sequence_number_to IS NOT NULL THEN
803: dbms_sql.bind_variable(c, 'doc_sequence_number_to', var.doc_sequence_number_to);
804: END IF;

Line 803: dbms_sql.bind_variable(c, 'doc_sequence_number_to', var.doc_sequence_number_to);

799: IF var.doc_sequence_number_from IS NOT NULL THEN
800: dbms_sql.bind_variable(c, 'doc_sequence_number_from', var.doc_sequence_number_from);
801: END IF;
802: IF var.doc_sequence_number_to IS NOT NULL THEN
803: dbms_sql.bind_variable(c, 'doc_sequence_number_to', var.doc_sequence_number_to);
804: END IF;
805: /*
806: -- bug3940958 added for new binds
807: -- p_reporting_entity_id is used only for operating unit level

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

805: /*
806: -- bug3940958 added for new binds
807: -- p_reporting_entity_id is used only for operating unit level
808: IF var.reporting_level = '3000' THEN
809: dbms_sql.bind_variable(c, 'p_reporting_entity_id', var.reporting_entity_id);
810: END IF;
811: */
812: IF var.batch_source_name IS NOT NULL THEN
813: dbms_sql.bind_variable(c, 'batch_source_name', var.batch_source_name);

Line 813: dbms_sql.bind_variable(c, 'batch_source_name', var.batch_source_name);

809: dbms_sql.bind_variable(c, 'p_reporting_entity_id', var.reporting_entity_id);
810: END IF;
811: */
812: IF var.batch_source_name IS NOT NULL THEN
813: dbms_sql.bind_variable(c, 'batch_source_name', var.batch_source_name);
814: END IF;
815:
816: IF var.transaction_class IS NOT NULL THEN
817: dbms_sql.bind_variable(c, 'transaction_class', var.transaction_class);

Line 817: dbms_sql.bind_variable(c, 'transaction_class', var.transaction_class);

813: dbms_sql.bind_variable(c, 'batch_source_name', var.batch_source_name);
814: END IF;
815:
816: IF var.transaction_class IS NOT NULL THEN
817: dbms_sql.bind_variable(c, 'transaction_class', var.transaction_class);
818: END IF;
819: end bind;
820:
821:

Line 1128: dbms_sql.bind_variable(c, 'start_update_date', var.start_update_date);

1124: fa_rx_util_pkg.debug('AR_GET_BIND');
1125: --
1126: -- These bind variables(Date Type) were included in the WHERE clause
1127: --
1128: dbms_sql.bind_variable(c, 'start_update_date', var.start_update_date);
1129: dbms_sql.bind_variable(c, 'end_update_date', var.end_update_date);
1130:
1131: end check_bind;
1132:

Line 1129: dbms_sql.bind_variable(c, 'end_update_date', var.end_update_date);

1125: --
1126: -- These bind variables(Date Type) were included in the WHERE clause
1127: --
1128: dbms_sql.bind_variable(c, 'start_update_date', var.start_update_date);
1129: dbms_sql.bind_variable(c, 'end_update_date', var.end_update_date);
1130:
1131: end check_bind;
1132:
1133:

Line 1365: dbms_sql.bind_variable(c, 'start_due_date', var.start_due_date);

1361: --
1362: -- These bind variables(Date Type) were included in the WHERE clause
1363: --
1364: IF var.start_due_date IS NOT NULL THEN
1365: dbms_sql.bind_variable(c, 'start_due_date', var.start_due_date);
1366: END IF;
1367: IF var.end_due_date IS NOT NULL THEN
1368: dbms_sql.bind_variable(c, 'end_due_date', var.end_due_date);
1369: END IF;

Line 1368: dbms_sql.bind_variable(c, 'end_due_date', var.end_due_date);

1364: IF var.start_due_date IS NOT NULL THEN
1365: dbms_sql.bind_variable(c, 'start_due_date', var.start_due_date);
1366: END IF;
1367: IF var.end_due_date IS NOT NULL THEN
1368: dbms_sql.bind_variable(c, 'end_due_date', var.end_due_date);
1369: END IF;
1370:
1371: end forecast_bind;
1372:

Line 1820: dbms_sql.bind_variable(c, 'start_invoice_num', var.start_invoice_num);

1816: --
1817: -- These bind variables(Date Type) were included in the WHERE clause
1818: --
1819: IF var.start_invoice_num IS NOT NULL THEN
1820: dbms_sql.bind_variable(c, 'start_invoice_num', var.start_invoice_num);
1821: END IF;
1822: IF var.end_invoice_num IS NOT NULL THEN
1823: dbms_sql.bind_variable(c, 'end_invoice_num', var.end_invoice_num);
1824: END IF;

Line 1823: dbms_sql.bind_variable(c, 'end_invoice_num', var.end_invoice_num);

1819: IF var.start_invoice_num IS NOT NULL THEN
1820: dbms_sql.bind_variable(c, 'start_invoice_num', var.start_invoice_num);
1821: END IF;
1822: IF var.end_invoice_num IS NOT NULL THEN
1823: dbms_sql.bind_variable(c, 'end_invoice_num', var.end_invoice_num);
1824: END IF;
1825: IF var.start_amount IS NOT NULL THEN
1826: dbms_sql.bind_variable(c, 'start_amount', var.start_amount);
1827: END IF;

Line 1826: dbms_sql.bind_variable(c, 'start_amount', var.start_amount);

1822: IF var.end_invoice_num IS NOT NULL THEN
1823: dbms_sql.bind_variable(c, 'end_invoice_num', var.end_invoice_num);
1824: END IF;
1825: IF var.start_amount IS NOT NULL THEN
1826: dbms_sql.bind_variable(c, 'start_amount', var.start_amount);
1827: END IF;
1828: IF var.end_amount IS NOT NULL THEN
1829: dbms_sql.bind_variable(c, 'end_amount', var.end_amount);
1830: END IF;

Line 1829: dbms_sql.bind_variable(c, 'end_amount', var.end_amount);

1825: IF var.start_amount IS NOT NULL THEN
1826: dbms_sql.bind_variable(c, 'start_amount', var.start_amount);
1827: END IF;
1828: IF var.end_amount IS NOT NULL THEN
1829: dbms_sql.bind_variable(c, 'end_amount', var.end_amount);
1830: END IF;
1831:
1832: end sales_bind;
1833: