APPS.CSM_COUNTER_READING_EVENT_PKG dependencies on CSM_COUNTER_VALUES_ACC

Line 40: SELECT CSM_COUNTER_VALUES_ACC_S.NEXTVAL,

36: --Cursor Declarations
37: --Insert Cursor
38: CURSOR csr_ctr_reading_ins
39: IS
40: SELECT CSM_COUNTER_VALUES_ACC_S.NEXTVAL,
41: cnt_rd.counter_value_id,
42: cnt_acc.counter_id,
43: cnt_acc.user_id
44: FROM CSI_COUNTER_READINGS cnt_rd,

Line 48: (SELECT 1 FROM csm_counter_values_acc val_acc

44: FROM CSI_COUNTER_READINGS cnt_rd,
45: csm_counters_acc cnt_acc
46: where cnt_rd.counter_id=cnt_acc.counter_id
47: AND NOT EXISTS
48: (SELECT 1 FROM csm_counter_values_acc val_acc
49: WHERE VAL_acc.counter_value_id =cnt_rd.counter_value_id);
50:
51:
52: --update cursor

Line 58: csm_counter_values_acc val_acc

54: IS
55: SELECT val_acc.access_id,
56: val_acc.user_id
57: FROM CSI_COUNTER_READINGS cnt_rd,
58: csm_counter_values_acc val_acc
59: where cnt_rd.counter_id = val_acc.counter_id
60: AND cnt_rd.last_update_date >= p_lastrundate;
61:
62: --Delete cursor

Line 68: csm_counter_values_acc val_acc

64: IS
65: SELECT val_acc.access_id,
66: val_acc.user_id
67: FROM CSI_COUNTER_READINGS cnt_rd,
68: csm_counter_values_acc val_acc
69: where cnt_rd.counter_id = val_acc.counter_id
70: AND NOT EXISTS
71: (SELECT 1 FROM csm_counters_acc cnt_acc
72: WHERE cnt_acc.counter_id =val_acc.counter_id

Line 122: DELETE FROM csm_counter_values_acc WHERE access_id = l_access_list(i);

118: END LOOP;
119:
120: -- bulk delete from acc table
121: FORALL i IN 1..l_access_list.count
122: DELETE FROM csm_counter_values_acc WHERE access_id = l_access_list(i);
123:
124: l_access_list.delete;
125: END IF; -- end of process deletes
126:

Line 182: INSERT INTO csm_counter_values_acc

178:
179: END LOOP;
180:
181: FORALL i IN 1..l_access_list.count
182: INSERT INTO csm_counter_values_acc
183: (access_id,
184: counter_value_id,
185: counter_id,
186: user_id,

Line 259: SELECT CSM_COUNTER_VALUES_ACC_S.NEXTVAL,

255: --Cursor Declarations
256: --Insert Cursor
257: CURSOR csr_ctr_reading_ins(c_counter_value_id NUMBER,c_counter_id Number)
258: IS
259: SELECT CSM_COUNTER_VALUES_ACC_S.NEXTVAL,
260: cnt_rd.counter_value_id,
261: cnt_acc.counter_id,
262: cnt_acc.user_id
263: FROM CSI_COUNTER_READINGS cnt_rd,

Line 269: (SELECT 1 FROM csm_counter_values_acc val_acc

265: where cnt_rd.counter_id=cnt_acc.counter_id
266: AND cnt_rd.counter_value_id = c_counter_value_id
267: AND cnt_acc.counter_id = c_counter_id
268: AND NOT EXISTS
269: (SELECT 1 FROM csm_counter_values_acc val_acc
270: WHERE val_acc.counter_value_id =cnt_rd.counter_value_id
271: AND val_acc.user_id =cnt_acc.user_id);
272:
273: BEGIN

Line 304: INSERT INTO csm_counter_values_acc

300:
301: END LOOP;
302:
303: FORALL i IN 1..l_access_list.count
304: INSERT INTO csm_counter_values_acc
305: (access_id,
306: counter_value_id,
307: counter_id,
308: user_id,

Line 374: FROM csm_counter_values_acc val_acc

370: CURSOR csr_ctr_reading_upd(c_counter_value_id NUMBER)
371: IS
372: SELECT val_acc.access_id,
373: val_acc.user_id
374: FROM csm_counter_values_acc val_acc
375: WHERE val_acc.counter_value_id =c_counter_value_id;
376:
377: BEGIN
378: