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_ITC_RATES_PKG dependencies on FA_ITC_RATES

Line 1: PACKAGE BODY FA_ITC_RATES_PKG as

1: PACKAGE BODY FA_ITC_RATES_PKG as
2: /* $Header: faxiitcb.pls 120.8 2009/04/10 07:44:21 deemitta ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 34: CURSOR C is SELECT rowid FROM fa_itc_rates

30: X_LAST_UPDATED_BY in NUMBER,
31: X_LAST_UPDATE_LOGIN in NUMBER
32: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
33:
34: CURSOR C is SELECT rowid FROM fa_itc_rates
35: WHERE itc_amount_id = X_Itc_Amount_Id;
36:
37: begin
38:

Line 39: INSERT INTO fa_itc_rates (

35: WHERE itc_amount_id = X_Itc_Amount_Id;
36:
37: begin
38:
39: INSERT INTO fa_itc_rates (
40: itc_amount_id,
41: tax_year,
42: life_in_months,
43: itc_amount_rate,

Line 106: calling_fn => 'fa_itc_rates_pkg.insert_row', p_log_level_rec => p_log_level_rec);

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

Line 156: FROM fa_itc_rates

152: attribute13,
153: attribute14,
154: attribute15,
155: attribute_category_code
156: FROM fa_itc_rates
157: WHERE itc_amount_id = X_Itc_Amount_Id
158: FOR UPDATE of itc_amount_id NOWAIT;
159: Recinfo C%ROWTYPE;
160:

Line 262: UPDATE fa_itc_rates

258: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
259:
260: begin
261:
262: UPDATE fa_itc_rates
263: SET itc_amount_id = X_Itc_Amount_Id,
264: tax_year = X_Tax_Year,
265: life_in_months = X_Life_In_Months,
266: itc_amount_rate = X_Itc_Amount_Rate,

Line 296: calling_fn => 'fa_itc_rates_pkg.update_row', p_log_level_rec => p_log_level_rec);

292:
293: exception
294: when others then
295: fa_srvr_msg.add_sql_error(
296: calling_fn => 'fa_itc_rates_pkg.update_row', p_log_level_rec => p_log_level_rec);
297: raise;
298:
299: end UPDATE_ROW;
300:

Line 307: DELETE FROM fa_itc_rates

303: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
304:
305: begin
306:
307: DELETE FROM fa_itc_rates
308: WHERE itc_amount_id = X_Itc_Amount_Id;
309:
310: if (SQL%NOTFOUND) then
311: Raise NO_DATA_FOUND;

Line 317: calling_fn => 'fa_itc_rates_pkg.delete_row', p_log_level_rec => p_log_level_rec);

313:
314: exception
315: when others then
316: fa_srvr_msg.add_sql_error(
317: calling_fn => 'fa_itc_rates_pkg.delete_row', p_log_level_rec => p_log_level_rec);
318: raise;
319:
320: end DELETE_ROW;
321:

Line 362: from fa_itc_rates

358: end if;
359:
360: select count(*)
361: into h_record_exists
362: from fa_itc_rates
363: where itc_amount_id = X_Itc_Amount_Id;
364:
365: if (h_record_exists > 0) then
366: fa_itc_rates_pkg.update_row (

Line 366: fa_itc_rates_pkg.update_row (

362: from fa_itc_rates
363: where itc_amount_id = X_Itc_Amount_Id;
364:
365: if (h_record_exists > 0) then
366: fa_itc_rates_pkg.update_row (
367: X_Itc_Amount_Id => X_Itc_Amount_Id,
368: X_Tax_Year => X_Tax_Year,
369: X_Life_In_Months => X_Life_In_Months,
370: X_Itc_Amount_Rate => X_Itc_Amount_Rate,

Line 393: fa_itc_rates_pkg.insert_row (

389: X_Last_Updated_By => user_id,
390: X_Last_Update_Login => 0
391: , p_log_level_rec => p_log_level_rec);
392: else
393: fa_itc_rates_pkg.insert_row (
394: X_Rowid => row_id,
395: X_Itc_Amount_Id => X_Itc_Amount_Id,
396: X_Tax_Year => X_Tax_Year,
397: X_Life_In_Months => X_Life_In_Months,

Line 427: CALLED_FN => 'fa_itc_rates_pkg.load_row',

423:
424: exception
425: when others then
426: FA_STANDARD_PKG.RAISE_ERROR(
427: CALLED_FN => 'fa_itc_rates_pkg.load_row',
428: CALLING_FN => 'upload fa_itc_rates', p_log_level_rec => p_log_level_rec);
429:
430: end LOAD_ROW;
431:

Line 428: CALLING_FN => 'upload fa_itc_rates', p_log_level_rec => p_log_level_rec);

424: exception
425: when others then
426: FA_STANDARD_PKG.RAISE_ERROR(
427: CALLED_FN => 'fa_itc_rates_pkg.load_row',
428: CALLING_FN => 'upload fa_itc_rates', p_log_level_rec => p_log_level_rec);
429:
430: end LOAD_ROW;
431:
432: /*Bug 8355119 overloading function for release specific signatures*/

