174: MAX_OI_BUFFER_SIZE NUMBER := 1000;
175: --
176: l_txn_rec csi_datastructures_pub.transaction_rec;
177: l_temp_txn_rec csi_datastructures_pub.transaction_rec;
178: l_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
179: l_derive_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
180: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
181: --
182: l_dflt_ctr_prop_rec csi_ctr_datastructures_pub.ctr_property_readings_rec;
175: --
176: l_txn_rec csi_datastructures_pub.transaction_rec;
177: l_temp_txn_rec csi_datastructures_pub.transaction_rec;
178: l_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
179: l_derive_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
180: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
181: --
182: l_dflt_ctr_prop_rec csi_ctr_datastructures_pub.ctr_property_readings_rec;
183: l_ctr_prop_rdg_rec csi_ctr_datastructures_pub.ctr_property_readings_rec;
176: l_txn_rec csi_datastructures_pub.transaction_rec;
177: l_temp_txn_rec csi_datastructures_pub.transaction_rec;
178: l_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
179: l_derive_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
180: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
181: --
182: l_dflt_ctr_prop_rec csi_ctr_datastructures_pub.ctr_property_readings_rec;
183: l_ctr_prop_rdg_rec csi_ctr_datastructures_pub.ctr_property_readings_rec;
184: l_temp_ctr_prop_rec csi_ctr_datastructures_pub.ctr_property_readings_rec;
178: l_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
179: l_derive_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
180: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
181: --
182: l_dflt_ctr_prop_rec csi_ctr_datastructures_pub.ctr_property_readings_rec;
183: l_ctr_prop_rdg_rec csi_ctr_datastructures_pub.ctr_property_readings_rec;
184: l_temp_ctr_prop_rec csi_ctr_datastructures_pub.ctr_property_readings_rec;
185: --
186: l_reset_only VARCHAR2(1);
179: l_derive_ctr_rec csi_ctr_datastructures_pub.counter_readings_rec;
180: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
181: --
182: l_dflt_ctr_prop_rec csi_ctr_datastructures_pub.ctr_property_readings_rec;
183: l_ctr_prop_rdg_rec csi_ctr_datastructures_pub.ctr_property_readings_rec;
184: l_temp_ctr_prop_rec csi_ctr_datastructures_pub.ctr_property_readings_rec;
185: --
186: l_reset_only VARCHAR2(1);
187:
180: l_temp_ctr_rdg_rec csi_ctr_datastructures_pub.counter_readings_rec;
181: --
182: l_dflt_ctr_prop_rec csi_ctr_datastructures_pub.ctr_property_readings_rec;
183: l_ctr_prop_rdg_rec csi_ctr_datastructures_pub.ctr_property_readings_rec;
184: l_temp_ctr_prop_rec csi_ctr_datastructures_pub.ctr_property_readings_rec;
185: --
186: l_reset_only VARCHAR2(1);
187:
188: --bug 13262205
241: p_commit VARCHAR2(30) ;
242: p_init_msg_list VARCHAR2(1) ;
243: p_validation_level NUMBER;
244: p_txn_tbl csi_datastructures_pub.transaction_tbl;
245: p_ctr_rdg_tbl csi_ctr_datastructures_pub.counter_readings_tbl;
246: p_ctr_prop_rdg_tbl csi_ctr_datastructures_pub.ctr_property_readings_tbl;
247: --Added for 13866801 mvaradam
248: BEGIN
249: --Added for Bug 13262205
242: p_init_msg_list VARCHAR2(1) ;
243: p_validation_level NUMBER;
244: p_txn_tbl csi_datastructures_pub.transaction_tbl;
245: p_ctr_rdg_tbl csi_ctr_datastructures_pub.counter_readings_tbl;
246: p_ctr_prop_rdg_tbl csi_ctr_datastructures_pub.ctr_property_readings_tbl;
247: --Added for 13866801 mvaradam
248: BEGIN
249: --Added for Bug 13262205
250: l_src_txn_from_date := fnd_date.canonical_to_date(p_src_txn_from_date);