[Home] [Help]
957: C.COUNTER_ID counter_id,
958: C.START_DATE_ACTIVE start_date_active,
959: C.END_DATE_ACTIVE end_date_active,
960: C.UOM_CODE uom_code
961: FROM CSI_COUNTERS_VL C, CSI_COUNTER_ASSOCIATIONS CCA
962: WHERE C.COUNTER_ID = CCA.COUNTER_ID(+)
963: AND CCA.SOURCE_OBJECT_CODE = 'CP'
964: AND CCA.SOURCE_OBJECT_ID = c_instance_id
965: AND C.COUNTER_TEMPLATE_NAME = c_counter_name
965: AND C.COUNTER_TEMPLATE_NAME = c_counter_name
966: AND trunc(nvl(C.start_date_active, sysdate)) <= trunc(sysdate)
967: AND trunc(nvl(C.end_date_active, sysdate+1)) > trunc(sysdate)
968: -- Changes by jaramana on 28-DEC-2009 for bug 9229943
969: -- Lock the CSI_COUNTERS_VL row to prevent incorrect updates
970: FOR UPDATE OF c.ctr_val_max_seq_no;
971:
972: l_get_current_value_name get_current_value_name%ROWTYPE;
973:
1215: AND CCCV.COUNTER_TEMPLATE_NAME = c_counter_name
1216: AND trunc(nvl(CCCV.start_date_active, sysdate)) <= trunc(sysdate)
1217: AND trunc(nvl(CCCV.end_date_active, sysdate+1)) > trunc(sysdate))
1218: */
1219: FROM CSI_COUNTERS_VL C, CSI_COUNTER_ASSOCIATIONS CCA
1220: WHERE CCA.SOURCE_OBJECT_ID = CI.subject_id
1221: AND C.COUNTER_ID = CCA.COUNTER_ID(+)
1222: AND CCA.SOURCE_OBJECT_CODE = 'CP'
1223: AND C.COUNTER_TEMPLATE_NAME = c_counter_name
1439: -- Cursor changed by jaramana on 03-DEC-2008 for bug 7426643 (FP of 7263702)
1440: -- Removed the use of csi_cp_counters_v
1441: CURSOR get_all_counters(c_instance_id NUMBER, c_uom_code VARCHAR2) IS
1442: SELECT DISTINCT C.COUNTER_TEMPLATE_NAME counter_name
1443: FROM CSI_COUNTERS_VL C, CSI_COUNTER_ASSOCIATIONS CCA
1444: WHERE C.UOM_CODE = c_uom_code
1445: AND trunc(nvl(C.start_date_active, sysdate)) <= trunc(sysdate)
1446: AND trunc(nvl(C.end_date_active, sysdate+1)) > trunc(sysdate)
1447: AND C.COUNTER_ID = CCA.COUNTER_ID(+)