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);
251: l_src_txn_to_date := fnd_date.canonical_to_date(p_src_txn_to_date);
252:
253: IF NVL(p_reprocess_option,'SELECTED') = 'ALL' THEN
254: UPDATE CSI_CTR_READINGS_INTERFACE cri
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);
251: l_src_txn_to_date := fnd_date.canonical_to_date(p_src_txn_to_date);
252:
253: IF NVL(p_reprocess_option,'SELECTED') = 'ALL' THEN
254: UPDATE CSI_CTR_READINGS_INTERFACE cri
255: SET process_status = 'R'