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

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

730:
731: -- Bug 4214787 : only bind p_reporting_entity_id when reporting level is Operating Unit
732: IF var.p_reporting_level = 3000 then
733: IF var.p_reporting_entity_id IS NOT NULL THEN
734: dbms_sql.bind_variable(c, 'p_reporting_entity_id', var.p_reporting_entity_id);
735: END IF;
736: END IF;
737:
738: IF var.p_currency_code_low IS NOT NULL THEN

Line 739: dbms_sql.bind_variable(c, 'p_currency_code_low', var.p_currency_code_low);

735: END IF;
736: END IF;
737:
738: IF var.p_currency_code_low IS NOT NULL THEN
739: dbms_sql.bind_variable(c, 'p_currency_code_low', var.p_currency_code_low);
740: END IF;
741:
742: IF var.p_currency_code_high IS NOT NULL THEN
743: dbms_sql.bind_variable(c, 'p_currency_code_high', var.p_currency_code_high);

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

739: dbms_sql.bind_variable(c, 'p_currency_code_low', var.p_currency_code_low);
740: END IF;
741:
742: IF var.p_currency_code_high IS NOT NULL THEN
743: dbms_sql.bind_variable(c, 'p_currency_code_high', var.p_currency_code_high);
744: END IF;
745:
746: IF var.p_invoice_type_low IS NOT NULL THEN
747: dbms_sql.bind_variable(c, 'p_invoice_type_low', var.p_invoice_type_low);

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

743: dbms_sql.bind_variable(c, 'p_currency_code_high', var.p_currency_code_high);
744: END IF;
745:
746: IF var.p_invoice_type_low IS NOT NULL THEN
747: dbms_sql.bind_variable(c, 'p_invoice_type_low', var.p_invoice_type_low);
748: END IF;
749:
750: IF var.p_invoice_type_high IS NOT NULL THEN
751: dbms_sql.bind_variable(c, 'p_invoice_type_high', var.p_invoice_type_high);

Line 751: dbms_sql.bind_variable(c, 'p_invoice_type_high', var.p_invoice_type_high);

747: dbms_sql.bind_variable(c, 'p_invoice_type_low', var.p_invoice_type_low);
748: END IF;
749:
750: IF var.p_invoice_type_high IS NOT NULL THEN
751: dbms_sql.bind_variable(c, 'p_invoice_type_high', var.p_invoice_type_high);
752: END IF;
753:
754:
755: IF var.p_trx_date_low IS NOT NULL THEN

Line 756: dbms_sql.bind_variable(c, 'p_trx_date_low', var.p_trx_date_low);

752: END IF;
753:
754:
755: IF var.p_trx_date_low IS NOT NULL THEN
756: dbms_sql.bind_variable(c, 'p_trx_date_low', var.p_trx_date_low);
757: END IF;
758:
759: IF var.p_trx_date_high IS NOT NULL THEN
760: dbms_sql.bind_variable(c, 'p_trx_date_high', var.p_trx_date_high);

Line 760: dbms_sql.bind_variable(c, 'p_trx_date_high', var.p_trx_date_high);

756: dbms_sql.bind_variable(c, 'p_trx_date_low', var.p_trx_date_low);
757: END IF;
758:
759: IF var.p_trx_date_high IS NOT NULL THEN
760: dbms_sql.bind_variable(c, 'p_trx_date_high', var.p_trx_date_high);
761: END IF;
762:
763:
764: IF var.p_due_date_low IS NOT NULL THEN

Line 765: dbms_sql.bind_variable(c, 'p_due_date_low', var.p_due_date_low);

761: END IF;
762:
763:
764: IF var.p_due_date_low IS NOT NULL THEN
765: dbms_sql.bind_variable(c, 'p_due_date_low', var.p_due_date_low);
766: END IF;
767:
768: IF var.p_due_date_high IS NOT NULL THEN
769: dbms_sql.bind_variable(c, 'p_due_date_high', var.p_due_date_high);

Line 769: dbms_sql.bind_variable(c, 'p_due_date_high', var.p_due_date_high);

765: dbms_sql.bind_variable(c, 'p_due_date_low', var.p_due_date_low);
766: END IF;
767:
768: IF var.p_due_date_high IS NOT NULL THEN
769: dbms_sql.bind_variable(c, 'p_due_date_high', var.p_due_date_high);
770: END IF;
771:
772:
773:

Line 775: dbms_sql.bind_variable(c, 'p_adj_type_low', var.p_adj_type_low);

