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_COUNTERS_ACC_PKG dependencies on JTM_HOOK_UTIL_PKG

Line 12: g_ctr_grps_pubi_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

8:
9: g_ctr_grps_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTER_GROUPS_ACC';
10: g_ctr_grps_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_GROUPS';
11: g_ctr_grps_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_GROUP_ID';
12: g_ctr_grps_pubi_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
13: JTM_HOOK_UTIL_PKG.t_publication_item_list('CS_COUNTER_GROUPS');
14:
15: g_counters_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTERS_ACC';
16: g_counters_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTERS';

Line 13: JTM_HOOK_UTIL_PKG.t_publication_item_list('CS_COUNTER_GROUPS');

9: g_ctr_grps_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTER_GROUPS_ACC';
10: g_ctr_grps_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_GROUPS';
11: g_ctr_grps_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_GROUP_ID';
12: g_ctr_grps_pubi_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
13: JTM_HOOK_UTIL_PKG.t_publication_item_list('CS_COUNTER_GROUPS');
14:
15: g_counters_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTERS_ACC';
16: g_counters_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTERS';
17: g_counters_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_ID';

Line 18: g_counters_pubi_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

14:
15: g_counters_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTERS_ACC';
16: g_counters_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTERS';
17: g_counters_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_ID';
18: g_counters_pubi_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
19: JTM_HOOK_UTIL_PKG.t_publication_item_list('CS_COUNTERS');
20:
21: g_ctr_props_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTER_PROPS_ACC';
22: g_ctr_props_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_PROPERTIES';

Line 19: JTM_HOOK_UTIL_PKG.t_publication_item_list('CS_COUNTERS');

15: g_counters_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTERS_ACC';
16: g_counters_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTERS';
17: g_counters_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_ID';
18: g_counters_pubi_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
19: JTM_HOOK_UTIL_PKG.t_publication_item_list('CS_COUNTERS');
20:
21: g_ctr_props_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTER_PROPS_ACC';
22: g_ctr_props_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_PROPERTIES';
23: g_ctr_props_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_PROPERTY_ID';

Line 24: g_ctr_props_pubi_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

20:
21: g_ctr_props_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTER_PROPS_ACC';
22: g_ctr_props_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_PROPERTIES';
23: g_ctr_props_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_PROPERTY_ID';
24: g_ctr_props_pubi_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
25: JTM_HOOK_UTIL_PKG.t_publication_item_list('CS_COUNTER_PROPS');
26:
27: g_old_resource_id NUMBER; -- variable containing old resource_id; populated in Pre_Update hook
28: g_debug_level NUMBER; -- debug level

Line 25: JTM_HOOK_UTIL_PKG.t_publication_item_list('CS_COUNTER_PROPS');

21: g_ctr_props_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTER_PROPS_ACC';
22: g_ctr_props_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_PROPERTIES';
23: g_ctr_props_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_PROPERTY_ID';
24: g_ctr_props_pubi_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
25: JTM_HOOK_UTIL_PKG.t_publication_item_list('CS_COUNTER_PROPS');
26:
27: g_old_resource_id NUMBER; -- variable containing old resource_id; populated in Pre_Update hook
28: g_debug_level NUMBER; -- debug level
29:

Line 58: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

