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 611: dbms_sql.bind_variable(c, 'b_book', var.book);

607:
608: IF (g_print_debug) THEN
609: fa_rx_util_pkg.debug('farx_dp.bind()+');
610: END IF;
611: dbms_sql.bind_variable(c, 'b_book', var.book);
612: dbms_sql.bind_variable(c, 'b_fy_name', var.fy_name);
613: dbms_sql.bind_variable(c, 'b_report_style', var.report_style);
614: if (param.from_bal is not null and param.to_bal is not null) then
615: dbms_sql.bind_variable(c, 'from_bal', param.from_bal);

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

608: IF (g_print_debug) THEN
609: fa_rx_util_pkg.debug('farx_dp.bind()+');
610: END IF;
611: dbms_sql.bind_variable(c, 'b_book', var.book);
612: dbms_sql.bind_variable(c, 'b_fy_name', var.fy_name);
613: dbms_sql.bind_variable(c, 'b_report_style', var.report_style);
614: if (param.from_bal is not null and param.to_bal is not null) then
615: dbms_sql.bind_variable(c, 'from_bal', param.from_bal);
616: dbms_sql.bind_variable(c, 'to_bal', param.to_bal);

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

609: fa_rx_util_pkg.debug('farx_dp.bind()+');
610: END IF;
611: dbms_sql.bind_variable(c, 'b_book', var.book);
612: dbms_sql.bind_variable(c, 'b_fy_name', var.fy_name);
613: dbms_sql.bind_variable(c, 'b_report_style', var.report_style);
614: if (param.from_bal is not null and param.to_bal is not null) then
615: dbms_sql.bind_variable(c, 'from_bal', param.from_bal);
616: dbms_sql.bind_variable(c, 'to_bal', param.to_bal);
617: end if;

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

611: dbms_sql.bind_variable(c, 'b_book', var.book);
612: dbms_sql.bind_variable(c, 'b_fy_name', var.fy_name);
613: dbms_sql.bind_variable(c, 'b_report_style', var.report_style);
614: if (param.from_bal is not null and param.to_bal is not null) then
615: dbms_sql.bind_variable(c, 'from_bal', param.from_bal);
616: dbms_sql.bind_variable(c, 'to_bal', param.to_bal);
617: end if;
618: if param.from_acct is not null and param.to_acct is not null then
619: dbms_sql.bind_variable(c, 'from_acct', param.from_acct);

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

612: dbms_sql.bind_variable(c, 'b_fy_name', var.fy_name);
613: dbms_sql.bind_variable(c, 'b_report_style', var.report_style);
614: if (param.from_bal is not null and param.to_bal is not null) then
615: dbms_sql.bind_variable(c, 'from_bal', param.from_bal);
616: dbms_sql.bind_variable(c, 'to_bal', param.to_bal);
617: end if;
618: if param.from_acct is not null and param.to_acct is not null then
619: dbms_sql.bind_variable(c, 'from_acct', param.from_acct);
620: dbms_sql.bind_variable(c, 'to_acct', param.to_acct);

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

615: dbms_sql.bind_variable(c, 'from_bal', param.from_bal);
616: dbms_sql.bind_variable(c, 'to_bal', param.to_bal);
617: end if;
618: if param.from_acct is not null and param.to_acct is not null then
619: dbms_sql.bind_variable(c, 'from_acct', param.from_acct);
620: dbms_sql.bind_variable(c, 'to_acct', param.to_acct);
621: end if;
622: if param.from_cc is not null and param.to_cc is not null then
623: dbms_sql.bind_variable(c, 'from_cc', param.from_cc);

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

616: dbms_sql.bind_variable(c, 'to_bal', param.to_bal);
617: end if;
618: if param.from_acct is not null and param.to_acct is not null then
619: dbms_sql.bind_variable(c, 'from_acct', param.from_acct);
620: dbms_sql.bind_variable(c, 'to_acct', param.to_acct);
621: end if;
622: if param.from_cc is not null and param.to_cc is not null then
623: dbms_sql.bind_variable(c, 'from_cc', param.from_cc);
624: dbms_sql.bind_variable(c, 'to_cc', param.to_cc);

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

619: dbms_sql.bind_variable(c, 'from_acct', param.from_acct);
620: dbms_sql.bind_variable(c, 'to_acct', param.to_acct);
621: end if;
622: if param.from_cc is not null and param.to_cc is not null then
623: dbms_sql.bind_variable(c, 'from_cc', param.from_cc);
624: dbms_sql.bind_variable(c, 'to_cc', param.to_cc);
625: end if;
626: if param.from_maj_cat is not null and param.to_maj_cat is not null then
627: dbms_sql.bind_variable(c, 'from_maj_cat', param.from_maj_cat);

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

620: dbms_sql.bind_variable(c, 'to_acct', param.to_acct);
621: end if;
622: if param.from_cc is not null and param.to_cc is not null then
623: dbms_sql.bind_variable(c, 'from_cc', param.from_cc);
624: dbms_sql.bind_variable(c, 'to_cc', param.to_cc);
625: end if;
626: if param.from_maj_cat is not null and param.to_maj_cat is not null then
627: dbms_sql.bind_variable(c, 'from_maj_cat', param.from_maj_cat);
628: dbms_sql.bind_variable(c, 'to_maj_cat', param.to_maj_cat);

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

623: dbms_sql.bind_variable(c, 'from_cc', param.from_cc);
624: dbms_sql.bind_variable(c, 'to_cc', param.to_cc);
625: end if;
626: if param.from_maj_cat is not null and param.to_maj_cat is not null then
627: dbms_sql.bind_variable(c, 'from_maj_cat', param.from_maj_cat);
628: dbms_sql.bind_variable(c, 'to_maj_cat', param.to_maj_cat);
629: end if;
630: if param.from_min_cat is not null then
631: dbms_sql.bind_variable(c, 'from_min_cat', param.from_min_cat);

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

