DBA Data[Home] [Help]

APPS.FA_RATES_PKG dependencies on FA_RATES_PKG

Line 1: PACKAGE BODY FA_RATES_PKG as

1: PACKAGE BODY FA_RATES_PKG as
2: /* $Header: faxiratb.pls 120.10 2011/03/11 02:42:57 saalampa ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 131: calling_fn => 'fa_rates_pkg.update_row', p_log_level_rec => p_log_level_rec);

127:
128: exception
129: when others then
130: fa_srvr_msg.add_sql_error(
131: calling_fn => 'fa_rates_pkg.update_row', p_log_level_rec => p_log_level_rec);
132: raise;
133:
134: end UPDATE_ROW;
135:

Line 156: calling_fn => 'fa_rates_pkg.delete_row', p_log_level_rec => p_log_level_rec);

152:
153: exception
154: when others then
155: fa_srvr_msg.add_sql_error(
156: calling_fn => 'fa_rates_pkg.delete_row', p_log_level_rec => p_log_level_rec);
157: raise;
158:
159: end DELETE_ROW;
160:

Line 202: fa_rates_pkg.update_row (

198:
199: if (h_record_exists > 0) then
200: -- Update only if a change occurred.
201: if (h_rate <> X_Rate) then
202: fa_rates_pkg.update_row (
203: X_Method_ID => X_Method_ID,
204: X_Year => X_Year,
205: X_Period_Placed_In_Service => X_Period_Placed_In_Service,
206: X_Rate => X_Rate,

Line 213: fa_rates_pkg.insert_row (

209: X_Last_Update_Login => 0
210: , p_log_level_rec => p_log_level_rec);
211: end if;
212: else
213: fa_rates_pkg.insert_row (
214: X_Rowid => row_id,
215: X_Method_Id => X_Method_Id,
216: X_Year => X_Year,
217: X_Period_Placed_In_Service => X_Period_Placed_In_Service,

Line 231: calling_fn => 'fa_rates_pkg.load_row', p_log_level_rec => p_log_level_rec);

227: exception
228: when others then
229:
230: fa_srvr_msg.add_sql_error(
231: calling_fn => 'fa_rates_pkg.load_row', p_log_level_rec => p_log_level_rec);
232:
233: FA_STANDARD_PKG.RAISE_ERROR(
234: CALLED_FN => 'fa_rates_pkg.load_row',
235: CALLING_FN => 'upload fa_rates',

Line 234: CALLED_FN => 'fa_rates_pkg.load_row',

230: fa_srvr_msg.add_sql_error(
231: calling_fn => 'fa_rates_pkg.load_row', p_log_level_rec => p_log_level_rec);
232:
233: FA_STANDARD_PKG.RAISE_ERROR(
234: CALLED_FN => 'fa_rates_pkg.load_row',
235: CALLING_FN => 'upload fa_rates',
236: p_log_level_rec => p_log_level_rec);
237:
238: end LOAD_ROW;

Line 274: fa_rates_pkg.update_row (

270: if (fnd_load_util.upload_test(user_id, x_last_update_date,
271: x_db_last_updated_by, x_db_last_update_date,
272: X_CUSTOM_MODE)) then
273:
274: fa_rates_pkg.update_row (
275: X_Method_ID => X_Method_ID,
276: X_Year => X_Year,
277: X_Period_Placed_In_Service => X_Period_Placed_In_Service,
278: X_Rate => X_Rate,

Line 285: fa_rates_pkg.insert_row (

281: X_Last_Update_Login => 0
282: ,p_log_level_rec => p_log_level_rec);
283: end if;
284: else
285: fa_rates_pkg.insert_row (
286: X_Rowid => row_id,
287: X_Method_Id => X_Method_Id,
288: X_Year => X_Year,
289: X_Period_Placed_In_Service => X_Period_Placed_In_Service,

Line 303: calling_fn => 'fa_rates_pkg.load_row'

299: exception
300: when others then
301:
302: fa_srvr_msg.add_sql_error(
303: calling_fn => 'fa_rates_pkg.load_row'
304: ,p_log_level_rec => p_log_level_rec);
305:
306: FA_STANDARD_PKG.RAISE_ERROR(
307: CALLED_FN => 'fa_rates_pkg.load_row',

Line 307: CALLED_FN => 'fa_rates_pkg.load_row',

303: calling_fn => 'fa_rates_pkg.load_row'
304: ,p_log_level_rec => p_log_level_rec);
305:
306: FA_STANDARD_PKG.RAISE_ERROR(
307: CALLED_FN => 'fa_rates_pkg.load_row',
308: CALLING_FN => 'upload fa_rates'
309: ,p_log_level_rec => p_log_level_rec);
310:
311: end LOAD_ROW;

Line 364: fa_rates_pkg.LOAD_ROW (

360: else
361: h_depr_last_year_flag := FALSE;
362: end if;
363:
364: fa_rates_pkg.LOAD_ROW (
365: x_custom_mode => x_custom_mode,
366: x_method_id => h_method_id,
367: x_db_last_update_date => h_last_update_date,
368: x_db_last_updated_by => h_last_updated_by,

Line 383: calling_fn => 'fa_rates_pkg.load_seed_row');

379: calling_fn => 'update fa_flat_rates');
380:
381: fa_standard_pkg.raise_error(
382: called_fn => 'farat.lct',
383: calling_fn => 'fa_rates_pkg.load_seed_row');
384:
385: END LOAD_SEED_ROW;
386:
387: END FA_RATES_PKG;

Line 387: END FA_RATES_PKG;

383: calling_fn => 'fa_rates_pkg.load_seed_row');
384:
385: END LOAD_SEED_ROW;
386:
387: END FA_RATES_PKG;