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_FLAT_RATES_PKG dependencies on FA_FLAT_RATES

Line 1: PACKAGE BODY FA_FLAT_RATES_PKG as

1: PACKAGE BODY FA_FLAT_RATES_PKG as
2: /* $Header: faxiflrb.pls 120.10.12020000.2 2012/07/19 12:33:18 dvjoshi ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 33: CURSOR C is SELECT rowid FROM fa_flat_rates

29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER
31: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
32:
33: CURSOR C is SELECT rowid FROM fa_flat_rates
34: where method_id = X_Method_Id
35: and basic_rate = X_Basic_Rate
36: and adjusted_rate = X_Adjusted_Rate;
37:

Line 40: INSERT INTO fa_flat_rates (

36: and adjusted_rate = X_Adjusted_Rate;
37:
38: begin
39:
40: INSERT INTO fa_flat_rates (
41: method_id,
42: basic_rate,
43: adjusted_rate,
44: adjusting_rate,

Line 105: calling_fn => 'fa_flat_rates_pkg.insert_row', p_log_level_rec => p_log_level_rec);

101:
102: exception
103: when others then
104: fa_srvr_msg.add_sql_error(
105: calling_fn => 'fa_flat_rates_pkg.insert_row', p_log_level_rec => p_log_level_rec);
106: raise;
107:
108: end INSERT_ROW;
109:

Line 153: FROM fa_flat_rates

149: attribute13,
150: attribute14,
151: attribute15,
152: attribute_category_code
153: FROM fa_flat_rates
154: where method_id = X_Method_Id
155: and basic_rate = X_Basic_Rate
156: and adjusted_rate = X_Adjusted_Rate
157: FOR UPDATE of method_id, basic_rate, adjusted_rate NOWAIT;

Line 257: UPDATE fa_flat_rates

253: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
254:
255: begin
256:
257: UPDATE fa_flat_rates
258: SET method_id = X_Method_ID,
259: basic_rate = X_Basic_Rate,
260: adjusted_rate = X_Adjusted_Rate,
261: adjusting_rate = X_Adjusting_Rate,

Line 288: calling_fn => 'fa_flat_rates_pkg.update_row', p_log_level_rec => p_log_level_rec);

284:
285: exception
286: when others then
287: fa_srvr_msg.add_sql_error(
288: calling_fn => 'fa_flat_rates_pkg.update_row', p_log_level_rec => p_log_level_rec);
289: raise;
290:
291: end UPDATE_ROW;
292:

Line 301: DELETE FROM fa_flat_rates

297: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
298:
299: begin
300:
301: DELETE FROM fa_flat_rates
302: where method_id = X_Method_Id
303: and basic_rate = X_Basic_Rate
304: and adjusted_rate = X_Adjusted_Rate;
305:

Line 313: calling_fn => 'fa_flat_rates_pkg.delete_row', p_log_level_rec => p_log_level_rec);

309:
310: exception
311: when others then
312: fa_srvr_msg.add_sql_error(
313: calling_fn => 'fa_flat_rates_pkg.delete_row', p_log_level_rec => p_log_level_rec);
314: raise;
315:
316: end DELETE_ROW;
317:

Line 357: from fa_flat_rates fr

353: end if;
354:
355: select count(*)
356: into h_record_exists
357: from fa_flat_rates fr
358: where fr.method_id = X_Method_Id
359: and fr.basic_rate = X_Basic_Rate
360: and fr.adjusted_rate = X_Adjusted_Rate;
361:

Line 363: fa_flat_rates_pkg.update_row (

359: and fr.basic_rate = X_Basic_Rate
360: and fr.adjusted_rate = X_Adjusted_Rate;
361:
362: if (h_record_exists > 0) then
363: fa_flat_rates_pkg.update_row (
364: X_Method_Id => X_Method_Id,
365: X_Basic_Rate => X_Basic_Rate,
366: X_Adjusted_Rate => X_Adjusted_Rate,
367: X_Adjusting_Rate => X_Adjusting_Rate,

Line 389: fa_flat_rates_pkg.insert_row (

385: X_Last_Updated_By => user_id,
386: X_Last_Update_Login => 0
387: , p_log_level_rec => p_log_level_rec);
388: else
389: fa_flat_rates_pkg.insert_row (
390: X_Rowid => row_id,
391: X_Method_Id => X_Method_Id,
392: X_Basic_Rate => X_Basic_Rate,
393: X_Adjusted_Rate => X_Adjusted_Rate,

Line 422: CALLED_FN => 'fa_flat_rates_pkg.load_row',

418:
419: exception
420: when others then
421: FA_STANDARD_PKG.RAISE_ERROR(
422: CALLED_FN => 'fa_flat_rates_pkg.load_row',
423: CALLING_FN => 'upload fa_flat_rates', p_log_level_rec => p_log_level_rec);
424:
425: end LOAD_ROW;
426: /*Bug 8355119 overloading function for release specific signatures*/

