42: cursor c_get_name(p_payment_method_id NUMBER) is
43: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3
44: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;
45: begin
46: --hr_utility.trace_on(null,'EFT');
47: l_payment_method_id := p_payment_method_id;
48: open c_get_name(p_payment_method_id);
49: fetch c_get_name into l_id_header,l_id_body,l_id_footer;
50: close c_get_name;
395: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
396: l_inputs ff_exec.inputs_t;
397: l_outputs ff_exec.outputs_t;
398: BEGIN
399: hr_utility.set_location('--In Formula ',20);
400: --
401: -- Initialize the formula
402: --
403: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
401: -- Initialize the formula
402: --
403: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
404: --
405: hr_utility.trace('after ff_exec');
406: -- Set up the input values
407: --
408: IF l_inputs.count > 0 and p_inputs.count > 0 THEN
409: FOR i IN l_inputs.first..l_inputs.last LOOP
417: END IF;
418: --
419: -- Run the formula
420: --
421: hr_utility.trace('about to exec');
422: ff_exec.run_formula(l_inputs,l_outputs);
423: --
424: hr_utility.trace('After exec');
425: -- Populate the output table
420: --
421: hr_utility.trace('about to exec');
422: ff_exec.run_formula(l_inputs,l_outputs);
423: --
424: hr_utility.trace('After exec');
425: -- Populate the output table
426: --
427: IF l_outputs.count > 0 and p_inputs.count > 0 then
428: FOR i IN l_outputs.first..l_outputs.last LOOP
433: END IF;
434: END LOOP;
435: END LOOP;
436: END IF;
437: hr_utility.set_location('--Leaving Formula ',21);
438: EXCEPTION
439: WHEN hr_formula_error THEN
440: fnd_message.set_name('PER','FFX22J_FORMULA_NOT_FOUND');
441: fnd_message.set_token('1', g_formula_name);