APPS.CSM_CTR_PROP_READ_EVENT_PKG dependencies on CSI_CTR_PROPERTY_READINGS

Line 12: g_count_prp_table_name CONSTANT VARCHAR2(30) := 'CSI_CTR_PROPERTY_READINGS';

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 :=
16: CSM_ACC_PKG.t_publication_item_list('CSM_COUNTER_PROP_VALUES');

Line 31: CSI_CTR_PROPERTY_READINGS B,

27: IS
28: SELECT
29: B.COUNTER_PROP_VALUE_ID
30: FROM
31: CSI_CTR_PROPERTY_READINGS B,
32: csm_counter_values_acc VACC
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

Line 92: CSI_CTR_PROPERTY_READINGS B,

88: SELECT
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;

Line 148: CSI_CTR_PROPERTY_READINGS B,

144: SELECT
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;

Line 196: TYPE counter_prop_val_tbl_typ IS TABLE OF CSI_CTR_PROPERTY_READINGS.counter_prop_value_id%TYPE INDEX BY BINARY_INTEGER;

192: p_message OUT NOCOPY VARCHAR2)
193: IS
194: PRAGMA AUTONOMOUS_TRANSACTION;
195: --variable declarations
196: TYPE counter_prop_val_tbl_typ IS TABLE OF CSI_CTR_PROPERTY_READINGS.counter_prop_value_id%TYPE INDEX BY BINARY_INTEGER;
197:
198: l_sqlerrno VARCHAR2(20);
199: l_sqlerrmsg varchar2(2000);
200: l_mark_dirty boolean;

Line 216: FROM CSI_CTR_PROPERTY_READINGS prd,

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
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

Line 232: FROM CSI_CTR_PROPERTY_READINGS prd,

228: CURSOR csr_ctr_prop_reading_del
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