[Home] [Help]
PACKAGE: APPS.FA_DEPRN_SUMMARY_PKG
Source
1 PACKAGE FA_DEPRN_SUMMARY_PKG AUTHID CURRENT_USER as
2 /* $Header: faxidss.pls 120.8 2010/12/22 12:42:56 gigupta ship $ */
3
4
5 PROCEDURE Insert_Row(X_Rowid IN OUT NOCOPY VARCHAR2,
6 X_Book_Type_Code VARCHAR2,
7 X_Asset_Id NUMBER,
8 X_Deprn_Run_Date DATE,
9 X_Deprn_Amount NUMBER,
10 X_Ytd_Deprn NUMBER,
11 X_Deprn_Reserve NUMBER,
12 X_Deprn_Source_Code VARCHAR2,
13 X_Adjusted_Cost NUMBER,
14 X_Bonus_Rate NUMBER DEFAULT NULL,
15 X_Ltd_Production NUMBER DEFAULT NULL,
16 X_Period_Counter NUMBER,
17 X_Production NUMBER DEFAULT NULL,
18 X_Reval_Amortization NUMBER DEFAULT NULL,
19 X_Reval_Amortization_Basis NUMBER DEFAULT NULL,
20 X_Reval_Deprn_Expense NUMBER DEFAULT NULL,
21 X_Reval_Reserve NUMBER DEFAULT NULL,
22 X_Reval_loss_balance NUMBER DEFAULT NULL,
23 X_Ytd_Production NUMBER DEFAULT NULL,
24 X_Ytd_Reval_Deprn_Expense NUMBER DEFAULT NULL,
25 X_Bonus_Deprn_Amount NUMBER DEFAULT NULL,
26 X_Bonus_Ytd_Deprn NUMBER DEFAULT NULL,
27 X_Bonus_Deprn_Reserve NUMBER DEFAULT NULL,
28 X_Impairment_Amount NUMBER DEFAULT NULL,
29 X_Ytd_Impairment NUMBER DEFAULT NULL,
30 X_impairment_reserve NUMBER DEFAULT NULL,
31 X_mrc_sob_type_code VARCHAR2 DEFAULT 'P',
32 X_set_of_books_id NUMBER ,
33 X_Calling_Fn VARCHAR2
34 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
35
36 PROCEDURE Lock_Row(X_Rowid VARCHAR2,
37 X_Book_Type_Code VARCHAR2,
38 X_Asset_Id NUMBER,
39 X_Deprn_Run_Date DATE,
40 X_Deprn_Amount NUMBER,
41 X_Ytd_Deprn NUMBER,
42 X_Deprn_Reserve NUMBER,
43 X_Deprn_Source_Code VARCHAR2,
44 X_Adjusted_Cost NUMBER,
45 X_Bonus_Rate NUMBER DEFAULT NULL,
46 X_Ltd_Production NUMBER DEFAULT NULL,
47 X_Period_Counter NUMBER,
48 X_Production NUMBER DEFAULT NULL,
49 X_Reval_Amortization NUMBER DEFAULT NULL,
50 X_Reval_Amortization_Basis NUMBER DEFAULT NULL,
51 X_Reval_Deprn_Expense NUMBER DEFAULT NULL,
52 X_Reval_Reserve NUMBER DEFAULT NULL,
53 X_Ytd_Production NUMBER DEFAULT NULL,
54 X_Ytd_Reval_Deprn_Expense NUMBER DEFAULT NULL,
55 X_Calling_Fn VARCHAR2
56 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
57
58
59
60 PROCEDURE Update_Row(X_Rowid VARCHAR2 DEFAULT NULL,
61 X_Book_Type_Code VARCHAR2 DEFAULT NULL,
62 X_Asset_Id NUMBER DEFAULT NULL,
63 X_Deprn_Run_Date DATE DEFAULT NULL,
64 X_Deprn_Amount NUMBER DEFAULT NULL,
65 X_Ytd_Deprn NUMBER DEFAULT NULL,
66 X_Deprn_Reserve NUMBER DEFAULT NULL,
67 X_Deprn_Source_Code VARCHAR2 DEFAULT NULL,
68 X_Adjusted_Cost NUMBER DEFAULT NULL,
69 X_Bonus_Rate NUMBER DEFAULT NULL,
70 X_Ltd_Production NUMBER DEFAULT NULL,
71 X_Period_Counter NUMBER DEFAULT NULL,
72 X_Production NUMBER DEFAULT NULL,
73 X_Reval_Amortization NUMBER DEFAULT NULL,
74 X_Reval_Amortization_Basis NUMBER DEFAULT NULL,
75 X_Reval_Deprn_Expense NUMBER DEFAULT NULL,
76 X_Reval_Reserve NUMBER DEFAULT NULL,
77 X_Ytd_Production NUMBER DEFAULT NULL,
78 X_Ytd_Reval_Deprn_Expense NUMBER DEFAULT NULL,
79 X_Bonus_Deprn_Amount NUMBER DEFAULT NULL,
80 X_Bonus_Ytd_Deprn NUMBER DEFAULT NULL,
81 X_Bonus_Deprn_Reserve NUMBER DEFAULT NULL,
82 X_Impairment_Amount NUMBER DEFAULT NULL,
83 X_Ytd_Impairment NUMBER DEFAULT NULL,
84 X_impairment_reserve NUMBER DEFAULT NULL,
85 X_mrc_sob_type_code VARCHAR2 DEFAULT 'P',
86 X_set_of_books_id NUMBER ,
87 X_Calling_Fn VARCHAR2
88 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
89
90 PROCEDURE Delete_Row(X_Rowid VARCHAR2 DEFAULT NULL,
91 X_Asset_Id NUMBER DEFAULT NULL,
92 X_mrc_sob_type_code VARCHAR2 DEFAULT 'P',
93 X_set_of_books_id NUMBER ,
94 X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
95
96 PROCEDURE Lock_B_Row(X_Book_Type_Code VARCHAR2 DEFAULT NULL,
97 X_Asset_Id NUMBER,
98 X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
99
100 PROCEDURE UnLock_B_Row(X_Calling_Fn VARCHAR2, p_log_level_rec IN FA_API_TYPES.log_level_rec_type);
101
102 END FA_DEPRN_SUMMARY_PKG;