APPS.CSI_CTR_INTERFACE_PUB dependencies on CSI_CTR_READINGS_INTERFACE

Line 27: FROM CSI_CTR_READINGS_INTERFACE

23: ) IS
24: --
25: CURSOR PURGE_CUR is
26: SELECT counter_interface_id
27: FROM CSI_CTR_READINGS_INTERFACE
28: WHERE process_status = 'P';
29:
30: TYPE NumTabType IS VARRAY(10000) OF NUMBER;
31: counter_intf_id_del NumTabType;

Line 96: FROM CSI_CTR_READINGS_INTERFACE

92: ,RESET_COUNTER_READING
93: ,OBJECT_VERSION_NUMBER
94: ,DISABLED_FLAG
95: ,COUNTER_NAME
96: FROM CSI_CTR_READINGS_INTERFACE
97: WHERE batch_name = p_batch_name
98: AND process_Status = 'R'
99: AND source_transaction_date between l_src_txn_from_date and l_src_txn_to_date
100: ORDER BY VALUE_TIMESTAMP asc, COUNTER_ID asc;

Line 254: UPDATE CSI_CTR_READINGS_INTERFACE cri

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'
256: WHERE cri.batch_name = p_batch_name
257: AND cri.process_Status = 'E'
258: AND cri.source_transaction_date between l_src_txn_from_date and l_src_txn_to_date; --Changed for Bug 13262205

Line 270: DELETE FROM CSI_CTR_READINGS_INTERFACE

266: counter_intf_id_del
267: LIMIT MAX_BUFFER_SIZE;
268: --
269: FORALL i1 IN 1 .. counter_intf_id_del.COUNT
270: DELETE FROM CSI_CTR_READINGS_INTERFACE
271: WHERE counter_interface_id = counter_intf_id_del(i1);
272: --
273: FORALL i1 IN 1 .. counter_intf_id_del.COUNT
274: DELETE FROM CSI_CTR_READ_PROP_INTERFACE

Line 284: UPDATE CSI_CTR_READINGS_INTERFACE cri

280: COMMIT;
281: CLOSE PURGE_CUR;
282: END IF;
283: --
284: UPDATE CSI_CTR_READINGS_INTERFACE cri
285: SET cri.counter_id = (select ccv.counter_id from CSI_COUNTERS_VL ccv
286: where ccv.name = cri.counter_name)
287: WHERE cri.counter_id IS NULL
288: AND cri.counter_name IS NOT NULL;

Line 894: UPDATE CSI_CTR_READINGS_INTERFACE

890: END LOOP; -- l_counter_interface_id_mig.count Loop
891: --
892: -- Bulk Update error text,process_status and counter_value_id
893: FORALL j IN 1 .. l_counter_interface_id_mig.count
894: UPDATE CSI_CTR_READINGS_INTERFACE
895: SET process_status = l_PROCESS_STATUS_mig(j),
896: counter_value_id = l_COUNTER_VALUE_ID_mig(j),
897: error_text = l_ERROR_TEXT_mig(j)
898: WHERE counter_interface_id = l_counter_interface_id_mig(j);