<%@LANGUAGE="VBSCRIPT"%>
<%
Option explicit
Response.Expires = 0 ' always load the page, dont store
%>
<%
'=====================================================
' Schedule a Task
'=====================================================
%>
<%
'------------ ACCESS CONTROL ------------------
%>
<%
'------------ Variable Definition -------------
'------------ Constants Declaration -----------
'------------ Variable Init -------------------
'----------------------------------------------
%>
<%
Function Insert_Scheduling_Message( SSmsg, SSduedate )
Dim SEQ_msg_id
SEQ_msg_id = Get_From_DUAL("SEQ_MSG_ID.nextval")
OraSession.BeginTrans
OraDatabase.ExecuteSQL _
" INSERT INTO message_board (msg_id, msg_details, submition_date, due_date)"&_
" VALUES ("& SEQ_msg_id &", '"& SSmsg &"', "& ORA_SYSDATE &","& TO_ORADATE( SSduedate ) &")"
OraSession.CommitTrans
End Function
%>
<%
'Process submition
If CBool(QStrPar("action")) AND objAccessControl.UserLogedIn Then
Call Insert_Scheduling_Message ( QStrPar("FRmsg"), QStrPar("FRduedate") )
%>
<%
Call CloseWindow
End If
%>
Release Manager