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

710: --
711: -- These bind variables(Date Type) were included in the WHERE clause
712: --
713: IF var.start_gl_date IS NOT NULL THEN
714: dbms_sql.bind_variable(c, 'start_gl_date', var.start_gl_date);
715: END IF;
716: IF var.end_gl_date IS NOT NULL THEN
717: dbms_sql.bind_variable(c, 'end_gl_date', var.end_gl_date);
718: END IF;

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

713: IF var.start_gl_date IS NOT NULL THEN
714: dbms_sql.bind_variable(c, 'start_gl_date', var.start_gl_date);
715: END IF;
716: IF var.end_gl_date IS NOT NULL THEN
717: dbms_sql.bind_variable(c, 'end_gl_date', var.end_gl_date);
718: END IF;
719:
720: --begin for bug 1814839
721:

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

721:
722: IF var.start_bill_to_customer_name IS NULL AND var.end_bill_to_customer_name IS NULL THEN
723: NULL;
724: ELSIF var.start_bill_to_customer_name IS NULL THEN
725: dbms_sql.bind_variable(c, 'end_bill_to_customer_name', var.end_bill_to_customer_name);
726: ELSIF var.end_bill_to_customer_name IS NULL THEN
727: dbms_sql.bind_variable(c, 'start_bill_to_customer_name', var.start_bill_to_customer_name);
728: ELSE
729: dbms_sql.bind_variable(c, 'end_bill_to_customer_name', var.end_bill_to_customer_name);

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

723: NULL;
724: ELSIF var.start_bill_to_customer_name IS NULL THEN
725: dbms_sql.bind_variable(c, 'end_bill_to_customer_name', var.end_bill_to_customer_name);
726: ELSIF var.end_bill_to_customer_name IS NULL THEN
727: dbms_sql.bind_variable(c, 'start_bill_to_customer_name', var.start_bill_to_customer_name);
728: ELSE
729: dbms_sql.bind_variable(c, 'end_bill_to_customer_name', var.end_bill_to_customer_name);
730: dbms_sql.bind_variable(c, 'start_bill_to_customer_name', var.start_bill_to_customer_name);
731:

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

725: dbms_sql.bind_variable(c, 'end_bill_to_customer_name', var.end_bill_to_customer_name);
726: ELSIF var.end_bill_to_customer_name IS NULL THEN
727: dbms_sql.bind_variable(c, 'start_bill_to_customer_name', var.start_bill_to_customer_name);
728: ELSE
729: dbms_sql.bind_variable(c, 'end_bill_to_customer_name', var.end_bill_to_customer_name);
730: dbms_sql.bind_variable(c, 'start_bill_to_customer_name', var.start_bill_to_customer_name);
731:
732: END IF;
733:

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

726: ELSIF var.end_bill_to_customer_name IS NULL THEN
727: dbms_sql.bind_variable(c, 'start_bill_to_customer_name', var.start_bill_to_customer_name);
728: ELSE
729: dbms_sql.bind_variable(c, 'end_bill_to_customer_name', var.end_bill_to_customer_name);
730: dbms_sql.bind_variable(c, 'start_bill_to_customer_name', var.start_bill_to_customer_name);
731:
732: END IF;
733:
734: --end for bug 1814839

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

733:
734: --end for bug 1814839
735:
736: IF var.start_transaction_date IS NOT NULL THEN
737: dbms_sql.bind_variable(c, 'start_transaction_date', var.start_transaction_date);
738: END IF;
739: IF var.end_transaction_date IS NOT NULL THEN
740: dbms_sql.bind_variable(c, 'end_transaction_date', var.end_transaction_date);
741: END IF;

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

736: IF var.start_transaction_date IS NOT NULL THEN
737: dbms_sql.bind_variable(c, 'start_transaction_date', var.start_transaction_date);
738: END IF;
739: IF var.end_transaction_date IS NOT NULL THEN
740: dbms_sql.bind_variable(c, 'end_transaction_date', var.end_transaction_date);
741: END IF;
742:
743: select MEANING into YES_NO_Y from ar_lookups
744: where lookup_type = 'YES/NO' and LOOKUP_CODE = 'Y';

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

743: select MEANING into YES_NO_Y from ar_lookups
744: where lookup_type = 'YES/NO' and LOOKUP_CODE = 'Y';
745: select MEANING into YES_NO_N from ar_lookups
746: where lookup_type = 'YES/NO' and LOOKUP_CODE = 'N';
747: dbms_sql.bind_variable(c, 'YES', YES_NO_Y);
748: dbms_sql.bind_variable(c, 'NO', YES_NO_N);
749:
750: -- Bug 1988421
751: IF var.start_transaction_type IS NOT NULL THEN

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

