APPS.FA_FORMULAS_PKG dependencies on FA_FORMULAS

Line 1: PACKAGE BODY FA_FORMULAS_PKG as

1: PACKAGE BODY FA_FORMULAS_PKG as
2: /* $Header: faxiforb.pls 120.9.12010000.1 2008/07/28 13:25:30 appldev ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 20: CURSOR C is SELECT rowid FROM fa_formulas

16: X_REVISED_RATE IN NUMBER DEFAULT NULL,
17: X_GUARANTEE_RATE IN NUMBER DEFAULT NULL,
18: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
19:
20: CURSOR C is SELECT rowid FROM fa_formulas
21: where method_id = X_Method_Id;
22:
23: begin
24:

Line 25: INSERT INTO fa_formulas (

21: where method_id = X_Method_Id;
22:
23: begin
24:
25: INSERT INTO fa_formulas (
26: method_id,
27: formula_actual,
28: formula_displayed,
29: formula_parsed,

Line 64: calling_fn => 'fa_formulas_pkg.insert_row'

60:
61: exception
62: when others then
63: fa_srvr_msg.add_sql_error(
64: calling_fn => 'fa_formulas_pkg.insert_row'
65: ,p_log_level_rec => p_log_level_rec);
66: raise;
67:
68: end INSERT_ROW;

Line 87: FROM fa_formulas

83: formula_parsed,
84: original_rate,
85: revised_rate,
86: guarantee_rate
87: FROM fa_formulas
88: where method_id = X_Method_Id
89: FOR UPDATE of method_id NOWAIT;
90: Recinfo C%ROWTYPE;
91:

Line 134: UPDATE fa_formulas

130: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
131:
132: begin
133:
134: UPDATE fa_formulas
135: SET method_id = X_Method_ID,
136: formula_actual = X_Formula_Actual,
137: formula_displayed = X_Formula_Displayed,
138: formula_parsed = X_Formula_Parsed,

Line 150: calling_fn => 'fa_formulas_pkg.update_row'

146:
147: exception
148: when others then
149: fa_srvr_msg.add_sql_error(
150: calling_fn => 'fa_formulas_pkg.update_row'
151: ,p_log_level_rec => p_log_level_rec);
152: raise;
153:
154: end UPDATE_ROW;

Line 162: DELETE FROM fa_formulas

158: ,p_log_level_rec in fa_api_types.log_level_rec_type default null) is
159:
160: begin
161:
162: DELETE FROM fa_formulas
163: where method_id = X_Method_Id;
164:
165: if (SQL%NOTFOUND) then
166: Raise NO_DATA_FOUND;

Line 172: calling_fn => 'fa_formulas_pkg.delete_row'

168:
169: exception
170: when others then
171: fa_srvr_msg.add_sql_error(
172: calling_fn => 'fa_formulas_pkg.delete_row'
173: ,p_log_level_rec => p_log_level_rec);
174: raise;
175:
176: end DELETE_ROW;

Line 204: from fa_formulas

200: user_id := fnd_load_util.owner_id (X_Owner);
201:
202: select count(*)
203: into h_record_exists
204: from fa_formulas
205: where method_id = X_Method_ID;
206:
207: if (h_record_exists > 0) then
208: if (fnd_load_util.upload_test(user_id, x_last_update_date,

Line 212: fa_formulas_pkg.update_row (

208: if (fnd_load_util.upload_test(user_id, x_last_update_date,
209: x_db_last_updated_by,x_db_last_update_date,
210: X_CUSTOM_MODE)) then
211:
212: fa_formulas_pkg.update_row (
213: X_Method_ID => X_Method_ID,
214: X_Formula_Actual => X_Formula_Actual,
215: X_Formula_Displayed => X_Formula_Displayed,
216: X_Formula_Parsed => X_Formula_Parsed,

Line 227: fa_formulas_pkg.insert_row (

223: ,p_log_level_rec => p_log_level_rec);
224: end if;
225: else
226:
227: fa_formulas_pkg.insert_row (
228: X_Rowid => row_id,
229: X_Method_ID => X_Method_ID,
230: X_Formula_Actual => X_Formula_Actual,
231: X_Formula_Displayed => X_Formula_Displayed,

Line 248: CALLED_FN => 'fa_formulas_pkg.load_row',

244: exception
245: when others then
246:
247: FA_STANDARD_PKG.RAISE_ERROR(
248: CALLED_FN => 'fa_formulas_pkg.load_row',
249: CALLING_FN => 'upload fa_formulas'
250: ,p_log_level_rec => p_log_level_rec);
251:
252: end LOAD_ROW;

Line 249: CALLING_FN => 'upload fa_formulas'

245: when others then
246:
247: FA_STANDARD_PKG.RAISE_ERROR(
248: CALLED_FN => 'fa_formulas_pkg.load_row',
249: CALLING_FN => 'upload fa_formulas'
250: ,p_log_level_rec => p_log_level_rec);
251:
252: end LOAD_ROW;
253:

Line 309: fa_formulas_pkg.LOAD_ROW (

305: else
306: h_depr_last_year_flag := FALSE;
307: end if;
308:
309: fa_formulas_pkg.LOAD_ROW (
310: x_custom_mode => x_custom_mode,
311: x_method_id => h_method_id,
312: x_db_last_update_date => h_last_update_date,
313: x_db_last_updated_by => h_last_updated_by,

Line 328: calling_fn => 'update fa_formulas');

324: EXCEPTION
325: WHEN methods_err THEN
326:
327: fa_srvr_msg.add_sql_error(
328: calling_fn => 'update fa_formulas');
329:
330: fa_standard_pkg.raise_error(
331: called_fn => 'farat.lct',
332: calling_fn => 'fa_formulas_pkg.load_seed_row');

Line 332: calling_fn => 'fa_formulas_pkg.load_seed_row');

328: calling_fn => 'update fa_formulas');
329:
330: fa_standard_pkg.raise_error(
331: called_fn => 'farat.lct',
332: calling_fn => 'fa_formulas_pkg.load_seed_row');
333:
334: END LOAD_SEED_ROW;
335:
336: END FA_FORMULAS_PKG;

Line 336: END FA_FORMULAS_PKG;

332: calling_fn => 'fa_formulas_pkg.load_seed_row');
333:
334: END LOAD_SEED_ROW;
335:
336: END FA_FORMULAS_PKG;