The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE UPDATE_COUNTER_READING_PRE(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
p_validation_level IN NUMBER,
p_CTR_GRP_LOG_ID IN NUMBER,
p_CTR_RDG_Tbl IN CS_CTR_CAPTURE_READING_PUB.CTR_RDG_Tbl_Type := CS_CTR_CAPTURE_READING_PUB.G_MISS_CTR_RDG_TBL,
p_PROP_RDG_Tbl IN CS_CTR_CAPTURE_READING_PUB.PROP_RDG_Tbl_Type := CS_CTR_CAPTURE_READING_PUB.G_MISS_PROP_RDG_TBL,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
--NEEDED
l_JTM_enable_prof_value varchar2(255);
' ''UPDATE_COUNTER_READING_PRE'', ' ||
' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
' ''Error:'' || SQLERRM ' || ',' ||
' 1,' ||
' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||
' ''UPDATE_COUNTER_READING_PRE'', ' ||
' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
' ''The procedure is called.'', ' ||
' 4,' ||
' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||
' begin ' || 'JTM_CTR_CAPTURE_READING_VUHK' || '.' || 'UPDATE_COUNTER_READING_PRE' ||
'(:1,:2,:3,:4,:5,:6,:7,:8, :9); ' ||
END UPDATE_COUNTER_READING_PRE;
PROCEDURE UPDATE_COUNTER_READING_POST(
P_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
p_validation_level IN NUMBER,
p_CTR_GRP_LOG_ID IN NUMBER,
p_CTR_RDG_Tbl IN CS_CTR_CAPTURE_READING_PUB.CTR_RDG_Tbl_Type := CS_CTR_CAPTURE_READING_PUB.G_MISS_CTR_RDG_TBL,
p_PROP_RDG_Tbl IN CS_CTR_CAPTURE_READING_PUB.PROP_RDG_Tbl_Type := CS_CTR_CAPTURE_READING_PUB.G_MISS_PROP_RDG_TBL,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
l_JTM_enable_prof_value varchar2(255);
' ''UPDATE_COUNTER_READING_POST'', ' ||
' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
' ''Error:'' || SQLERRM ' || ',' ||
' 1,' ||
' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||
' ''UPDATE_COUNTER_READING_POST'', ' ||
' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
' ''The procedure is called.'', ' ||
' 4,' ||
' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||
' begin ' || 'JTM_CTR_CAPTURE_READING_VUHK' || '.' || 'UPDATE_COUNTER_READING_POST' ||
'(:1,:2,:3,:4,:5,:6,:7,:8, :9); ' ||
END UPDATE_COUNTER_READING_POST;
PROCEDURE UPDATE_COUNTER_READING_PRE (
p_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
p_validation_level IN NUMBER,
p_CTR_RDG_Rec IN CS_CTR_CAPTURE_READING_PUB.CTR_RDG_Rec_Type,
p_COUNTER_GRP_LOG_ID IN NUMBER,
p_object_version_number IN NUMBER,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
--NEEDED
l_JTM_enable_prof_value varchar2(255);
' ''UPDATE_COUNTER_READING_PRE'', ' ||
' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
' ''Error:'' || SQLERRM ' || ',' ||
' 1,' ||
' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||
' ''UPDATE_COUNTER_READING_PRE'', ' ||
' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
' ''The procedure is called.'', ' ||
' 4,' ||
' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_PRE''); ' ||
' begin ' || 'JTM_CTR_CAPTURE_READING_VUHK' || '.' || 'UPDATE_COUNTER_READING_PRE' ||
'(:1,:2,:3,:4,:5,:6,:7,:8, :9); ' ||
END UPDATE_COUNTER_READING_PRE;
PROCEDURE UPDATE_COUNTER_READING_POST (
p_Api_Version_Number IN NUMBER,
P_Init_Msg_List IN VARCHAR2,
P_Commit IN VARCHAR2,
p_validation_level IN NUMBER,
p_CTR_RDG_Rec IN CS_CTR_CAPTURE_READING_PUB.CTR_RDG_Rec_Type,
p_COUNTER_GRP_LOG_ID IN NUMBER,
p_object_version_number IN NUMBER,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
--NEEDED
l_JTM_enable_prof_value varchar2(255);
' ''UPDATE_COUNTER_READING_POST'', ' ||
' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
' ''Error:'' || SQLERRM ' || ',' ||
' 1,' ||
' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||
' ''UPDATE_COUNTER_READING_POST'', ' ||
' ''CS_CTR_CAPTURE_READING_VUHK'', ' ||
' ''The procedure is called.'', ' ||
' 4,' ||
' ''JTM.CS_CTR_CAPTURE_READING_VUHK.UPDATE_COUNTER_READING_POST''); ' ||
' begin ' || 'JTM_CTR_CAPTURE_READING_VUHK' || '.' || 'UPDATE_COUNTER_READING_POST' ||
'(:1,:2,:3,:4,:5,:6,:7,:8, :9); ' ||
END UPDATE_COUNTER_READING_POST;
p_READING_UPDATED IN VARCHAR2,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
BEGIN
X_Return_Status := FND_API.G_RET_STS_SUCCESS;
p_READING_UPDATED IN VARCHAR2,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
BEGIN
X_Return_Status := FND_API.G_RET_STS_SUCCESS;
PROCEDURE UPDATE_CTR_PROP_READING_PRE (
p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_validation_level IN NUMBER,
p_PROP_RDG_Rec IN CS_CTR_CAPTURE_READING_PUB.PROP_RDG_Rec_Type,
p_COUNTER_GRP_LOG_ID IN NUMBER,
p_object_version_number IN NUMBER,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
BEGIN
X_Return_Status := FND_API.G_RET_STS_SUCCESS;
END UPDATE_CTR_PROP_READING_PRE;
PROCEDURE UPDATE_CTR_PROP_READING_POST (
p_api_version_number IN NUMBER,
p_init_msg_list IN VARCHAR2,
p_commit IN VARCHAR2,
p_validation_level IN NUMBER,
p_PROP_RDG_Rec IN CS_CTR_CAPTURE_READING_PUB.PROP_RDG_Rec_Type,
p_COUNTER_GRP_LOG_ID IN NUMBER,
p_object_version_number IN NUMBER,
X_Return_Status OUT NOCOPY VARCHAR2,
X_Msg_Count OUT NOCOPY NUMBER,
X_Msg_Data OUT NOCOPY VARCHAR2
)
IS
BEGIN
X_Return_Status := FND_API.G_RET_STS_SUCCESS;
END UPDATE_CTR_PROP_READING_POST;