Line 423: CALLING_FN => 'upload fa_flat_rates', p_log_level_rec => p_log_level_rec);

419: exception
420: when others then
421: FA_STANDARD_PKG.RAISE_ERROR(
422: CALLED_FN => 'fa_flat_rates_pkg.load_row',
423: CALLING_FN => 'upload fa_flat_rates', p_log_level_rec => p_log_level_rec);
424:
425: end LOAD_ROW;
426: /*Bug 8355119 overloading function for release specific signatures*/
427: procedure LOAD_ROW (

Line 466: from fa_flat_rates fr

462: user_id := fnd_load_util.owner_id (X_Owner);
463:
464: select count(*)
465: into h_record_exists
466: from fa_flat_rates fr
467: where fr.method_id = X_Method_Id
468: and fr.basic_rate = X_Basic_Rate
469: and fr.adjusted_rate = X_Adjusted_Rate;
470:

Line 476: fa_flat_rates_pkg.update_row (

472: if (fnd_load_util.upload_test(user_id, x_last_update_date,
473: x_db_last_updated_by,x_db_last_update_date,
474: X_CUSTOM_MODE )) then
475:
476: fa_flat_rates_pkg.update_row (
477: X_Method_Id => X_Method_Id,
478: X_Basic_Rate => X_Basic_Rate,
479: X_Adjusted_Rate => X_Adjusted_Rate,
480: X_Adjusting_Rate => X_Adjusting_Rate,

Line 505: fa_flat_rates_pkg.insert_row (

501: end if;
502:
503: else
504:
505: fa_flat_rates_pkg.insert_row (
506: X_Rowid => row_id,
507: X_Method_Id => X_Method_Id,
508: X_Basic_Rate => X_Basic_Rate,
509: X_Adjusted_Rate => X_Adjusted_Rate,

Line 538: CALLED_FN => 'fa_flat_rates_pkg.load_row',

534:
535: exception
536: when others then
537: FA_STANDARD_PKG.RAISE_ERROR(
538: CALLED_FN => 'fa_flat_rates_pkg.load_row',
539: CALLING_FN => 'upload fa_flat_rates'
540: ,p_log_level_rec => p_log_level_rec);
541:
542: end LOAD_ROW;

Line 539: CALLING_FN => 'upload fa_flat_rates'

535: exception
536: when others then
537: FA_STANDARD_PKG.RAISE_ERROR(
538: CALLED_FN => 'fa_flat_rates_pkg.load_row',
539: CALLING_FN => 'upload fa_flat_rates'
540: ,p_log_level_rec => p_log_level_rec);
541:
542: end LOAD_ROW;
543:

Line 614: fa_flat_rates_pkg.LOAD_ROW (

610: else
611: h_depr_last_year_flag := FALSE;
612: end if;
613:
614: fa_flat_rates_pkg.LOAD_ROW (
615: x_custom_mode => x_custom_mode,
616: x_method_id => h_method_id,
617: x_db_last_update_date => h_last_update_date,
618: x_db_last_updated_by => h_last_updated_by,

Line 652: calling_fn => 'fa_flat_rates_pkg.load_seed_row'

648: ,p_log_level_rec => p_log_level_rec);
649:
650: fa_standard_pkg.raise_error(
651: called_fn => 'farat.lct',
652: calling_fn => 'fa_flat_rates_pkg.load_seed_row'
653: ,p_log_level_rec => p_log_level_rec);
654:
655: END LOAD_SEED_ROW;
656:

Line 657: END FA_FLAT_RATES_PKG;

653: ,p_log_level_rec => p_log_level_rec);
654:
655: END LOAD_SEED_ROW;
656:
657: END FA_FLAT_RATES_PKG;