APPS.PAY_AE_EFT dependencies on FF_EXEC

Line 47: l_inputs ff_exec.inputs_t;

43: l_body varchar2(100);
44: l_footer varchar2(100);
45: l_bank_code varchar2(100);
46: l_employer_code varchar2(100);
47: l_inputs ff_exec.inputs_t;
48: l_outputs ff_exec.outputs_t;
49:
50: /*cursor c_get_name(p_payment_method_id NUMBER) is
51: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5

Line 48: l_outputs ff_exec.outputs_t;

44: l_footer varchar2(100);
45: l_bank_code varchar2(100);
46: l_employer_code varchar2(100);
47: l_inputs ff_exec.inputs_t;
48: l_outputs ff_exec.outputs_t;
49:
50: /*cursor c_get_name(p_payment_method_id NUMBER) is
51: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
52: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id; */

Line 206: l_inputs ff_exec.inputs_t;

202: l_body varchar2(100);
203: l_footer varchar2(100);
204: l_bank_code varchar2(100);
205: l_employer_code varchar2(100);
206: l_inputs ff_exec.inputs_t;
207: l_outputs ff_exec.outputs_t;
208:
209: /*cursor c_get_name(p_payment_method_id NUMBER) is
210: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5

Line 207: l_outputs ff_exec.outputs_t;

203: l_footer varchar2(100);
204: l_bank_code varchar2(100);
205: l_employer_code varchar2(100);
206: l_inputs ff_exec.inputs_t;
207: l_outputs ff_exec.outputs_t;
208:
209: /*cursor c_get_name(p_payment_method_id NUMBER) is
210: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
211: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id; */

Line 376: l_inputs ff_exec.inputs_t;

372: l_body varchar2(100);
373: l_footer varchar2(100);
374: l_bank_code varchar2(100);
375: l_employer_code varchar2(100);
376: l_inputs ff_exec.inputs_t;
377: l_outputs ff_exec.outputs_t;
378:
379: /*cursor c_get_name(p_payment_method_id NUMBER) is
380: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5

Line 377: l_outputs ff_exec.outputs_t;

373: l_footer varchar2(100);
374: l_bank_code varchar2(100);
375: l_employer_code varchar2(100);
376: l_inputs ff_exec.inputs_t;
377: l_outputs ff_exec.outputs_t;
378:
379: /*cursor c_get_name(p_payment_method_id NUMBER) is
380: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
381: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;*/

Line 492: ,p_inputs IN ff_exec.inputs_t

488: ----------
489: -----
490: PROCEDURE run_formula(p_formula_id IN NUMBER
491: ,p_effective_date IN DATE
492: ,p_inputs IN ff_exec.inputs_t
493: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
494: l_inputs ff_exec.inputs_t;
495: l_outputs ff_exec.outputs_t;
496: BEGIN

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

489: -----
490: PROCEDURE run_formula(p_formula_id IN NUMBER
491: ,p_effective_date IN DATE
492: ,p_inputs IN ff_exec.inputs_t
493: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
494: l_inputs ff_exec.inputs_t;
495: l_outputs ff_exec.outputs_t;
496: BEGIN
497: hr_utility.set_location('--In Formula ',20);

Line 494: l_inputs ff_exec.inputs_t;

490: PROCEDURE run_formula(p_formula_id IN NUMBER
491: ,p_effective_date IN DATE
492: ,p_inputs IN ff_exec.inputs_t
493: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
494: l_inputs ff_exec.inputs_t;
495: l_outputs ff_exec.outputs_t;
496: BEGIN
497: hr_utility.set_location('--In Formula ',20);
498: --

Line 495: l_outputs ff_exec.outputs_t;

491: ,p_effective_date IN DATE
492: ,p_inputs IN ff_exec.inputs_t
493: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
494: l_inputs ff_exec.inputs_t;
495: l_outputs ff_exec.outputs_t;
496: BEGIN
497: hr_utility.set_location('--In Formula ',20);
498: --
499: -- Initialize the formula

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

497: hr_utility.set_location('--In Formula ',20);
498: --
499: -- Initialize the formula
500: --
501: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
502: --
503: hr_utility.trace('after ff_exec');
504: -- Set up the input values
505: --

Line 503: hr_utility.trace('after ff_exec');

499: -- Initialize the formula
500: --
501: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
502: --
503: hr_utility.trace('after ff_exec');
504: -- Set up the input values
505: --
506: IF l_inputs.count > 0 and p_inputs.count > 0 THEN
507: FOR i IN l_inputs.first..l_inputs.last LOOP

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

516: --
517: -- Run the formula
518: --
519: hr_utility.trace('about to exec');
520: ff_exec.run_formula(l_inputs,l_outputs);
521: --
522: hr_utility.trace('After exec');
523: -- Populate the output table
524: --