DBA Data[Home] [Help]

APPS.BEN_PD_FORMULA_PKG dependencies on FF_FORMULAS_F_PKG

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 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,