[Home] [Help]
PACKAGE BODY: APPS.FA_MASS_CHG_UTILS_PKG
Source
1 PACKAGE BODY FA_MASS_CHG_UTILS_PKG AS
2 /* $Header: FAXMCUTB.pls 120.4 2009/03/27 04:07:14 bridgway ship $ */
3
4
5 /*===========================================================================+
6 | PROCEDURE Insert_Itf |
7 +============================================================================*/
8
9 PROCEDURE Insert_Itf(
10 X_Report_Type IN VARCHAR2,
11 X_Request_Id IN NUMBER,
12 X_Mass_Change_Id IN NUMBER,
13 X_Asset_Rec IN ASSET_REC_TYPE,
14 X_Last_Update_Date IN DATE,
15 X_Last_Updated_By IN NUMBER,
16 X_Created_By IN NUMBER,
17 X_Creation_Date IN DATE,
18 X_Last_Update_Login IN NUMBER
19 , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
20
21 BEGIN
22
23 IF (X_Report_Type = 'PREVIEW') THEN
24 INSERT INTO fa_mass_changes_itf (
25 REQUEST_ID ,
26 MASS_CHANGE_ID ,
27 ASSET_ID ,
28 ASSET_NUMBER ,
29 DESCRIPTION ,
30 ASSET_TYPE ,
31 BOOK ,
32 CATEGORY ,
33 FROM_CONVENTION ,
34 TO_CONVENTION ,
35 FROM_LIFE_IN_MONTHS ,
36 TO_LIFE_IN_MONTHS ,
37 FROM_METHOD_CODE ,
38 TO_METHOD_CODE ,
39 FROM_BASIC_RATE ,
40 TO_BASIC_RATE ,
41 FROM_ADJUSTED_RATE ,
42 TO_ADJUSTED_RATE ,
43 FROM_PRODUCTION_CAPACITY ,
44 TO_PRODUCTION_CAPACITY ,
45 FROM_BONUS_RULE ,
46 TO_BONUS_RULE ,
47 FROM_GROUP_ASSET_NUMBER ,
48 TO_GROUP_ASSET_NUMBER ,
49 last_update_date ,
50 last_updated_by ,
51 created_by ,
52 creation_date ,
53 last_update_login ,
54 FROM_SALVAGE_TYPE ,
55 TO_SALVAGE_TYPE ,
56 FROM_PERCENT_SALVAGE_VALUE ,
57 TO_PERCENT_SALVAGE_VALUE ,
58 FROM_SALVAGE_VALUE ,
59 TO_SALVAGE_VALUE ,
60 FROM_DEPRN_LIMIT_TYPE ,
61 TO_DEPRN_LIMIT_TYPE ,
62 FROM_DEPRN_LIMIT ,
63 TO_DEPRN_LIMIT ,
64 FROM_DEPRN_LIMIT_AMOUNT ,
65 TO_DEPRN_LIMIT_AMOUNT
66 ) VALUES (
67 X_REQUEST_ID ,
68 X_MASS_CHANGE_ID ,
69 X_Asset_Rec.ASSET_ID ,
70 X_Asset_Rec.ASSET_NUMBER ,
71 X_Asset_Rec.DESCRIPTION ,
72 X_Asset_Rec.ASSET_TYPE ,
73 X_Asset_Rec.BOOK_TYPE_CODE ,
74 X_Asset_Rec.CATEGORY ,
75 X_Asset_Rec.FROM_CONVENTION ,
76 X_Asset_Rec.TO_CONVENTION ,
77 X_Asset_Rec.FROM_LIFE_IN_MONTHS ,
78 X_Asset_Rec.TO_LIFE_IN_MONTHS ,
79 X_Asset_Rec.FROM_METHOD ,
80 X_Asset_Rec.TO_METHOD ,
81 X_Asset_Rec.FROM_BASIC_RATE_PCT ,
82 X_Asset_Rec.TO_BASIC_RATE_PCT ,
83 X_Asset_Rec.FROM_ADJUSTED_RATE_PCT ,
84 X_Asset_Rec.TO_ADJUSTED_RATE_PCT ,
85 X_Asset_Rec.FROM_CAPACITY ,
86 X_Asset_Rec.TO_CAPACITY ,
87 X_Asset_Rec.FROM_BONUS_RULE ,
88 X_Asset_Rec.TO_BONUS_RULE ,
89 X_Asset_Rec.FROM_GROUP_ASSET_NUMBER ,
90 X_Asset_Rec.TO_GROUP_ASSET_NUMBER ,
91 X_last_update_date ,
92 X_last_updated_by ,
93 X_created_by ,
94 X_creation_date ,
95 X_last_update_login ,
96 X_Asset_Rec.FROM_SALVAGE_TYPE ,
97 X_Asset_Rec.TO_SALVAGE_TYPE ,
98 X_Asset_Rec.FROM_PERCENT_SALVAGE_VALUE ,
99 X_Asset_Rec.TO_PERCENT_SALVAGE_VALUE ,
100 X_Asset_Rec.FROM_SALVAGE_VALUE ,
101 X_Asset_Rec.TO_SALVAGE_VALUE ,
102 X_Asset_Rec.FROM_DEPRN_LIMIT_TYPE ,
103 X_Asset_Rec.TO_DEPRN_LIMIT_TYPE ,
104 X_Asset_Rec.FROM_DEPRN_LIMIT ,
105 X_Asset_Rec.TO_DEPRN_LIMIT ,
106 X_Asset_Rec.FROM_DEPRN_LIMIT_AMOUNT ,
107 X_Asset_Rec.TO_DEPRN_LIMIT_AMOUNT
108 );
109 ELSIF (X_Report_Type = 'REVIEW') THEN
110 INSERT INTO fa_mass_changes_itf (
111 REQUEST_ID ,
112 MASS_CHANGE_ID ,
113 ASSET_ID ,
114 ASSET_NUMBER ,
115 DESCRIPTION ,
116 ASSET_TYPE ,
117 BOOK ,
118 CATEGORY ,
119 FROM_CONVENTION ,
120 TO_CONVENTION ,
121 FROM_LIFE_IN_MONTHS ,
122 TO_LIFE_IN_MONTHS ,
123 FROM_METHOD_CODE ,
124 TO_METHOD_CODE ,
125 FROM_BASIC_RATE ,
126 TO_BASIC_RATE ,
127 FROM_ADJUSTED_RATE ,
128 TO_ADJUSTED_RATE ,
129 FROM_PRODUCTION_CAPACITY ,
130 TO_PRODUCTION_CAPACITY ,
131 FROM_BONUS_RULE ,
132 TO_BONUS_RULE ,
133 FROM_GROUP_ASSET_NUMBER ,
134 TO_GROUP_ASSET_NUMBER ,
135 last_update_date ,
136 last_updated_by ,
137 created_by ,
138 creation_date ,
139 last_update_login ,
140 FROM_SALVAGE_TYPE ,
141 TO_SALVAGE_TYPE ,
142 FROM_PERCENT_SALVAGE_VALUE ,
143 TO_PERCENT_SALVAGE_VALUE ,
144 FROM_SALVAGE_VALUE ,
145 TO_SALVAGE_VALUE ,
146 FROM_DEPRN_LIMIT_TYPE ,
147 TO_DEPRN_LIMIT_TYPE ,
148 FROM_DEPRN_LIMIT ,
149 TO_DEPRN_LIMIT ,
150 FROM_DEPRN_LIMIT_AMOUNT ,
151 TO_DEPRN_LIMIT_AMOUNT
152 ) VALUES (
153 X_REQUEST_ID ,
154 X_MASS_CHANGE_ID ,
155 X_Asset_Rec.ASSET_ID ,
156 X_Asset_Rec.ASSET_NUMBER ,
157 X_Asset_Rec.DESCRIPTION ,
158 X_Asset_Rec.ASSET_TYPE ,
159 X_Asset_Rec.BOOK_TYPE_CODE ,
160 X_Asset_Rec.CATEGORY ,
161 X_Asset_Rec.FROM_CONVENTION ,
162 X_Asset_Rec.TO_CONVENTION ,
163 X_Asset_Rec.FROM_LIFE_IN_MONTHS ,
164 X_Asset_Rec.TO_LIFE_IN_MONTHS ,
165 X_Asset_Rec.FROM_METHOD ,
166 X_Asset_Rec.TO_METHOD ,
167 X_Asset_Rec.FROM_BASIC_RATE_PCT ,
168 X_Asset_Rec.TO_BASIC_RATE_PCT ,
169 X_Asset_Rec.FROM_ADJUSTED_RATE_PCT ,
170 X_Asset_Rec.TO_ADJUSTED_RATE_PCT ,
171 X_Asset_Rec.FROM_CAPACITY ,
172 X_Asset_Rec.TO_CAPACITY ,
173 X_Asset_Rec.FROM_BONUS_RULE ,
174 X_Asset_Rec.TO_BONUS_RULE ,
175 X_Asset_Rec.FROM_GROUP_ASSET_NUMBER ,
176 X_Asset_Rec.TO_GROUP_ASSET_NUMBER ,
177 X_last_update_date ,
178 X_last_updated_by ,
179 X_created_by ,
180 X_creation_date ,
181 X_last_update_login ,
182 X_Asset_Rec.FROM_SALVAGE_TYPE ,
183 X_Asset_Rec.TO_SALVAGE_TYPE ,
184 X_Asset_Rec.FROM_PERCENT_SALVAGE_VALUE ,
185 X_Asset_Rec.TO_PERCENT_SALVAGE_VALUE ,
186 X_Asset_Rec.FROM_SALVAGE_VALUE ,
187 X_Asset_Rec.TO_SALVAGE_VALUE ,
188 X_Asset_Rec.FROM_DEPRN_LIMIT_TYPE ,
189 X_Asset_Rec.TO_DEPRN_LIMIT_TYPE ,
190 X_Asset_Rec.FROM_DEPRN_LIMIT ,
191 X_Asset_Rec.TO_DEPRN_LIMIT ,
192 X_Asset_Rec.FROM_DEPRN_LIMIT_AMOUNT ,
193 X_Asset_Rec.TO_DEPRN_LIMIT_AMOUNT
194 );
195 END IF;
196
197 EXCEPTION
198 WHEN OTHERS THEN
199 FA_SRVR_MSG.Add_Message(
200 CALLING_FN => 'FA_MASS_CHG_UTILS_PKG.Insert_Itf',
201 NAME => 'FA_SHARED_INSERT_FAILED',
202 TOKEN1 => 'FAILED',
203 VALUE1 => 'FA_MASS_RECLASS_ITF', p_log_level_rec => p_log_level_rec);
204
205 FA_SRVR_MSG.Add_SQL_Error(
206 CALLING_FN => 'FA_MASS_CHG_UTILS_PKG.Insert_Itf', p_log_level_rec => p_log_level_rec);
207
208 raise;
209
210 END Insert_Itf;
211
212
213
214 END FA_MASS_CHG_UTILS_PKG;