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

Line 14: g_empty_tab ff_exec.outputs_t; -- donot populate. Only to be used a default value

10: g_criteria_rate_defn_id number(15):= null;
11: --
12: g_asg_rec per_all_assignments_f%ROWTYPE;
13: g_per_rec per_all_people_f%ROWTYPE;
14: g_empty_tab ff_exec.outputs_t; -- donot populate. Only to be used a default value
15: --
16: --
17: Type tc_criteria is record(
18: short_code ben_eligy_criteria.short_code%type,

Line 60: p_param_tab in ff_exec.outputs_t default g_empty_tab

56: p_param9 in varchar2 default null,
57: p_param9_value in varchar2 default null,
58: p_param10 in varchar2 default null,
59: p_param10_value in varchar2 default null,
60: p_param_tab in ff_exec.outputs_t default g_empty_tab
61: )
62: return ff_exec.outputs_t is
63: --
64: l_proc varchar2(80) := 'exec_pref_rate_formula';

Line 62: return ff_exec.outputs_t is

58: p_param10 in varchar2 default null,
59: p_param10_value in varchar2 default null,
60: p_param_tab in ff_exec.outputs_t default g_empty_tab
61: )
62: return ff_exec.outputs_t is
63: --
64: l_proc varchar2(80) := 'exec_pref_rate_formula';
65: l_inputs ff_exec.inputs_t;
66: l_outputs ff_exec.outputs_t;

Line 65: l_inputs ff_exec.inputs_t;

61: )
62: return ff_exec.outputs_t is
63: --
64: l_proc varchar2(80) := 'exec_pref_rate_formula';
65: l_inputs ff_exec.inputs_t;
66: l_outputs ff_exec.outputs_t;
67: j int;
68: l_param_tab_count number;
69: --

Line 66: l_outputs ff_exec.outputs_t;

62: return ff_exec.outputs_t is
63: --
64: l_proc varchar2(80) := 'exec_pref_rate_formula';
65: l_inputs ff_exec.inputs_t;
66: l_outputs ff_exec.outputs_t;
67: j int;
68: l_param_tab_count number;
69: --
70: l_organization_id per_all_assignments_f.organization_id%type;

Line 83: ff_exec.init_formula

79: begin
80: --
81: hr_utility.set_location ('Entering '||l_proc,10);
82: --
83: ff_exec.init_formula
84: (p_formula_id => p_formula_id,
85: p_effective_date => p_effective_date,
86: p_inputs => l_inputs,
87: p_outputs => l_outputs);

Line 185: ff_exec.run_formula(p_inputs => l_inputs,

181: end loop;
182: --
183: -- We have loaded the input record. Now run the formula.
184: --
185: ff_exec.run_formula(p_inputs => l_inputs,
186: p_outputs => l_outputs,
187: p_use_dbi_cache => false); -- bug# 2430017
188: --
189: hr_utility.set_location ('Leaving '||l_proc,10);

Line 220: l_outputs ff_exec.outputs_t;

216: l_rl_rt_counter number:= 0;
217: l_rate number := 0;
218: rec_no number;
219: l_cnt number:= 0;
220: l_outputs ff_exec.outputs_t;
221: l_param_tab ff_exec.outputs_t;
222: l_rate_matrix_rate_id pqh_rate_matrix_rates_f.rate_matrix_rate_id%type;
223: --
224: -- Declare local procedure

Line 221: l_param_tab ff_exec.outputs_t;

217: l_rate number := 0;
218: rec_no number;
219: l_cnt number:= 0;
220: l_outputs ff_exec.outputs_t;
221: l_param_tab ff_exec.outputs_t;
222: l_rate_matrix_rate_id pqh_rate_matrix_rates_f.rate_matrix_rate_id%type;
223: --
224: -- Declare local procedure
225: --

Line 623: p_param_tab in ff_exec.outputs_t default g_empty_tab

619: p_param9 in varchar2 default null,
620: p_param9_value in varchar2 default null,
621: p_param10 in varchar2 default null,
622: p_param10_value in varchar2 default null,
623: p_param_tab in ff_exec.outputs_t default g_empty_tab
624: )
625: return ff_exec.outputs_t is
626: --
627: l_proc varchar2(80) := 'exec_rate_calc_formula';

Line 625: return ff_exec.outputs_t is

621: p_param10 in varchar2 default null,
622: p_param10_value in varchar2 default null,
623: p_param_tab in ff_exec.outputs_t default g_empty_tab
624: )
625: return ff_exec.outputs_t is
626: --
627: l_proc varchar2(80) := 'exec_rate_calc_formula';
628: l_inputs ff_exec.inputs_t;
629: l_outputs ff_exec.outputs_t;

Line 628: l_inputs ff_exec.inputs_t;

624: )
625: return ff_exec.outputs_t is
626: --
627: l_proc varchar2(80) := 'exec_rate_calc_formula';
628: l_inputs ff_exec.inputs_t;
629: l_outputs ff_exec.outputs_t;
630: j int;
631: l_param_tab_count number;
632: --

Line 629: l_outputs ff_exec.outputs_t;

625: return ff_exec.outputs_t is
626: --
627: l_proc varchar2(80) := 'exec_rate_calc_formula';
628: l_inputs ff_exec.inputs_t;
629: l_outputs ff_exec.outputs_t;
630: j int;
631: l_param_tab_count number;
632: --
633: l_organization_id per_all_assignments_f.organization_id%type;

Line 646: ff_exec.init_formula

642: begin
643: --
644: hr_utility.set_location ('Entering '||l_proc,10);
645: --
646: ff_exec.init_formula
647: (p_formula_id => p_formula_id,
648: p_effective_date => p_effective_date,
649: p_inputs => l_inputs,
650: p_outputs => l_outputs);

Line 748: ff_exec.run_formula(p_inputs => l_inputs,

744: end loop;
745: --
746: -- We have loaded the input record. Now run the formula.
747: --
748: ff_exec.run_formula(p_inputs => l_inputs,
749: p_outputs => l_outputs,
750: p_use_dbi_cache => false); -- bug# 2430017
751: --
752: hr_utility.set_location ('Leaving '||l_proc,10);

Line 833: l_outputs ff_exec.outputs_t;

829: Where criteria_rate_defn_id = p_crit_rt_defn_id
830: and business_group_id = p_business_group_id;
831: --
832: l_proc varchar2(72) := g_package||'calculate_crit_rate_defn_rt';
833: l_outputs ff_exec.outputs_t;
834: --
835: Begin
836: --
837: hr_utility.set_location('Entering:'||l_proc, 5);