APPS.CS_CTR_CAPTURE_READING_PUB dependencies on CSI_COUNTER_ASSOCIATIONS

Line 41: l_src_obj_code CSI_COUNTER_ASSOCIATIONS.source_object_code%TYPE;

37: l_prop_rdg_count NUMBER := 0;
38: l_msg_index NUMBER;
39: l_msg_count NUMBER;
40: l_empty_txn VARCHAR2(1);
41: l_src_obj_code CSI_COUNTER_ASSOCIATIONS.source_object_code%TYPE;
42: l_src_obj_id NUMBER;
43:
44: BEGIN
45: -- Standard Start of API savepoint

Line 147: from CSI_COUNTER_ASSOCIATIONS

143: ELSE -- No Group Log provided. So, using the counter info to create Transaction
144: Begin
145: select source_object_code,source_object_id
146: into l_src_obj_code,l_src_obj_id
147: from CSI_COUNTER_ASSOCIATIONS
148: where counter_id = p_ctr_rdg_tbl(l_array_counter).counter_id
149: and rownum < 2;
150: --
151: l_txn_tbl(l_rdg_count).source_transaction_date := sysdate;

Line 459: l_src_obj_code CSI_COUNTER_ASSOCIATIONS.source_object_code%TYPE;

455: l_api_version_number CONSTANT NUMBER := 1.0;
456: l_txn_tbl csi_datastructures_pub.transaction_tbl;
457: l_ctr_rdg_tbl csi_ctr_datastructures_pub.counter_readings_tbl;
458: l_ctr_prop_rdg_tbl csi_ctr_datastructures_pub.ctr_property_readings_tbl;
459: l_src_obj_code CSI_COUNTER_ASSOCIATIONS.source_object_code%TYPE;
460: l_src_obj_id NUMBER;
461: --
462: l_rdg_count NUMBER := 0;
463: l_msg_index NUMBER;

Line 483: from CSI_COUNTER_ASSOCIATIONS

479: IF p_counter_grp_log_id IS NULL THEN
480: Begin
481: select source_object_code,source_object_id
482: into l_src_obj_code,l_src_obj_id
483: from CSI_COUNTER_ASSOCIATIONS
484: where counter_id = p_ctr_rdg_rec.counter_id
485: and rownum < 2;
486: --
487: l_txn_tbl(1).source_transaction_date := sysdate;