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.6 2005/07/28 00:19:56 tkawamur 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 default null) 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 24: INSERT INTO fa_rates (

20: and period_placed_in_service = X_Period_Placed_In_Service;
21:
22: begin
23:
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'

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

Line 74: FROM fa_rates

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

Line 116: UPDATE fa_rates

112: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
113:
114: begin
115:
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'

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

Line 145: DELETE FROM fa_rates

141: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) is
142:
143: begin
144:
145: DELETE FROM fa_rates
146: where method_id = X_Method_Id
147: and year = X_Year
148: and period_placed_in_service = X_Period_Placed_In_Service;
149:

Line 157: calling_fn => 'fa_rates_pkg.delete_row'

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

Line 186: from fa_rates

182: user_id := fnd_load_util.owner_id (X_Owner);
183:
184: select count(*)
185: into h_record_exists
186: from fa_rates
187: where method_id = X_Method_ID
188: and year = X_Year
189: and period_placed_in_service = X_Period_Placed_In_Service;
190:

Line 197: fa_rates_pkg.update_row (

193: if (fnd_load_util.upload_test(user_id, x_last_update_date,
194: x_db_last_updated_by, x_db_last_update_date,
195: X_CUSTOM_MODE)) then
196:
197: fa_rates_pkg.update_row (
198: X_Method_ID => X_Method_ID,
199: X_Year => X_Year,
200: X_Period_Placed_In_Service => X_Period_Placed_In_Service,
201: X_Rate => X_Rate,

Line 208: fa_rates_pkg.insert_row (

204: X_Last_Update_Login => 0
205: ,p_log_level_rec => p_log_level_rec);
206: end if;
207: else
208: fa_rates_pkg.insert_row (
209: X_Rowid => row_id,
210: X_Method_Id => X_Method_Id,
211: X_Year => X_Year,
212: X_Period_Placed_In_Service => X_Period_Placed_In_Service,

Line 226: calling_fn => 'fa_rates_pkg.load_row'

222: exception
223: when others then
224:
225: fa_srvr_msg.add_sql_error(
226: calling_fn => 'fa_rates_pkg.load_row'
227: ,p_log_level_rec => p_log_level_rec);
228:
229: FA_STANDARD_PKG.RAISE_ERROR(
230: CALLED_FN => 'fa_rates_pkg.load_row',

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

226: calling_fn => 'fa_rates_pkg.load_row'
227: ,p_log_level_rec => p_log_level_rec);
228:
229: FA_STANDARD_PKG.RAISE_ERROR(
230: CALLED_FN => 'fa_rates_pkg.load_row',
231: CALLING_FN => 'upload fa_rates'
232: ,p_log_level_rec => p_log_level_rec);
233:
234: end LOAD_ROW;

Line 231: CALLING_FN => 'upload fa_rates'

227: ,p_log_level_rec => p_log_level_rec);
228:
229: FA_STANDARD_PKG.RAISE_ERROR(
230: CALLED_FN => 'fa_rates_pkg.load_row',
231: CALLING_FN => 'upload fa_rates'
232: ,p_log_level_rec => p_log_level_rec);
233:
234: end LOAD_ROW;
235:

Line 287: fa_rates_pkg.LOAD_ROW (

283: else
284: h_depr_last_year_flag := FALSE;
285: end if;
286:
287: fa_rates_pkg.LOAD_ROW (
288: x_custom_mode => x_custom_mode,
289: x_method_id => h_method_id,
290: x_db_last_update_date => h_last_update_date,
291: x_db_last_updated_by => h_last_updated_by,

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

302: calling_fn => 'update fa_flat_rates');
303:
304: fa_standard_pkg.raise_error(
305: called_fn => 'farat.lct',
306: calling_fn => 'fa_rates_pkg.load_seed_row');
307:
308: END LOAD_SEED_ROW;
309:
310: END FA_RATES_PKG;

Line 310: END FA_RATES_PKG;

306: calling_fn => 'fa_rates_pkg.load_seed_row');
307:
308: END LOAD_SEED_ROW;
309:
310: END FA_RATES_PKG;