744: where lookup_type = 'YES/NO' and LOOKUP_CODE = 'Y';
745: select MEANING into YES_NO_N from ar_lookups
746: where lookup_type = 'YES/NO' and LOOKUP_CODE = 'N';
747: dbms_sql.bind_variable(c, 'YES', YES_NO_Y);
748: dbms_sql.bind_variable(c, 'NO', YES_NO_N);
749:
750: -- Bug 1988421
751: IF var.start_transaction_type IS NOT NULL THEN
752: dbms_sql.bind_variable(c, 'start_transaction_type', var.start_transaction_type);

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

748: dbms_sql.bind_variable(c, 'NO', YES_NO_N);
749:
750: -- Bug 1988421
751: IF var.start_transaction_type IS NOT NULL THEN
752: dbms_sql.bind_variable(c, 'start_transaction_type', var.start_transaction_type);
753: END IF;
754: IF var.end_transaction_type IS NOT NULL THEN
755: dbms_sql.bind_variable(c, 'end_transaction_type', var.end_transaction_type);
756: END IF;

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

751: IF var.start_transaction_type IS NOT NULL THEN
752: dbms_sql.bind_variable(c, 'start_transaction_type', var.start_transaction_type);
753: END IF;
754: IF var.end_transaction_type IS NOT NULL THEN
755: dbms_sql.bind_variable(c, 'end_transaction_type', var.end_transaction_type);
756: END IF;
757: IF var.start_transaction_class IS NOT NULL THEN
758: dbms_sql.bind_variable(c, 'start_transaction_class', var.start_transaction_class);
759: END IF;

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

754: IF var.end_transaction_type IS NOT NULL THEN
755: dbms_sql.bind_variable(c, 'end_transaction_type', var.end_transaction_type);
756: END IF;
757: IF var.start_transaction_class IS NOT NULL THEN
758: dbms_sql.bind_variable(c, 'start_transaction_class', var.start_transaction_class);
759: END IF;
760: IF var.end_transaction_class IS NOT NULL THEN
761: dbms_sql.bind_variable(c, 'end_transaction_class', var.end_transaction_class);
762: END IF;

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

757: IF var.start_transaction_class IS NOT NULL THEN
758: dbms_sql.bind_variable(c, 'start_transaction_class', var.start_transaction_class);
759: END IF;
760: IF var.end_transaction_class IS NOT NULL THEN
761: dbms_sql.bind_variable(c, 'end_transaction_class', var.end_transaction_class);
762: END IF;
763: IF var.start_bill_to_customer_number IS NOT NULL THEN
764: dbms_sql.bind_variable(c, 'start_bill_to_customer_number', var.start_bill_to_customer_number);
765: END IF;

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

760: IF var.end_transaction_class IS NOT NULL THEN
761: dbms_sql.bind_variable(c, 'end_transaction_class', var.end_transaction_class);
762: END IF;
763: IF var.start_bill_to_customer_number IS NOT NULL THEN
764: dbms_sql.bind_variable(c, 'start_bill_to_customer_number', var.start_bill_to_customer_number);
765: END IF;
766: IF var.end_bill_to_customer_number IS NOT NULL THEN
767: dbms_sql.bind_variable(c, 'end_bill_to_customer_number', var.end_bill_to_customer_number);
768: END IF;

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

763: IF var.start_bill_to_customer_number IS NOT NULL THEN
764: dbms_sql.bind_variable(c, 'start_bill_to_customer_number', var.start_bill_to_customer_number);
765: END IF;
766: IF var.end_bill_to_customer_number IS NOT NULL THEN
767: dbms_sql.bind_variable(c, 'end_bill_to_customer_number', var.end_bill_to_customer_number);
768: END IF;
769: IF var.start_currency IS NOT NULL THEN
770: dbms_sql.bind_variable(c, 'start_currency', var.start_currency);
771: END IF;

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

766: IF var.end_bill_to_customer_number IS NOT NULL THEN
767: dbms_sql.bind_variable(c, 'end_bill_to_customer_number', var.end_bill_to_customer_number);
768: END IF;
769: IF var.start_currency IS NOT NULL THEN
770: dbms_sql.bind_variable(c, 'start_currency', var.start_currency);
771: END IF;
772: IF var.end_currency IS NOT NULL THEN
773: dbms_sql.bind_variable(c, 'end_currency', var.end_currency);
774: END IF;

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

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

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

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

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

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

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

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

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

781: IF var.doc_sequence_number_from IS NOT NULL THEN
782: dbms_sql.bind_variable(c, 'doc_sequence_number_from', var.doc_sequence_number_from);
783: END IF;
784: IF var.doc_sequence_number_to IS NOT NULL THEN
785: dbms_sql.bind_variable(c, 'doc_sequence_number_to', var.doc_sequence_number_to);
786: END IF;
787:
788: -- bug3940958 added for new binds
789: -- p_reporting_entity_id is used only for operating unit level

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

