DBA Data[Home] [Help]

APPS.CSL_CS_COUNTERS_ACC_PKG dependencies on CS_COUNTER_PROPERTIES

Line 22: g_ctr_props_table_name CONSTANT VARCHAR2(30) := 'CS_COUNTER_PROPERTIES';

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

Line 94: FROM CS_COUNTER_PROPERTIES

90: RETURN NUMBER
91: IS
92: CURSOR c_parent(b_ctr_prop_id NUMBER) IS
93: SELECT COUNTER_ID
94: FROM CS_COUNTER_PROPERTIES
95: WHERE COUNTER_PROPERTY_ID = b_ctr_prop_id;
96: l_parent_id NUMBER;
97: BEGIN
98: OPEN c_parent(p_ctr_prop_id);

Line 117: Procedures for CS_COUNTER_PROPERTIES hooks

113: RETURN NULL;
114: END Get_Parent_Counter_Id;
115:
116: /***************************************
117: Procedures for CS_COUNTER_PROPERTIES hooks
118: ***************************************/
119:
120: /* private procedure that replicates given counter value related data for resource
121: * reading is always controlled by counter_value not counter_prop

Line 178: FROM CS_COUNTER_PROPERTIES

174: )
175: IS
176: CURSOR c_counter_property (b_counter_id NUMBER) IS
177: SELECT COUNTER_PROPERTY_ID
178: FROM CS_COUNTER_PROPERTIES
179: WHERE COUNTER_ID = b_counter_id;
180: r_counter_property_id c_counter_property%ROWTYPE;
181: l_ins_ctr_val_success BOOLEAN := TRUE;
182: BEGIN

Line 226: FROM CS_COUNTER_PROPERTIES

222: )
223: IS
224: CURSOR c_counter_property (b_counter_id NUMBER) IS
225: SELECT COUNTER_PROPERTY_ID
226: FROM CS_COUNTER_PROPERTIES
227: WHERE COUNTER_ID = b_counter_id;
228: r_counter_property_id c_counter_property%ROWTYPE;
229: l_del_ctr_val_success BOOLEAN := TRUE;
230: BEGIN