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.FARX_DP dependencies on DBMS_SQL

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

723:
724: IF (g_print_debug) THEN
725: fa_rx_util_pkg.debug('farx_dp.bind()+');
726: END IF;
727: dbms_sql.bind_variable(c, 'b_book', var.book);
728: dbms_sql.bind_variable(c, 'b_fy_name', var.fy_name);
729: dbms_sql.bind_variable(c, 'b_report_style', var.report_style);
730: -- MRC
731: if param.mrcsobtype = 'R' then

Line 728: dbms_sql.bind_variable(c, 'b_fy_name', var.fy_name);

724: IF (g_print_debug) THEN
725: fa_rx_util_pkg.debug('farx_dp.bind()+');
726: END IF;
727: dbms_sql.bind_variable(c, 'b_book', var.book);
728: dbms_sql.bind_variable(c, 'b_fy_name', var.fy_name);
729: dbms_sql.bind_variable(c, 'b_report_style', var.report_style);
730: -- MRC
731: if param.mrcsobtype = 'R' then
732: dbms_sql.bind_variable(c, 'b_set_of_books_id', var.set_of_books_id);

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

725: fa_rx_util_pkg.debug('farx_dp.bind()+');
726: END IF;
727: dbms_sql.bind_variable(c, 'b_book', var.book);
728: dbms_sql.bind_variable(c, 'b_fy_name', var.fy_name);
729: dbms_sql.bind_variable(c, 'b_report_style', var.report_style);
730: -- MRC
731: if param.mrcsobtype = 'R' then
732: dbms_sql.bind_variable(c, 'b_set_of_books_id', var.set_of_books_id);
733: end if;

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

728: dbms_sql.bind_variable(c, 'b_fy_name', var.fy_name);
729: dbms_sql.bind_variable(c, 'b_report_style', var.report_style);
730: -- MRC
731: if param.mrcsobtype = 'R' then
732: dbms_sql.bind_variable(c, 'b_set_of_books_id', var.set_of_books_id);
733: end if;
734: -- End MRC
735: if (param.from_bal is not null and param.to_bal is not null) then
736: dbms_sql.bind_variable(c, 'from_bal', param.from_bal);

Line 736: dbms_sql.bind_variable(c, 'from_bal', param.from_bal);

732: dbms_sql.bind_variable(c, 'b_set_of_books_id', var.set_of_books_id);
733: end if;
734: -- End MRC
735: if (param.from_bal is not null and param.to_bal is not null) then
736: dbms_sql.bind_variable(c, 'from_bal', param.from_bal);
737: dbms_sql.bind_variable(c, 'to_bal', param.to_bal);
738: end if;
739: if param.from_acct is not null and param.to_acct is not null then
740: dbms_sql.bind_variable(c, 'from_acct', param.from_acct);

Line 737: dbms_sql.bind_variable(c, 'to_bal', param.to_bal);

733: end if;
734: -- End MRC
735: if (param.from_bal is not null and param.to_bal is not null) then
736: dbms_sql.bind_variable(c, 'from_bal', param.from_bal);
737: dbms_sql.bind_variable(c, 'to_bal', param.to_bal);
738: end if;
739: if param.from_acct is not null and param.to_acct is not null then
740: dbms_sql.bind_variable(c, 'from_acct', param.from_acct);
741: dbms_sql.bind_variable(c, 'to_acct', param.to_acct);

Line 740: dbms_sql.bind_variable(c, 'from_acct', param.from_acct);

736: dbms_sql.bind_variable(c, 'from_bal', param.from_bal);
737: dbms_sql.bind_variable(c, 'to_bal', param.to_bal);
738: end if;
739: if param.from_acct is not null and param.to_acct is not null then
740: dbms_sql.bind_variable(c, 'from_acct', param.from_acct);
741: dbms_sql.bind_variable(c, 'to_acct', param.to_acct);
742: end if;
743: if param.from_cc is not null and param.to_cc is not null then
744: dbms_sql.bind_variable(c, 'from_cc', param.from_cc);

Line 741: dbms_sql.bind_variable(c, 'to_acct', param.to_acct);

737: dbms_sql.bind_variable(c, 'to_bal', param.to_bal);
738: end if;
739: if param.from_acct is not null and param.to_acct is not null then
740: dbms_sql.bind_variable(c, 'from_acct', param.from_acct);
741: dbms_sql.bind_variable(c, 'to_acct', param.to_acct);
742: end if;
743: if param.from_cc is not null and param.to_cc is not null then
744: dbms_sql.bind_variable(c, 'from_cc', param.from_cc);
745: dbms_sql.bind_variable(c, 'to_cc', param.to_cc);

