APPS.CSM_COUNTER_EVENT_PKG dependencies on CS_COUNTERS

Line 16: g_counters_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTERS';

12: -- --------- ------ ------------------------------------------
13:
14: /*** Globals ***/
15: g_counters_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC';
16: g_counters_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTERS';
17: g_counters_seq_name CONSTANT VARCHAR2(30) := 'CSM_COUNTERS_ACC_S';
18: g_counters_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_ID';
19: g_counters_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
20: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTERS');

Line 41: CURSOR l_counter_value_csr(p_counter_id cs_counters.counter_id%TYPE, p_user_id NUMBER)

37: IS
38: l_err_msg VARCHAR2(4000);
39: l_user_id NUMBER;
40:
41: CURSOR l_counter_value_csr(p_counter_id cs_counters.counter_id%TYPE, p_user_id NUMBER)
42: IS
43: SELECT cval.counter_value_id
44: FROM csm_counter_values_acc acc,
45: CSI_COUNTER_READINGS cval

Line 211: CURSOR l_counter_value_csr(p_counter_id cs_counters.counter_id%TYPE, p_instance_id NUMBER,

207: IS
208: l_err_msg VARCHAR2(4000);
209: l_user_id NUMBER;
210:
211: CURSOR l_counter_value_csr(p_counter_id cs_counters.counter_id%TYPE, p_instance_id NUMBER,
212: p_user_id NUMBER)
213: IS
214: SELECT cval.counter_value_id
215: FROM CSI_COUNTERS_B cntrs,

Line 284: CURSOR l_user_ids_csr (p_counter_id cs_counters.counter_id%TYPE)

280: l_dmllist CHAR(1);
281: l_time_stamp DATE;
282: l_markdirty BOOLEAN;
283:
284: CURSOR l_user_ids_csr (p_counter_id cs_counters.counter_id%TYPE)
285: IS
286: SELECT acc.user_id,
287: acc.access_id
288: FROM csm_counters_acc acc

Line 354: CURSOR l_user_ids_csr (p_counter_id cs_counters.counter_id%TYPE)

350: l_dmllist CHAR(1);
351: l_time_stamp DATE;
352: l_markdirty BOOLEAN;
353:
354: CURSOR l_user_ids_csr (p_counter_id cs_counters.counter_id%TYPE)
355: IS
356: SELECT acc.user_id
357: FROM CSI_COUNTERS_B ctr
358: , CS_CSI_COUNTER_GROUPS cgrp

Line 689: CURSOR l_counter_value_csr(p_counter_id cs_counters.counter_id%TYPE, p_instance_id NUMBER,

685: IS
686: l_err_msg VARCHAR2(4000);
687: l_counter_value_id CSI_COUNTER_READINGS.counter_value_id%TYPE;
688:
689: CURSOR l_counter_value_csr(p_counter_id cs_counters.counter_id%TYPE, p_instance_id NUMBER,
690: p_user_id NUMBER)
691: IS
692: SELECT cval.value_timestamp,
693: cval.counter_value_id