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

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

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

731: END IF;
732: END IF;
733:
734: IF var.p_currency_code_low IS NOT NULL THEN
735: dbms_sql.bind_variable(c, 'p_currency_code_low', var.p_currency_code_low);
736: END IF;
737:
738: IF var.p_currency_code_high IS NOT NULL THEN
739: dbms_sql.bind_variable(c, 'p_currency_code_high', var.p_currency_code_high);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

767:
768:
769:
770: IF var.p_adj_type_low IS NOT NULL THEN
771: dbms_sql.bind_variable(c, 'p_adj_type_low', var.p_adj_type_low);
772: END IF;
773:
774: IF var.p_adj_type_high IS NOT NULL THEN
775: dbms_sql.bind_variable(c, 'p_adj_type_high', var.p_adj_type_high);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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