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
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;
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
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;
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
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;
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
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);
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: --
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
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: --
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
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: --