APPS.HR_ES_UTILITY dependencies on FF_EXEC

Line 393: l_inputs ff_exec.inputs_t;

389: -- PROCEDURE validate_cif
390: --------------------------------------------------------------------------------
391: PROCEDURE validate_cif(p_org_info VARCHAR2) is
392:
393: l_inputs ff_exec.inputs_t;
394: l_outputs ff_exec.outputs_t;
395: l_formula_id ff_formulas_f.formula_id%type;
396: l_formula_mesg varchar2(50);
397: l_effective_start_date ff_formulas_f.effective_start_date%type;

Line 394: l_outputs ff_exec.outputs_t;

390: --------------------------------------------------------------------------------
391: PROCEDURE validate_cif(p_org_info VARCHAR2) is
392:
393: l_inputs ff_exec.inputs_t;
394: l_outputs ff_exec.outputs_t;
395: l_formula_id ff_formulas_f.formula_id%type;
396: l_formula_mesg varchar2(50);
397: l_effective_start_date ff_formulas_f.effective_start_date%type;
398:

Line 412: ff_exec.init_formula(l_formula_id, l_effective_start_date, l_inputs, l_outputs);

408: OPEN get_formula_id;
409: FETCH get_formula_id INTO l_formula_id, l_effective_start_date;
410: CLOSE get_formula_id;
411:
412: ff_exec.init_formula(l_formula_id, l_effective_start_date, l_inputs, l_outputs);
413: FOR l_in_cnt IN l_inputs.first..l_inputs.LAST LOOP
414: IF l_inputs(l_in_cnt).name = 'CIF_NUMBER' THEN
415: l_inputs(l_in_cnt).value := p_org_info;
416: END IF;

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

415: l_inputs(l_in_cnt).value := p_org_info;
416: END IF;
417: END LOOP;
418:
419: ff_exec.run_formula(l_inputs,l_outputs);
420:
421: FOR l_out_cnt IN l_outputs.first..l_outputs.LAST LOOP
422: IF l_outputs(l_out_cnt).name = 'RETURN_VALUE' THEN
423: l_formula_mesg := l_outputs(l_out_cnt).value;

Line 459: l_inputs ff_exec.inputs_t;

455: -- PROCEDURE validate_cac
456: --------------------------------------------------------------------------------
457: PROCEDURE validate_cac(p_org_info VARCHAR2) is
458:
459: l_inputs ff_exec.inputs_t;
460: l_outputs ff_exec.outputs_t;
461: l_formula_id ff_formulas_f.formula_id%type;
462: l_formula_mesg varchar2(50);
463: l_effective_start_date ff_formulas_f.effective_start_date%type;

Line 460: l_outputs ff_exec.outputs_t;

456: --------------------------------------------------------------------------------
457: PROCEDURE validate_cac(p_org_info VARCHAR2) is
458:
459: l_inputs ff_exec.inputs_t;
460: l_outputs ff_exec.outputs_t;
461: l_formula_id ff_formulas_f.formula_id%type;
462: l_formula_mesg varchar2(50);
463: l_effective_start_date ff_formulas_f.effective_start_date%type;
464:

Line 478: ff_exec.init_formula(l_formula_id, l_effective_start_date, l_inputs, l_outputs);

474: OPEN get_formula_id;
475: FETCH get_formula_id INTO l_formula_id, l_effective_start_date;
476: CLOSE get_formula_id;
477:
478: ff_exec.init_formula(l_formula_id, l_effective_start_date, l_inputs, l_outputs);
479: FOR l_in_cnt IN l_inputs.first..l_inputs.LAST LOOP
480: IF l_inputs(l_in_cnt).name = 'CAC_NUMBER' THEN
481: l_inputs(l_in_cnt).value := p_org_info;
482: END IF;

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

481: l_inputs(l_in_cnt).value := p_org_info;
482: END IF;
483: END LOOP;
484:
485: ff_exec.run_formula(l_inputs,l_outputs);
486:
487: FOR l_out_cnt IN l_outputs.first..l_outputs.LAST LOOP
488: IF l_outputs(l_out_cnt).name = 'RETURN_VALUE' THEN
489: l_formula_mesg := l_outputs(l_out_cnt).value;