Line 744: dbms_sql.bind_variable(c, 'from_cc', param.from_cc);

740: dbms_sql.bind_variable(c, 'from_acct', param.from_acct);
741: dbms_sql.bind_variable(c, 'to_acct', param.to_acct);
742: end if;
743: if param.from_cc is not null and param.to_cc is not null then
744: dbms_sql.bind_variable(c, 'from_cc', param.from_cc);
745: dbms_sql.bind_variable(c, 'to_cc', param.to_cc);
746: end if;
747: if param.from_maj_cat is not null and param.to_maj_cat is not null then
748: dbms_sql.bind_variable(c, 'from_maj_cat', param.from_maj_cat);

Line 745: dbms_sql.bind_variable(c, 'to_cc', param.to_cc);

741: dbms_sql.bind_variable(c, 'to_acct', param.to_acct);
742: end if;
743: if param.from_cc is not null and param.to_cc is not null then
744: dbms_sql.bind_variable(c, 'from_cc', param.from_cc);
745: dbms_sql.bind_variable(c, 'to_cc', param.to_cc);
746: end if;
747: if param.from_maj_cat is not null and param.to_maj_cat is not null then
748: dbms_sql.bind_variable(c, 'from_maj_cat', param.from_maj_cat);
749: dbms_sql.bind_variable(c, 'to_maj_cat', param.to_maj_cat);

Line 748: dbms_sql.bind_variable(c, 'from_maj_cat', param.from_maj_cat);

744: dbms_sql.bind_variable(c, 'from_cc', param.from_cc);
745: dbms_sql.bind_variable(c, 'to_cc', param.to_cc);
746: end if;
747: if param.from_maj_cat is not null and param.to_maj_cat is not null then
748: dbms_sql.bind_variable(c, 'from_maj_cat', param.from_maj_cat);
749: dbms_sql.bind_variable(c, 'to_maj_cat', param.to_maj_cat);
750: end if;
751: if param.from_min_cat is not null then
752: dbms_sql.bind_variable(c, 'from_min_cat', param.from_min_cat);

Line 749: dbms_sql.bind_variable(c, 'to_maj_cat', param.to_maj_cat);

745: dbms_sql.bind_variable(c, 'to_cc', param.to_cc);
746: end if;
747: if param.from_maj_cat is not null and param.to_maj_cat is not null then
748: dbms_sql.bind_variable(c, 'from_maj_cat', param.from_maj_cat);
749: dbms_sql.bind_variable(c, 'to_maj_cat', param.to_maj_cat);
750: end if;
751: if param.from_min_cat is not null then
752: dbms_sql.bind_variable(c, 'from_min_cat', param.from_min_cat);
753: end if;

Line 752: dbms_sql.bind_variable(c, 'from_min_cat', param.from_min_cat);

748: dbms_sql.bind_variable(c, 'from_maj_cat', param.from_maj_cat);
749: dbms_sql.bind_variable(c, 'to_maj_cat', param.to_maj_cat);
750: end if;
751: if param.from_min_cat is not null then
752: dbms_sql.bind_variable(c, 'from_min_cat', param.from_min_cat);
753: end if;
754: if param.to_min_cat is not null then
755: dbms_sql.bind_variable(c, 'to_min_cat', param.to_min_cat);
756: end if;

Line 755: dbms_sql.bind_variable(c, 'to_min_cat', param.to_min_cat);

751: if param.from_min_cat is not null then
752: dbms_sql.bind_variable(c, 'from_min_cat', param.from_min_cat);
753: end if;
754: if param.to_min_cat is not null then
755: dbms_sql.bind_variable(c, 'to_min_cat', param.to_min_cat);
756: end if;
757: if param.prop_type is not null then
758: dbms_sql.bind_variable(c, 'prop_type', param.prop_type);
759: end if;

Line 758: dbms_sql.bind_variable(c, 'prop_type', param.prop_type);

