DBA Data[Home] [Help]

APPS.PAY_SA_EFT dependencies on FF_EXEC

Line 40: l_inputs ff_exec.inputs_t;

36: ,p_report_text10 OUT NOCOPY VARCHAR2) return varchar2 IS
37: l_header varchar2(100);
38: l_body varchar2(100);
39: l_footer varchar2(100);
40: l_inputs ff_exec.inputs_t;
41: l_outputs ff_exec.outputs_t;
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; */

Line 41: l_outputs ff_exec.outputs_t;

37: l_header varchar2(100);
38: l_body varchar2(100);
39: l_footer varchar2(100);
40: l_inputs ff_exec.inputs_t;
41: l_outputs ff_exec.outputs_t;
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:

Line 176: l_inputs ff_exec.inputs_t;

172: ,p_local_nationality IN VARCHAR2) return varchar2 IS
173: l_header varchar2(100);
174: l_body varchar2(100);
175: l_footer varchar2(100);
176: l_inputs ff_exec.inputs_t;
177: l_outputs ff_exec.outputs_t;
178:
179: /*cursor c_get_name(p_payment_method_id NUMBER) is
180: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3

Line 177: l_outputs ff_exec.outputs_t;

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

Line 322: l_inputs ff_exec.inputs_t;

318: ,p_report_text10 OUT NOCOPY VARCHAR2) return varchar2 IS
319: l_header varchar2(100);
320: l_body varchar2(100);
321: l_footer varchar2(100);
322: l_inputs ff_exec.inputs_t;
323: l_outputs ff_exec.outputs_t;
324:
325: /*cursor c_get_name(p_payment_method_id NUMBER) is
326: select PMETH_INFORMATION1,PMETH_INFORMATION2,PMETH_INFORMATION3

Line 323: l_outputs ff_exec.outputs_t;

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

Line 423: ,p_inputs IN ff_exec.inputs_t

419: ----------
420: -----
421: PROCEDURE run_formula(p_formula_id IN NUMBER
422: ,p_effective_date IN DATE
423: ,p_inputs IN ff_exec.inputs_t
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

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

420: -----
421: PROCEDURE run_formula(p_formula_id IN NUMBER
422: ,p_effective_date IN DATE
423: ,p_inputs IN ff_exec.inputs_t
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);

Line 425: l_inputs ff_exec.inputs_t;

421: PROCEDURE run_formula(p_formula_id IN NUMBER
422: ,p_effective_date IN DATE
423: ,p_inputs IN ff_exec.inputs_t
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: --

Line 426: l_outputs ff_exec.outputs_t;

422: ,p_effective_date IN DATE
423: ,p_inputs IN ff_exec.inputs_t
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

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

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);
433: --
434: hr_utility.trace('after ff_exec');
435: -- Set up the input values
436: --

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

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

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

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
455: --