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