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.FF_EXEC dependencies on FF_WRAPPER_PKG

Line 85: /* Use FF_WRAPPER_PKG instead of dynamic SQL. */

81: /* following allow sanity checking */
82: input_rows number, -- rows in the inputs table.
83: output_rows number -- rows in the outputs table.
84:
85: /* Use FF_WRAPPER_PKG instead of dynamic SQL. */
86: ,use_ff_wrapper boolean
87: );
88:
89: --

Line 2092: p_d in out nocopy ff_wrapper_pkg.t_date,

2088: p_outputs in ff_exec.outputs_t,
2089: p_fmla_info in fmla_info_t,
2090: p_fdiu_info in fdiu_info_t,
2091: p_ctx_info in out nocopy dbi_cache_t,
2092: p_d in out nocopy ff_wrapper_pkg.t_date,
2093: p_n in out nocopy ff_wrapper_pkg.t_number,
2094: p_t in out nocopy ff_wrapper_pkg.t_text,
2095: p_i in out nocopy ff_wrapper_pkg.t_number,
2096: p_use_dbi_cache in boolean

Line 2093: p_n in out nocopy ff_wrapper_pkg.t_number,

2089: p_fmla_info in fmla_info_t,
2090: p_fdiu_info in fdiu_info_t,
2091: p_ctx_info in out nocopy dbi_cache_t,
2092: p_d in out nocopy ff_wrapper_pkg.t_date,
2093: p_n in out nocopy ff_wrapper_pkg.t_number,
2094: p_t in out nocopy ff_wrapper_pkg.t_text,
2095: p_i in out nocopy ff_wrapper_pkg.t_number,
2096: p_use_dbi_cache in boolean
2097: ) is

Line 2094: p_t in out nocopy ff_wrapper_pkg.t_text,

2090: p_fdiu_info in fdiu_info_t,
2091: p_ctx_info in out nocopy dbi_cache_t,
2092: p_d in out nocopy ff_wrapper_pkg.t_date,
2093: p_n in out nocopy ff_wrapper_pkg.t_number,
2094: p_t in out nocopy ff_wrapper_pkg.t_text,
2095: p_i in out nocopy ff_wrapper_pkg.t_number,
2096: p_use_dbi_cache in boolean
2097: ) is
2098:

Line 2095: p_i in out nocopy ff_wrapper_pkg.t_number,

2091: p_ctx_info in out nocopy dbi_cache_t,
2092: p_d in out nocopy ff_wrapper_pkg.t_date,
2093: p_n in out nocopy ff_wrapper_pkg.t_number,
2094: p_t in out nocopy ff_wrapper_pkg.t_text,
2095: p_i in out nocopy ff_wrapper_pkg.t_number,
2096: p_use_dbi_cache in boolean
2097: ) is
2098:
2099: l_context_total1 binary_integer;

Line 2345: p_d in ff_wrapper_pkg.t_date,

2341: (
2342: p_cache_slot in binary_integer,
2343: p_fmla_info in fmla_info_t,
2344: p_fdiu_info in fdiu_info_t,
2345: p_d in ff_wrapper_pkg.t_date,
2346: p_n in ff_wrapper_pkg.t_number,
2347: p_t in ff_wrapper_pkg.t_text,
2348: p_i in ff_wrapper_pkg.t_number,
2349: p_outputs in out nocopy ff_exec.outputs_t

Line 2346: p_n in ff_wrapper_pkg.t_number,

2342: p_cache_slot in binary_integer,
2343: p_fmla_info in fmla_info_t,
2344: p_fdiu_info in fdiu_info_t,
2345: p_d in ff_wrapper_pkg.t_date,
2346: p_n in ff_wrapper_pkg.t_number,
2347: p_t in ff_wrapper_pkg.t_text,
2348: p_i in ff_wrapper_pkg.t_number,
2349: p_outputs in out nocopy ff_exec.outputs_t
2350: ) is

Line 2347: p_t in ff_wrapper_pkg.t_text,

2343: p_fmla_info in fmla_info_t,
2344: p_fdiu_info in fdiu_info_t,
2345: p_d in ff_wrapper_pkg.t_date,
2346: p_n in ff_wrapper_pkg.t_number,
2347: p_t in ff_wrapper_pkg.t_text,
2348: p_i in ff_wrapper_pkg.t_number,
2349: p_outputs in out nocopy ff_exec.outputs_t
2350: ) is
2351: l_first_fdiu binary_integer;

Line 2348: p_i in ff_wrapper_pkg.t_number,

2344: p_fdiu_info in fdiu_info_t,
2345: p_d in ff_wrapper_pkg.t_date,
2346: p_n in ff_wrapper_pkg.t_number,
2347: p_t in ff_wrapper_pkg.t_text,
2348: p_i in ff_wrapper_pkg.t_number,
2349: p_outputs in out nocopy ff_exec.outputs_t
2350: ) is
2351: l_first_fdiu binary_integer;
2352: l_last_fdiu binary_integer;

