APPS.PAY_US_GARN_UPGRADE dependencies on FF_FORMULAS_F

Line 50: FF_FORMULAS_F.FORMULA_TEXT%TYPE

46: inputs element information with
47: the newly created special
48: inputs element information value
49: 17-Nov-2011 emunisek 115.4 13375560 Replaced Long Datatype by
50: FF_FORMULAS_F.FORMULA_TEXT%TYPE
51: *****************************************************************************/
52:
53: /************************************************************
54: ** Local Package Variables

Line 180: from ff_formulas_f

176:
177: -- Get Formula Text for modification
178: cursor c_formula_text(cp_formula_name varchar2) IS
179: select formula_text
180: from ff_formulas_f
181: where formula_name = cp_formula_name
182: and business_group_id = p_business_grp_id;
183:
184: l_formula_name varchar2(100);

Line 186: l_formula_text ff_formulas_f.formula_text%TYPE;

182: and business_group_id = p_business_grp_id;
183:
184: l_formula_name varchar2(100);
185: l_cal_formula_name varchar2(100);
186: l_formula_text ff_formulas_f.formula_text%TYPE;
187: l_new_formula_text ff_formulas_f.formula_text%TYPE;
188: BEGIN
189: hr_utility.trace('Entering ' || gv_package_name || '.modify_formula_text');
190:

Line 187: l_new_formula_text ff_formulas_f.formula_text%TYPE;

183:
184: l_formula_name varchar2(100);
185: l_cal_formula_name varchar2(100);
186: l_formula_text ff_formulas_f.formula_text%TYPE;
187: l_new_formula_text ff_formulas_f.formula_text%TYPE;
188: BEGIN
189: hr_utility.trace('Entering ' || gv_package_name || '.modify_formula_text');
190:
191: /*

Line 227: update ff_formulas_f

223: l_new_formula_text := replace(l_formula_text,
224: upper(replace(p_new_ele_name, ' ' ,'_')),
225: upper(replace(p_old_ele_name, ' ' ,'_')));
226:
227: update ff_formulas_f
228: set formula_text = l_new_formula_text
229: where formula_name = l_formula_name
230: and business_group_id = p_business_grp_id;
231:

Line 240: from ff_formulas_f

236: */
237: delete
238: from ff_compiled_info
239: where formula_id in (select formula_id
240: from ff_formulas_f
241: where formula_name in (l_formula_name,
242: l_cal_formula_name));
243: delete
244: from ff_fdi_usages

Line 246: from ff_formulas_f

242: l_cal_formula_name));
243: delete
244: from ff_fdi_usages
245: where formula_id in (select formula_id
246: from ff_formulas_f
247: where formula_name in (l_formula_name,
248: l_cal_formula_name));
249:
250: hr_utility.trace('Leaving ' || gv_package_name || '.modify_formula_text');