DBA Data[Home] [Help]

APPS.PAY_KW_EFT dependencies on FF_EXEC

Line 43: l_inputs ff_exec.inputs_t;

39: l_body varchar2(100);
40: l_footer varchar2(100);
41: l_bank_code varchar2(100);
42: l_employer_code varchar2(100);
43: l_inputs ff_exec.inputs_t;
44: l_outputs ff_exec.outputs_t;
45: cursor c_get_name(p_payment_method_id NUMBER) is
46: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
47: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;

Line 44: l_outputs ff_exec.outputs_t;

40: l_footer varchar2(100);
41: l_bank_code varchar2(100);
42: l_employer_code varchar2(100);
43: l_inputs ff_exec.inputs_t;
44: l_outputs ff_exec.outputs_t;
45: cursor c_get_name(p_payment_method_id NUMBER) is
46: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
47: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;
48: begin

Line 177: l_inputs ff_exec.inputs_t;

173: l_body varchar2(100);
174: l_footer varchar2(100);
175: l_bank_code varchar2(100);
176: l_employer_code varchar2(100);
177: l_inputs ff_exec.inputs_t;
178: l_outputs ff_exec.outputs_t;
179: cursor c_get_name(p_payment_method_id NUMBER) is
180: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
181: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;

Line 178: l_outputs ff_exec.outputs_t;

174: l_footer varchar2(100);
175: l_bank_code varchar2(100);
176: l_employer_code varchar2(100);
177: l_inputs ff_exec.inputs_t;
178: l_outputs ff_exec.outputs_t;
179: cursor c_get_name(p_payment_method_id NUMBER) is
180: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
181: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;
182: begin

Line 322: l_inputs ff_exec.inputs_t;

318: l_body varchar2(100);
319: l_footer varchar2(100);
320: l_bank_code varchar2(100);
321: l_employer_code varchar2(100);
322: l_inputs ff_exec.inputs_t;
323: l_outputs ff_exec.outputs_t;
324: cursor c_get_name(p_payment_method_id NUMBER) is
325: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
326: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;

Line 323: l_outputs ff_exec.outputs_t;

319: l_footer varchar2(100);
320: l_bank_code varchar2(100);
321: l_employer_code varchar2(100);
322: l_inputs ff_exec.inputs_t;
323: l_outputs ff_exec.outputs_t;
324: cursor c_get_name(p_payment_method_id NUMBER) is
325: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3,PMETH_INFORMATION4,PMETH_INFORMATION5
326: from PAY_ORG_PAYMENT_METHODS_F where ORG_PAYMENT_METHOD_ID = p_payment_method_id;
327: begin

Line 418: ,p_inputs IN ff_exec.inputs_t

414: ----------
415: -----
416: PROCEDURE run_formula(p_formula_id IN NUMBER
417: ,p_effective_date IN DATE
418: ,p_inputs IN ff_exec.inputs_t
419: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
420: l_inputs ff_exec.inputs_t;
421: l_outputs ff_exec.outputs_t;
422: BEGIN

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

415: -----
416: PROCEDURE run_formula(p_formula_id IN NUMBER
417: ,p_effective_date IN DATE
418: ,p_inputs IN ff_exec.inputs_t
419: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
420: l_inputs ff_exec.inputs_t;
421: l_outputs ff_exec.outputs_t;
422: BEGIN
423: hr_utility.set_location('--In Formula ',20);

Line 420: l_inputs ff_exec.inputs_t;

416: PROCEDURE run_formula(p_formula_id IN NUMBER
417: ,p_effective_date IN DATE
418: ,p_inputs IN ff_exec.inputs_t
419: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
420: l_inputs ff_exec.inputs_t;
421: l_outputs ff_exec.outputs_t;
422: BEGIN
423: hr_utility.set_location('--In Formula ',20);
424: --

Line 421: l_outputs ff_exec.outputs_t;

417: ,p_effective_date IN DATE
418: ,p_inputs IN ff_exec.inputs_t
419: ,p_outputs IN OUT NOCOPY ff_exec.outputs_t) IS
420: l_inputs ff_exec.inputs_t;
421: l_outputs ff_exec.outputs_t;
422: BEGIN
423: hr_utility.set_location('--In Formula ',20);
424: --
425: -- Initialize the formula

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

423: hr_utility.set_location('--In Formula ',20);
424: --
425: -- Initialize the formula
426: --
427: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
428: --
429: hr_utility.trace('after ff_exec');
430: -- Set up the input values
431: --

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

425: -- Initialize the formula
426: --
427: ff_exec.init_formula(p_formula_id, p_effective_date , l_inputs, l_outputs);
428: --
429: hr_utility.trace('after ff_exec');
430: -- Set up the input values
431: --
432: IF l_inputs.count > 0 and p_inputs.count > 0 THEN
433: FOR i IN l_inputs.first..l_inputs.last LOOP

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

442: --
443: -- Run the formula
444: --
445: hr_utility.trace('about to exec');
446: ff_exec.run_formula(l_inputs,l_outputs);
447: --
448: hr_utility.trace('After exec');
449: -- Populate the output table
450: --