Line 2663: l_d ff_wrapper_pkg.t_date;

2659: l_first_fdiu binary_integer;
2660: l_last_fdiu binary_integer;
2661: l_count_fdiu binary_integer;
2662: l_fmla_name varchar2(80);
2663: l_d ff_wrapper_pkg.t_date;
2664: l_n ff_wrapper_pkg.t_number;
2665: l_t ff_wrapper_pkg.t_text;
2666: l_i ff_wrapper_pkg.t_number;
2667: begin

Line 2664: l_n ff_wrapper_pkg.t_number;

2660: l_last_fdiu binary_integer;
2661: l_count_fdiu binary_integer;
2662: l_fmla_name varchar2(80);
2663: l_d ff_wrapper_pkg.t_date;
2664: l_n ff_wrapper_pkg.t_number;
2665: l_t ff_wrapper_pkg.t_text;
2666: l_i ff_wrapper_pkg.t_number;
2667: begin
2668: g_debug := hr_utility.debug_enabled;

Line 2665: l_t ff_wrapper_pkg.t_text;

2661: l_count_fdiu binary_integer;
2662: l_fmla_name varchar2(80);
2663: l_d ff_wrapper_pkg.t_date;
2664: l_n ff_wrapper_pkg.t_number;
2665: l_t ff_wrapper_pkg.t_text;
2666: l_i ff_wrapper_pkg.t_number;
2667: begin
2668: g_debug := hr_utility.debug_enabled;
2669: if g_debug then

Line 2666: l_i ff_wrapper_pkg.t_number;

2662: l_fmla_name varchar2(80);
2663: l_d ff_wrapper_pkg.t_date;
2664: l_n ff_wrapper_pkg.t_number;
2665: l_t ff_wrapper_pkg.t_text;
2666: l_i ff_wrapper_pkg.t_number;
2667: begin
2668: g_debug := hr_utility.debug_enabled;
2669: if g_debug then
2670: ff_utils.entry('run_formula');

Line 2744: ff_wrapper_pkg.g_d := l_d;

2740:
2741: end;
2742: else
2743: begin
2744: ff_wrapper_pkg.g_d := l_d;
2745: ff_wrapper_pkg.g_i := l_i;
2746: ff_wrapper_pkg.g_n := l_n;
2747: ff_wrapper_pkg.g_t := l_t;
2748: ff_wrapper_pkg.g_fferln := null;

Line 2745: ff_wrapper_pkg.g_i := l_i;

2741: end;
2742: else
2743: begin
2744: ff_wrapper_pkg.g_d := l_d;
2745: ff_wrapper_pkg.g_i := l_i;
2746: ff_wrapper_pkg.g_n := l_n;
2747: ff_wrapper_pkg.g_t := l_t;
2748: ff_wrapper_pkg.g_fferln := null;
2749: ff_wrapper_pkg.g_ffercd := null;

Line 2746: ff_wrapper_pkg.g_n := l_n;

2742: else
2743: begin
2744: ff_wrapper_pkg.g_d := l_d;
2745: ff_wrapper_pkg.g_i := l_i;
2746: ff_wrapper_pkg.g_n := l_n;
2747: ff_wrapper_pkg.g_t := l_t;
2748: ff_wrapper_pkg.g_fferln := null;
2749: ff_wrapper_pkg.g_ffercd := null;
2750: ff_wrapper_pkg.g_ffermt := null;

Line 2747: ff_wrapper_pkg.g_t := l_t;

2743: begin
2744: ff_wrapper_pkg.g_d := l_d;
2745: ff_wrapper_pkg.g_i := l_i;
2746: ff_wrapper_pkg.g_n := l_n;
2747: ff_wrapper_pkg.g_t := l_t;
2748: ff_wrapper_pkg.g_fferln := null;
2749: ff_wrapper_pkg.g_ffercd := null;
2750: ff_wrapper_pkg.g_ffermt := null;
2751: execute immediate

Line 2748: ff_wrapper_pkg.g_fferln := null;

2744: ff_wrapper_pkg.g_d := l_d;
2745: ff_wrapper_pkg.g_i := l_i;
2746: ff_wrapper_pkg.g_n := l_n;
2747: ff_wrapper_pkg.g_t := l_t;
2748: ff_wrapper_pkg.g_fferln := null;
2749: ff_wrapper_pkg.g_ffercd := null;
2750: ff_wrapper_pkg.g_ffermt := null;
2751: execute immediate
2752: 'begin ' || g_fmla_info(l_cache_slot).package_name || '.formula; end;';

Line 2749: ff_wrapper_pkg.g_ffercd := null;

