eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.
PACKAGE: APPS.FA_MASSADD_PREPARE_PKG

Source


1 package FA_MASSADD_PREPARE_PKG AUTHID CURRENT_USER as
2 /* $Header: FAMAPREPS.pls 120.4 2009/10/14 13:09:34 anujain ship $ */
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 --bug 8984263
33     INVOICE_LINE_NUMBER          Fa_Mass_Additions.INVOICE_LINE_NUMBER%TYPE,
34     INVOICE_DISTRIBUTION_ID      Fa_Mass_Additions.INVOICE_DISTRIBUTION_ID%TYPE,
35 --bug 8984263
36     VENDOR_NUMBER                Fa_Mass_Additions.VENDOR_NUMBER%TYPE,
37     PO_VENDOR_ID                 Fa_Mass_Additions.PO_VENDOR_ID%TYPE,
38     PO_NUMBER                    Fa_Mass_Additions.PO_NUMBER%TYPE,
39     POSTING_STATUS               Fa_Mass_Additions.POSTING_STATUS%TYPE,
40     QUEUE_NAME                   Fa_Mass_Additions.QUEUE_NAME%TYPE,
41     INVOICE_DATE                 Fa_Mass_Additions.INVOICE_DATE%TYPE,
42     INVOICE_CREATED_BY           Fa_Mass_Additions.INVOICE_CREATED_BY%TYPE,
43     INVOICE_UPDATED_BY           Fa_Mass_Additions.INVOICE_UPDATED_BY%TYPE,
44     PAYABLES_COST                Fa_Mass_Additions.PAYABLES_COST%TYPE,
45     INVOICE_ID                   Fa_Mass_Additions.INVOICE_ID%TYPE,
46     PAYABLES_BATCH_NAME          Fa_Mass_Additions.PAYABLES_BATCH_NAME%TYPE,
47     DEPRECIATE_FLAG              Fa_Mass_Additions.DEPRECIATE_FLAG%TYPE,
48     PARENT_MASS_ADDITION_ID      Fa_Mass_Additions.PARENT_MASS_ADDITION_ID%TYPE,
49     PARENT_ASSET_ID              Fa_Mass_Additions.PARENT_ASSET_ID%TYPE,
50     SPLIT_MERGED_CODE            Fa_Mass_Additions.SPLIT_MERGED_CODE%TYPE,
51     AP_DISTRIBUTION_LINE_NUMBER  Fa_Mass_Additions.AP_DISTRIBUTION_LINE_NUMBER%TYPE,
52     POST_BATCH_ID                Fa_Mass_Additions.POST_BATCH_ID%TYPE,
53     ADD_TO_ASSET_ID              Fa_Mass_Additions.ADD_TO_ASSET_ID%TYPE,
54     AMORTIZE_FLAG                Fa_Mass_Additions.AMORTIZE_FLAG%TYPE,
55     NEW_MASTER_FLAG              Fa_Mass_Additions.NEW_MASTER_FLAG%TYPE,
56     ASSET_KEY_CCID               Fa_Mass_Additions.ASSET_KEY_CCID%TYPE,
57     ASSET_TYPE                   Fa_Mass_Additions.ASSET_TYPE%TYPE,
58     DEPRN_RESERVE                Fa_Mass_Additions.DEPRN_RESERVE%TYPE,
59     YTD_DEPRN                    Fa_Mass_Additions.YTD_DEPRN%TYPE,
60     BEGINNING_NBV                Fa_Mass_Additions.BEGINNING_NBV%TYPE,
61     CREATED_BY                   Fa_Mass_Additions.CREATED_BY%TYPE,
62     CREATION_DATE                Fa_Mass_Additions.CREATION_DATE%TYPE,
63     LAST_UPDATE_LOGIN            Fa_Mass_Additions.LAST_UPDATE_LOGIN%TYPE,
64     SALVAGE_VALUE                Fa_Mass_Additions.SALVAGE_VALUE%TYPE,
65     ACCOUNTING_DATE              Fa_Mass_Additions.ACCOUNTING_DATE%TYPE,
66     ATTRIBUTE1                   Fa_Mass_Additions.ATTRIBUTE1%TYPE,
67     ATTRIBUTE2                   Fa_Mass_Additions.ATTRIBUTE2%TYPE,
68     ATTRIBUTE3                   Fa_Mass_Additions.ATTRIBUTE3%TYPE,
69     ATTRIBUTE4                   Fa_Mass_Additions.ATTRIBUTE4%TYPE,
70     ATTRIBUTE5                   Fa_Mass_Additions.ATTRIBUTE5%TYPE,
71     ATTRIBUTE6                   Fa_Mass_Additions.ATTRIBUTE6%TYPE,
72     ATTRIBUTE7                   Fa_Mass_Additions.ATTRIBUTE7%TYPE,
73     ATTRIBUTE8                   Fa_Mass_Additions.ATTRIBUTE8%TYPE,
74     ATTRIBUTE9                   Fa_Mass_Additions.ATTRIBUTE9%TYPE,
75     ATTRIBUTE10                  Fa_Mass_Additions.ATTRIBUTE10%TYPE,
76     ATTRIBUTE11                  Fa_Mass_Additions.ATTRIBUTE11%TYPE,
77     ATTRIBUTE12                  Fa_Mass_Additions.ATTRIBUTE12%TYPE,
78     ATTRIBUTE13                  Fa_Mass_Additions.ATTRIBUTE13%TYPE,
79     ATTRIBUTE14                  Fa_Mass_Additions.ATTRIBUTE14%TYPE,
80     ATTRIBUTE15                  Fa_Mass_Additions.ATTRIBUTE15%TYPE,
81     ATTRIBUTE_CATEGORY_CODE      Fa_Mass_Additions.ATTRIBUTE_CATEGORY_CODE%TYPE,
82     FULLY_RSVD_REVALS_COUNTER    Fa_Mass_Additions.FULLY_RSVD_REVALS_COUNTER%TYPE,
83     MERGE_INVOICE_NUMBER         Fa_Mass_Additions.MERGE_INVOICE_NUMBER%TYPE,
84     MERGE_VENDOR_NUMBER          Fa_Mass_Additions.MERGE_VENDOR_NUMBER%TYPE,
85     PRODUCTION_CAPACITY          Fa_Mass_Additions.PRODUCTION_CAPACITY%TYPE,
86     REVAL_AMORTIZATION_BASIS     Fa_Mass_Additions.REVAL_AMORTIZATION_BASIS%TYPE,
87     REVAL_RESERVE                Fa_Mass_Additions.REVAL_RESERVE%TYPE,
88     UNIT_OF_MEASURE              Fa_Mass_Additions.UNIT_OF_MEASURE%TYPE,
89     UNREVALUED_COST              Fa_Mass_Additions.UNREVALUED_COST%TYPE,
90     YTD_REVAL_DEPRN_EXPENSE      Fa_Mass_Additions.YTD_REVAL_DEPRN_EXPENSE%TYPE,
91     ATTRIBUTE16                  Fa_Mass_Additions.ATTRIBUTE16%TYPE,
92     ATTRIBUTE17                  Fa_Mass_Additions.ATTRIBUTE17%TYPE,
93     ATTRIBUTE18                  Fa_Mass_Additions.ATTRIBUTE18%TYPE,
94     ATTRIBUTE19                  Fa_Mass_Additions.ATTRIBUTE19%TYPE,
95     ATTRIBUTE20                  Fa_Mass_Additions.ATTRIBUTE20%TYPE,
96     ATTRIBUTE21                  Fa_Mass_Additions.ATTRIBUTE21%TYPE,
97     ATTRIBUTE22                  Fa_Mass_Additions.ATTRIBUTE22%TYPE,
98     ATTRIBUTE23                  Fa_Mass_Additions.ATTRIBUTE23%TYPE,
99     ATTRIBUTE24                  Fa_Mass_Additions.ATTRIBUTE24%TYPE,
100     ATTRIBUTE25                  Fa_Mass_Additions.ATTRIBUTE25%TYPE,
101     ATTRIBUTE26                  Fa_Mass_Additions.ATTRIBUTE26%TYPE,
102     ATTRIBUTE27                  Fa_Mass_Additions.ATTRIBUTE27%TYPE,
103     ATTRIBUTE28                  Fa_Mass_Additions.ATTRIBUTE28%TYPE,
104     ATTRIBUTE29                  Fa_Mass_Additions.ATTRIBUTE29%TYPE,
105     ATTRIBUTE30                  Fa_Mass_Additions.ATTRIBUTE30%TYPE,
106     MERGED_CODE                  Fa_Mass_Additions.MERGED_CODE%TYPE,
107     SPLIT_CODE                   Fa_Mass_Additions.SPLIT_CODE%TYPE,
108     MERGE_PARENT_MASS_ADD_ID     Fa_Mass_Additions.MERGE_PARENT_MASS_ADDITIONS_ID%TYPE,
109     SPLIT_PARENT_MASS_ADD_ID     Fa_Mass_Additions.SPLIT_PARENT_MASS_ADDITIONS_ID%TYPE,
110     PROJECT_ASSET_LINE_ID        Fa_Mass_Additions.PROJECT_ASSET_LINE_ID%TYPE,
111     PROJECT_ID                   Fa_Mass_Additions.PROJECT_ID%TYPE,
112     TASK_ID                      Fa_Mass_Additions.TASK_ID%TYPE,
113     SUM_UNITS                    Fa_Mass_Additions.SUM_UNITS%TYPE,
114     DIST_NAME                    Fa_Mass_Additions.DIST_NAME%TYPE,
115     GLOBAL_ATTRIBUTE1            Fa_Mass_Additions.GLOBAL_ATTRIBUTE1%TYPE,
116     GLOBAL_ATTRIBUTE2            Fa_Mass_Additions.GLOBAL_ATTRIBUTE2%TYPE,
117     GLOBAL_ATTRIBUTE3            Fa_Mass_Additions.GLOBAL_ATTRIBUTE3%TYPE,
118     GLOBAL_ATTRIBUTE4            Fa_Mass_Additions.GLOBAL_ATTRIBUTE4%TYPE,
119     GLOBAL_ATTRIBUTE5            Fa_Mass_Additions.GLOBAL_ATTRIBUTE5%TYPE,
120     GLOBAL_ATTRIBUTE6            Fa_Mass_Additions.GLOBAL_ATTRIBUTE6%TYPE,
121     GLOBAL_ATTRIBUTE7            Fa_Mass_Additions.GLOBAL_ATTRIBUTE7%TYPE,
122     GLOBAL_ATTRIBUTE8            Fa_Mass_Additions.GLOBAL_ATTRIBUTE8%TYPE,
123     GLOBAL_ATTRIBUTE9            Fa_Mass_Additions.GLOBAL_ATTRIBUTE9%TYPE,
124     GLOBAL_ATTRIBUTE10           Fa_Mass_Additions.GLOBAL_ATTRIBUTE10%TYPE,
125     GLOBAL_ATTRIBUTE11           Fa_Mass_Additions.GLOBAL_ATTRIBUTE11%TYPE,
126     GLOBAL_ATTRIBUTE12           Fa_Mass_Additions.GLOBAL_ATTRIBUTE12%TYPE,
127     GLOBAL_ATTRIBUTE13           Fa_Mass_Additions.GLOBAL_ATTRIBUTE13%TYPE,
128     GLOBAL_ATTRIBUTE14           Fa_Mass_Additions.GLOBAL_ATTRIBUTE14%TYPE,
129     GLOBAL_ATTRIBUTE15           Fa_Mass_Additions.GLOBAL_ATTRIBUTE15%TYPE,
130     GLOBAL_ATTRIBUTE16           Fa_Mass_Additions.GLOBAL_ATTRIBUTE16%TYPE,
131     GLOBAL_ATTRIBUTE17           Fa_Mass_Additions.GLOBAL_ATTRIBUTE17%TYPE,
132     GLOBAL_ATTRIBUTE18           Fa_Mass_Additions.GLOBAL_ATTRIBUTE18%TYPE,
133     GLOBAL_ATTRIBUTE19           Fa_Mass_Additions.GLOBAL_ATTRIBUTE19%TYPE,
134     GLOBAL_ATTRIBUTE20           Fa_Mass_Additions.GLOBAL_ATTRIBUTE20%TYPE,
135     GLOBAL_ATTRIBUTE_CATEGORY    Fa_Mass_Additions.GLOBAL_ATTRIBUTE_CATEGORY%TYPE,
136     CONTEXT                      Fa_Mass_Additions.CONTEXT%TYPE,
137     INVENTORIAL                  Fa_Mass_Additions.INVENTORIAL%TYPE,
138     SHORT_FISCAL_YEAR_FLAG       Fa_Mass_Additions.SHORT_FISCAL_YEAR_FLAG%TYPE,
139     CONVERSION_DATE              Fa_Mass_Additions.CONVERSION_DATE%TYPE,
140     ORIGINAL_DEPRN_START_DATE    Fa_Mass_Additions.ORIGINAL_DEPRN_START_DATE%TYPE,
141     GROUP_ASSET_ID               Fa_Mass_Additions.GROUP_ASSET_ID%TYPE,
142     CUA_PARENT_HIERARCHY_ID      Fa_Mass_Additions.CUA_PARENT_HIERARCHY_ID%TYPE,
143     UNITS_TO_ADJUST              Fa_Mass_Additions.UNITS_TO_ADJUST%TYPE,
144     BONUS_YTD_DEPRN              Fa_Mass_Additions.BONUS_YTD_DEPRN%TYPE,
145     BONUS_DEPRN_RESERVE          Fa_Mass_Additions.BONUS_DEPRN_RESERVE%TYPE,
146     AMORTIZE_NBV_FLAG            Fa_Mass_Additions.AMORTIZE_NBV_FLAG%TYPE,
147     AMORTIZATION_START_DATE      Fa_Mass_Additions.AMORTIZATION_START_DATE%TYPE,
148     TRANSACTION_TYPE_CODE        Fa_Mass_Additions.TRANSACTION_TYPE_CODE%TYPE,
149     TRANSACTION_DATE             Fa_Mass_Additions.TRANSACTION_DATE%TYPE,
150     WARRANTY_ID                  Fa_Mass_Additions.WARRANTY_ID%TYPE,
151     LEASE_ID                     Fa_Mass_Additions.LEASE_ID%TYPE,
152     LESSOR_ID                    Fa_Mass_Additions.LESSOR_ID%TYPE,
153     PROPERTY_TYPE_CODE           Fa_Mass_Additions.PROPERTY_TYPE_CODE%TYPE,
154     PROPERTY_1245_1250_CODE      Fa_Mass_Additions.PROPERTY_1245_1250_CODE%TYPE,
155     IN_USE_FLAG                  Fa_Mass_Additions.IN_USE_FLAG%TYPE,
156     OWNED_LEASED                 Fa_Mass_Additions.OWNED_LEASED%TYPE,
157     NEW_USED                     Fa_Mass_Additions.NEW_USED%TYPE,
158     ASSET_ID                     Fa_Mass_Additions.ASSET_ID%TYPE,
159     MATERIAL_INDICATOR_FLAG      Fa_Mass_Additions.MATERIAL_INDICATOR_FLAG%TYPE,
160     distributions_table          fa_mass_add_dist_tbl);
161 
162   -------------------------
163   -- Mass Addition table --
164   -------------------------
165   type mass_add_rec_tbl is table of mass_add_rec index by binary_integer;
166 
167 
168   -- Public constant declarations
169 
170   -- Public variable declarations
171 
172   -- Public function and procedure declarations
173   procedure prepare_mass_additions(
174                 errbuf                  OUT NOCOPY VARCHAR2,
175                 retcode                 OUT NOCOPY NUMBER,
176                 p_book_type_code        IN varchar2);
177   function update_mass_additions(p_mass_add_rec_tbl     FA_MASSADD_PREPARE_PKG.mass_add_rec_tbl,
178                                  p_log_level_rec    IN  FA_API_TYPES.log_level_rec_type default null)
179     return boolean;
180 
181 end FA_MASSADD_PREPARE_PKG;