771:
772:
773:
774: IF var.p_adj_type_low IS NOT NULL THEN
775: dbms_sql.bind_variable(c, 'p_adj_type_low', var.p_adj_type_low);
776: END IF;
777:
778: IF var.p_adj_type_high IS NOT NULL THEN
779: dbms_sql.bind_variable(c, 'p_adj_type_high', var.p_adj_type_high);

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

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

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

779: dbms_sql.bind_variable(c, 'p_adj_type_high', var.p_adj_type_high);
780: END IF;
781:
782: IF var.p_gl_date_low IS NOT NULL THEN
783: dbms_sql.bind_variable(c, 'p_gl_date_low', var.p_gl_date_low);
784: END IF;
785:
786: IF var.p_gl_date_high IS NOT NULL THEN
787: dbms_sql.bind_variable(c, 'p_gl_date_high', var.p_gl_date_high);

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

783: dbms_sql.bind_variable(c, 'p_gl_date_low', var.p_gl_date_low);
784: END IF;
785:
786: IF var.p_gl_date_high IS NOT NULL THEN
787: dbms_sql.bind_variable(c, 'p_gl_date_high', var.p_gl_date_high);
788: END IF;
789:
790: IF var.p_doc_seq_name IS NOT NULL THEN
791: dbms_sql.bind_variable(c, 'p_doc_seq_name',var.p_doc_seq_name);

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

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

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

791: dbms_sql.bind_variable(c, 'p_doc_seq_name',var.p_doc_seq_name);
792: END IF;
793:
794: IF var.p_doc_seq_low IS NOT NULL THEN
795: dbms_sql.bind_variable(c, 'p_doc_seq_low',var.p_doc_seq_low);
796: END IF;
797:
798: IF var.p_doc_seq_high IS NOT NULL THEN
799: dbms_sql.bind_variable(c, 'p_doc_seq_high',var.p_doc_seq_high);

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

795: dbms_sql.bind_variable(c, 'p_doc_seq_low',var.p_doc_seq_low);
796: END IF;
797:
798: IF var.p_doc_seq_high IS NOT NULL THEN
799: dbms_sql.bind_variable(c, 'p_doc_seq_high',var.p_doc_seq_high);
800: END IF;
801:
802: select meaning into l_Yes from AR_LOOKUPS
803: where lookup_type = 'YES/NO' and lookup_code = 'Y';

Line 808: dbms_sql.bind_variable(c, 'c_Yes', l_Yes);

804:
805: select meaning into l_No from AR_LOOKUPS
806: where lookup_type = 'YES/NO' and lookup_code = 'N';
807:
808: dbms_sql.bind_variable(c, 'c_Yes', l_Yes);
809: dbms_sql.bind_variable(c, 'c_No', l_No);
810: /* Start FP Bug 5724794 */
811: if accounting_method = 'CASH' OR CO_SEG_WHERE IS NOT NULL then
812: -- if accounting_method <> 'ACCRUAL' then /* End FP Bug 5724794 SPDIXIT */

Line 809: dbms_sql.bind_variable(c, 'c_No', l_No);

805: select meaning into l_No from AR_LOOKUPS
806: where lookup_type = 'YES/NO' and lookup_code = 'N';
807:
808: dbms_sql.bind_variable(c, 'c_Yes', l_Yes);
809: dbms_sql.bind_variable(c, 'c_No', l_No);
810: /* Start FP Bug 5724794 */
811: if accounting_method = 'CASH' OR CO_SEG_WHERE IS NOT NULL then
812: -- if accounting_method <> 'ACCRUAL' then /* End FP Bug 5724794 SPDIXIT */
813: dbms_sql.bind_variable(c,'p_coa_id',var.chart_of_accounts_id);

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

809: dbms_sql.bind_variable(c, 'c_No', l_No);
810: /* Start FP Bug 5724794 */
811: if accounting_method = 'CASH' OR CO_SEG_WHERE IS NOT NULL then
812: -- if accounting_method <> 'ACCRUAL' then /* End FP Bug 5724794 SPDIXIT */
813: dbms_sql.bind_variable(c,'p_coa_id',var.chart_of_accounts_id);
814: end if;
815:
816: dbms_sql.bind_variable(c,'set_of_books_id',var.books_id);
817:

Line 816: dbms_sql.bind_variable(c,'set_of_books_id',var.books_id);

812: -- if accounting_method <> 'ACCRUAL' then /* End FP Bug 5724794 SPDIXIT */
813: dbms_sql.bind_variable(c,'p_coa_id',var.chart_of_accounts_id);
814: end if;
815:
816: dbms_sql.bind_variable(c,'set_of_books_id',var.books_id);
817:
818: end aradj_bind;
819:
820: --