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.8 2009/04/10 07:45:19 deemitta 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) 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', 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_recapture_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_recapture_rates

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

Line 263: UPDATE fa_itc_recapture_rates

259: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) 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', p_log_level_rec => p_log_level_rec);

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

Line 308: DELETE FROM fa_itc_recapture_rates

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

Line 318: calling_fn => 'fa_itc_recapture_rates_pkg.delete_row', p_log_level_rec => p_log_level_rec);

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

Line 363: from fa_itc_recapture_rates

359: end if;
360:
361: select count(*)
362: into h_record_exists
363: from fa_itc_recapture_rates
364: where itc_recapture_id = X_Itc_Recapture_Id;
365:
366: if (h_record_exists > 0) then
367: fa_itc_recapture_rates_pkg.update_row (

Line 367: fa_itc_recapture_rates_pkg.update_row (

363: from fa_itc_recapture_rates
364: where itc_recapture_id = X_Itc_Recapture_Id;
365:
366: if (h_record_exists > 0) then
367: fa_itc_recapture_rates_pkg.update_row (
368: X_Itc_Recapture_Id => X_Itc_Recapture_Id,
369: X_Tax_Year => X_Tax_Year,
370: X_Life_In_Months => X_Life_In_Months,
371: X_Year_Of_Retirement => X_Year_Of_Retirement,

Line 394: fa_itc_recapture_rates_pkg.insert_row (

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

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

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

Line 429: CALLING_FN => 'upload fa_itc_recapture_rates', p_log_level_rec => p_log_level_rec);

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

Line 474: from fa_itc_recapture_rates

470: user_id := fnd_load_util.owner_id (X_Owner);
471:
472: select count(*)
473: into h_record_exists
474: from fa_itc_recapture_rates
475: where itc_recapture_id = X_Itc_Recapture_Id;
476:
477: if (h_record_exists > 0) then
478:

Line 481: from fa_itc_recapture_rates

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

Line 488: fa_itc_recapture_rates_pkg.update_row (

484: if (fnd_load_util.upload_test(user_id, x_last_update_date,
485: db_last_updated_by, db_last_update_date,
486: X_CUSTOM_MODE)) then
487:
488: fa_itc_recapture_rates_pkg.update_row (
489: X_Itc_Recapture_Id => X_Itc_Recapture_Id,
490: X_Tax_Year => X_Tax_Year,
491: X_Life_In_Months => X_Life_In_Months,
492: X_Year_Of_Retirement => X_Year_Of_Retirement,

Line 516: fa_itc_recapture_rates_pkg.insert_row (

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

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

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

Line 551: CALLING_FN => 'upload fa_itc_recapture_rates'

547: exception
548: when others then
549: FA_STANDARD_PKG.RAISE_ERROR(
550: CALLED_FN => 'fa_itc_recapture_rates_pkg.load_row',
551: CALLING_FN => 'upload fa_itc_recapture_rates'
552: ,p_log_level_rec => p_log_level_rec);
553:
554: end LOAD_ROW;
555: /*bug 8355119 adding R12 specific funtion LOAD_SEED_ROW*/

Line 589: fa_itc_recapture_rates_pkg.LOAD_ROW (

585:
586: if (x_upload_mode = 'NLS') then
587: null;
588: else
589: fa_itc_recapture_rates_pkg.LOAD_ROW (
590: x_custom_mode => x_custom_mode,
591: x_itc_recapture_id => x_itc_recapture_id,
592: x_owner => x_owner,
593: x_last_update_date => x_last_update_date,

Line 618: END FA_ITC_RECAPTURE_RATES_PKG;

614: end if;
615:
616: END LOAD_SEED_ROW;
617:
618: END FA_ITC_RECAPTURE_RATES_PKG;