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_EVENT_PKG dependencies on CSM_ACC_PKG

Line 19: g_counters_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

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');
21:
22: g_counter_val_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC';
23: g_counter_val_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_VALUES';

Line 20: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTERS');

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');
21:
22: g_counter_val_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC';
23: g_counter_val_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_VALUES';
24: g_counter_val_seq_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC_S';

Line 26: g_counter_val_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

22: g_counter_val_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC';
23: g_counter_val_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_VALUES';
24: g_counter_val_seq_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC_S';
25: g_counter_val_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_VALUE_ID';
26: g_counter_val_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
27: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTER_VALUES');
28:
29:
30: l_markdirty_failed EXCEPTION;

Line 27: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTER_VALUES');

23: g_counter_val_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_VALUES';
24: g_counter_val_seq_name CONSTANT VARCHAR2(30) := 'CSM_COUNTER_VALUES_ACC_S';
25: g_counter_val_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_VALUE_ID';
26: g_counter_val_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
27: CSM_ACC_PKG.t_publication_item_list('CSF_M_COUNTER_VALUES');
28:
29:
30: l_markdirty_failed EXCEPTION;
31:

Line 59: CSM_ACC_PKG.Delete_Acc

55: l_user_id := p_user_id;
56:
57: FOR r_counter_value_rec in l_counter_value_csr(p_counter_id, l_user_id) LOOP
58: --Call DELETE ACC
59: CSM_ACC_PKG.Delete_Acc
60: ( P_PUBLICATION_ITEM_NAMES => g_counter_val_pubi_name
61: ,P_ACC_TABLE_NAME => g_counter_val_acc_table_name
62: ,P_PK1_NAME => g_counter_val_pk1_name
63: ,P_PK1_NUM_VALUE => r_counter_value_rec.counter_value_id

Line 118: CSM_ACC_PKG.Delete_Acc

114: FOR r_acc_csr IN l_acc_csr(p_counter_id) LOOP
115: l_user_id := r_acc_csr.user_id;
116:
117: -- delete counter for the user
118: CSM_ACC_PKG.Delete_Acc
119: ( P_PUBLICATION_ITEM_NAMES => g_counters_pubi_name
120: ,P_ACC_TABLE_NAME => g_counters_acc_table_name
121: ,P_PK1_NAME => g_counters_pk1_name
122: ,P_PK1_NUM_VALUE => p_counter_id

Line 172: CSM_ACC_PKG.Delete_Acc

168: l_err_msg := 'Entering CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_D' || ' for PK ' || to_char(p_counter_id);
169: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_D',FND_LOG.LEVEL_PROCEDURE);
170:
171: -- delete counter for the user
172: CSM_ACC_PKG.Delete_Acc
173: ( P_PUBLICATION_ITEM_NAMES => g_counters_pubi_name
174: ,P_ACC_TABLE_NAME => g_counters_acc_table_name
175: ,P_PK1_NAME => g_counters_pk1_name
176: ,P_PK1_NUM_VALUE => p_counter_id

Line 242: CSM_ACC_PKG.Delete_Acc

238: l_user_id := p_user_id;
239:
240: FOR r_counter_value_rec in l_counter_value_csr(p_counter_id, p_instance_id, l_user_id) LOOP
241: --Call DELETE ACC
242: CSM_ACC_PKG.Delete_Acc
243: ( P_PUBLICATION_ITEM_NAMES => g_counter_val_pubi_name
244: ,P_ACC_TABLE_NAME => g_counter_val_acc_table_name
245: ,P_PK1_NAME => g_counter_val_pk1_name
246: ,P_PK1_NUM_VALUE => r_counter_value_rec.counter_value_id

Line 376: CSM_ACC_PKG.Insert_Acc

372:
373: -- Open USER IDs loop
374: FOR r_user_id_rec IN l_user_ids_csr(p_counter_id) LOOP
375: -- Call Insert ACC
376: CSM_ACC_PKG.Insert_Acc
377: ( P_PUBLICATION_ITEM_NAMES => g_counters_pubi_name
378: ,P_ACC_TABLE_NAME => g_counters_acc_table_name
379: ,P_SEQ_NAME => g_counters_seq_name
380: ,P_PK1_NAME => g_counters_pk1_name

Line 488: CSM_ACC_PKG.Insert_Acc

484: l_instance_id := r_user_id_rec.instance_id;
485: l_max_counter_readings := NVL(csm_profile_pkg.get_max_readings_per_counter(l_user_id),0);
486:
487: -- Call Insert ACC
488: CSM_ACC_PKG.Insert_Acc
489: ( P_PUBLICATION_ITEM_NAMES => g_counter_val_pubi_name
490: ,P_ACC_TABLE_NAME => g_counter_val_acc_table_name
491: ,P_SEQ_NAME => g_counter_val_seq_name
492: ,P_PK1_NAME => g_counter_val_pk1_name

Line 516: CSM_ACC_PKG.Delete_Acc

512:
513: -- delete counter readings so as to keep history number of readings on the device
514: IF l_max_counter_readings_csr%ROWCOUNT > l_max_counter_readings THEN
515: --Call DELETE ACC
516: CSM_ACC_PKG.Delete_Acc
517: ( P_PUBLICATION_ITEM_NAMES => g_counter_val_pubi_name
518: ,P_ACC_TABLE_NAME => g_counter_val_acc_table_name
519: ,P_PK1_NAME => g_counter_val_pk1_name
520: ,P_PK1_NUM_VALUE => l_max_counter_readings_rec.counter_value_id

Line 648: CSM_ACC_PKG.Insert_Acc

644: x_return_status := FND_API.G_RET_STS_SUCCESS;
645: l_err_msg := 'Entering CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_I' || ' for cnt_id ' || to_char(p_counter_id);
646: CSM_UTIL_PKG.LOG( l_err_msg, 'CSM_COUNTER_EVENT_PKG.COUNTER_MDIRTY_I', FND_LOG.LEVEL_PROCEDURE);
647:
648: CSM_ACC_PKG.Insert_Acc
649: ( P_PUBLICATION_ITEM_NAMES => g_counters_pubi_name
650: ,P_ACC_TABLE_NAME => g_counters_acc_table_name
651: ,P_SEQ_NAME => g_counters_seq_name
652: ,P_PK1_NAME => g_counters_pk1_name

Line 725: CSM_ACC_PKG.Insert_Acc

721:
722: l_counter_value_id := r_counter_value_rec.counter_value_id;
723:
724: --Call Insert ACC
725: CSM_ACC_PKG.Insert_Acc
726: ( P_PUBLICATION_ITEM_NAMES => g_counter_val_pubi_name
727: ,P_ACC_TABLE_NAME => g_counter_val_acc_table_name
728: ,P_SEQ_NAME => g_counter_val_seq_name
729: ,P_PK1_NAME => g_counter_val_pk1_name