APPS.DPP_ERROR_PVT SQL Statements

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

Line: 28

PROCEDURE Update_Error(
    p_api_version   	 IN 	  NUMBER
   ,p_init_msg_list	     IN 	  VARCHAR2     := FND_API.G_FALSE
   ,p_commit	         IN 	  VARCHAR2     := FND_API.G_FALSE
   ,p_validation_level	 IN 	  NUMBER       := FND_API.G_VALID_LEVEL_FULL
   ,x_return_status	     OUT  NOCOPY	  VARCHAR2
   ,x_msg_count	         OUT NOCOPY	  NUMBER
   ,x_msg_data	         OUT 	NOCOPY  VARCHAR2
   ,p_exe_update_rec	 IN   dpp_error_rec_type
   ,p_lines_tbl	         IN   dpp_lines_tbl_type
)
IS
l_api_name              CONSTANT VARCHAR2(30) := 'Update_Error';

Line: 48

l_exe_update_rec        DPP_ERROR_PVT.dpp_error_rec_type    := p_exe_update_rec;

Line: 50

l_update_count          NUMBER;

Line: 53

l_x_exe_update_rec      DPP_ExecutionDetails_PVT.DPP_EXE_UPDATE_REC_TYPE;

Line: 54

l_status_Update_tbl     DPP_ExecutionDetails_PVT.dpp_status_Update_tbl_type;

Line: 55

l_module 				CONSTANT VARCHAR2(100) := 'dpp.plsql.DPP_ERROR_PVT.UPDATE_ERROR';

Line: 60

    SAVEPOINT  Update_Error_PVT;

Line: 88

        l_x_EXE_UPDATE_rec.Execution_Detail_ID          := l_exe_update_rec.Execution_Detail_ID;

Line: 89

        l_x_EXE_UPDATE_rec.Transaction_Header_ID        := l_exe_update_rec.Transaction_Header_ID;

Line: 91

        l_x_exe_update_rec.Execution_End_Date           := sysdate;

Line: 92

        l_x_exe_update_rec.execution_status             := 'ERROR';

Line: 93

        l_x_exe_update_rec.Last_Updated_By              := l_exe_update_rec.Last_Updated_By;

Line: 94

        l_x_exe_update_rec.Provider_Process_Id          := l_exe_update_rec.Provider_Process_Id;

Line: 95

        l_x_exe_update_rec.Provider_Process_Instance_id   := l_exe_update_rec.Provider_Process_Instance_id;

Line: 96

        l_x_exe_update_rec.Output_XML                     := l_exe_update_rec.Output_XML;

Line: 101

    l_status_Update_tbl(i).update_status := 'N';

Line: 102

    l_status_Update_tbl(i).transaction_line_id := l_lines_tbl(i);

Line: 106

        DPP_ExecutionDetails_PVT.Update_ExecutionDetails(
         p_api_version   	 => l_api_version
        ,p_init_msg_list	 => FND_API.G_FALSE
        ,p_commit	         => FND_API.G_FALSE
        ,p_validation_level	 => FND_API.G_VALID_LEVEL_FULL
        ,x_return_status	 => l_return_status
        ,x_msg_count	     => l_msg_count
        ,x_msg_data	         => l_msg_data
        ,p_EXE_UPDATE_rec	 => l_x_exe_update_rec
        ,p_status_Update_tbl => l_status_Update_tbl
        );

Line: 147

   ROLLBACK TO Update_Error_PVT;

Line: 162

   ROLLBACK TO Update_Error_PVT;

Line: 177

   ROLLBACK TO Update_Error_PVT;

Line: 179

               fnd_message.set_token('ROUTINE', 'DPP_ERROR_PVT.Update_Error');

Line: 198

  END Update_Error;