754: if param.to_min_cat is not null then
755: dbms_sql.bind_variable(c, 'to_min_cat', param.to_min_cat);
756: end if;
757: if param.prop_type is not null then
758: dbms_sql.bind_variable(c, 'prop_type', param.prop_type);
759: end if;
760: if param.from_asset_num is not null and param.to_asset_num is not null then
761: dbms_sql.bind_variable(c, 'from_asset_num', param.from_asset_num);
762: dbms_sql.bind_variable(c, 'to_asset_num', param.to_asset_num);

Line 761: dbms_sql.bind_variable(c, 'from_asset_num', param.from_asset_num);

757: if param.prop_type is not null then
758: dbms_sql.bind_variable(c, 'prop_type', param.prop_type);
759: end if;
760: if param.from_asset_num is not null and param.to_asset_num is not null then
761: dbms_sql.bind_variable(c, 'from_asset_num', param.from_asset_num);
762: dbms_sql.bind_variable(c, 'to_asset_num', param.to_asset_num);
763: elsif param.from_asset_num is not null and param.to_asset_num is null then
764: dbms_sql.bind_variable(c, 'from_asset_num', param.from_asset_num);
765: end if;

Line 762: dbms_sql.bind_variable(c, 'to_asset_num', param.to_asset_num);

758: dbms_sql.bind_variable(c, 'prop_type', param.prop_type);
759: end if;
760: if param.from_asset_num is not null and param.to_asset_num is not null then
761: dbms_sql.bind_variable(c, 'from_asset_num', param.from_asset_num);
762: dbms_sql.bind_variable(c, 'to_asset_num', param.to_asset_num);
763: elsif param.from_asset_num is not null and param.to_asset_num is null then
764: dbms_sql.bind_variable(c, 'from_asset_num', param.from_asset_num);
765: end if;
766:

Line 764: dbms_sql.bind_variable(c, 'from_asset_num', param.from_asset_num);

760: if param.from_asset_num is not null and param.to_asset_num is not null then
761: dbms_sql.bind_variable(c, 'from_asset_num', param.from_asset_num);
762: dbms_sql.bind_variable(c, 'to_asset_num', param.to_asset_num);
763: elsif param.from_asset_num is not null and param.to_asset_num is null then
764: dbms_sql.bind_variable(c, 'from_asset_num', param.from_asset_num);
765: end if;
766:
767: dbms_sql.bind_variable(c, 'b_period_close_date', var.calendar_period_close_date); -- Added for Bug#3499862.
768:

Line 767: dbms_sql.bind_variable(c, 'b_period_close_date', var.calendar_period_close_date); -- Added for Bug#3499862.

763: elsif param.from_asset_num is not null and param.to_asset_num is null then
764: dbms_sql.bind_variable(c, 'from_asset_num', param.from_asset_num);
765: end if;
766:
767: dbms_sql.bind_variable(c, 'b_period_close_date', var.calendar_period_close_date); -- Added for Bug#3499862.
768:
769: IF (param.cat_seg_num IS NOT NULL) THEN
770: dbms_sql.bind_variable(c, 'from_cat_seg_val', param.from_cat_seg_val);
771: dbms_sql.bind_variable(c, 'to_cat_seg_val', param.to_cat_seg_val);

Line 770: dbms_sql.bind_variable(c, 'from_cat_seg_val', param.from_cat_seg_val);

766:
767: dbms_sql.bind_variable(c, 'b_period_close_date', var.calendar_period_close_date); -- Added for Bug#3499862.
768:
769: IF (param.cat_seg_num IS NOT NULL) THEN
770: dbms_sql.bind_variable(c, 'from_cat_seg_val', param.from_cat_seg_val);
771: dbms_sql.bind_variable(c, 'to_cat_seg_val', param.to_cat_seg_val);
772: END IF;
773: IF (g_print_debug) THEN
774: fa_rx_util_pkg.debug('farx_dp.bind()-');

Line 771: dbms_sql.bind_variable(c, 'to_cat_seg_val', param.to_cat_seg_val);

767: dbms_sql.bind_variable(c, 'b_period_close_date', var.calendar_period_close_date); -- Added for Bug#3499862.
768:
769: IF (param.cat_seg_num IS NOT NULL) THEN
770: dbms_sql.bind_variable(c, 'from_cat_seg_val', param.from_cat_seg_val);
771: dbms_sql.bind_variable(c, 'to_cat_seg_val', param.to_cat_seg_val);
772: END IF;
773: IF (g_print_debug) THEN
774: fa_rx_util_pkg.debug('farx_dp.bind()-');
775: END IF;