28: l_formula_id ff_formulas_f.formula_id%type := 0;
29:
30: CURSOR customer_formula_csr IS
31: SELECT formula_id
32: FROM ff_formulas_x
33: WHERE formula_name = 'BUDGET_' || p_formula_name
34: AND business_group_id = p_business_group_id;
35:
36: CURSOR template_formula_csr IS
34: AND business_group_id = p_business_group_id;
35:
36: CURSOR template_formula_csr IS
37: SELECT formula_id
38: FROM ff_formulas_x
39: WHERE formula_name = 'TEMPLATE_' || p_formula_name
40: AND business_group_id IS NULL;
41:
42: BEGIN
589: l_job_id per_budget_elements.job_id%type;
590: l_organization_id per_budget_elements.organization_id%type;
591: l_period_end_date per_time_periods.end_date%type;
592: l_position_id per_budget_elements.position_id%type;
593: p_formula_id ff_formulas_x.formula_id%type;
594:
595: BEGIN
596:
597: -- Return zero if any of the mandatory input parameters is null
1058: l_job_id per_budget_elements.job_id%type;
1059: l_organization_id per_budget_elements.organization_id%type;
1060: l_period_end_date per_time_periods.end_date%type;
1061: l_position_id per_budget_elements.position_id%type;
1062: p_formula_id ff_formulas_x.formula_id%type;
1063:
1064: BEGIN
1065:
1066: