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 JTM_HOOK_UTIL_PKG

Line 9: g_ctr_vals_pubi_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

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';
13:

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 15: g_ctr_prop_vals_pubi_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

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 :=
16: JTM_HOOK_UTIL_PKG.t_publication_item_list('CS_COUNTER_PROP_VALS');
17: g_ctr_prop_vals_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_PROP_VALUES';
18: g_ctr_prop_vals_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_PROP_VALUE_ID';
19:

Line 16: JTM_HOOK_UTIL_PKG.t_publication_item_list('CS_COUNTER_PROP_VALS');

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 :=
16: JTM_HOOK_UTIL_PKG.t_publication_item_list('CS_COUNTER_PROP_VALS');
17: g_ctr_prop_vals_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_PROP_VALUES';
18: g_ctr_prop_vals_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_PROP_VALUE_ID';
19:
20: g_debug_level NUMBER; -- debug level

Line 82: JTM_HOOK_UTIL_PKG.Insert_Acc

78: )
79: IS
80: BEGIN
81: -- add debug info later.
82: JTM_HOOK_UTIL_PKG.Insert_Acc
83: ( P_PUBLICATION_ITEM_NAMES => g_ctr_prop_vals_pubi_name
84: ,P_ACC_TABLE_NAME => g_ctr_prop_vals_acc_table_name
85: ,P_PK1_NAME => g_ctr_prop_vals_pk1_name
86: ,P_PK1_NUM_VALUE => p_counter_prop_value_id

Line 97: JTM_HOOK_UTIL_PKG.Delete_Acc

93: )
94: IS
95: BEGIN
96: -- add debug info later.
97: JTM_HOOK_UTIL_PKG.Delete_Acc
98: ( P_PUBLICATION_ITEM_NAMES => g_ctr_prop_vals_pubi_name
99: ,P_ACC_TABLE_NAME => g_ctr_prop_vals_acc_table_name
100: ,P_PK1_NAME => g_ctr_prop_vals_pk1_name
101: ,P_PK1_NUM_VALUE => p_counter_prop_value_id

Line 112: JTM_HOOK_UTIL_PKG.UPDATE_Acc

108: ,p_acc_id IN NUMBER
109: )
110: IS
111: BEGIN
112: JTM_HOOK_UTIL_PKG.UPDATE_Acc
113: ( P_PUBLICATION_ITEM_NAMES => g_ctr_prop_vals_pubi_name
114: ,P_ACC_TABLE_NAME => g_ctr_prop_vals_acc_table_name
115: ,P_RESOURCE_ID => p_resource_id
116: ,P_ACCESS_ID => p_acc_id

Line 135: JTM_HOOK_UTIL_PKG.Insert_Acc

131: SELECT COUNTER_PROP_VALUE_ID
132: FROM CS_COUNTER_PROP_VALUES
133: WHERE COUNTER_VALUE_ID = b_counter_value_id;
134: BEGIN
135: JTM_HOOK_UTIL_PKG.Insert_Acc
136: ( P_PUBLICATION_ITEM_NAMES => g_ctr_vals_pubi_name
137: ,P_ACC_TABLE_NAME => g_ctr_vals_acc_table_name
138: ,P_PK1_NAME => g_ctr_vals_pk1_name
139: ,P_PK1_NUM_VALUE => p_counter_value_id

Line 154: JTM_HOOK_UTIL_PKG.UPDATE_Acc

150: ,p_acc_id IN NUMBER
151: )
152: IS
153: BEGIN
154: JTM_HOOK_UTIL_PKG.UPDATE_Acc
155: ( P_PUBLICATION_ITEM_NAMES => g_ctr_vals_pubi_name
156: ,P_ACC_TABLE_NAME => g_ctr_vals_acc_table_name
157: ,P_RESOURCE_ID => p_resource_id
158: ,P_ACCESS_ID => p_acc_id

Line 172: JTM_HOOK_UTIL_PKG.Delete_Acc

168: SELECT COUNTER_PROP_VALUE_ID
169: FROM CS_COUNTER_PROP_VALUES
170: WHERE COUNTER_VALUE_ID = b_counter_value_id;
171: BEGIN
172: JTM_HOOK_UTIL_PKG.Delete_Acc
173: ( P_PUBLICATION_ITEM_NAMES => g_ctr_vals_pubi_name
174: ,P_ACC_TABLE_NAME => g_ctr_vals_acc_table_name
175: ,P_PK1_NAME => g_ctr_vals_pk1_name
176: ,P_PK1_NUM_VALUE => p_counter_value_id

Line 258: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

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:
260: /*** Check if the p_counter_value_id is valid ***/
261: OPEN c_counter_value( p_counter_value_id );
262: FETCH c_counter_value INTO r_counter_value;

Line 336: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

332: l_counter_id := Get_Parent_Counter_Id(r_ctr_vals.counter_value_id);
333:
334: IF l_counter_id IS NOT NULL
335: THEN
336: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List
337: ( p_acc_table_name => g_counters_acc_table_name
338: ,p_pk1_name => g_counters_pk1_name
339: ,p_pk1_num_value => l_counter_id
340: ,l_tab_resource_id => l_tab_resource_id

Line 390: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

386: x_return_status := FND_API.G_RET_STS_SUCCESS;
387:
388: FOR r_ctr_vals IN c_ctr_vals( p_COUNTER_GRP_LOG_ID ) LOOP
389:
390: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List
391: ( p_acc_table_name => g_ctr_vals_acc_table_name
392: ,p_pk1_name => g_ctr_vals_pk1_name
393: ,p_pk1_num_value => r_ctr_vals.counter_value_id
394: ,l_tab_resource_id => l_tab_resource_id

Line 430: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

426: l_tab_access_id dbms_sql.Number_Table;
427: BEGIN
428: x_return_status := FND_API.G_RET_STS_SUCCESS;
429:
430: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List
431: ( p_acc_table_name => g_ctr_vals_acc_table_name
432: ,p_pk1_name => g_ctr_vals_pk1_name
433: ,p_pk1_num_value => p_counter_value_id
434: ,l_tab_resource_id => l_tab_resource_id

Line 491: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

487: BEGIN
488: x_return_status := FND_API.G_RET_STS_SUCCESS;
489:
490: FOR r_ctr_prop_vals IN c_ctr_prop_val( p_COUNTER_GRP_LOG_ID ) LOOP
491: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List
492: ( p_acc_table_name => g_counters_acc_table_name
493: ,p_pk1_name => g_counters_pk1_name
494: ,p_pk1_num_value => r_ctr_prop_vals.COUNTER_VALUE_ID
495: ,l_tab_resource_id => l_tab_resource_id

Line 548: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

544: BEGIN
545: x_return_status := FND_API.G_RET_STS_SUCCESS;
546:
547: FOR r_ctr_prop_vals IN c_ctr_prop_val( p_COUNTER_GRP_LOG_ID ) LOOP
548: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List
549: ( p_acc_table_name => g_ctr_prop_vals_acc_table_name
550: ,p_pk1_name => g_ctr_prop_vals_pk1_name
551: ,p_pk1_num_value => r_ctr_prop_vals.COUNTER_PROP_VALUE_ID
552: ,l_tab_resource_id => l_tab_resource_id

Line 588: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

584: l_tab_access_id dbms_sql.Number_Table;
585: BEGIN
586: x_return_status := FND_API.G_RET_STS_SUCCESS;
587:
588: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List
589: ( p_acc_table_name => g_ctr_vals_acc_table_name
590: ,p_pk1_name => g_ctr_vals_pk1_name
591: ,p_pk1_num_value => p_counter_prop_val_id
592: ,l_tab_resource_id => l_tab_resource_id