DBA Data[Home] [Help]

APPS.CSI_COUNTER_READINGS_PVT dependencies on CSI_COUNTER_READINGS_PVT

Line 1: PACKAGE BODY CSI_COUNTER_READINGS_PVT as

1: PACKAGE BODY CSI_COUNTER_READINGS_PVT as
2: /* $Header: csivcrdb.pls 120.41.12010000.3 2008/11/25 22:43:29 anjgupta ship $ */
3: --
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_COUNTER_READINGS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csivcrdb.pls';

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_COUNTER_READINGS_PVT';

1: PACKAGE BODY CSI_COUNTER_READINGS_PVT as
2: /* $Header: csivcrdb.pls 120.41.12010000.3 2008/11/25 22:43:29 anjgupta ship $ */
3: --
4: G_PKG_NAME CONSTANT VARCHAR2(30):= 'CSI_COUNTER_READINGS_PVT';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'csivcrdb.pls';
6: --
7: FUNCTION get_reading_before_reset(p_counter_id NUMBER,
8: p_value_timestamp DATE)

Line 796: IF NOT csi_counter_readings_pvt.Transaction_ID_Exists(p_txn_rec.transaction_id) THEN

792: l_process_flag := TRUE;
793: WHILE l_process_flag LOOP
794: select CSI_TRANSACTIONS_S.nextval
795: into p_txn_rec.transaction_id from dual;
796: IF NOT csi_counter_readings_pvt.Transaction_ID_Exists(p_txn_rec.transaction_id) THEN
797: l_process_flag := FALSE;
798: END IF;
799: END LOOP;
800: ELSE

Line 801: IF csi_counter_readings_pvt.Transaction_ID_Exists(p_txn_rec.transaction_id) THEN

797: l_process_flag := FALSE;
798: END IF;
799: END LOOP;
800: ELSE
801: IF csi_counter_readings_pvt.Transaction_ID_Exists(p_txn_rec.transaction_id) THEN
802: csi_ctr_gen_utility_pvt.ExitWithErrMsg
803: ( p_msg_name => 'CSI_TXN_ID_ALREADY_EXISTS'
804: ,p_token1_name => 'TRANSACTION_ID'
805: ,p_token1_val => to_char(p_txn_rec.transaction_id)

Line 6939: END CSI_COUNTER_READINGS_PVT;

6935: p_data => x_msg_data
6936: );
6937: END ESTIMATE_FIXED_VALUES;
6938: --
6939: END CSI_COUNTER_READINGS_PVT;