APPS.CSM_CTR_PROP_READ_EVENT_PKG dependencies on CSM_COUNTER_PROP_VALUES_ACC

Line 11: g_count_prp_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC';

7: -- Person Date Comments
8: -----------------------------------------------------------
9:
10: /*** Globals ***/
11: g_count_prp_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC';
12: g_count_prp_table_name CONSTANT VARCHAR2(30) := 'CSI_CTR_PROPERTY_READINGS';
13: g_count_prp_seq_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC_S';
14: g_count_prp_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_PROP_VALUE_ID';
15: g_count_prp_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 13: g_count_prp_seq_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC_S';

9:
10: /*** Globals ***/
11: g_count_prp_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC';
12: g_count_prp_table_name CONSTANT VARCHAR2(30) := 'CSI_CTR_PROPERTY_READINGS';
13: g_count_prp_seq_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_PROP_VALUES_ACC_S';
14: g_count_prp_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_PROP_VALUE_ID';
15: g_count_prp_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
16: CSM_ACC_PKG.t_publication_item_list('CSM_COUNTER_PROP_VALUES');
17:

Line 37: FROM CSM_COUNTER_PROP_VALUES_ACC PVACC

33: WHERE B.COUNTER_VALUE_ID = VACC.COUNTER_VALUE_ID
34: AND VACC.USER_ID = c_user_id
35: AND VACC.COUNTER_VALUE_ID = c_counter_value_id
36: AND NOT EXISTS( SELECT 1
37: FROM CSM_COUNTER_PROP_VALUES_ACC PVACC
38: WHERE PVACC.COUNTER_PROP_VALUE_ID = B.COUNTER_PROP_VALUE_ID
39: AND PVACC.USER_ID = c_user_id);
40:
41: --variable declarations

Line 93: CSM_COUNTER_PROP_VALUES_ACC VACC

89: VACC.ACCESS_ID ,
90: VACC.USER_ID
91: FROM
92: CSI_CTR_PROPERTY_READINGS B,
93: CSM_COUNTER_PROP_VALUES_ACC VACC
94: WHERE B.COUNTER_PROP_VALUE_ID = VACC.COUNTER_PROP_VALUE_ID
95: AND VACC.USER_ID = c_user_id
96: AND B.COUNTER_PROP_VALUE_ID = c_counter_value_id;
97:

Line 149: CSM_COUNTER_PROP_VALUES_ACC VACC

145: VACC.ACCESS_ID ,
146: B.COUNTER_PROP_VALUE_ID
147: FROM
148: CSI_CTR_PROPERTY_READINGS B,
149: CSM_COUNTER_PROP_VALUES_ACC VACC
150: WHERE B.COUNTER_PROP_VALUE_ID = VACC.COUNTER_PROP_VALUE_ID
151: AND VACC.USER_ID = c_user_id
152: AND B.COUNTER_VALUE_ID = c_counter_value_id;
153:

Line 213: SELECT CSM_COUNTER_PROP_VALUES_ACC_S.NEXTVAL,

209: --Cursor Declarations
210: --Insert Cursor
211: CURSOR csr_ctr_prop_reading_ins (c_last_run_date DATE)
212: IS
213: SELECT CSM_COUNTER_PROP_VALUES_ACC_S.NEXTVAL,
214: prd.counter_prop_value_id,
215: val_acc.user_id
216: FROM CSI_CTR_PROPERTY_READINGS prd,
217: csm_counter_values_acc val_acc

Line 221: (SELECT 1 FROM CSM_COUNTER_PROP_VALUES_ACC prop_acc

217: csm_counter_values_acc val_acc
218: where prd.counter_value_id = val_acc.counter_value_id
219: AND val_acc.creation_date >= c_last_run_date
220: AND NOT EXISTS
221: (SELECT 1 FROM CSM_COUNTER_PROP_VALUES_ACC prop_acc
222: WHERE prop_acc.counter_prop_value_id =prd.counter_prop_value_id
223: AND prop_acc.user_id = val_acc.user_id );
224:
225: --update Not supported for property reading

Line 233: CSM_COUNTER_PROP_VALUES_ACC prop_acc

229: IS
230: SELECT prop_acc.access_id,
231: prop_acc.user_id
232: FROM CSI_CTR_PROPERTY_READINGS prd,
233: CSM_COUNTER_PROP_VALUES_ACC prop_acc
234: where prd.counter_prop_value_id = prop_acc.counter_prop_value_id
235: AND NOT EXISTS
236: (SELECT 1 FROM csm_counter_values_acc val_acc
237: WHERE prd.counter_value_id = val_acc.counter_value_id

Line 287: DELETE FROM CSM_COUNTER_PROP_VALUES_ACC WHERE access_id = l_access_list(i);

283: END LOOP;
284:
285: -- bulk delete from acc table
286: FORALL i IN 1..l_access_list.count
287: DELETE FROM CSM_COUNTER_PROP_VALUES_ACC WHERE access_id = l_access_list(i);
288:
289: l_access_list.delete;
290: END IF; -- end of process deletes
291:

Line 311: INSERT INTO CSM_COUNTER_PROP_VALUES_ACC

307:
308: END LOOP;
309:
310: FORALL i IN 1..l_access_list.count
311: INSERT INTO CSM_COUNTER_PROP_VALUES_ACC
312: (access_id,
313: counter_prop_value_id,
314: user_id,
315: counter,