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_RECAPTURE_RATES_PKG dependencies on FA_ITC_RECAPTURE_RATES

Line 1: PACKAGE BODY FA_ITC_RECAPTURE_RATES_PKG as

1: PACKAGE BODY FA_ITC_RECAPTURE_RATES_PKG as
2: /* $Header: faxiitrb.pls 120.6 2005/07/28 00:20:21 tkawamur ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 34: CURSOR C is SELECT rowid FROM fa_itc_recapture_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 default null) is
33: /*
34: CURSOR C is SELECT rowid FROM fa_itc_recapture_rates
35: WHERE itc_recapture_id = X_Itc_Recapture_Id;
36: */
37: begin
38:

Line 39: INSERT INTO fa_itc_recapture_rates (

35: WHERE itc_recapture_id = X_Itc_Recapture_Id;
36: */
37: begin
38:
39: INSERT INTO fa_itc_recapture_rates (
40: itc_recapture_id,
41: tax_year,
42: life_in_months,
43: year_of_retirement,

Line 106: calling_fn => 'fa_itc_recapture_rates_pkg.insert_row'

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

Line 157: FROM fa_itc_recapture_rates

153: attribute13,
154: attribute14,
155: attribute15,
156: attribute_category_code
157: FROM fa_itc_recapture_rates
158: WHERE itc_recapture_id = X_Itc_Recapture_Id
159: FOR UPDATE of itc_recapture_id NOWAIT;
160: Recinfo C%ROWTYPE;
161:

Line 263: UPDATE fa_itc_recapture_rates

259: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
260:
261: begin
262:
263: UPDATE fa_itc_recapture_rates
264: SET itc_recapture_id = X_Itc_Recapture_Id,
265: tax_year = X_Tax_Year,
266: life_in_months = X_Life_In_Months,
267: year_of_retirement = X_Year_Of_Retirement,

Line 297: calling_fn => 'fa_itc_recapture_rates_pkg.update_row'

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

Line 309: DELETE FROM fa_itc_recapture_rates

305: ,p_log_level_rec in fa_api_types.log_level_rec_type default null) is
306:
307: begin
308:
309: DELETE FROM fa_itc_recapture_rates
310: WHERE itc_recapture_id = X_Itc_Recapture_Id;
311:
312: if (SQL%NOTFOUND) then
313: Raise NO_DATA_FOUND;

Line 319: calling_fn => 'fa_itc_recapture_rates_pkg.delete_row'

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

Line 366: from fa_itc_recapture_rates

362: user_id := fnd_load_util.owner_id (X_Owner);
363:
364: select count(*)
365: into h_record_exists
366: from fa_itc_recapture_rates
367: where itc_recapture_id = X_Itc_Recapture_Id;
368:
369: if (h_record_exists > 0) then
370:

Line 373: from fa_itc_recapture_rates

369: if (h_record_exists > 0) then
370:
371: select last_updated_by, last_update_date
372: into db_last_updated_by, db_last_update_date
373: from fa_itc_recapture_rates
374: where itc_recapture_id = X_Itc_Recapture_Id;
375:
376: if (fnd_load_util.upload_test(user_id, x_last_update_date,
377: db_last_updated_by, db_last_update_date,

Line 380: fa_itc_recapture_rates_pkg.update_row (

376: if (fnd_load_util.upload_test(user_id, x_last_update_date,
377: db_last_updated_by, db_last_update_date,
378: X_CUSTOM_MODE)) then
379:
380: fa_itc_recapture_rates_pkg.update_row (
381: X_Itc_Recapture_Id => X_Itc_Recapture_Id,
382: X_Tax_Year => X_Tax_Year,
383: X_Life_In_Months => X_Life_In_Months,
384: X_Year_Of_Retirement => X_Year_Of_Retirement,

Line 408: fa_itc_recapture_rates_pkg.insert_row (

404: X_Last_Update_Login => 0
405: ,p_log_level_rec => p_log_level_rec);
406: end if;
407: else
408: fa_itc_recapture_rates_pkg.insert_row (
409: X_Rowid => row_id,
410: X_Itc_Recapture_Id => X_Itc_Recapture_Id,
411: X_Tax_Year => X_Tax_Year,
412: X_Life_In_Months => X_Life_In_Months,

Line 442: CALLED_FN => 'fa_itc_recapture_rates_pkg.load_row',

438:
439: exception
440: when others then
441: FA_STANDARD_PKG.RAISE_ERROR(
442: CALLED_FN => 'fa_itc_recapture_rates_pkg.load_row',
443: CALLING_FN => 'upload fa_itc_recapture_rates'
444: ,p_log_level_rec => p_log_level_rec);
445:
446: end LOAD_ROW;

Line 443: CALLING_FN => 'upload fa_itc_recapture_rates'

439: exception
440: when others then
441: FA_STANDARD_PKG.RAISE_ERROR(
442: CALLED_FN => 'fa_itc_recapture_rates_pkg.load_row',
443: CALLING_FN => 'upload fa_itc_recapture_rates'
444: ,p_log_level_rec => p_log_level_rec);
445:
446: end LOAD_ROW;
447:

Line 481: fa_itc_recapture_rates_pkg.LOAD_ROW (

477:
478: if (x_upload_mode = 'NLS') then
479: null;
480: else
481: fa_itc_recapture_rates_pkg.LOAD_ROW (
482: x_custom_mode => x_custom_mode,
483: x_itc_recapture_id => x_itc_recapture_id,
484: x_owner => x_owner,
485: x_last_update_date => x_last_update_date,

Line 510: END FA_ITC_RECAPTURE_RATES_PKG;

506: end if;
507:
508: END LOAD_SEED_ROW;
509:
510: END FA_ITC_RECAPTURE_RATES_PKG;