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_DETAIL_PKG dependencies on FA_DEPRN_DETAIL

Line 1: PACKAGE BODY FA_DEPRN_DETAIL_PKG as

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

Line 33: CURSOR C_dd IS SELECT rowid FROM fa_deprn_detail

29: X_mrc_sob_type_code VARCHAR2 DEFAULT 'P',
30: X_Calling_Fn VARCHAR2,
31: p_log_level_rec in fa_api_types.log_level_rec_type default null) IS
32:
33: CURSOR C_dd IS SELECT rowid FROM fa_deprn_detail
34: WHERE distribution_id = X_Distribution_Id
35: AND book_type_code = X_Book_Type_Code
36: AND period_counter = X_Period_Counter;
37: CURSOR C_dd_mc IS SELECT rowid FROM fa_deprn_detail

Line 37: CURSOR C_dd_mc IS SELECT rowid FROM fa_deprn_detail

33: CURSOR C_dd IS SELECT rowid FROM fa_deprn_detail
34: WHERE distribution_id = X_Distribution_Id
35: AND book_type_code = X_Book_Type_Code
36: AND period_counter = X_Period_Counter;
37: CURSOR C_dd_mc IS SELECT rowid FROM fa_deprn_detail
38: WHERE distribution_id = X_Distribution_Id
39: AND book_type_code = X_Book_Type_Code
40: AND period_counter = X_Period_Counter;
41:

Line 46: INSERT INTO fa_deprn_detail_mrc_v(

42: BEGIN
43:
44: if (X_mrc_sob_type_code = 'R') then
45:
46: INSERT INTO fa_deprn_detail_mrc_v(
47: book_type_code,
48: asset_id,
49: period_counter,
50: distribution_id,

Line 107: INSERT INTO fa_deprn_detail(

103: end if;
104: CLOSE C_dd_mc;
105: else
106:
107: INSERT INTO fa_deprn_detail(
108: book_type_code,
109: asset_id,
110: period_counter,
111: distribution_id,

Line 173: (Called_Fn => 'FA_DEPRN_DETAIL_PKG.Insert_Row',

169:
170: EXCEPTION
171: WHEN Others THEN
172: FA_STANDARD_PKG.RAISE_ERROR
173: (Called_Fn => 'FA_DEPRN_DETAIL_PKG.Insert_Row',
174: Calling_Fn => X_Calling_Fn
175: ,p_log_level_rec => p_log_level_rec);
176: END Insert_Row;
177:

Line 225: FROM fa_deprn_detail

221: reval_amortization,
222: reval_deprn_expense,
223: reval_reserve,
224: ytd_reval_deprn_expense
225: FROM fa_deprn_detail
226: WHERE rowid = X_Rowid
227: FOR UPDATE of Distribution_Id NOWAIT;
228: Recinfo C%ROWTYPE;
229:

Line 330: UPDATE fa_deprn_detail_mrc_v

326:
327: if (X_rowid is not null) then
328:
329: if (X_mrc_sob_type_code = 'R') then
330: UPDATE fa_deprn_detail_mrc_v
331: SET
332: book_type_code = decode(X_Book_Type_Code,
333: NULL, book_type_code,
334: FND_API.G_MISS_CHAR, null,

Line 418: UPDATE fa_deprn_detail

414: X_Ytd_Reval_Deprn_Expense)
415: WHERE rowid = X_Rowid;
416:
417: else
418: UPDATE fa_deprn_detail
419: SET
420: book_type_code = decode(X_Book_Type_Code,
421: NULL, book_type_code,
422: FND_API.G_MISS_CHAR, null,

Line 507: UPDATE fa_deprn_detail_mrc_v

503: WHERE rowid = X_Rowid;
504: end if;
505: else
506: if (X_mrc_sob_type_code = 'R') then
507: UPDATE fa_deprn_detail_mrc_v
508: SET
509: book_type_code = decode(X_Book_Type_Code,
510: NULL, book_type_code,
511: FND_API.G_MISS_CHAR, null,

Line 600: UPDATE fa_deprn_detail

596: NULL, distribution_id,
597: X_Distribution_Id);
598:
599: else
600: UPDATE fa_deprn_detail
601: SET
602: book_type_code = decode(X_Book_Type_Code,
603: NULL, book_type_code,
604: FND_API.G_MISS_CHAR, null,

Line 702: (Called_Fn => 'FA_DEPRN_DETAIL_PKG.Update_Row',

698: end if;
699: EXCEPTION
700: WHEN Others THEN
701: FA_STANDARD_PKG.RAISE_ERROR
702: (Called_Fn => 'FA_DEPRN_DETAIL_PKG.Update_Row',
703: Calling_Fn => X_Calling_Fn
704: ,p_log_level_rec => p_log_level_rec);
705: END Update_Row;
706:

Line 718: DELETE FROM fa_deprn_detail_mrc_v

714: BEGIN
715:
716: if (X_mrc_sob_type_code = 'R') then
717: if X_Rowid is not null then
718: DELETE FROM fa_deprn_detail_mrc_v
719: WHERE rowid = X_Rowid;
720: elsif X_Asset_Id is not null then
721: DELETE FROM fa_deprn_detail_mrc_v
722: WHERE asset_id = X_Asset_Id;

Line 721: DELETE FROM fa_deprn_detail_mrc_v

717: if X_Rowid is not null then
718: DELETE FROM fa_deprn_detail_mrc_v
719: WHERE rowid = X_Rowid;
720: elsif X_Asset_Id is not null then
721: DELETE FROM fa_deprn_detail_mrc_v
722: WHERE asset_id = X_Asset_Id;
723: else
724: -- error message
725: null;

Line 729: DELETE FROM fa_deprn_detail

725: null;
726: end if;
727: else
728: if X_Rowid is not null then
729: DELETE FROM fa_deprn_detail
730: WHERE rowid = X_Rowid;
731: elsif X_Asset_Id is not null then
732: DELETE FROM fa_deprn_detail
733: WHERE asset_id = X_Asset_Id;

Line 732: DELETE FROM fa_deprn_detail

728: if X_Rowid is not null then
729: DELETE FROM fa_deprn_detail
730: WHERE rowid = X_Rowid;
731: elsif X_Asset_Id is not null then
732: DELETE FROM fa_deprn_detail
733: WHERE asset_id = X_Asset_Id;
734: else
735: -- error message
736: null;

Line 746: (Called_Fn => 'FA_DEPRN_DETAIL_PKG.Delete_Row',

742: end if;
743: EXCEPTION
744: WHEN Others THEN
745: FA_STANDARD_PKG.RAISE_ERROR
746: (Called_Fn => 'FA_DEPRN_DETAIL_PKG.Delete_Row',
747: Calling_Fn => X_Calling_Fn
748: ,p_log_level_rec => p_log_level_rec);
749: END Delete_Row;
750:

Line 752: END FA_DEPRN_DETAIL_PKG;

748: ,p_log_level_rec => p_log_level_rec);
749: END Delete_Row;
750:
751:
752: END FA_DEPRN_DETAIL_PKG;