51: where ORG_PAYMENT_METHOD_ID = p_payment_method_id
52: and p_Date_Earned between effective_start_date and effective_end_date ;
53:
54: begin
55: --hr_utility.trace_on(null,'EFT');
56: l_payment_method_id := p_payment_method_id;
57: open c_get_name(p_payment_method_id,p_Date_Earned);
58: fetch c_get_name into l_id_header,l_id_body,l_id_footer;
59: close c_get_name;
424: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
425: l_inputs ff_exec.inputs_t;
426: l_outputs ff_exec.outputs_t;
427: BEGIN
428: hr_utility.set_location('--In Formula ',20);
429: --
430: -- Initialize the formula
431: --
432: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
430: -- Initialize the formula
431: --
432: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
433: --
434: hr_utility.trace('after ff_exec');
435: -- Set up the input values
436: --
437: IF l_inputs.count > 0 and p_inputs.count > 0 THEN
438: FOR i IN l_inputs.first..l_inputs.last LOOP
446: END IF;
447: --
448: -- Run the formula
449: --
450: hr_utility.trace('about to exec');
451: ff_exec.run_formula(l_inputs,l_outputs);
452: --
453: hr_utility.trace('After exec');
454: -- Populate the output table
449: --
450: hr_utility.trace('about to exec');
451: ff_exec.run_formula(l_inputs,l_outputs);
452: --
453: hr_utility.trace('After exec');
454: -- Populate the output table
455: --
456: IF l_outputs.count > 0 and p_inputs.count > 0 then
457: FOR i IN l_outputs.first..l_outputs.last LOOP
462: END IF;
463: END LOOP;
464: END LOOP;
465: END IF;
466: hr_utility.set_location('--Leaving Formula ',21);
467: EXCEPTION
468: WHEN hr_formula_error THEN
469: fnd_message.set_name('PER','FFX22J_FORMULA_NOT_FOUND');
470: fnd_message.set_token('1', g_formula_name);