[Home] [Help]
101: AND NVL(ctr.start_date_active,sysdate) <= cv.value_timestamp
102: AND NVL(ctr.end_date_active,(sysdate+1)) > cv.value_timestamp;
103: --
104: BEGIN
105: -- Standard Start of API savepoint
106: SAVEPOINT capture_counter_reading;
107: -- Standard call to check for call compatibility.
108: IF NOT FND_API.Compatible_API_Call (l_api_version,
109: p_api_version,
103: --
104: BEGIN
105: -- Standard Start of API savepoint
106: SAVEPOINT capture_counter_reading;
107: -- Standard call to check for call compatibility.
108: IF NOT FND_API.Compatible_API_Call (l_api_version,
109: p_api_version,
110: l_api_name ,
111: G_PKG_NAME ) THEN
744: END IF;
745: --
746: csi_ctr_gen_utility_pvt.put_line('Capture Counter Reading Public API Successfully Completed...');
747: csi_ctr_gen_utility_pvt.put_line('*******************************************************************');
748: -- Standard call to get message count and IF count is get message info.
749: FND_MSG_PUB.Count_And_Get
750: ( p_count => x_msg_count,
751: p_data => x_msg_data
752: );
846: AND NVL(ctr.start_date_active,sysdate) <= cv.value_timestamp
847: AND NVL(ctr.end_date_active,(sysdate+1)) > cv.value_timestamp;
848: --
849: BEGIN
850: -- Standard Start of API savepoint
851: SAVEPOINT update_counter_reading;
852: -- Standard call to check for call compatibility.
853: IF NOT FND_API.Compatible_API_Call (l_api_version,
854: p_api_version,
848: --
849: BEGIN
850: -- Standard Start of API savepoint
851: SAVEPOINT update_counter_reading;
852: -- Standard call to check for call compatibility.
853: IF NOT FND_API.Compatible_API_Call (l_api_version,
854: p_api_version,
855: l_api_name ,
856: G_PKG_NAME ) THEN
1128: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
1129: COMMIT WORK;
1130: END IF;
1131: --
1132: -- Standard call to get message count and IF count is get message info.
1133: FND_MSG_PUB.Count_And_Get
1134: ( p_count => x_msg_count,
1135: p_data => x_msg_data
1136: );