DBA Data[Home] [Help]

APPS.CSL_CS_COUNTER_VALS_ACC_PKG dependencies on JTM_CS_COUNTERS_ACC

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

1: PACKAGE BODY CSL_CS_COUNTER_VALS_ACC_PKG AS
2: /* $Header: cslcvacb.pls 115.10 2002/11/08 14:02:58 asiegers ship $ */
3:
4: /*** Globals ***/
5: g_counters_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTERS_ACC';
6: g_counters_pk1_name CONSTANT VARCHAR2(30) := 'COUNTER_ID';
7:
8: g_ctr_vals_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_CS_COUNTER_VALUES_ACC';
9: g_ctr_vals_pubi_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=

Line 186: *** PUBLIC APIS accessed by JTM_CS_COUNTERS_ACC_PKG

182: END LOOP;
183: END DELETE_CTR_VALUE_ACC_Record;
184:
185: /*******************************************************
186: *** PUBLIC APIS accessed by JTM_CS_COUNTERS_ACC_PKG
187: *******************************************************/
188:
189: FUNCTION POST_INSERT_PARENT
190: ( p_counter_id IN NUMBER

Line 251: FROM JTM_CS_COUNTERS_ACC

247: FROM CS_COUNTER_VALUES
248: WHERE COUNTER_VALUE_ID = b_counter_value_id;
249: CURSOR c_counter_acc (b_counter_id NUMBER) IS
250: SELECT *
251: FROM JTM_CS_COUNTERS_ACC
252: WHERE COUNTER_ID = b_counter_id;
253: r_counter_value c_counter_value%ROWTYPE;
254: r_counter_acc c_counter_acc%ROWTYPE;
255: l_counter_id CS_COUNTER_VALUES.COUNTER_ID%TYPE;

Line 279: JTM_CS_COUNTERS_ACC ***/

275: END IF;
276: CLOSE c_counter_value;
277:
278: /*** Check if the counter id is a valid counter_id in the acc table
279: JTM_CS_COUNTERS_ACC ***/
280: OPEN c_counter_acc( l_counter_id );
281: FETCH c_counter_acc INTO r_counter_acc;
282: IF c_counter_acc%NOTFOUND THEN
283: /*** no -> don't replicate ***/