DBA Data[Home] [Help]

APPS.CSI_COUNTER_READINGS_PVT dependencies on CSI_TRANSACTIONS

Line 77: from CSI_TRANSACTIONS

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

Line 794: select CSI_TRANSACTIONS_S.nextval

790: IF p_txn_rec.transaction_id IS NULL OR
791: p_txn_rec.transaction_id = FND_API.G_MISS_NUM 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;

Line 849: CSI_TRANSACTIONS_PKG.Insert_Row

845: nvl(p_commit,FND_API.G_FALSE) ||'-'||
846: nvl(p_init_msg_list,FND_API.G_FALSE) ||'-'||
847: nvl(p_validation_level,FND_API.G_VALID_LEVEL_FULL) );
848:
849: CSI_TRANSACTIONS_PKG.Insert_Row
850: ( px_transaction_id => p_txn_rec.transaction_id,
851: p_transaction_date => p_txn_rec.transaction_date,
852: p_source_transaction_date => p_txn_rec.source_transaction_date,
853: p_transaction_type_id => p_txn_rec.transaction_type_id,

Line 4448: from csi_transactions

4444: --
4445: Begin
4446: select transaction_type_id
4447: into l_txn_type_id
4448: from csi_transactions
4449: where transaction_id = l_curr_ctr_rdg_rec.transaction_id;
4450: Exception
4451: when no_data_found then
4452: l_txn_type_id := -1;