DBA Data[Home] [Help]

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 200: l_inputs ff_exec.inputs_t;

196: l_body varchar2(100);
197: l_footer varchar2(100);
198: l_bank_code varchar2(100);
199: l_employer_code varchar2(100);
200: l_inputs ff_exec.inputs_t;
201: l_outputs ff_exec.outputs_t;
202:
203: cursor c_get_name(p_payment_method_id NUMBER) is
204: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5

Line 201: l_outputs ff_exec.outputs_t;

197: l_footer varchar2(100);
198: l_bank_code varchar2(100);
199: l_employer_code varchar2(100);
200: l_inputs ff_exec.inputs_t;
201: l_outputs ff_exec.outputs_t;
202:
203: cursor c_get_name(p_payment_method_id NUMBER) is
204: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
205: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;

Line 364: l_inputs ff_exec.inputs_t;

360: l_body varchar2(100);
361: l_footer varchar2(100);
362: l_bank_code varchar2(100);
363: l_employer_code varchar2(100);
364: l_inputs ff_exec.inputs_t;
365: l_outputs ff_exec.outputs_t;
366:
367: cursor c_get_name(p_payment_method_id NUMBER) is
368: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5

Line 365: l_outputs ff_exec.outputs_t;

361: l_footer varchar2(100);
362: l_bank_code varchar2(100);
363: l_employer_code varchar2(100);
364: l_inputs ff_exec.inputs_t;
365: l_outputs ff_exec.outputs_t;
366:
367: cursor c_get_name(p_payment_method_id NUMBER) is
368: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
369: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;

Line 474: ,p_inputs IN ff_exec.inputs_t

470: ----------
471: -----
472: PROCEDURE run_formula(p_formula_id IN NUMBER
473: ,p_effective_date IN DATE
474: ,p_inputs IN ff_exec.inputs_t
475: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
476: l_inputs ff_exec.inputs_t;
477: l_outputs ff_exec.outputs_t;
478: BEGIN

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

471: -----
472: PROCEDURE run_formula(p_formula_id IN NUMBER
473: ,p_effective_date IN DATE
474: ,p_inputs IN ff_exec.inputs_t
475: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
476: l_inputs ff_exec.inputs_t;
477: l_outputs ff_exec.outputs_t;
478: BEGIN
479: hr_utility.set_location('--In Formula ',20);

Line 476: l_inputs ff_exec.inputs_t;

472: PROCEDURE run_formula(p_formula_id IN NUMBER
473: ,p_effective_date IN DATE
474: ,p_inputs IN ff_exec.inputs_t
475: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
476: l_inputs ff_exec.inputs_t;
477: l_outputs ff_exec.outputs_t;
478: BEGIN
479: hr_utility.set_location('--In Formula ',20);
480: --

Line 477: l_outputs ff_exec.outputs_t;

473: ,p_effective_date IN DATE
474: ,p_inputs IN ff_exec.inputs_t
475: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
476: l_inputs ff_exec.inputs_t;
477: l_outputs ff_exec.outputs_t;
478: BEGIN
479: hr_utility.set_location('--In Formula ',20);
480: --
481: -- Initialize the formula

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

479: hr_utility.set_location('--In Formula ',20);
480: --
481: -- Initialize the formula
482: --
483: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
484: --
485: hr_utility.trace('after ff_exec');
486: -- Set up the input values
487: --

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

481: -- Initialize the formula
482: --
483: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
484: --
485: hr_utility.trace('after ff_exec');
486: -- Set up the input values
487: --
488: IF l_inputs.count > 0 and p_inputs.count > 0 THEN
489: FOR i IN l_inputs.first..l_inputs.last LOOP

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

498: --
499: -- Run the formula
500: --
501: hr_utility.trace('about to exec');
502: ff_exec.run_formula(l_inputs,l_outputs);
503: --
504: hr_utility.trace('After exec');
505: -- Populate the output table
506: --