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.CSL_CS_COUNTER_VALS_ACC_PKG dependencies on CS_COUNTER_VALUES

Line 8: g_ctr_vals_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTER_VALUES_ACC';

4: /*** Globals ***/
5: g_counters_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTERS_ACC';
6: g_counters_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_ID';
7:
8: g_ctr_vals_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTER_VALUES_ACC';
9: g_ctr_vals_pubi_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
10: JTM_HOOK_UTIL_PKG.t_publication_item_list('CS_COUNTER_VALUES');
11: g_ctr_vals_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_VALUES';
12: g_ctr_vals_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_VALUE_ID';

Line 10: JTM_HOOK_UTIL_PKG.t_publication_item_list('CS_COUNTER_VALUES');

6: g_counters_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_ID';
7:
8: g_ctr_vals_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTER_VALUES_ACC';
9: g_ctr_vals_pubi_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
10: JTM_HOOK_UTIL_PKG.t_publication_item_list('CS_COUNTER_VALUES');
11: g_ctr_vals_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_VALUES';
12: g_ctr_vals_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_VALUE_ID';
13:
14: g_ctr_prop_vals_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTER_PROP_VALS_ACC';

Line 11: g_ctr_vals_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_VALUES';

7:
8: g_ctr_vals_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTER_VALUES_ACC';
9: g_ctr_vals_pubi_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
10: JTM_HOOK_UTIL_PKG.t_publication_item_list('CS_COUNTER_VALUES');
11: g_ctr_vals_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_VALUES';
12: g_ctr_vals_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_VALUE_ID';
13:
14: g_ctr_prop_vals_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTER_PROP_VALS_ACC';
15: g_ctr_prop_vals_pubi_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

Line 31: FROM CS_COUNTER_VALUES

27: RETURN NUMBER
28: IS
29: CURSOR c_parent(b_counter_value_id NUMBER) IS
30: SELECT COUNTER_ID
31: FROM CS_COUNTER_VALUES
32: WHERE COUNTER_VALUE_ID = b_counter_value_id;
33: l_parent_id NUMBER;
34: BEGIN
35: OPEN c_parent(p_counter_value_id);

Line 121: *** Private procedures that directly access the JTM_CS_COUNTER_VALUES_ACC tables

117: );
118: END UPDATE_CTR_PROP_VAL_ACC_RECORD;
119:
120: /***************************************
121: *** Private procedures that directly access the JTM_CS_COUNTER_VALUES_ACC tables
122: ***************************************/
123: -- add debug info later.
124:
125: PROCEDURE INSERT_CTR_VALUE_ACC_Record

Line 197: FROM CS_COUNTER_VALUES

193: RETURN BOOLEAN
194: IS
195: CURSOR c_counter_values (b_counter_id NUMBER) IS
196: SELECT COUNTER_VALUE_ID
197: FROM CS_COUNTER_VALUES
198: WHERE COUNTER_ID = b_counter_id;
199: BEGIN
200: FOR r_counter_value_id IN c_counter_values(p_counter_id)
201: LOOP

Line 219: FROM CS_COUNTER_VALUES

215: RETURN BOOLEAN
216: IS
217: CURSOR c_counter_values (b_counter_id NUMBER) IS
218: SELECT COUNTER_VALUE_ID
219: FROM CS_COUNTER_VALUES
220: WHERE COUNTER_ID = b_counter_id;
221: BEGIN
222: FOR r_counter_value_id IN c_counter_values(p_counter_id)
223: LOOP

Line 247: FROM CS_COUNTER_VALUES

243: RETURN BOOLEAN
244: IS
245: CURSOR c_counter_value (b_counter_value_id NUMBER) IS
246: SELECT *
247: FROM CS_COUNTER_VALUES
248: WHERE COUNTER_VALUE_ID = b_counter_value_id;
249: CURSOR c_counter_acc (b_counter_id NUMBER) IS
250: SELECT *
251: FROM JTM_CS_COUNTERS_ACC

Line 255: l_counter_id CS_COUNTER_VALUES.COUNTER_ID%TYPE;

251: FROM JTM_CS_COUNTERS_ACC
252: WHERE COUNTER_ID = b_counter_id;
253: r_counter_value c_counter_value%ROWTYPE;
254: r_counter_acc c_counter_acc%ROWTYPE;
255: l_counter_id CS_COUNTER_VALUES.COUNTER_ID%TYPE;
256: BEGIN
257: /*** get debug level ***/
258: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
259:

Line 291: The following procedures are for VUHK of CS_COUNTER_VALUES.

287: RETURN TRUE;
288: END Replicate_Record;
289:
290: /********************************************************
291: The following procedures are for VUHK of CS_COUNTER_VALUES.
292: *******************************************/
293:
294: /* Called before counter value Insert.
295: DO NOTHING

Line 323: FROM CS_COUNTER_VALUES

319: l_counter_id NUMBER;
320:
321: CURSOR c_ctr_vals( b_grp_log_id NUMBER ) IS
322: SELECT *
323: FROM CS_COUNTER_VALUES
324: WHERE COUNTER_GRP_LOG_ID = b_grp_log_id;
325:
326: BEGIN
327: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 382: FROM CS_COUNTER_VALUES

378: l_tab_resource_id dbms_sql.Number_Table;
379: l_tab_access_id dbms_sql.Number_Table;
380: CURSOR c_ctr_vals( b_grp_log_id NUMBER ) IS
381: SELECT *
382: FROM CS_COUNTER_VALUES
383: WHERE COUNTER_GRP_LOG_ID = b_grp_log_id;
384:
385: BEGIN
386: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 484: , CS_COUNTER_VALUES CCS

480: CURSOR c_ctr_prop_val ( b_ctr_grp_log_id NUMBER ) IS
481: SELECT CPV.COUNTER_PROP_VALUE_ID
482: , CPV.COUNTER_VALUE_ID
483: FROM CS_COUNTER_PROP_VALUES CPV
484: , CS_COUNTER_VALUES CCS
485: WHERE CCS.COUNTER_VALUE_ID = CPV.COUNTER_VALUE_ID
486: AND CCS.COUNTER_GRP_LOG_ID = b_ctr_grp_log_id;
487: BEGIN
488: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 539: , CS_COUNTER_VALUES CCS

535: CURSOR c_ctr_prop_val ( b_ctr_grp_log_id NUMBER ) IS
536: SELECT CPV.COUNTER_PROP_VALUE_ID
537: , CPV.COUNTER_VALUE_ID
538: FROM CS_COUNTER_PROP_VALUES CPV
539: , CS_COUNTER_VALUES CCS
540: WHERE CCS.COUNTER_VALUE_ID = CPV.COUNTER_VALUE_ID
541: AND CCS.COUNTER_GRP_LOG_ID = b_ctr_grp_log_id;
542:
543: