[Home] [Help]
PACKAGE: APPS.EAM_ASSET_OPERATION_TXN_PUB
Source
1 PACKAGE EAM_ASSET_OPERATION_TXN_PUB AUTHID CURRENT_USER AS
2 /* $Header: EAMPACHS.pls 120.2 2005/08/03 05:56:33 ksiddhar noship $ */
3 /*
4 -- API name : EAM_ASSET_OPERATION_TXN_PUB
5 -- Type : Public
6 -- Pre-reqs : None.
7 */
8
9
10
11 G_PKG_NAME CONSTANT VARCHAR2(30):='EAM_ASSET_OPERATION_TXN_PUB';
12
13 TYPE eam_quality_rec_type is RECORD
14 (
15 batch_id number,
16 row_id number,
17 instance_id number,
18 organization_id number,
19 plan_id number,
20 spec_id number,
21 p_enable_flag number,
22 element_id number,
23 element_value varchar2(2000),
24 element_validation_flag varchar2(100),
25 transaction_number number,
26 collection_id number,
27 occurrence number,
28 return_status varchar2(1),
29 transaction_type number
30 );
31
32
33 TYPE eam_quality_tbl_type IS TABLE OF eam_quality_rec_type
34 INDEX BY BINARY_INTEGER;
35
36 TYPE Ctr_Property_Readings_Rec IS RECORD
37 (
38 counter_id number :=null,
39 counter_property_id number,
40 property_value varchar2(240),
41 value_timestamp date,
42 attribute_category varchar2(30),
43 attribute1 varchar2(150),
44 attribute2 varchar2(150),
45 attribute3 varchar2(150),
46 attribute4 varchar2(150),
47 attribute5 varchar2(150),
48 attribute6 varchar2(150),
49 attribute7 varchar2(150),
50 attribute8 varchar2(150),
51 attribute9 varchar2(150),
52 attribute10 varchar2(150),
53 attribute11 varchar2(150),
54 attribute12 varchar2(150),
55 attribute13 varchar2(150),
56 attribute14 varchar2(150),
57 attribute15 varchar2(150),
58 migrated_flag VARCHAR2(1)
59 );
60
61 TYPE Ctr_Property_readings_Tbl IS TABLE OF Ctr_Property_Readings_Rec
62 INDEX BY BINARY_INTEGER;
63
64 TYPE meter_reading_rec_type is RECORD
65 (
66 meter_id number :=null,
67 meter_reading_id number,
68 current_reading number,
69 current_reading_date date,
70 reset_flag varchar2(1),
71 description varchar2(100),
72 wip_entity_id number,
73 check_in_out_type number,
74 instance_id number,
75 source_line_id number,
76 source_code varchar2(30),
77 wo_entry_fake_flag varchar2(1),
78 adjustment_type varchar2(30),
79 adjustment_reading number,
80 net_reading number,
81 reset_reason varchar2(255),
82 attribute_category varchar2(30),
83 attribute1 varchar2(150),
84 attribute2 varchar2(150),
85 attribute3 varchar2(150),
86 attribute4 varchar2(150),
87 attribute5 varchar2(150),
88 attribute6 varchar2(150),
89 attribute7 varchar2(150),
90 attribute8 varchar2(150),
91 attribute9 varchar2(150),
92 attribute10 varchar2(150),
93 attribute11 varchar2(150),
94 attribute12 varchar2(150),
95 attribute13 varchar2(150),
96 attribute14 varchar2(150),
97 attribute15 varchar2(150),
98 attribute16 varchar2(150),
99 attribute17 varchar2(150),
100 attribute18 varchar2(150),
101 attribute19 varchar2(150),
102 attribute20 varchar2(150),
103 attribute21 varchar2(150),
104 attribute22 varchar2(150),
105 attribute23 varchar2(150),
106 attribute24 varchar2(150),
107 attribute25 varchar2(150),
108 attribute26 varchar2(150),
109 attribute27 varchar2(150),
110 attribute28 varchar2(150),
111 attribute29 varchar2(150),
112 attribute30 varchar2(150),
113 value_before_reset number,
114 p_ignore_warnings varchar2(1)
115
116
117 );
118
119
120 TYPE meter_reading_rec_tbl_type IS TABLE OF EAM_ASSET_OPERATION_TXN_PUB.meter_reading_rec_type
121 INDEX BY BINARY_INTEGER;
122
123
124
125
126
127
128
129
130 /*
131 This procedure is used to insert records in to EAM_ASSET_OPERATION_TXN table.
132 -- Parameters :
133 -- IN :
134 -- P_API_VERSION Version of the API
135 -- P_INIT_MSG_LIST Flag to indicate initialization of message list
136 -- P_COMMIT Flag to indicate whether API should commit changes
137 -- P_VALIDATION_LEVEL Validation Level of the API
138 -- P_TXN_DATE indicates transaction date of the Checkin/Checkout Transaction
139 -- P_TXN_TYPE indicates the Type of the Transaction(Checkin or Checkout)
140 -- P_INSTANCE_ID Asset id identifier of the asset or rebuildable.
141 -- P_COMMENTS To log additional information / Remarks about the transaction.
142 -- P_QA_COLLECTION_ID quality collection plan identifier to identify collection results entered for current transaction.
143 -- P_OPERABLE_FLAG Status of the Asset or Rebuildable at the time Of Transaction.
144 -- P_EMPLOYEE_ID Employee Identifier for whom the transaction has been carried.
145 -- P_EAM_OPS_QUALITY_TBL Quality Plan record table capturing the quality collection plan results entered for current transaction.
146 -- P_METER_READING_REC_TBL Meter Reading record table capturing the meter readings entered for current transaction.
147 -- P_COUNTER_PROPERTIES_TBL Counter/Meter Properties table capturing the counter/meter properties of meters for current transaction.
148 -- OUT :
149 -- X_RETURN_STATUS Return status of the procedure call
150 -- X_MSG_COUNT Count of the return messages that API returns
151 -- X_MSG_DATA The collection of the messages
152 */
153
154 PROCEDURE process_checkinout_txn
155 (
156 p_api_version IN number :=1.0,
157 p_init_msg_list IN varchar2 :=fnd_api.g_false,
158 p_commit IN varchar2 :=fnd_api.g_false,
159 p_validation_level IN number :=fnd_api.g_valid_level_full,
160 p_txn_date IN date :=sysdate,
161 p_txn_type IN number,
162 p_instance_id IN number,
163 p_comments IN varchar2 := NULL,
164 p_qa_collection_id IN number := NULL,
165 p_operable_flag IN number,
166 p_employee_id IN number,
167 p_eam_ops_quality_tbl IN eam_asset_operation_txn_pub.eam_quality_tbl_type,
168 p_meter_reading_rec_tbl IN eam_asset_operation_txn_pub.meter_reading_rec_tbl_type,
169 p_counter_properties_tbl IN eam_asset_operation_txn_pub.Ctr_Property_readings_Tbl,
170 p_attribute_category IN varchar2 := NULL,
171 p_attribute1 IN varchar2 := NULL,
172 p_attribute2 IN varchar2 := NULL,
173 p_attribute3 IN varchar2 := NULL,
174 p_attribute4 IN varchar2 := NULL,
175 p_attribute5 IN varchar2 := NULL,
176 p_attribute6 IN varchar2 := NULL,
177 p_attribute7 IN varchar2 := NULL,
178 p_attribute8 IN varchar2 := NULL,
179 p_attribute9 IN varchar2 := NULL,
180 p_attribute10 IN varchar2 := NULL,
181 p_attribute11 IN varchar2 := NULL,
182 p_attribute12 IN varchar2 := NULL,
183 p_attribute13 IN varchar2 := NULL,
184 p_attribute14 IN varchar2 := NULL,
185 p_attribute15 IN varchar2 := NULL,
186 x_return_status OUT NOCOPY varchar2,
187 x_msg_count OUT NOCOPY number,
188 x_msg_data OUT NOCOPY varchar2
189 );
190
191
192
193
194 PROCEDURE PRINT_LOG(info varchar2);
195
196
197 END EAM_ASSET_OPERATION_TXN_PUB;