APPS.CSL_CS_COUNTER_VALS_ACC_PKG dependencies on CS_COUNTER_PROP_VALUES

Line 17: g_ctr_prop_vals_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_PROP_VALUES';

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
21:

Line 56: FROM CS_COUNTER_PROP_VALUES

52: RETURN NUMBER
53: IS
54: CURSOR c_parent(b_counter_prop_val_id NUMBER) IS
55: SELECT COUNTER_VALUE_ID
56: FROM CS_COUNTER_PROP_VALUES
57: WHERE COUNTER_PROP_VALUE_ID = b_counter_prop_val_id;
58: l_parent_id NUMBER;
59: BEGIN
60: OPEN c_parent(p_counter_prop_val_id);

Line 132: FROM CS_COUNTER_PROP_VALUES

128: )
129: IS
130: CURSOR c_counter_prop_value (b_counter_value_id NUMBER) IS
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

Line 169: FROM CS_COUNTER_PROP_VALUES

165: )
166: IS
167: CURSOR c_counter_prop_value (b_counter_value_id NUMBER) IS
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

Line 451: The following procedures are for VUHK of CS_COUNTER_PROP_VALUES.

447: END POST_DELETE_COUNTER_VALUE;
448:
449:
450: /****************************************************************
451: The following procedures are for VUHK of CS_COUNTER_PROP_VALUES.
452: ****************************************************************/
453:
454: /* Called before counter prop value Insert.
455: DO NOTHING

Line 483: FROM CS_COUNTER_PROP_VALUES CPV

479:
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

Line 538: FROM CS_COUNTER_PROP_VALUES CPV

534:
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: