APPS.BEN_PD_FORMULA_PKG dependencies on FF_FORMULAS_F

Line 10: DELETE FROM ff_formulas_f

6: PROCEDURE remove_formula_from_FF
7: ( p_formula_name in varchar2) is
8:
9: begin
10: DELETE FROM ff_formulas_f
11: WHERE formula_name = p_formula_name;
12: exception
13: when no_data_found then
14: -- No record found to be deleted.

Line 36: CURSOR ffRow IS SELECT rowId FROM ff_formulas_f

32: l_rowid varchar2(255);
33: l_formula_name varchar2(255);
34: l_lastUpdateDate date;
35:
36: CURSOR ffRow IS SELECT rowId FROM ff_formulas_f
37: WHERE formula_id = p_formula_id
38: and p_effective_start_date between effective_start_date and effective_end_date;
39:
40: BEGIN

Line 48: ff_formulas_f_pkg.insert_row(

44: select ff_formulas_s.nextval
45: into l_formula_id
46: from sys.dual;
47:
48: ff_formulas_f_pkg.insert_row(
49: x_rowid => l_rowid,
50: x_formula_id => l_formula_id,
51: x_effective_start_date => p_effective_start_date,
52: x_effective_end_date => p_effective_end_date,

Line 68: ff_formulas_f_pkg.update_row(

64: open ffRow;
65: Fetch ffRow into l_rowid;
66: close ffRow;
67:
68: ff_formulas_f_pkg.update_row(
69: x_rowid => l_rowid,
70: x_formula_id => l_formula_id,
71: x_effective_start_date => p_effective_start_date,
72: x_effective_end_date => p_effective_end_date,

Line 114: ff_formulas_f_pkg.insert_row(

110: select ff_formulas_s.nextval
111: into l_formula_id
112: from sys.dual;
113:
114: ff_formulas_f_pkg.insert_row(
115: x_rowid => l_rowid,
116: x_formula_id => l_formula_id,
117: x_effective_start_date => sysdate,
118: x_effective_end_date => hr_general.end_of_time,

Line 130: ff_formulas_f_pkg.update_row(

126: x_last_update_date => l_lastUpdateDate
127: );
128: else -- Formula Already created, now update it instead
129: l_formula_id := r_fff.ff_formula_id;
130: ff_formulas_f_pkg.update_row(
131: x_rowid => l_rowid,
132: x_formula_id => l_formula_id,
133: x_effective_start_date => sysdate,
134: x_effective_end_date => hr_general.end_of_time,

Line 255: from ff_formulas_f

251: RESULT_TYPE_CD,
252: OBJECT_VERSION_NUMBER,
253: INFORMATION325)
254: select -999999, -999999, 'COPY_FF',1, formula_text--to_lob(formula_text) AMN: Bug 13563529
255: from ff_formulas_f
256: where formula_id = p_formula_id
257: and p_effective_start_date between effective_start_date and effective_end_date;
258:
259: select information325 into l_clob from ben_copy_entity_results

Line 287: FROM ff_formulas_f

283: /*
284: --Cursor to fetch formula details
285: CURSOR c_formula IS
286: SELECT effective_start_date, effective_end_date
287: FROM ff_formulas_f
288: WHERE formula_id = p_formula_id
289: AND business_group_id = p_business_group_id
290: AND TRUNC(p_effective_date) BETWEEN effective_start_date AND effective_end_date;
291: */

Line 377: from ff_formulas_f

373: declare
374: l_rowid varchar2(100);
375: begin
376: select rowid into l_rowid
377: from ff_formulas_f
378: where formula_id = p_formula_id
379: and p_effective_date between effective_start_date and effective_end_date;
380:
381: ff_formulas_f_pkg.delete_row(

Line 381: ff_formulas_f_pkg.delete_row(

377: from ff_formulas_f
378: where formula_id = p_formula_id
379: and p_effective_date between effective_start_date and effective_end_date;
380:
381: ff_formulas_f_pkg.delete_row(
382: x_rowid => l_rowid,
383: x_formula_id => p_formula_id,
384: x_dt_delete_mode => 'DELETE',
385: x_validation_start_date => p_effective_date,