eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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.13.12020000.2 2012/07/19 12:35:37 dvjoshi 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) 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', p_log_level_rec => p_log_level_rec);

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

Line 86: FROM fa_formulas

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

Line 133: UPDATE fa_formulas

129: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
130:
131: begin
132:
133: UPDATE fa_formulas
134: SET formula_actual = X_Formula_Actual,
135: formula_displayed = X_Formula_Displayed,
136: formula_parsed = X_Formula_Parsed,
137: last_update_date = X_Last_Update_Date,

Line 148: calling_fn => 'fa_formulas_pkg.update_row', p_log_level_rec => p_log_level_rec);

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

Line 159: DELETE FROM fa_formulas

155: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
156:
157: begin
158:
159: DELETE FROM fa_formulas
160: where method_id = X_Method_Id;
161:
162: if (SQL%NOTFOUND) then
163: Raise NO_DATA_FOUND;

Line 169: calling_fn => 'fa_formulas_pkg.delete_row', p_log_level_rec => p_log_level_rec);

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

Line 201: from fa_formulas

197: end if;
198:
199: select count(*)
200: into h_record_exists
201: from fa_formulas
202: where method_id = X_Method_ID;
203:
204: if (h_record_exists > 0) then
205: fa_formulas_pkg.update_row (

Line 205: fa_formulas_pkg.update_row (

201: from fa_formulas
202: where method_id = X_Method_ID;
203:
204: if (h_record_exists > 0) then
205: fa_formulas_pkg.update_row (
206: X_Method_ID => X_Method_ID,
207: X_Formula_Actual => X_Formula_Actual,
208: X_Formula_Displayed => X_Formula_Displayed,
209: X_Formula_Parsed => X_Formula_Parsed,

Line 218: fa_formulas_pkg.insert_row (

214: X_Revised_Rate => X_Revised_Rate,
215: X_Guarantee_Rate => X_Guarantee_Rate
216: , p_log_level_rec => p_log_level_rec);
217: else
218: fa_formulas_pkg.insert_row (
219: X_Rowid => row_id,
220: X_Method_ID => X_Method_ID,
221: X_Formula_Actual => X_Formula_Actual,
222: X_Formula_Displayed => X_Formula_Displayed,

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

234:
235: exception
236: when others then
237: FA_STANDARD_PKG.RAISE_ERROR(
238: CALLED_FN => 'fa_formulas_pkg.load_row',
239: CALLING_FN => 'upload fa_formulas', p_log_level_rec => p_log_level_rec);
240:
241: end LOAD_ROW;
242:

Line 239: CALLING_FN => 'upload fa_formulas', p_log_level_rec => p_log_level_rec);

235: exception
236: when others then
237: FA_STANDARD_PKG.RAISE_ERROR(
238: CALLED_FN => 'fa_formulas_pkg.load_row',
239: CALLING_FN => 'upload fa_formulas', p_log_level_rec => p_log_level_rec);
240:
241: end LOAD_ROW;
242:
243: procedure LOAD_ROW (

Line 269: from fa_formulas

265: user_id := fnd_load_util.owner_id (X_Owner);
266:
267: select count(*)
268: into h_record_exists
269: from fa_formulas
270: where method_id = X_Method_ID;
271:
272: if (h_record_exists > 0) then
273: if (fnd_load_util.upload_test(user_id, x_last_update_date,

Line 277: fa_formulas_pkg.update_row (

273: if (fnd_load_util.upload_test(user_id, x_last_update_date,
274: x_db_last_updated_by,x_db_last_update_date,
275: X_CUSTOM_MODE)) then
276:
277: fa_formulas_pkg.update_row (
278: X_Method_ID => X_Method_ID,
279: X_Formula_Actual => X_Formula_Actual,
280: X_Formula_Displayed => X_Formula_Displayed,
281: X_Formula_Parsed => X_Formula_Parsed,

Line 292: fa_formulas_pkg.insert_row (

288: ,p_log_level_rec => p_log_level_rec);
289: end if;
290: else
291:
292: fa_formulas_pkg.insert_row (
293: X_Rowid => row_id,
294: X_Method_ID => X_Method_ID,
295: X_Formula_Actual => X_Formula_Actual,
296: X_Formula_Displayed => X_Formula_Displayed,

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

309: exception
310: when others then
311:
312: FA_STANDARD_PKG.RAISE_ERROR(
313: CALLED_FN => 'fa_formulas_pkg.load_row',
314: CALLING_FN => 'upload fa_formulas'
315: ,p_log_level_rec => p_log_level_rec);
316:
317: end LOAD_ROW;

Line 314: CALLING_FN => 'upload fa_formulas'

310: when others then
311:
312: FA_STANDARD_PKG.RAISE_ERROR(
313: CALLED_FN => 'fa_formulas_pkg.load_row',
314: CALLING_FN => 'upload fa_formulas'
315: ,p_log_level_rec => p_log_level_rec);
316:
317: end LOAD_ROW;
318:

Line 374: fa_formulas_pkg.LOAD_ROW (

370: else
371: h_depr_last_year_flag := FALSE;
372: end if;
373:
374: fa_formulas_pkg.LOAD_ROW (
375: x_custom_mode => x_custom_mode,
376: x_method_id => h_method_id,
377: x_db_last_update_date => h_last_update_date,
378: x_db_last_updated_by => h_last_updated_by,

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

389: EXCEPTION
390: WHEN methods_err THEN
391:
392: fa_srvr_msg.add_sql_error(
393: calling_fn => 'update fa_formulas');
394:
395: fa_standard_pkg.raise_error(
396: called_fn => 'farat.lct',
397: calling_fn => 'fa_formulas_pkg.load_seed_row');

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

393: calling_fn => 'update fa_formulas');
394:
395: fa_standard_pkg.raise_error(
396: called_fn => 'farat.lct',
397: calling_fn => 'fa_formulas_pkg.load_seed_row');
398:
399: END LOAD_SEED_ROW;
400:
401: END FA_FORMULAS_PKG;

Line 401: END FA_FORMULAS_PKG;

397: calling_fn => 'fa_formulas_pkg.load_seed_row');
398:
399: END LOAD_SEED_ROW;
400:
401: END FA_FORMULAS_PKG;