[Home] [Help]
PACKAGE: APPS.FA_MASS_CHG_UTILS_PKG
Source
1 PACKAGE FA_MASS_CHG_UTILS_PKG AS
2 /* $Header: FAXMCUTS.pls 120.2.12010000.1 2008/07/28 13:20:05 appldev ship $ */
3
4 TYPE mass_change_rec_type is record(
5 mass_change_id number,
6 book_type_code varchar2(15),
7 transaction_date_entered date,
8 concurrent_request_id number,
9 status varchar2(10),
10 asset_type varchar2(30),
11 category_id number,
12 from_asset_number varchar2(15),
13 to_asset_number varchar2(15),
14 from_date_placed_in_service date,
15 to_date_placed_in_service date,
16 from_convention varchar2(10),
17 to_convention varchar2(10),
18 from_method_code varchar2(12),
19 to_method_code varchar2(12),
20 from_life_in_months number,
21 to_life_in_months number,
22 from_bonus_rule varchar2(30),
23 to_bonus_rule varchar2(30),
24 date_effective date,
25 from_basic_rate number,
26 to_basic_rate number,
27 from_adjusted_rate number,
28 to_adjusted_rate number,
29 from_production_capacity number,
30 to_production_capacity number,
31 from_uom varchar2(25),
32 to_uom varchar2(12),
33 from_group_association varchar2(30),
34 to_group_association varchar2(30),
35 from_group_asset_id number,
36 to_group_asset_id number,
37 from_group_asset_number varchar2(15),
38 to_group_asset_number varchar2(15),
39 change_fully_rsvd_assets varchar2(3),
40 amortize_flag varchar2(1),
41 created_by number,
42 creation_date date,
43 last_updated_by number,
44 last_update_login number,
45 last_update_date date,
46 from_salvage_type varchar2(30),
47 to_salvage_type varchar2(30),
48 from_percent_salvage_value number,
49 to_percent_salvage_value number,
50 from_salvage_value number,
51 to_salvage_value number,
52 from_deprn_limit_type varchar2(30),
53 to_deprn_limit_type varchar2(30),
54 from_deprn_limit number,
55 to_deprn_limit number,
56 from_deprn_limit_amount number,
57 to_deprn_limit_amount number
58 );
59
60 TYPE asset_rec_type is record(
61 asset_id NUMBER(15),
62 asset_number VARCHAR2(15),
63 description VARCHAR2(80),
64 asset_type VARCHAR2(15),
65 book_type_code VARCHAR2(15), -- corporate/tax book for asset
66 category_id NUMBER(15), -- current category in database
67 category VARCHAR2(210),-- in concatenated string
68 from_convention VARCHAR2(10), -- prorate convention
69 to_convention VARCHAR2(10), -- prorate convention
70 from_method VARCHAR2(12),
71 to_method VARCHAR2(12),
72 from_life_in_months NUMBER(4),
73 to_life_in_months NUMBER(4),
74 from_life VARCHAR2(6), -- New life year.mo
75 to_life VARCHAR2(6), -- New life year.mo
76 from_basic_rate NUMBER,
77 to_basic_rate NUMBER,
78 from_basic_rate_pct NUMBER, -- in percentage(rounded)
79 to_basic_rate_pct NUMBER, -- in percentage(rounded)
80 from_adjusted_rate NUMBER,
81 to_adjusted_rate NUMBER,
82 from_adjusted_rate_pct NUMBER, -- in percentage(rounded)
83 to_adjusted_rate_pct NUMBER, -- in percentage(rounded)
84 from_bonus_rule VARCHAR2(30),
85 to_bonus_rule VARCHAR2(30),
86 from_capacity NUMBER,
87 to_capacity NUMBER,
88 from_unit_of_measure VARCHAR2(25),
89 to_unit_of_measure VARCHAR2(25),
90 from_group_asset_number VARCHAR2(15),
91 to_group_asset_number VARCHAR2(15),
92 from_salvage_type VARCHAR2(30),
93 to_salvage_type VARCHAR2(30),
94 from_percent_salvage_value NUMBER,
95 to_percent_salvage_value NUMBER,
96 from_salvage_value NUMBER,
97 to_salvage_value NUMBER,
98 from_deprn_limit_type VARCHAR2(30),
99 to_deprn_limit_type VARCHAR2(30),
100 from_deprn_limit NUMBER,
101 to_deprn_limit NUMBER,
102 from_deprn_limit_amount NUMBER,
103 to_deprn_limit_amount NUMBER
104 );
105
106 TYPE asset_tbl_type is table of asset_rec_type INDEX BY BINARY_INTEGER;
107
108
109 /*=====================================================================================+
110 |
111 | Name: Insert_Itf
112 |
113 | Description: Proecedure to insert an asset record into the interface table,
114 | fa_mass_changes_itf, for report exchange.
115 |
116 | Parameters: X_Report_Type -- PREVIEW or REVIEW
117 | X_Request_Id -- Concurrent request id.
118 | X_Mass_Change_Id -- Mass change id.
119 | X_Asset_Rec -- Asset record with all the information.
120 | X_Last_Update_Date .. X_Last_Update_Login
121 | -- Standard who columns
122 |
123 | Returns:
124 |
125 | Notes:
126 |
127 +=====================================================================================*/
128
129 PROCEDURE Insert_Itf(
130 X_Report_Type IN VARCHAR2,
131 X_Request_Id IN NUMBER,
132 X_Mass_Change_Id IN NUMBER,
133 X_Asset_Rec IN ASSET_REC_TYPE,
134 X_Last_Update_Date IN DATE,
135 X_Last_Updated_By IN NUMBER,
136 X_Created_By IN NUMBER,
137 X_Creation_Date IN DATE,
138 X_Last_Update_Login IN NUMBER,
139 p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null
140 );
141
142 END FA_MASS_CHG_UTILS_PKG;