787:
788: -- bug3940958 added for new binds
789: -- p_reporting_entity_id is used only for operating unit level
790: IF var.reporting_level = '3000' THEN
791: dbms_sql.bind_variable(c, 'p_reporting_entity_id', var.reporting_entity_id);
792: END IF;
793:
794: IF var.batch_source_name IS NOT NULL THEN
795: dbms_sql.bind_variable(c, 'batch_source_name', var.batch_source_name);

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

791: dbms_sql.bind_variable(c, 'p_reporting_entity_id', var.reporting_entity_id);
792: END IF;
793:
794: IF var.batch_source_name IS NOT NULL THEN
795: dbms_sql.bind_variable(c, 'batch_source_name', var.batch_source_name);
796: END IF;
797:
798: IF var.transaction_class IS NOT NULL THEN
799: dbms_sql.bind_variable(c, 'transaction_class', var.transaction_class);

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

795: dbms_sql.bind_variable(c, 'batch_source_name', var.batch_source_name);
796: END IF;
797:
798: IF var.transaction_class IS NOT NULL THEN
799: dbms_sql.bind_variable(c, 'transaction_class', var.transaction_class);
800: END IF;
801: end bind;
802:
803:

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

1106: fa_rx_util_pkg.debug('AR_GET_BIND');
1107: --
1108: -- These bind variables(Date Type) were included in the WHERE clause
1109: --
1110: dbms_sql.bind_variable(c, 'start_update_date', var.start_update_date);
1111: dbms_sql.bind_variable(c, 'end_update_date', var.end_update_date);
1112:
1113: end check_bind;
1114:

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

1107: --
1108: -- These bind variables(Date Type) were included in the WHERE clause
1109: --
1110: dbms_sql.bind_variable(c, 'start_update_date', var.start_update_date);
1111: dbms_sql.bind_variable(c, 'end_update_date', var.end_update_date);
1112:
1113: end check_bind;
1114:
1115:

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

1343: --
1344: -- These bind variables(Date Type) were included in the WHERE clause
1345: --
1346: IF var.start_due_date IS NOT NULL THEN
1347: dbms_sql.bind_variable(c, 'start_due_date', var.start_due_date);
1348: END IF;
1349: IF var.end_due_date IS NOT NULL THEN
1350: dbms_sql.bind_variable(c, 'end_due_date', var.end_due_date);
1351: END IF;

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

1346: IF var.start_due_date IS NOT NULL THEN
1347: dbms_sql.bind_variable(c, 'start_due_date', var.start_due_date);
1348: END IF;
1349: IF var.end_due_date IS NOT NULL THEN
1350: dbms_sql.bind_variable(c, 'end_due_date', var.end_due_date);
1351: END IF;
1352:
1353: end forecast_bind;
1354:

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

1798: --
1799: -- These bind variables(Date Type) were included in the WHERE clause
1800: --
1801: IF var.start_invoice_num IS NOT NULL THEN
1802: dbms_sql.bind_variable(c, 'start_invoice_num', var.start_invoice_num);
1803: END IF;
1804: IF var.end_invoice_num IS NOT NULL THEN
1805: dbms_sql.bind_variable(c, 'end_invoice_num', var.end_invoice_num);
1806: END IF;

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

1801: IF var.start_invoice_num IS NOT NULL THEN
1802: dbms_sql.bind_variable(c, 'start_invoice_num', var.start_invoice_num);
1803: END IF;
1804: IF var.end_invoice_num IS NOT NULL THEN
1805: dbms_sql.bind_variable(c, 'end_invoice_num', var.end_invoice_num);
1806: END IF;
1807: IF var.start_amount IS NOT NULL THEN
1808: dbms_sql.bind_variable(c, 'start_amount', var.start_amount);
1809: END IF;

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

1804: IF var.end_invoice_num IS NOT NULL THEN
1805: dbms_sql.bind_variable(c, 'end_invoice_num', var.end_invoice_num);
1806: END IF;
1807: IF var.start_amount IS NOT NULL THEN
1808: dbms_sql.bind_variable(c, 'start_amount', var.start_amount);
1809: END IF;
1810: IF var.end_amount IS NOT NULL THEN
1811: dbms_sql.bind_variable(c, 'end_amount', var.end_amount);
1812: END IF;

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

1807: IF var.start_amount IS NOT NULL THEN
1808: dbms_sql.bind_variable(c, 'start_amount', var.start_amount);
1809: END IF;
1810: IF var.end_amount IS NOT NULL THEN
1811: dbms_sql.bind_variable(c, 'end_amount', var.end_amount);
1812: END IF;
1813:
1814: end sales_bind;
1815: