DBA Data[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;