2745: ff_wrapper_pkg.g_i := l_i;
2746: ff_wrapper_pkg.g_n := l_n;
2747: ff_wrapper_pkg.g_t := l_t;
2748: ff_wrapper_pkg.g_fferln := null;
2749: ff_wrapper_pkg.g_ffercd := null;
2750: ff_wrapper_pkg.g_ffermt := null;
2751: execute immediate
2752: 'begin ' || g_fmla_info(l_cache_slot).package_name || '.formula; end;';
2753: exception

Line 2750: ff_wrapper_pkg.g_ffermt := null;

2746: ff_wrapper_pkg.g_n := l_n;
2747: ff_wrapper_pkg.g_t := l_t;
2748: ff_wrapper_pkg.g_fferln := null;
2749: ff_wrapper_pkg.g_ffercd := null;
2750: ff_wrapper_pkg.g_ffermt := null;
2751: execute immediate
2752: 'begin ' || g_fmla_info(l_cache_slot).package_name || '.formula; end;';
2753: exception
2754: when bad_plsql then

Line 2767: l_d := ff_wrapper_pkg.g_d;

2763: hr_utility.set_message_token('2', sqlerrm);
2764: hr_utility.raise_error;
2765: end;
2766: --
2767: l_d := ff_wrapper_pkg.g_d;
2768: l_i := ff_wrapper_pkg.g_i;
2769: l_n := ff_wrapper_pkg.g_n;
2770: l_t := ff_wrapper_pkg.g_t;
2771: l_line_number := ff_wrapper_pkg.g_fferln;

Line 2768: l_i := ff_wrapper_pkg.g_i;

2764: hr_utility.raise_error;
2765: end;
2766: --
2767: l_d := ff_wrapper_pkg.g_d;
2768: l_i := ff_wrapper_pkg.g_i;
2769: l_n := ff_wrapper_pkg.g_n;
2770: l_t := ff_wrapper_pkg.g_t;
2771: l_line_number := ff_wrapper_pkg.g_fferln;
2772: l_err_number := ff_wrapper_pkg.g_ffercd;

Line 2769: l_n := ff_wrapper_pkg.g_n;

2765: end;
2766: --
2767: l_d := ff_wrapper_pkg.g_d;
2768: l_i := ff_wrapper_pkg.g_i;
2769: l_n := ff_wrapper_pkg.g_n;
2770: l_t := ff_wrapper_pkg.g_t;
2771: l_line_number := ff_wrapper_pkg.g_fferln;
2772: l_err_number := ff_wrapper_pkg.g_ffercd;
2773: l_error_message := ff_wrapper_pkg.g_ffermt;

Line 2770: l_t := ff_wrapper_pkg.g_t;

2766: --
2767: l_d := ff_wrapper_pkg.g_d;
2768: l_i := ff_wrapper_pkg.g_i;
2769: l_n := ff_wrapper_pkg.g_n;
2770: l_t := ff_wrapper_pkg.g_t;
2771: l_line_number := ff_wrapper_pkg.g_fferln;
2772: l_err_number := ff_wrapper_pkg.g_ffercd;
2773: l_error_message := ff_wrapper_pkg.g_ffermt;
2774: end if;

Line 2771: l_line_number := ff_wrapper_pkg.g_fferln;

2767: l_d := ff_wrapper_pkg.g_d;
2768: l_i := ff_wrapper_pkg.g_i;
2769: l_n := ff_wrapper_pkg.g_n;
2770: l_t := ff_wrapper_pkg.g_t;
2771: l_line_number := ff_wrapper_pkg.g_fferln;
2772: l_err_number := ff_wrapper_pkg.g_ffercd;
2773: l_error_message := ff_wrapper_pkg.g_ffermt;
2774: end if;
2775:

Line 2772: l_err_number := ff_wrapper_pkg.g_ffercd;

2768: l_i := ff_wrapper_pkg.g_i;
2769: l_n := ff_wrapper_pkg.g_n;
2770: l_t := ff_wrapper_pkg.g_t;
2771: l_line_number := ff_wrapper_pkg.g_fferln;
2772: l_err_number := ff_wrapper_pkg.g_ffercd;
2773: l_error_message := ff_wrapper_pkg.g_ffermt;
2774: end if;
2775:
2776: /*

Line 2773: l_error_message := ff_wrapper_pkg.g_ffermt;

2769: l_n := ff_wrapper_pkg.g_n;
2770: l_t := ff_wrapper_pkg.g_t;
2771: l_line_number := ff_wrapper_pkg.g_fferln;
2772: l_err_number := ff_wrapper_pkg.g_ffercd;
2773: l_error_message := ff_wrapper_pkg.g_ffermt;
2774: end if;
2775:
2776: /*
2777: * Check for specific error conditions.