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_DEPRN_SUMMARY_PKG dependencies on FA_DEPRN_SUMMARY

Line 1: PACKAGE BODY FA_DEPRN_SUMMARY_PKG as

1: PACKAGE BODY FA_DEPRN_SUMMARY_PKG as
2: /* $Header: faxidsb.pls 120.4 2005/07/25 10:01:27 yyoon ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Book_Type_Code VARCHAR2,

Line 30: CURSOR C_ds IS SELECT rowid FROM fa_deprn_summary

26: X_mrc_sob_type_code VARCHAR2 DEFAULT 'P',
27: X_Calling_Fn VARCHAR2,
28: p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
29:
30: CURSOR C_ds IS SELECT rowid FROM fa_deprn_summary
31: WHERE asset_id = X_Asset_Id
32: AND book_type_code = X_Book_Type_Code
33: AND period_counter = X_Period_Counter;
34:

Line 35: CURSOR C_ds_mc IS SELECT rowid FROM fa_deprn_summary_mrc_v

31: WHERE asset_id = X_Asset_Id
32: AND book_type_code = X_Book_Type_Code
33: AND period_counter = X_Period_Counter;
34:
35: CURSOR C_ds_mc IS SELECT rowid FROM fa_deprn_summary_mrc_v
36: WHERE asset_id = X_Asset_Id
37: AND book_type_code = X_Book_Type_Code
38: AND period_counter = X_Period_Counter;
39:

Line 45: INSERT INTO fa_deprn_summary_mrc_v(

41: BEGIN
42:
43: if (X_mrc_sob_type_code = 'R') then
44:
45: INSERT INTO fa_deprn_summary_mrc_v(
46: book_type_code,
47: asset_id,
48: deprn_run_date,
49: deprn_amount,

Line 100: INSERT INTO fa_deprn_summary(

96: end if;
97: CLOSE C_ds_mc;
98:
99: else
100: INSERT INTO fa_deprn_summary(
101: book_type_code,
102: asset_id,
103: deprn_run_date,
104: deprn_amount,

Line 160: CALLED_FN => 'fa_deprn_summary_pkg.insert_row',

156:
157: exception
158: when others then
159: FA_STANDARD_PKG.RAISE_ERROR(
160: CALLED_FN => 'fa_deprn_summary_pkg.insert_row',
161: CALLING_FN => X_Calling_Fn
162: ,p_log_level_rec => p_log_level_rec);
163:
164: END Insert_Row;

Line 208: FROM fa_deprn_summary

204: reval_reserve,
205: ytd_production,
206: ytd_reval_deprn_expense,
207: prior_fy_expense
208: FROM fa_deprn_summary
209: WHERE rowid = X_Rowid
210: FOR UPDATE of Asset_Id NOWAIT;
211: Recinfo C%ROWTYPE;
212:

Line 304: UPDATE fa_deprn_summary_mrc_v

300: if (X_rowid is not null) then
301:
302: if (X_mrc_sob_type_code = 'R') then
303:
304: UPDATE fa_deprn_summary_mrc_v
305: SET
306: book_type_code = decode(X_Book_Type_Code,
307: NULL, book_type_code,
308: FND_API.G_MISS_CHAR, null,

Line 393: UPDATE fa_deprn_summary

389: WHERE rowid = X_Rowid;
390:
391: else
392:
393: UPDATE fa_deprn_summary
394: SET
395: book_type_code = decode(X_Book_Type_Code,
396: NULL, book_type_code,
397: FND_API.G_MISS_CHAR, null,

Line 486: UPDATE fa_deprn_summary_mrc_v

482:
483: else -- rowid is null (use asset,book,pc)
484:
485: if (X_mrc_sob_type_code = 'R') then
486: UPDATE fa_deprn_summary_mrc_v
487: SET
488: book_type_code = decode(X_Book_Type_Code,
489: NULL, book_type_code,
490: FND_API.G_MISS_CHAR, null,

Line 578: UPDATE fa_deprn_summary

574: and period_counter = X_Period_Counter;
575:
576: else
577:
578: UPDATE fa_deprn_summary
579: SET
580: book_type_code = decode(X_Book_Type_Code,
581: NULL, book_type_code,
582: FND_API.G_MISS_CHAR, null,

Line 678: calling_fn => 'fa_deprn_summary_pkg.update_row'

674:
675: exception
676: when others then
677: fa_srvr_msg.add_sql_error(
678: calling_fn => 'fa_deprn_summary_pkg.update_row'
679: ,p_log_level_rec => p_log_level_rec);
680: raise;
681:
682: END Update_Row;

Line 696: DELETE FROM fa_deprn_summary_mrc_v

692: BEGIN
693:
694: if (X_mrc_sob_type_code = 'R') then
695: if X_Rowid is not null then
696: DELETE FROM fa_deprn_summary_mrc_v
697: WHERE rowid = X_Rowid;
698: elsif X_Asset_Id is not null then
699: DELETE FROM fa_deprn_summary_mrc_v
700: WHERE asset_id = X_Asset_Id;

Line 699: DELETE FROM fa_deprn_summary_mrc_v

695: if X_Rowid is not null then
696: DELETE FROM fa_deprn_summary_mrc_v
697: WHERE rowid = X_Rowid;
698: elsif X_Asset_Id is not null then
699: DELETE FROM fa_deprn_summary_mrc_v
700: WHERE asset_id = X_Asset_Id;
701: else
702: -- print error message
703: null;

Line 707: DELETE FROM fa_deprn_summary

703: null;
704: end if;
705: else
706: if X_Rowid is not null then
707: DELETE FROM fa_deprn_summary
708: WHERE rowid = X_Rowid;
709: elsif X_Asset_Id is not null then
710: DELETE FROM fa_deprn_summary
711: WHERE asset_id = X_Asset_Id;

Line 710: DELETE FROM fa_deprn_summary

706: if X_Rowid is not null then
707: DELETE FROM fa_deprn_summary
708: WHERE rowid = X_Rowid;
709: elsif X_Asset_Id is not null then
710: DELETE FROM fa_deprn_summary
711: WHERE asset_id = X_Asset_Id;
712: else
713: -- print error message
714: null;

Line 726: CALLED_FN => 'fa_deprn_summary_pkg.delete_row',

722:
723: exception
724: when others then
725: FA_STANDARD_PKG.RAISE_ERROR(
726: CALLED_FN => 'fa_deprn_summary_pkg.delete_row',
727: CALLING_FN => X_Calling_Fn
728: ,p_log_level_rec => p_log_level_rec);
729:
730: END Delete_Row;

Line 889: FROM fa_deprn_summary

885: reval_reserve,
886: ytd_production,
887: ytd_reval_deprn_expense,
888: prior_fy_expense
889: FROM fa_deprn_summary
890: WHERE Book_Type_Code = nvl(X_Book_Type_Code, Book_Type_Code)
891: AND Asset_Id = X_Asset_Id
892: AND Deprn_Source_Code = 'BOOKS'
893: FOR UPDATE of Asset_Id NOWAIT;

Line 935: CALLED_FN => 'fa_deprn_summary_pkg.lock_b_row',

931: CLOSE C_DeprnSummary;
932: EXCEPTION
933: when app_exception.record_lock_exception then
934: FA_STANDARD_PKG.RAISE_ERROR(
935: CALLED_FN => 'fa_deprn_summary_pkg.lock_b_row',
936: CALLING_FN => X_Calling_Fn,
937: NAME => 'FA_SHARED_ASSETS_LOCKED'
938: ,p_log_level_rec => p_log_level_rec);
939: when others then

Line 941: CALLED_FN => 'fa_deprn_summary_pkg.lock_b_row',

937: NAME => 'FA_SHARED_ASSETS_LOCKED'
938: ,p_log_level_rec => p_log_level_rec);
939: when others then
940: FA_STANDARD_PKG.RAISE_ERROR(
941: CALLED_FN => 'fa_deprn_summary_pkg.lock_b_row',
942: CALLING_FN => X_Calling_Fn
943: ,p_log_level_rec => p_log_level_rec);
944: END Lock_B_Row;
945:

Line 956: CALLED_FN => 'fa_deprn_summary_pkg.unlock_b_row',

952:
953: EXCEPTION
954: when others then
955: FA_STANDARD_PKG.RAISE_ERROR(
956: CALLED_FN => 'fa_deprn_summary_pkg.unlock_b_row',
957: CALLING_FN => X_Calling_Fn
958: ,p_log_level_rec => p_log_level_rec);
959: END UnLock_B_Row;
960:

Line 961: END FA_DEPRN_SUMMARY_PKG;

957: CALLING_FN => X_Calling_Fn
958: ,p_log_level_rec => p_log_level_rec);
959: END UnLock_B_Row;
960:
961: END FA_DEPRN_SUMMARY_PKG;