DBA Data[Home] [Help]

APPS.CSI_COUNTER_READINGS_PVT dependencies on CSI_TRANSACTIONS

Line 78: from CSI_TRANSACTIONS

74: BEGIN
75: Begin
76: select 'x'
77: into l_exists
78: from CSI_TRANSACTIONS
79: where transaction_id = p_transaction_id;
80: l_return_value := TRUE;
81: Exception
82: when no_data_found then

Line 916: select CSI_TRANSACTIONS_S.nextval

912: IF p_txn_rec.transaction_id IS NULL OR
913: p_txn_rec.transaction_id = FND_API.G_MISS_NUM THEN
914: l_process_flag := TRUE;
915: WHILE l_process_flag LOOP
916: select CSI_TRANSACTIONS_S.nextval
917: into p_txn_rec.transaction_id from dual;
918: IF NOT csi_counter_readings_pvt.Transaction_ID_Exists(p_txn_rec.transaction_id) THEN
919: l_process_flag := FALSE;
920: END IF;

Line 973: CSI_TRANSACTIONS_PKG.Insert_Row

969: nvl(p_init_msg_list,FND_API.G_FALSE) ||'-'||
970: nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL) );
971: END IF; -- 8214848 - dsingire
972:
973: CSI_TRANSACTIONS_PKG.Insert_Row
974: ( px_transaction_id => p_txn_rec.transaction_id,
975: p_transaction_date => p_txn_rec.transaction_date,
976: p_source_transaction_date => p_txn_rec.source_transaction_date,
977: p_transaction_type_id => p_txn_rec.transaction_type_id,

Line 5178: from csi_transactions

5174: --
5175: Begin
5176: select transaction_type_id
5177: into l_txn_type_id
5178: from csi_transactions
5179: where transaction_id = l_curr_ctr_rdg_rec.transaction_id;
5180: Exception
5181: when no_data_found then
5182: l_txn_type_id := -1;