DBA Data[Home] [Help]

APPS.HRI_OLTP_DISC_UTLZTN dependencies on FF_EXEC

Line 76: l_ff_inputs FF_Exec.Inputs_t;

72: RETURN NUMBER IS
73:
74: l_hours_worked NUMBER;
75: l_formula_id NUMBER;
76: l_ff_inputs FF_Exec.Inputs_t;
77: l_ff_outputs FF_Exec.Outputs_t;
78:
79: BEGIN
80:

Line 77: l_ff_outputs FF_Exec.Outputs_t;

73:
74: l_hours_worked NUMBER;
75: l_formula_id NUMBER;
76: l_ff_inputs FF_Exec.Inputs_t;
77: l_ff_outputs FF_Exec.Outputs_t;
78:
79: BEGIN
80:
81: SELECT formula_id INTO l_formula_id

Line 90: FF_Exec.Init_Formula

86: AND (business_group_id = p_business_group_id
87: OR (business_group_id IS NULL AND p_business_group_id IS NULL));
88:
89: -- Initialise the Inputs and Outputs tables
90: FF_Exec.Init_Formula
91: ( p_formula_id => l_formula_id
92: , p_effective_date => SYSDATE
93: , p_inputs => l_ff_inputs
94: , p_outputs => l_ff_outputs );

Line 108: FF_Exec.Run_Formula

104:
105: END LOOP;
106:
107: -- Run the formula and get the return value
108: FF_Exec.Run_Formula
109: ( p_inputs => l_ff_inputs
110: , p_outputs => l_ff_outputs);
111:
112: l_hours_worked := TO_NUMBER(l_ff_outputs(l_ff_outputs.first).value);