Line 475: from fa_itc_rates

471: user_id := fnd_load_util.owner_id (X_Owner);
472:
473: select count(*)
474: into h_record_exists
475: from fa_itc_rates
476: where itc_amount_id = X_Itc_Amount_Id;
477:
478: if (h_record_exists > 0) then
479:

Line 482: from fa_itc_rates

478: if (h_record_exists > 0) then
479:
480: select last_updated_by, last_update_date
481: into db_last_updated_by, db_last_update_date
482: from fa_itc_rates
483: where itc_amount_id = X_Itc_Amount_Id;
484:
485: if (fnd_load_util.upload_test(user_id, x_last_update_date,
486: db_last_updated_by, db_last_update_date,

Line 489: fa_itc_rates_pkg.update_row (

485: if (fnd_load_util.upload_test(user_id, x_last_update_date,
486: db_last_updated_by, db_last_update_date,
487: X_CUSTOM_MODE)) then
488:
489: fa_itc_rates_pkg.update_row (
490: X_Itc_Amount_Id => X_Itc_Amount_Id,
491: X_Tax_Year => X_Tax_Year,
492: X_Life_In_Months => X_Life_In_Months,
493: X_Itc_Amount_Rate => X_Itc_Amount_Rate,

Line 517: fa_itc_rates_pkg.insert_row (

513: X_Last_Update_Login => 0
514: ,p_log_level_rec => p_log_level_rec);
515: end if;
516: else
517: fa_itc_rates_pkg.insert_row (
518: X_Rowid => row_id,
519: X_Itc_Amount_Id => X_Itc_Amount_Id,
520: X_Tax_Year => X_Tax_Year,
521: X_Life_In_Months => X_Life_In_Months,

Line 551: CALLED_FN => 'fa_itc_rates_pkg.load_row',

547:
548: exception
549: when others then
550: FA_STANDARD_PKG.RAISE_ERROR(
551: CALLED_FN => 'fa_itc_rates_pkg.load_row',
552: CALLING_FN => 'upload fa_itc_rates'
553: ,p_log_level_rec => p_log_level_rec);
554:
555: end LOAD_ROW;

Line 552: CALLING_FN => 'upload fa_itc_rates'

548: exception
549: when others then
550: FA_STANDARD_PKG.RAISE_ERROR(
551: CALLED_FN => 'fa_itc_rates_pkg.load_row',
552: CALLING_FN => 'upload fa_itc_rates'
553: ,p_log_level_rec => p_log_level_rec);
554:
555: end LOAD_ROW;
556:

Line 591: fa_itc_rates_pkg.LOAD_ROW (

587:
588: if (x_upload_mode = 'NLS') then
589: null;
590: else
591: fa_itc_rates_pkg.LOAD_ROW (
592: x_custom_mode => x_custom_mode,
593: x_itc_amount_id => x_itc_amount_id,
594: x_owner => x_owner,
595: x_last_update_date => x_last_update_date,

Line 620: END FA_ITC_RATES_PKG;

616: end if;
617:
618: END LOAD_SEED_ROW;
619:
620: END FA_ITC_RATES_PKG;