APPS.CSL_CS_COUNTERS_ACC_PKG dependencies on CS_COUNTER_GROUPS

Line 9: g_ctr_grps_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTER_GROUPS_ACC';

5: g_item_insts_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CSI_ITEM_INSTANCES_ACC';
6: g_item_insts_table_name CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';
7: g_item_insts_pk1_name CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
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');

Line 10: g_ctr_grps_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_GROUPS';

6: g_item_insts_table_name CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';
7: g_item_insts_pk1_name CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
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:

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 40: FROM CS_COUNTER_GROUPS

36: RETURN NUMBER
37: IS
38: CURSOR c_parent(b_counter_group_id NUMBER) IS
39: SELECT SOURCE_OBJECT_ID
40: FROM CS_COUNTER_GROUPS
41: WHERE SOURCE_OBJECT_CODE = 'CP' AND COUNTER_GROUP_ID = b_counter_group_id;
42: l_parent_id NUMBER;
43: BEGIN
44: OPEN c_parent(p_counter_group_id);

Line 252: Procedures for CS_COUNTER_GROUPS hooks

248: END LOOP;
249: END DELETE_COUNTER_ACC_RECORD;
250:
251: /***************************************
252: Procedures for CS_COUNTER_GROUPS hooks
253: ***************************************/
254: /* private procedure that replicates given counter group related data for resource */
255: PROCEDURE INSERT_CTR_GRP_ACC_RECORD ( p_counter_group_id IN NUMBER,
256: p_resource_id IN NUMBER

Line 334: FROM CS_COUNTER_GROUPS

330: RETURN BOOLEAN
331: IS
332: CURSOR c_counter_group ( b_counter_group_id NUMBER) IS
333: SELECT null
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;

Line 387: FROM CS_COUNTER_GROUPS

383: RETURN BOOLEAN
384: IS
385: CURSOR c_counter_groups (b_item_instance_id NUMBER) IS
386: SELECT COUNTER_GROUP_ID
387: FROM CS_COUNTER_GROUPS
388: WHERE SOURCE_OBJECT_CODE = 'CP' AND SOURCE_OBJECT_ID = b_item_instance_id;
389: BEGIN
390: FOR r_counter_group_id IN c_counter_groups(p_item_instance_id)
391: LOOP

Line 427: FROM CS_COUNTER_GROUPS

423: RETURN BOOLEAN
424: IS
425: CURSOR c_counter_groups (b_item_instance_id NUMBER) IS
426: SELECT COUNTER_GROUP_ID
427: FROM CS_COUNTER_GROUPS
428: WHERE SOURCE_OBJECT_CODE = 'CP' AND SOURCE_OBJECT_ID = b_item_instance_id;
429: BEGIN
430: FOR r_counter_group_id IN c_counter_groups(p_item_instance_id) LOOP
431: DELETE_CTR_GRP_ACC_RECORD(r_counter_group_id.COUNTER_GROUP_ID, p_resource_id);