DBA Data[Home] [Help]

APPS.PAY_NL_PAYFILE dependencies on FF_EXEC

Line 56: l_inputs ff_exec.inputs_t;

52: l_payee_id pay_personal_payment_methods_f.payee_id%TYPE;
53: l_payee_name VARCHAR(35);
54: l_org_count NUMBER;
55: --
56: l_inputs ff_exec.inputs_t;
57: l_outputs ff_exec.outputs_t;
58: p_formula_exists BOOLEAN := TRUE;
59: p_formula_cached BOOLEAN := FALSE;
60: p_formula_id ff_formulas_f.formula_id%TYPE;

Line 57: l_outputs ff_exec.outputs_t;

53: l_payee_name VARCHAR(35);
54: l_org_count NUMBER;
55: --
56: l_inputs ff_exec.inputs_t;
57: l_outputs ff_exec.outputs_t;
58: p_formula_exists BOOLEAN := TRUE;
59: p_formula_cached BOOLEAN := FALSE;
60: p_formula_id ff_formulas_f.formula_id%TYPE;
61: p_formula_name ff_formulas_f.formula_name%TYPE;

Line 291: l_inputs ff_exec.inputs_t;

287: ,p_transaction_desc IN VARCHAR2
288: ,p_prepayment_id IN VARCHAR2
289: ) RETURN VARCHAR2 IS
290: l_transaction_desc varchar(131);
291: l_inputs ff_exec.inputs_t;
292: l_outputs ff_exec.outputs_t;
293: p_formula_exists BOOLEAN := TRUE;
294: p_formula_cached BOOLEAN := FALSE;
295: p_formula_id ff_formulas_f.formula_id%TYPE;

Line 292: l_outputs ff_exec.outputs_t;

288: ,p_prepayment_id IN VARCHAR2
289: ) RETURN VARCHAR2 IS
290: l_transaction_desc varchar(131);
291: l_inputs ff_exec.inputs_t;
292: l_outputs ff_exec.outputs_t;
293: p_formula_exists BOOLEAN := TRUE;
294: p_formula_cached BOOLEAN := FALSE;
295: p_formula_id ff_formulas_f.formula_id%TYPE;
296: p_formula_name ff_formulas_f.formula_name%TYPE;

Line 403: ,p_inputs IN ff_exec.inputs_t

399: END cache_formula;
400: PROCEDURE run_formula(p_formula_id IN NUMBER
401: ,p_effective_date IN DATE
402: ,p_formula_name IN VARCHAR2
403: ,p_inputs IN ff_exec.inputs_t
404: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
405: l_inputs ff_exec.inputs_t;
406: l_outputs ff_exec.outputs_t;
407: BEGIN

Line 404: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS

400: PROCEDURE run_formula(p_formula_id IN NUMBER
401: ,p_effective_date IN DATE
402: ,p_formula_name IN VARCHAR2
403: ,p_inputs IN ff_exec.inputs_t
404: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
405: l_inputs ff_exec.inputs_t;
406: l_outputs ff_exec.outputs_t;
407: BEGIN
408: hr_utility.set_location('--In Formula ',20);

Line 405: l_inputs ff_exec.inputs_t;

401: ,p_effective_date IN DATE
402: ,p_formula_name IN VARCHAR2
403: ,p_inputs IN ff_exec.inputs_t
404: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
405: l_inputs ff_exec.inputs_t;
406: l_outputs ff_exec.outputs_t;
407: BEGIN
408: hr_utility.set_location('--In Formula ',20);
409: --

Line 406: l_outputs ff_exec.outputs_t;

402: ,p_formula_name IN VARCHAR2
403: ,p_inputs IN ff_exec.inputs_t
404: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
405: l_inputs ff_exec.inputs_t;
406: l_outputs ff_exec.outputs_t;
407: BEGIN
408: hr_utility.set_location('--In Formula ',20);
409: --
410: -- Initialize the formula

Line 412: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);

408: hr_utility.set_location('--In Formula ',20);
409: --
410: -- Initialize the formula
411: --
412: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
413: --
414: -- Set up the input values
415: --
416: IF l_inputs.count > 0 and p_inputs.count > 0 THEN

Line 429: ff_exec.run_formula(l_inputs,l_outputs);

425: END IF;
426: --
427: -- Run the formula
428: --
429: ff_exec.run_formula(l_inputs,l_outputs);
430: --
431: -- Populate the output table
432: --
433: IF l_outputs.count > 0 and p_inputs.count > 0 then