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_RATES_PKG dependencies on FA_RATES

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 17: CURSOR C is SELECT rowid FROM fa_rates

13: X_LAST_UPDATED_BY in NUMBER,
14: X_LAST_UPDATE_LOGIN in NUMBER
15: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
16:
17: CURSOR C is SELECT rowid FROM fa_rates
18: where method_id = X_Method_Id
19: and year = X_Year
20: and period_placed_in_service = X_Period_Placed_In_Service;
21:

Line 23: ad_zd_seed.prepare('fa_rates');

19: and year = X_Year
20: and period_placed_in_service = X_Period_Placed_In_Service;
21:
22: begin
23: ad_zd_seed.prepare('fa_rates');
24: INSERT INTO fa_rates (
25: method_id,
26: year,
27: period_placed_in_service,

Line 24: INSERT INTO fa_rates (

20: and period_placed_in_service = X_Period_Placed_In_Service;
21:
22: begin
23: ad_zd_seed.prepare('fa_rates');
24: INSERT INTO fa_rates (
25: method_id,
26: year,
27: period_placed_in_service,
28: rate,

Line 57: calling_fn => 'fa_rates.insert_row', p_log_level_rec => p_log_level_rec);

53:
54: exception
55: when others then
56: fa_srvr_msg.add_sql_error(
57: calling_fn => 'fa_rates.insert_row', p_log_level_rec => p_log_level_rec);
58: raise;
59:
60: end INSERT_ROW;
61:

Line 73: FROM fa_rates

69: SELECT method_id,
70: year,
71: period_placed_in_service,
72: rate
73: FROM fa_rates
74: where method_id = X_Method_Id
75: and year = X_Year
76: and period_placed_in_service = X_Period_Placed_In_Service
77: FOR UPDATE of method_id, year, period_placed_in_service NOWAIT;

Line 115: ad_zd_seed.prepare('fa_rates');

111: X_LAST_UPDATE_LOGIN in NUMBER
112: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
113:
114: begin
115: ad_zd_seed.prepare('fa_rates');
116: UPDATE fa_rates
117: SET method_id = X_Method_ID,
118: year = X_Year,
119: period_placed_in_service= X_Period_Placed_In_Service,

Line 116: UPDATE fa_rates

112: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
113:
114: begin
115: ad_zd_seed.prepare('fa_rates');
116: UPDATE fa_rates
117: SET method_id = X_Method_ID,
118: year = X_Year,
119: period_placed_in_service= X_Period_Placed_In_Service,
120: rate = X_Rate,

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 143: ad_zd_seed.prepare('fa_rates');

139: X_PERIOD_PLACED_IN_SERVICE in NUMBER
140: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
141:
142: begin
143: ad_zd_seed.prepare('fa_rates');
144: DELETE FROM fa_rates
145: where method_id = X_Method_Id
146: and year = X_Year
147: and period_placed_in_service = X_Period_Placed_In_Service;

Line 144: DELETE FROM fa_rates

140: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
141:
142: begin
143: ad_zd_seed.prepare('fa_rates');
144: DELETE FROM fa_rates
145: where method_id = X_Method_Id
146: and year = X_Year
147: and period_placed_in_service = X_Period_Placed_In_Service;
148:

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 187: from fa_rates

183: begin
184:
185: select rate
186: into h_rate
187: from fa_rates
188: where method_id = X_Method_ID
189: and year = X_Year
190: and period_placed_in_service = X_Period_Placed_In_Service;
191:

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 235: CALLING_FN => 'upload fa_rates',

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;
239: /*Bug 8355119 overloading function for release specific signatures*/

Line 263: from fa_rates

259: user_id := fnd_load_util.owner_id (X_Owner);
260:
261: select count(*)
262: into h_record_exists
263: from fa_rates
264: where method_id = X_Method_ID
265: and year = X_Year
266: and period_placed_in_service = X_Period_Placed_In_Service;
267:

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 308: CALLING_FN => 'upload fa_rates'

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;
312: /*bug 8355119 adding R12 specific funtion LOAD_SEED_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;