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.5 2009/04/15 14:35:57 bridgway ship $ */
3:
4: PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
5: X_Book_Type_Code VARCHAR2,

Line 34: CURSOR C_dd IS SELECT rowid FROM fa_deprn_detail

30: X_set_of_books_id NUMBER ,
31: X_Calling_Fn VARCHAR2
32: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
33:
34: CURSOR C_dd IS SELECT rowid FROM fa_deprn_detail
35: WHERE distribution_id = X_Distribution_Id
36: AND book_type_code = X_Book_Type_Code
37: AND period_counter = X_Period_Counter;
38: CURSOR C_dd_mc IS SELECT rowid FROM fa_mc_deprn_detail

Line 111: INSERT INTO fa_deprn_detail(

107: end if;
108: CLOSE C_dd_mc;
109: else
110:
111: INSERT INTO fa_deprn_detail(
112: book_type_code,
113: asset_id,
114: period_counter,
115: distribution_id,

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

173:
174: EXCEPTION
175: WHEN Others THEN
176: FA_STANDARD_PKG.RAISE_ERROR
177: (Called_Fn => 'FA_DEPRN_DETAIL_PKG.Insert_Row',
178: Calling_Fn => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
179: END Insert_Row;
180:
181:

Line 228: FROM fa_deprn_detail

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

Line 422: UPDATE fa_deprn_detail

418: X_Ytd_Reval_Deprn_Expense)
419: WHERE rowid = X_Rowid;
420:
421: else
422: UPDATE fa_deprn_detail
423: SET
424: book_type_code = decode(X_Book_Type_Code,
425: NULL, book_type_code,
426: FND_API.G_MISS_CHAR, null,

Line 605: UPDATE fa_deprn_detail

601: X_Distribution_Id)
602: and set_of_books_id = X_set_of_books_id;
603:
604: else
605: UPDATE fa_deprn_detail
606: SET
607: book_type_code = decode(X_Book_Type_Code,
608: NULL, book_type_code,
609: FND_API.G_MISS_CHAR, null,

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

703: end if;
704: EXCEPTION
705: WHEN Others THEN
706: FA_STANDARD_PKG.RAISE_ERROR
707: (Called_Fn => 'FA_DEPRN_DETAIL_PKG.Update_Row',
708: Calling_Fn => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
709: END Update_Row;
710:
711:

Line 734: DELETE FROM fa_deprn_detail

730: null;
731: end if;
732: else
733: if X_Rowid is not null then
734: DELETE FROM fa_deprn_detail
735: WHERE rowid = X_Rowid;
736: elsif X_Asset_Id is not null then
737: DELETE FROM fa_deprn_detail
738: WHERE asset_id = X_Asset_Id;

Line 737: DELETE FROM fa_deprn_detail

733: if X_Rowid is not null then
734: DELETE FROM fa_deprn_detail
735: WHERE rowid = X_Rowid;
736: elsif X_Asset_Id is not null then
737: DELETE FROM fa_deprn_detail
738: WHERE asset_id = X_Asset_Id;
739: else
740: -- error message
741: null;

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

747: end if;
748: EXCEPTION
749: WHEN Others THEN
750: FA_STANDARD_PKG.RAISE_ERROR
751: (Called_Fn => 'FA_DEPRN_DETAIL_PKG.Delete_Row',
752: Calling_Fn => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
753: END Delete_Row;
754:
755:

Line 756: END FA_DEPRN_DETAIL_PKG;

752: Calling_Fn => X_Calling_Fn, p_log_level_rec => p_log_level_rec);
753: END Delete_Row;
754:
755:
756: END FA_DEPRN_DETAIL_PKG;