100: AND NVL(ctr.start_date_active,sysdate) <= cv.value_timestamp
101: AND NVL(ctr.end_date_active,(sysdate+1)) > cv.value_timestamp;
102: --
103: BEGIN
104: -- Standard Start of API savepoint
105: SAVEPOINT capture_counter_reading;
106: -- Standard call to check for call compatibility.
107: IF NOT FND_API.Compatible_API_Call (l_api_version,
108: p_api_version,
102: --
103: BEGIN
104: -- Standard Start of API savepoint
105: SAVEPOINT capture_counter_reading;
106: -- Standard call to check for call compatibility.
107: IF NOT FND_API.Compatible_API_Call (l_api_version,
108: p_api_version,
109: l_api_name ,
110: G_PKG_NAME ) THEN
713: END IF;
714: --
715: csi_ctr_gen_utility_pvt.put_line('Capture Counter Reading Public API Successfully Completed...');
716: csi_ctr_gen_utility_pvt.put_line('*******************************************************************');
717: -- Standard call to get message count and IF count is get message info.
718: FND_MSG_PUB.Count_And_Get
719: ( p_count => x_msg_count,
720: p_data => x_msg_data
721: );
815: AND NVL(ctr.start_date_active,sysdate) <= cv.value_timestamp
816: AND NVL(ctr.end_date_active,(sysdate+1)) > cv.value_timestamp;
817: --
818: BEGIN
819: -- Standard Start of API savepoint
820: SAVEPOINT update_counter_reading;
821: -- Standard call to check for call compatibility.
822: IF NOT FND_API.Compatible_API_Call (l_api_version,
823: p_api_version,
817: --
818: BEGIN
819: -- Standard Start of API savepoint
820: SAVEPOINT update_counter_reading;
821: -- Standard call to check for call compatibility.
822: IF NOT FND_API.Compatible_API_Call (l_api_version,
823: p_api_version,
824: l_api_name ,
825: G_PKG_NAME ) THEN
1097: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
1098: COMMIT WORK;
1099: END IF;
1100: --
1101: -- Standard call to get message count and IF count is get message info.
1102: FND_MSG_PUB.Count_And_Get
1103: ( p_count => x_msg_count,
1104: p_data => x_msg_data
1105: );