eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_COUNTER_READING_EVENT_PKG dependencies on CSI_COUNTER_READINGS

Line 21: TYPE counter_value_tbl_typ IS TABLE OF CSI_COUNTER_READINGS.counter_value_id%TYPE INDEX BY BINARY_INTEGER;

17: p_message OUT NOCOPY VARCHAR2)
18: IS
19: PRAGMA AUTONOMOUS_TRANSACTION;
20: --variable declarations
21: TYPE counter_value_tbl_typ IS TABLE OF CSI_COUNTER_READINGS.counter_value_id%TYPE INDEX BY BINARY_INTEGER;
22: TYPE counter_tbl_typ IS TABLE OF CSI_COUNTER_READINGS.counter_id%TYPE INDEX BY BINARY_INTEGER;
23:
24: l_sqlerrno VARCHAR2(20);
25: l_sqlerrmsg varchar2(2000);

Line 22: TYPE counter_tbl_typ IS TABLE OF CSI_COUNTER_READINGS.counter_id%TYPE INDEX BY BINARY_INTEGER;

18: IS
19: PRAGMA AUTONOMOUS_TRANSACTION;
20: --variable declarations
21: TYPE counter_value_tbl_typ IS TABLE OF CSI_COUNTER_READINGS.counter_value_id%TYPE INDEX BY BINARY_INTEGER;
22: TYPE counter_tbl_typ IS TABLE OF CSI_COUNTER_READINGS.counter_id%TYPE INDEX BY BINARY_INTEGER;
23:
24: l_sqlerrno VARCHAR2(20);
25: l_sqlerrmsg varchar2(2000);
26: l_mark_dirty boolean;

Line 44: FROM CSI_COUNTER_READINGS cnt_rd,

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

Line 57: FROM CSI_COUNTER_READINGS cnt_rd,

53: CURSOR csr_ctr_reading_upd(p_lastrundate IN date)
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:

Line 67: FROM CSI_COUNTER_READINGS cnt_rd,

63: CURSOR csr_ctr_reading_del
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

Line 243: TYPE counter_value_tbl_typ IS TABLE OF CSI_COUNTER_READINGS.counter_value_id%TYPE INDEX BY BINARY_INTEGER;

239: p_error_msg OUT NOCOPY VARCHAR2,
240: x_return_status IN OUT NOCOPY VARCHAR2)
241: IS
242: --variable declarations
243: TYPE counter_value_tbl_typ IS TABLE OF CSI_COUNTER_READINGS.counter_value_id%TYPE INDEX BY BINARY_INTEGER;
244: TYPE counter_tbl_typ IS TABLE OF CSI_COUNTER_READINGS.counter_id%TYPE INDEX BY BINARY_INTEGER;
245:
246: l_sqlerrno VARCHAR2(20);
247: l_sqlerrmsg varchar2(2000);

Line 244: TYPE counter_tbl_typ IS TABLE OF CSI_COUNTER_READINGS.counter_id%TYPE INDEX BY BINARY_INTEGER;

240: x_return_status IN OUT NOCOPY VARCHAR2)
241: IS
242: --variable declarations
243: TYPE counter_value_tbl_typ IS TABLE OF CSI_COUNTER_READINGS.counter_value_id%TYPE INDEX BY BINARY_INTEGER;
244: TYPE counter_tbl_typ IS TABLE OF CSI_COUNTER_READINGS.counter_id%TYPE INDEX BY BINARY_INTEGER;
245:
246: l_sqlerrno VARCHAR2(20);
247: l_sqlerrmsg varchar2(2000);
248: l_mark_dirty boolean;

Line 263: FROM CSI_COUNTER_READINGS cnt_rd,

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,
264: csm_counters_acc cnt_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