54: jtm_message_log_pkg.Log_Msg
55: ( p_counter_group_id
56: , g_ctr_grps_table_name
57: , 'Exception happened in Get_Parent_Item_Instance_Id for ' || p_counter_group_id
58: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
59: RETURN NULL;
60: END Get_Parent_Item_Instance_Id;
61:
62: FUNCTION Get_Parent_Ctr_Grp_Id(p_counter_id IN NUMBER)

Line 85: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

81: jtm_message_log_pkg.Log_Msg
82: ( p_counter_id
83: , g_ctr_grps_table_name
84: , 'Exception happened in Get_Parent_Ctr_Grp_Id for ' || p_counter_id
85: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
86: RETURN NULL;
87: END Get_Parent_Ctr_Grp_Id;
88:
89: FUNCTION Get_Parent_Counter_Id(p_ctr_prop_id IN NUMBER)

Line 112: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

108: jtm_message_log_pkg.Log_Msg
109: ( p_ctr_prop_id
110: , g_ctr_grps_table_name
111: , 'Exception happened in Get_Parent_Counter_Id for ' || p_ctr_prop_id
112: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
113: RETURN NULL;
114: END Get_Parent_Counter_Id;
115:
116: /***************************************

Line 129: JTM_HOOK_UTIL_PKG.Insert_Acc

125: )
126: IS
127: BEGIN
128: -- add debug info later.
129: JTM_HOOK_UTIL_PKG.Insert_Acc
130: ( P_PUBLICATION_ITEM_NAMES => g_ctr_props_pubi_name
131: ,P_ACC_TABLE_NAME => g_ctr_props_acc_table_name
132: ,P_PK1_NAME => g_ctr_props_pk1_name
133: ,P_PK1_NUM_VALUE => p_counter_property_id

Line 145: JTM_HOOK_UTIL_PKG.UPDATE_Acc

141: )
142: IS
143: BEGIN
144: -- add debug info later.
145: JTM_HOOK_UTIL_PKG.UPDATE_Acc
146: ( P_PUBLICATION_ITEM_NAMES => g_ctr_props_pubi_name
147: ,P_ACC_TABLE_NAME => g_ctr_props_acc_table_name
148: ,P_RESOURCE_ID => p_resource_id
149: ,P_ACCESS_ID => p_acc_id

Line 159: JTM_HOOK_UTIL_PKG.DELETE_Acc

155: )
156: IS
157: BEGIN
158: -- add debug info later.
159: JTM_HOOK_UTIL_PKG.DELETE_Acc
160: ( P_PUBLICATION_ITEM_NAMES => g_ctr_props_pubi_name
161: ,P_ACC_TABLE_NAME => g_ctr_props_acc_table_name
162: ,P_PK1_NAME => g_ctr_props_pk1_name
163: ,P_PK1_NUM_VALUE => p_counter_property_id

Line 184: JTM_HOOK_UTIL_PKG.Insert_Acc

180: r_counter_property_id c_counter_property%ROWTYPE;
181: l_ins_ctr_val_success BOOLEAN := TRUE;
182: BEGIN
183: -- add debug info later.
184: JTM_HOOK_UTIL_PKG.Insert_Acc
185: ( P_PUBLICATION_ITEM_NAMES => g_counters_pubi_name
186: ,P_ACC_TABLE_NAME => g_counters_acc_table_name
187: ,P_PK1_NAME => g_counters_pk1_name
188: ,P_PK1_NUM_VALUE => p_counter_id

Line 211: JTM_HOOK_UTIL_PKG.Update_Acc

207: )
208: IS
209: BEGIN
210: -- add debug info later.
211: JTM_HOOK_UTIL_PKG.Update_Acc
212: ( P_PUBLICATION_ITEM_NAMES => g_counters_pubi_name
213: ,P_ACC_TABLE_NAME => g_counters_acc_table_name
214: ,P_RESOURCE_ID => p_resource_id
215: ,P_ACCESS_ID => p_acc_id

Line 232: JTM_HOOK_UTIL_PKG.Delete_Acc

228: r_counter_property_id c_counter_property%ROWTYPE;
229: l_del_ctr_val_success BOOLEAN := TRUE;
230: BEGIN
231: -- add debug info later.
232: JTM_HOOK_UTIL_PKG.Delete_Acc
233: ( P_PUBLICATION_ITEM_NAMES => g_counters_pubi_name
234: ,P_ACC_TABLE_NAME => g_counters_acc_table_name
235: ,P_PK1_NAME => g_counters_pk1_name
236: ,P_PK1_NUM_VALUE => p_counter_id

Line 265: JTM_HOOK_UTIL_PKG.Insert_Acc

261: FROM CS_COUNTERS
262: WHERE COUNTER_GROUP_ID = b_counter_group_id;
263: BEGIN
264: -- add debug info later.
265: JTM_HOOK_UTIL_PKG.Insert_Acc
266: ( P_PUBLICATION_ITEM_NAMES => g_ctr_grps_pubi_name
267: ,P_ACC_TABLE_NAME => g_ctr_grps_acc_table_name
268: ,P_PK1_NAME => g_ctr_grps_pk1_name
269: ,P_PK1_NUM_VALUE => p_counter_group_id

Line 287: JTM_HOOK_UTIL_PKG.Update_Acc

283: )
284: IS
285: BEGIN
286: -- add debug info later.
287: JTM_HOOK_UTIL_PKG.Update_Acc
288: ( P_PUBLICATION_ITEM_NAMES => g_ctr_grps_pubi_name
289: ,P_ACC_TABLE_NAME => g_ctr_grps_acc_table_name
290: ,P_RESOURCE_ID => p_resource_id
291: ,P_ACCESS_ID => p_acc_id

Line 306: JTM_HOOK_UTIL_PKG.Delete_Acc

302: FROM CS_COUNTERS
303: WHERE COUNTER_GROUP_ID = b_counter_group_id;
304: BEGIN
305: -- add debug info later.
306: JTM_HOOK_UTIL_PKG.Delete_Acc
307: ( P_PUBLICATION_ITEM_NAMES => g_ctr_grps_pubi_name
308: ,P_ACC_TABLE_NAME => g_ctr_grps_acc_table_name
309: ,P_PK1_NAME => g_ctr_grps_pk1_name
310: ,P_PK1_NUM_VALUE => p_counter_group_id

Line 338: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;

334: FROM CS_COUNTER_GROUPS
335: WHERE COUNTER_GROUP_ID = b_counter_group_id;
336: r_counter_group c_counter_group%ROWTYPE;
337: BEGIN
338: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
339: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
340: jtm_message_log_pkg.Log_Msg
341: ( p_counter_group_id
342: , g_ctr_grps_table_name

Line 339: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN

335: WHERE COUNTER_GROUP_ID = b_counter_group_id;
336: r_counter_group c_counter_group%ROWTYPE;
337: BEGIN
338: g_debug_level := JTM_HOOK_UTIL_PKG.Get_Debug_Level;
339: IF g_debug_level = JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL THEN
340: jtm_message_log_pkg.Log_Msg
341: ( p_counter_group_id
342: , g_ctr_grps_table_name
343: , 'Entering Replicate_Record'

Line 344: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

340: jtm_message_log_pkg.Log_Msg
341: ( p_counter_group_id
342: , g_ctr_grps_table_name
343: , 'Entering Replicate_Record'
344: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
345: END IF;
346: /* check if this is a valid counter_group_id. */
347: OPEN c_counter_group(p_counter_group_id);
348: FETCH c_counter_group INTO r_counter_group;

Line 350: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN

346: /* check if this is a valid counter_group_id. */
347: OPEN c_counter_group(p_counter_group_id);
348: FETCH c_counter_group INTO r_counter_group;
349: IF c_counter_group%NOTFOUND THEN
350: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR THEN
351: jtm_message_log_pkg.Log_Msg
352: ( p_counter_group_id
353: , g_ctr_grps_table_name
354: , 'Replicate_Record error: Could not find counter_group_id ' || p_counter_group_id

Line 355: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);

351: jtm_message_log_pkg.Log_Msg
352: ( p_counter_group_id
353: , g_ctr_grps_table_name
354: , 'Replicate_Record error: Could not find counter_group_id ' || p_counter_group_id
355: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
356: END IF;
357: CLOSE c_counter_group;
358: RETURN FALSE;
359: END IF;

Line 369: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);

365: jtm_message_log_pkg.Log_Msg
366: ( p_counter_group_id
367: , g_ctr_grps_table_name
368: , 'Exception happened in for counter_group_id ' || p_counter_group_id
369: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
370: RETURN FALSE;
371: END REPLICATE_RECORD;
372:
373:

Line 473: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

469: THEN
470: RETURN;
471: END IF;
472:
473: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List
474: ( p_acc_table_name => g_item_insts_acc_table_name
475: ,p_pk1_name => g_item_insts_pk1_name
476: ,p_pk1_num_value => l_item_instance_id
477: ,l_tab_resource_id => l_tab_resource_id

Line 520: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

516: THEN
517: RETURN;
518: END IF;
519:
520: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List
521: ( p_acc_table_name => g_ctr_grps_acc_table_name
522: ,p_pk1_name => g_ctr_grps_pk1_name
523: ,p_pk1_num_value => p_ctr_grp_id
524: ,l_tab_resource_id =>l_tab_resource_id

Line 560: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

556: THEN
557: RETURN;
558: END IF;
559:
560: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List
561: ( p_acc_table_name => g_ctr_grps_acc_table_name
562: ,p_pk1_name => g_ctr_grps_pk1_name
563: ,p_pk1_num_value => p_counter_group_id
564: ,l_tab_resource_id => l_tab_resource_id

Line 606: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

602: IF l_counter_group_id IS NULL
603: THEN
604: RETURN;
605: END IF;
606: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List
607: ( p_acc_table_name => g_ctr_grps_acc_table_name
608: ,p_pk1_name => g_ctr_grps_pk1_name
609: ,p_pk1_num_value => l_counter_group_id
610: ,l_tab_resource_id => l_tab_resource_id

Line 647: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

643: l_tab_access_id dbms_sql.Number_Table;
644: BEGIN
645: x_return_status := FND_API.G_RET_STS_SUCCESS;
646:
647: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List
648: ( p_acc_table_name => g_counters_acc_table_name
649: ,p_pk1_name => g_counters_pk1_name
650: ,p_pk1_num_value => p_ctr_id
651: ,l_tab_resource_id => l_tab_resource_id

Line 687: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

683: l_tab_access_id dbms_sql.Number_Table;
684: BEGIN
685: x_return_status := FND_API.G_RET_STS_SUCCESS;
686:
687: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List
688: ( p_acc_table_name => g_counters_acc_table_name
689: ,p_pk1_name => g_counters_pk1_name
690: ,p_pk1_num_value => p_counter_id
691: ,l_tab_resource_id => l_tab_resource_id

Line 735: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

731: THEN
732: RETURN;
733: END IF;
734:
735: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List
736: ( p_acc_table_name => g_counters_acc_table_name
737: ,p_pk1_name => g_counters_pk1_name
738: ,p_pk1_num_value => l_counter_id
739: ,l_tab_resource_id => l_tab_resource_id

Line 776: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

772: l_tab_access_id dbms_sql.Number_Table;
773: BEGIN
774: x_return_status := FND_API.G_RET_STS_SUCCESS;
775:
776: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List
777: ( p_acc_table_name => g_ctr_props_acc_table_name
778: ,p_pk1_name => g_ctr_props_pk1_name
779: ,p_pk1_num_value => p_ctr_prop_id
780: ,l_tab_resource_id => l_tab_resource_id

Line 816: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List

812: l_tab_access_id dbms_sql.Number_Table;
813: BEGIN
814: x_return_status := FND_API.G_RET_STS_SUCCESS;
815:
816: JTM_HOOK_UTIL_PKG.Get_Resource_Acc_List
817: ( p_acc_table_name => g_ctr_props_acc_table_name
818: ,p_pk1_name => g_ctr_props_pk1_name
819: ,p_pk1_num_value => p_counter_prop_id
820: ,l_tab_resource_id => l_tab_resource_id