APPS.AS_MESSAGE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 57

						-- to be inserted into
						-- AS_CONC_REQUEST_MESSAGES

G_User_Id	     NUMBER := FND_GLOBAL.User_Id;

Line: 65

PROCEDURE Insert_Row(X_Message_Text VARCHAR2,
		     X_Message_Type VARCHAR2,
		     X_Error_Number NUMBER) IS
BEGIN
  INSERT INTO as_conc_request_messages(conc_request_message_id,
				       creation_date,
				       created_by,
				       request_id,
				       type,
				       error_number,
				       text)
		         VALUES(as_conc_request_messages_s.nextval,
				SYSDATE,
				G_User_Id,
				G_Conc_Request_Id,
				X_Message_Type,
				X_Error_Number,
				X_Message_Text);

Line: 85

    Set_Error('AS_MESSAGE.Insert_Message');

Line: 89

PROCEDURE Insert_Message(Message_Text VARCHAR2,
			 Message_Type VARCHAR2,
			 Error_Number NUMBER) IS
BEGIN
  if (    (G_Output_Code = 'TABLE')
      and (G_Ins_Message_Flag = 'Y')) then
     Insert_Row(G_TMessage_Buffer(G_Msg_Count),
		G_TMessage_Type(G_Msg_Count), NULL);

Line: 99

  Insert_Row(Message_Text, Message_Type, Error_Number);

Line: 117

    Insert_Message(Message_Text, Message_Type, Error_Number);

Line: 188

     Insert_Row(G_TMessage_Buffer(G_Msg_Count),
		G_TMessage_Type(G_Msg_Count),
		NULL);

Line: 232

    Insert_Row(G_TMessage_Buffer(G_Msg_Count),
	       G_TMessage_Type(G_Msg_Count),
	       NULL);

Line: 346

  DELETE from as_conc_request_messages
  WHERE  request_id = X_Request_Id;

Line: 353

    SELECT max(conc_request_message_id)
    FROM   as_conc_request_messages
    WHERE  request_id = G_Conc_Request_Id;