624: dbms_sql.bind_variable(c, 'to_cc', param.to_cc);
625: end if;
626: if param.from_maj_cat is not null and param.to_maj_cat is not null then
627: dbms_sql.bind_variable(c, 'from_maj_cat', param.from_maj_cat);
628: dbms_sql.bind_variable(c, 'to_maj_cat', param.to_maj_cat);
629: end if;
630: if param.from_min_cat is not null then
631: dbms_sql.bind_variable(c, 'from_min_cat', param.from_min_cat);
632: end if;

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

627: dbms_sql.bind_variable(c, 'from_maj_cat', param.from_maj_cat);
628: dbms_sql.bind_variable(c, 'to_maj_cat', param.to_maj_cat);
629: end if;
630: if param.from_min_cat is not null then
631: dbms_sql.bind_variable(c, 'from_min_cat', param.from_min_cat);
632: end if;
633: if param.to_min_cat is not null then
634: dbms_sql.bind_variable(c, 'to_min_cat', param.to_min_cat);
635: end if;

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

630: if param.from_min_cat is not null then
631: dbms_sql.bind_variable(c, 'from_min_cat', param.from_min_cat);
632: end if;
633: if param.to_min_cat is not null then
634: dbms_sql.bind_variable(c, 'to_min_cat', param.to_min_cat);
635: end if;
636: if param.prop_type is not null then
637: dbms_sql.bind_variable(c, 'prop_type', param.prop_type);
638: end if;

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

633: if param.to_min_cat is not null then
634: dbms_sql.bind_variable(c, 'to_min_cat', param.to_min_cat);
635: end if;
636: if param.prop_type is not null then
637: dbms_sql.bind_variable(c, 'prop_type', param.prop_type);
638: end if;
639: if param.from_asset_num is not null and param.to_asset_num is not null then
640: dbms_sql.bind_variable(c, 'from_asset_num', param.from_asset_num);
641: dbms_sql.bind_variable(c, 'to_asset_num', param.to_asset_num);

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

636: if param.prop_type is not null then
637: dbms_sql.bind_variable(c, 'prop_type', param.prop_type);
638: end if;
639: if param.from_asset_num is not null and param.to_asset_num is not null then
640: dbms_sql.bind_variable(c, 'from_asset_num', param.from_asset_num);
641: dbms_sql.bind_variable(c, 'to_asset_num', param.to_asset_num);
642: elsif param.from_asset_num is not null and param.to_asset_num is null then
643: dbms_sql.bind_variable(c, 'from_asset_num', param.from_asset_num);
644: end if;

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

637: dbms_sql.bind_variable(c, 'prop_type', param.prop_type);
638: end if;
639: if param.from_asset_num is not null and param.to_asset_num is not null then
640: dbms_sql.bind_variable(c, 'from_asset_num', param.from_asset_num);
641: dbms_sql.bind_variable(c, 'to_asset_num', param.to_asset_num);
642: elsif param.from_asset_num is not null and param.to_asset_num is null then
643: dbms_sql.bind_variable(c, 'from_asset_num', param.from_asset_num);
644: end if;
645:

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

639: if param.from_asset_num is not null and param.to_asset_num is not null then
640: dbms_sql.bind_variable(c, 'from_asset_num', param.from_asset_num);
641: dbms_sql.bind_variable(c, 'to_asset_num', param.to_asset_num);
642: elsif param.from_asset_num is not null and param.to_asset_num is null then
643: dbms_sql.bind_variable(c, 'from_asset_num', param.from_asset_num);
644: end if;
645:
646: dbms_sql.bind_variable(c, 'b_period_close_date', var.calendar_period_close_date); -- Added for Bug#3499862.
647:

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

642: elsif param.from_asset_num is not null and param.to_asset_num is null then
643: dbms_sql.bind_variable(c, 'from_asset_num', param.from_asset_num);
644: end if;
645:
646: dbms_sql.bind_variable(c, 'b_period_close_date', var.calendar_period_close_date); -- Added for Bug#3499862.
647:
648: IF (param.cat_seg_num IS NOT NULL) THEN
649: dbms_sql.bind_variable(c, 'from_cat_seg_val', param.from_cat_seg_val);
650: dbms_sql.bind_variable(c, 'to_cat_seg_val', param.to_cat_seg_val);

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

645:
646: dbms_sql.bind_variable(c, 'b_period_close_date', var.calendar_period_close_date); -- Added for Bug#3499862.
647:
648: IF (param.cat_seg_num IS NOT NULL) THEN
649: dbms_sql.bind_variable(c, 'from_cat_seg_val', param.from_cat_seg_val);
650: dbms_sql.bind_variable(c, 'to_cat_seg_val', param.to_cat_seg_val);
651: END IF;
652: IF (g_print_debug) THEN
653: fa_rx_util_pkg.debug('farx_dp.bind()-');

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

646: dbms_sql.bind_variable(c, 'b_period_close_date', var.calendar_period_close_date); -- Added for Bug#3499862.
647:
648: IF (param.cat_seg_num IS NOT NULL) THEN
649: dbms_sql.bind_variable(c, 'from_cat_seg_val', param.from_cat_seg_val);
650: dbms_sql.bind_variable(c, 'to_cat_seg_val', param.to_cat_seg_val);
651: END IF;
652: IF (g_print_debug) THEN
653: fa_rx_util_pkg.debug('farx_dp.bind()-');
654: END IF;