APPS.HRI_OLTP_DISC_WRKFRC dependencies on FF_FORMULAS_F

Line 12: g_last_formula_id ff_formulas_f.formula_id%type;

8: g_bmt_code VARCHAR2(30);
9: g_bmt_meaning VARCHAR2(80);
10:
11: g_last_bg_id per_business_groups.business_group_id%type;
12: g_last_formula_id ff_formulas_f.formula_id%type;
13: g_last_formula_name ff_formulas_f.formula_name%type;
14:
15: /* Holds value passed to Discoverer when fast formulas do not exist */
16: g_no_valid_formula number := to_number(null);

Line 13: g_last_formula_name ff_formulas_f.formula_name%type;

9: g_bmt_meaning VARCHAR2(80);
10:
11: g_last_bg_id per_business_groups.business_group_id%type;
12: g_last_formula_id ff_formulas_f.formula_id%type;
13: g_last_formula_name ff_formulas_f.formula_name%type;
14:
15: /* Holds value passed to Discoverer when fast formulas do not exist */
16: g_no_valid_formula number := to_number(null);
17: /* Holds value passed to Discoverer when fast formulas do not exist or are not compiled */

Line 28: l_formula_id ff_formulas_f.formula_id%type := 0;

24: FUNCTION get_formula_id(p_business_group_id IN NUMBER
25: ,p_formula_name IN VARCHAR2)
26: RETURN NUMBER IS
27:
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

Line 235: l_formula_id ff_formulas_f.formula_id%type;

231: l_actuals_total NUMBER := 0;
232: l_assignment_id per_all_assignments_f.assignment_id%type;
233: l_budget_type_code per_budgets.unit%type;
234: l_business_group_id per_budgets.business_group_id%type;
235: l_formula_id ff_formulas_f.formula_id%type;
236: l_grade_id per_budget_elements.grade_id%type;
237: l_job_id per_budget_elements.job_id%type;
238: l_organization_id per_budget_elements.organization_id%type;
239: l_period_end_date per_time_periods.end_date%type;

Line 587: l_formula_id ff_formulas_f.formula_id%type;

583: l_budget_type_code1 per_budgets.unit%type;
584: l_budget_type_code2 per_budgets.unit%type;
585: l_budget_type_code3 per_budgets.unit%type;
586: l_business_group_id per_budgets.business_group_id%type;
587: l_formula_id ff_formulas_f.formula_id%type;
588: l_grade_id per_budget_elements.grade_id%type;
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;

Line 1056: l_formula_id ff_formulas_f.formula_id%type;

1052: l_budget_type_code1 per_budgets.unit%type;
1053: l_budget_type_code2 per_budgets.unit%type;
1054: l_budget_type_code3 per_budgets.unit%type;
1055: l_business_group_id per_budgets.business_group_id%type;
1056: l_formula_id ff_formulas_f.formula_id%type;
1057: l_grade_id per_budget_elements.grade_id%type;
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;