APPS.CSL_CS_COUNTERS_ACC_PKG dependencies on CS_COUNTERS

Line 1: PACKAGE BODY CSL_CS_COUNTERS_ACC_PKG AS

1: PACKAGE BODY CSL_CS_COUNTERS_ACC_PKG AS
2: /* $Header: cslctacb.pls 115.10 2002/11/08 14:03:34 asiegers ship $ */
3:
4: /*** Globals ***/
5: g_item_insts_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_INSTANCES_ACC';

Line 15: g_counters_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTERS_ACC';

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';
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');

Line 16: g_counters_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTERS';

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

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 67: FROM CS_COUNTERS

63: RETURN NUMBER
64: IS
65: CURSOR c_parent(b_counter_id NUMBER) IS
66: SELECT COUNTER_GROUP_ID
67: FROM CS_COUNTERS
68: WHERE COUNTER_ID = b_counter_id;
69: l_parent_id NUMBER;
70: BEGIN
71: OPEN c_parent(p_counter_id);

Line 169: Procedures for CS_COUNTERS hooks

165: );
166: END DELETE_COUNTER_PROP_ACC_RECORD;
167:
168: /***************************************
169: Procedures for CS_COUNTERS hooks
170: ***************************************/
171: /* private procedure that replicates given counters related data for resource */
172: PROCEDURE INSERT_COUNTER_ACC_RECORD ( p_counter_id IN NUMBER,
173: p_resource_id IN NUMBER

Line 261: FROM CS_COUNTERS

257: )
258: IS
259: CURSOR c_counter (b_counter_group_id NUMBER) IS
260: SELECT COUNTER_ID
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

Line 302: FROM CS_COUNTERS

298: )
299: IS
300: CURSOR c_counter (b_counter_group_id NUMBER) IS
301: SELECT COUNTER_ID
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

Line 438: *** The following Functions Called by VUHK of CS_COUNTERS_PUB

434: END Pre_Delete_Parent;
435:
436:
437: /***
438: *** The following Functions Called by VUHK of CS_COUNTERS_PUB
439: ***/
440:
441: /* Called before counter group Insert */
442: PROCEDURE PRE_INSERT_COUNTER_GROUP ( x_return_status out NOCOPY varchar2)

Line 833: END CSL_CS_COUNTERS_ACC_PKG;

829: END LOOP;
830: END IF;
831: END POST_DELETE_COUNTER_PROPERTY;
832:
833: END CSL_CS_COUNTERS_ACC_PKG;