[Home] [Help]
PACKAGE: APPS.FA_MASSADD_PREPARE_PKG
Source
1 package FA_MASSADD_PREPARE_PKG as
2 /* $Header: FAMAPREPS.pls 120.3 2005/08/26 22:53:10 snarayan noship $ */
3 -- Public type declarations
4 ---------------------------------
5 -- Mass Addition Record --
6 ---------------------------------
7 type mass_add_rec is RECORD(
8 MASS_ADDITION_ID Fa_Mass_Additions.MASS_ADDITION_ID%TYPE,
9 ASSET_NUMBER Fa_Mass_Additions.ASSET_NUMBER%TYPE,
10 TAG_NUMBER Fa_Mass_Additions.TAG_NUMBER%TYPE,
11 DESCRIPTION Fa_Mass_Additions.DESCRIPTION%TYPE,
12 ASSET_CATEGORY_ID Fa_Mass_Additions.ASSET_CATEGORY_ID%TYPE,
13 MANUFACTURER_NAME Fa_Mass_Additions.MANUFACTURER_NAME%TYPE,
14 SERIAL_NUMBER Fa_Mass_Additions.SERIAL_NUMBER%TYPE,
15 MODEL_NUMBER Fa_Mass_Additions.MODEL_NUMBER%TYPE,
16 BOOK_TYPE_CODE Fa_Mass_Additions.BOOK_TYPE_CODE%TYPE,
17 DATE_PLACED_IN_SERVICE Fa_Mass_Additions.DATE_PLACED_IN_SERVICE%TYPE,
18 FIXED_ASSETS_COST Fa_Mass_Additions.FIXED_ASSETS_COST%TYPE,
19 PAYABLES_UNITS Fa_Mass_Additions.PAYABLES_UNITS%TYPE,
20 FIXED_ASSETS_UNITS Fa_Mass_Additions.FIXED_ASSETS_UNITS%TYPE,
21 PAYABLES_CODE_COMBINATION_ID Fa_Mass_Additions.PAYABLES_CODE_COMBINATION_ID%TYPE,
22 EXPENSE_CODE_COMBINATION_ID Fa_Mass_Additions.EXPENSE_CODE_COMBINATION_ID%TYPE,
23 LOCATION_ID Fa_Mass_Additions.LOCATION_ID%TYPE,
24 ASSIGNED_TO Fa_Mass_Additions.ASSIGNED_TO%TYPE,
25 FEEDER_SYSTEM_NAME Fa_Mass_Additions.FEEDER_SYSTEM_NAME%TYPE,
26 CREATE_BATCH_DATE Fa_Mass_Additions.CREATE_BATCH_DATE%TYPE,
27 CREATE_BATCH_ID Fa_Mass_Additions.CREATE_BATCH_ID%TYPE,
28 LAST_UPDATE_DATE Fa_Mass_Additions.LAST_UPDATE_DATE%TYPE,
29 LAST_UPDATED_BY Fa_Mass_Additions.LAST_UPDATED_BY%TYPE,
30 REVIEWER_COMMENTS Fa_Mass_Additions.REVIEWER_COMMENTS%TYPE,
31 INVOICE_NUMBER Fa_Mass_Additions.INVOICE_NUMBER%TYPE,
32 VENDOR_NUMBER Fa_Mass_Additions.VENDOR_NUMBER%TYPE,
33 PO_VENDOR_ID Fa_Mass_Additions.PO_VENDOR_ID%TYPE,
34 PO_NUMBER Fa_Mass_Additions.PO_NUMBER%TYPE,
35 POSTING_STATUS Fa_Mass_Additions.POSTING_STATUS%TYPE,
36 QUEUE_NAME Fa_Mass_Additions.QUEUE_NAME%TYPE,
37 INVOICE_DATE Fa_Mass_Additions.INVOICE_DATE%TYPE,
38 INVOICE_CREATED_BY Fa_Mass_Additions.INVOICE_CREATED_BY%TYPE,
39 INVOICE_UPDATED_BY Fa_Mass_Additions.INVOICE_UPDATED_BY%TYPE,
40 PAYABLES_COST Fa_Mass_Additions.PAYABLES_COST%TYPE,
41 INVOICE_ID Fa_Mass_Additions.INVOICE_ID%TYPE,
42 PAYABLES_BATCH_NAME Fa_Mass_Additions.PAYABLES_BATCH_NAME%TYPE,
43 DEPRECIATE_FLAG Fa_Mass_Additions.DEPRECIATE_FLAG%TYPE,
44 PARENT_MASS_ADDITION_ID Fa_Mass_Additions.PARENT_MASS_ADDITION_ID%TYPE,
45 PARENT_ASSET_ID Fa_Mass_Additions.PARENT_ASSET_ID%TYPE,
46 SPLIT_MERGED_CODE Fa_Mass_Additions.SPLIT_MERGED_CODE%TYPE,
47 AP_DISTRIBUTION_LINE_NUMBER Fa_Mass_Additions.AP_DISTRIBUTION_LINE_NUMBER%TYPE,
48 POST_BATCH_ID Fa_Mass_Additions.POST_BATCH_ID%TYPE,
49 ADD_TO_ASSET_ID Fa_Mass_Additions.ADD_TO_ASSET_ID%TYPE,
50 AMORTIZE_FLAG Fa_Mass_Additions.AMORTIZE_FLAG%TYPE,
51 NEW_MASTER_FLAG Fa_Mass_Additions.NEW_MASTER_FLAG%TYPE,
52 ASSET_KEY_CCID Fa_Mass_Additions.ASSET_KEY_CCID%TYPE,
53 ASSET_TYPE Fa_Mass_Additions.ASSET_TYPE%TYPE,
54 DEPRN_RESERVE Fa_Mass_Additions.DEPRN_RESERVE%TYPE,
55 YTD_DEPRN Fa_Mass_Additions.YTD_DEPRN%TYPE,
56 BEGINNING_NBV Fa_Mass_Additions.BEGINNING_NBV%TYPE,
57 CREATED_BY Fa_Mass_Additions.CREATED_BY%TYPE,
58 CREATION_DATE Fa_Mass_Additions.CREATION_DATE%TYPE,
59 LAST_UPDATE_LOGIN Fa_Mass_Additions.LAST_UPDATE_LOGIN%TYPE,
60 SALVAGE_VALUE Fa_Mass_Additions.SALVAGE_VALUE%TYPE,
61 ACCOUNTING_DATE Fa_Mass_Additions.ACCOUNTING_DATE%TYPE,
62 ATTRIBUTE1 Fa_Mass_Additions.ATTRIBUTE1%TYPE,
63 ATTRIBUTE2 Fa_Mass_Additions.ATTRIBUTE2%TYPE,
64 ATTRIBUTE3 Fa_Mass_Additions.ATTRIBUTE3%TYPE,
65 ATTRIBUTE4 Fa_Mass_Additions.ATTRIBUTE4%TYPE,
66 ATTRIBUTE5 Fa_Mass_Additions.ATTRIBUTE5%TYPE,
67 ATTRIBUTE6 Fa_Mass_Additions.ATTRIBUTE6%TYPE,
68 ATTRIBUTE7 Fa_Mass_Additions.ATTRIBUTE7%TYPE,
69 ATTRIBUTE8 Fa_Mass_Additions.ATTRIBUTE8%TYPE,
70 ATTRIBUTE9 Fa_Mass_Additions.ATTRIBUTE9%TYPE,
71 ATTRIBUTE10 Fa_Mass_Additions.ATTRIBUTE10%TYPE,
72 ATTRIBUTE11 Fa_Mass_Additions.ATTRIBUTE11%TYPE,
73 ATTRIBUTE12 Fa_Mass_Additions.ATTRIBUTE12%TYPE,
74 ATTRIBUTE13 Fa_Mass_Additions.ATTRIBUTE13%TYPE,
75 ATTRIBUTE14 Fa_Mass_Additions.ATTRIBUTE14%TYPE,
76 ATTRIBUTE15 Fa_Mass_Additions.ATTRIBUTE15%TYPE,
77 ATTRIBUTE_CATEGORY_CODE Fa_Mass_Additions.ATTRIBUTE_CATEGORY_CODE%TYPE,
78 FULLY_RSVD_REVALS_COUNTER Fa_Mass_Additions.FULLY_RSVD_REVALS_COUNTER%TYPE,
79 MERGE_INVOICE_NUMBER Fa_Mass_Additions.MERGE_INVOICE_NUMBER%TYPE,
80 MERGE_VENDOR_NUMBER Fa_Mass_Additions.MERGE_VENDOR_NUMBER%TYPE,
81 PRODUCTION_CAPACITY Fa_Mass_Additions.PRODUCTION_CAPACITY%TYPE,
82 REVAL_AMORTIZATION_BASIS Fa_Mass_Additions.REVAL_AMORTIZATION_BASIS%TYPE,
83 REVAL_RESERVE Fa_Mass_Additions.REVAL_RESERVE%TYPE,
84 UNIT_OF_MEASURE Fa_Mass_Additions.UNIT_OF_MEASURE%TYPE,
85 UNREVALUED_COST Fa_Mass_Additions.UNREVALUED_COST%TYPE,
86 YTD_REVAL_DEPRN_EXPENSE Fa_Mass_Additions.YTD_REVAL_DEPRN_EXPENSE%TYPE,
87 ATTRIBUTE16 Fa_Mass_Additions.ATTRIBUTE16%TYPE,
88 ATTRIBUTE17 Fa_Mass_Additions.ATTRIBUTE17%TYPE,
89 ATTRIBUTE18 Fa_Mass_Additions.ATTRIBUTE18%TYPE,
90 ATTRIBUTE19 Fa_Mass_Additions.ATTRIBUTE19%TYPE,
91 ATTRIBUTE20 Fa_Mass_Additions.ATTRIBUTE20%TYPE,
92 ATTRIBUTE21 Fa_Mass_Additions.ATTRIBUTE21%TYPE,
93 ATTRIBUTE22 Fa_Mass_Additions.ATTRIBUTE22%TYPE,
94 ATTRIBUTE23 Fa_Mass_Additions.ATTRIBUTE23%TYPE,
95 ATTRIBUTE24 Fa_Mass_Additions.ATTRIBUTE24%TYPE,
96 ATTRIBUTE25 Fa_Mass_Additions.ATTRIBUTE25%TYPE,
97 ATTRIBUTE26 Fa_Mass_Additions.ATTRIBUTE26%TYPE,
98 ATTRIBUTE27 Fa_Mass_Additions.ATTRIBUTE27%TYPE,
99 ATTRIBUTE28 Fa_Mass_Additions.ATTRIBUTE28%TYPE,
100 ATTRIBUTE29 Fa_Mass_Additions.ATTRIBUTE29%TYPE,
101 ATTRIBUTE30 Fa_Mass_Additions.ATTRIBUTE30%TYPE,
102 MERGED_CODE Fa_Mass_Additions.MERGED_CODE%TYPE,
103 SPLIT_CODE Fa_Mass_Additions.SPLIT_CODE%TYPE,
104 MERGE_PARENT_MASS_ADD_ID Fa_Mass_Additions.MERGE_PARENT_MASS_ADDITIONS_ID%TYPE,
105 SPLIT_PARENT_MASS_ADD_ID Fa_Mass_Additions.SPLIT_PARENT_MASS_ADDITIONS_ID%TYPE,
106 PROJECT_ASSET_LINE_ID Fa_Mass_Additions.PROJECT_ASSET_LINE_ID%TYPE,
107 PROJECT_ID Fa_Mass_Additions.PROJECT_ID%TYPE,
108 TASK_ID Fa_Mass_Additions.TASK_ID%TYPE,
109 SUM_UNITS Fa_Mass_Additions.SUM_UNITS%TYPE,
110 DIST_NAME Fa_Mass_Additions.DIST_NAME%TYPE,
111 GLOBAL_ATTRIBUTE1 Fa_Mass_Additions.GLOBAL_ATTRIBUTE1%TYPE,
112 GLOBAL_ATTRIBUTE2 Fa_Mass_Additions.GLOBAL_ATTRIBUTE2%TYPE,
113 GLOBAL_ATTRIBUTE3 Fa_Mass_Additions.GLOBAL_ATTRIBUTE3%TYPE,
114 GLOBAL_ATTRIBUTE4 Fa_Mass_Additions.GLOBAL_ATTRIBUTE4%TYPE,
115 GLOBAL_ATTRIBUTE5 Fa_Mass_Additions.GLOBAL_ATTRIBUTE5%TYPE,
116 GLOBAL_ATTRIBUTE6 Fa_Mass_Additions.GLOBAL_ATTRIBUTE6%TYPE,
117 GLOBAL_ATTRIBUTE7 Fa_Mass_Additions.GLOBAL_ATTRIBUTE7%TYPE,
118 GLOBAL_ATTRIBUTE8 Fa_Mass_Additions.GLOBAL_ATTRIBUTE8%TYPE,
119 GLOBAL_ATTRIBUTE9 Fa_Mass_Additions.GLOBAL_ATTRIBUTE9%TYPE,
120 GLOBAL_ATTRIBUTE10 Fa_Mass_Additions.GLOBAL_ATTRIBUTE10%TYPE,
121 GLOBAL_ATTRIBUTE11 Fa_Mass_Additions.GLOBAL_ATTRIBUTE11%TYPE,
122 GLOBAL_ATTRIBUTE12 Fa_Mass_Additions.GLOBAL_ATTRIBUTE12%TYPE,
123 GLOBAL_ATTRIBUTE13 Fa_Mass_Additions.GLOBAL_ATTRIBUTE13%TYPE,
124 GLOBAL_ATTRIBUTE14 Fa_Mass_Additions.GLOBAL_ATTRIBUTE14%TYPE,
125 GLOBAL_ATTRIBUTE15 Fa_Mass_Additions.GLOBAL_ATTRIBUTE15%TYPE,
126 GLOBAL_ATTRIBUTE16 Fa_Mass_Additions.GLOBAL_ATTRIBUTE16%TYPE,
127 GLOBAL_ATTRIBUTE17 Fa_Mass_Additions.GLOBAL_ATTRIBUTE17%TYPE,
128 GLOBAL_ATTRIBUTE18 Fa_Mass_Additions.GLOBAL_ATTRIBUTE18%TYPE,
129 GLOBAL_ATTRIBUTE19 Fa_Mass_Additions.GLOBAL_ATTRIBUTE19%TYPE,
130 GLOBAL_ATTRIBUTE20 Fa_Mass_Additions.GLOBAL_ATTRIBUTE20%TYPE,
131 GLOBAL_ATTRIBUTE_CATEGORY Fa_Mass_Additions.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
132 CONTEXT Fa_Mass_Additions.CONTEXT%TYPE,
133 INVENTORIAL Fa_Mass_Additions.INVENTORIAL%TYPE,
134 SHORT_FISCAL_YEAR_FLAG Fa_Mass_Additions.SHORT_FISCAL_YEAR_FLAG%TYPE,
135 CONVERSION_DATE Fa_Mass_Additions.CONVERSION_DATE%TYPE,
136 ORIGINAL_DEPRN_START_DATE Fa_Mass_Additions.ORIGINAL_DEPRN_START_DATE%TYPE,
137 GROUP_ASSET_ID Fa_Mass_Additions.GROUP_ASSET_ID%TYPE,
138 CUA_PARENT_HIERARCHY_ID Fa_Mass_Additions.CUA_PARENT_HIERARCHY_ID%TYPE,
139 UNITS_TO_ADJUST Fa_Mass_Additions.UNITS_TO_ADJUST%TYPE,
140 BONUS_YTD_DEPRN Fa_Mass_Additions.BONUS_YTD_DEPRN%TYPE,
141 BONUS_DEPRN_RESERVE Fa_Mass_Additions.BONUS_DEPRN_RESERVE%TYPE,
142 AMORTIZE_NBV_FLAG Fa_Mass_Additions.AMORTIZE_NBV_FLAG%TYPE,
143 AMORTIZATION_START_DATE Fa_Mass_Additions.AMORTIZATION_START_DATE%TYPE,
144 TRANSACTION_TYPE_CODE Fa_Mass_Additions.TRANSACTION_TYPE_CODE%TYPE,
145 TRANSACTION_DATE Fa_Mass_Additions.TRANSACTION_DATE%TYPE,
146 WARRANTY_ID Fa_Mass_Additions.WARRANTY_ID%TYPE,
147 LEASE_ID Fa_Mass_Additions.LEASE_ID%TYPE,
148 LESSOR_ID Fa_Mass_Additions.LESSOR_ID%TYPE,
149 PROPERTY_TYPE_CODE Fa_Mass_Additions.PROPERTY_TYPE_CODE%TYPE,
150 PROPERTY_1245_1250_CODE Fa_Mass_Additions.PROPERTY_1245_1250_CODE%TYPE,
151 IN_USE_FLAG Fa_Mass_Additions.IN_USE_FLAG%TYPE,
152 OWNED_LEASED Fa_Mass_Additions.OWNED_LEASED%TYPE,
153 NEW_USED Fa_Mass_Additions.NEW_USED%TYPE,
154 ASSET_ID Fa_Mass_Additions.ASSET_ID%TYPE,
155 MATERIAL_INDICATOR_FLAG Fa_Mass_Additions.MATERIAL_INDICATOR_FLAG%TYPE,
156 distributions_table fa_mass_add_dist_tbl);
157
158 -------------------------
159 -- Mass Addition table --
160 -------------------------
161 type mass_add_rec_tbl is table of mass_add_rec index by binary_integer;
162
163
164 -- Public constant declarations
165
166 -- Public variable declarations
167
168 -- Public function and procedure declarations
169 procedure prepare_mass_additions(
170 errbuf OUT NOCOPY VARCHAR2,
171 retcode OUT NOCOPY NUMBER,
172 p_book_type_code IN varchar2);
173 function update_mass_additions(p_mass_add_rec_tbl FA_MASSADD_PREPARE_PKG.mass_add_rec_tbl,
174 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null)
175 return boolean;
176
177 end FA_MASSADD_PREPARE_PKG;