eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_SETS_PVT SQL Statements

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

Line: 88


                        ,x_msg         => 'before pa_project_sets_pkg.insert_row'
                        ,x_log_level   => 5);

Line: 92


     PA_PROJECT_SETS_PKG.insert_row
          (p_project_set_name       =>   p_project_set_name
          ,p_party_id               =>   l_party_id
          ,p_effective_start_date   =>   p_effective_start_date
          ,p_effective_end_date     =>   p_effective_end_date
          ,p_access_level           =>   p_access_level
          ,p_description            =>   p_description
          ,p_attribute_category     =>   p_attribute_category
          ,p_attribute1             =>   p_attribute1
          ,p_attribute2             =>   p_attribute2
          ,p_attribute3             =>   p_attribute3
          ,p_attribute4             =>   p_attribute4
          ,p_attribute5             =>   p_attribute5
          ,p_attribute6             =>   p_attribute6
          ,p_attribute7             =>   p_attribute7
          ,p_attribute8             =>   p_attribute8
          ,p_attribute9             =>   p_attribute9
          ,p_attribute10            =>   p_attribute10
          ,p_attribute11            =>   p_attribute11
          ,p_attribute12            =>   p_attribute12
          ,p_attribute13            =>   p_attribute13
          ,p_attribute14            =>   p_attribute14
          ,p_attribute15            =>   p_attribute15
          ,x_project_set_id         =>   x_project_set_id
          ,x_return_status          =>   l_return_status);

Line: 148


PROCEDURE update_project_set
( p_project_set_id         IN    pa_project_sets_b.project_set_id%TYPE
 ,p_project_set_name       IN    pa_project_sets_tl.name%TYPE
 ,p_party_id               IN    pa_project_sets_b.party_id%TYPE
 ,p_effective_start_date   IN    pa_project_sets_b.effective_start_date%TYPE
 ,p_effective_end_date     IN    pa_project_sets_b.effective_end_date%TYPE
 ,p_access_level           IN    pa_project_sets_b.access_level%TYPE
 ,p_description            IN    pa_project_sets_tl.description%TYPE
 ,p_party_name             IN    hz_parties.party_name%TYPE
 ,p_attribute_category     IN    pa_project_sets_b.attribute_category%TYPE
 ,p_attribute1             IN    pa_project_sets_b.attribute1%TYPE
 ,p_attribute2             IN    pa_project_sets_b.attribute2%TYPE
 ,p_attribute3             IN    pa_project_sets_b.attribute3%TYPE
 ,p_attribute4             IN    pa_project_sets_b.attribute4%TYPE
 ,p_attribute5             IN    pa_project_sets_b.attribute5%TYPE
 ,p_attribute6             IN    pa_project_sets_b.attribute6%TYPE
 ,p_attribute7             IN    pa_project_sets_b.attribute7%TYPE
 ,p_attribute8             IN    pa_project_sets_b.attribute8%TYPE
 ,p_attribute9             IN    pa_project_sets_b.attribute9%TYPE
 ,p_attribute10            IN    pa_project_sets_b.attribute10%TYPE
 ,p_attribute11            IN    pa_project_sets_b.attribute11%TYPE
 ,p_attribute12            IN    pa_project_sets_b.attribute12%TYPE
 ,p_attribute13            IN    pa_project_sets_b.attribute13%TYPE
 ,p_attribute14            IN    pa_project_sets_b.attribute14%TYPE
 ,p_attribute15            IN    pa_project_sets_b.attribute15%TYPE
 ,p_record_version_number  IN    pa_project_sets_b.record_version_number%TYPE
 ,x_return_status         OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS
  l_party_id                pa_project_sets_b.party_id%TYPE := p_party_id;

Line: 191


  PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_PROJECT_SETS_PVT.Update_Project_Set.begin'
                     ,x_msg         => 'Beginning of Update_Project_Set pvt'
                     ,x_log_level   => 5);

Line: 229


     PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_PROJECT_SETS_PVT.Update_Project_Set'
                        ,x_msg         => 'before pa_project_sets_pkg.insert_row'
                        ,x_log_level   => 5);

Line: 234


     PA_PROJECT_SETS_PKG.update_row
          (p_project_set_id         =>   p_project_set_id
          ,p_project_set_name       =>   p_project_set_name
          ,p_party_id               =>   l_party_id
          ,p_effective_start_date   =>   p_effective_start_date
          ,p_effective_end_date     =>   p_effective_end_date
          ,p_access_level           =>   p_access_level
          ,p_description            =>   p_description
          ,p_attribute_category     =>   p_attribute_category
          ,p_attribute1             =>   p_attribute1
          ,p_attribute2             =>   p_attribute2
          ,p_attribute3             =>   p_attribute3
          ,p_attribute4             =>   p_attribute4
          ,p_attribute5             =>   p_attribute5
          ,p_attribute6             =>   p_attribute6
          ,p_attribute7             =>   p_attribute7
          ,p_attribute8             =>   p_attribute8
          ,p_attribute9             =>   p_attribute9
          ,p_attribute10            =>   p_attribute10
          ,p_attribute11            =>   p_attribute11
          ,p_attribute12            =>   p_attribute12
          ,p_attribute13            =>   p_attribute13
          ,p_attribute14            =>   p_attribute14
          ,p_attribute15            =>   p_attribute15
          ,p_record_version_number  =>   p_record_version_number
          ,x_return_status          =>   l_return_status);

Line: 271


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PVT.Update_Project_Set'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 277


END Update_Project_Set;

Line: 280


PROCEDURE delete_project_set
(  p_project_set_id        IN  pa_project_sets_b.project_set_id%TYPE
  ,p_record_version_number IN  pa_project_sets_b.record_version_number%TYPE
  ,x_return_status        OUT  NOCOPY VARCHAR2   --File.Sql.39 bug 4440895
)
IS
 l_return_status          VARCHAR2(1);

Line: 298


  PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_PROJECT_SETS_PVT.Delete_Project_Set'
                     ,x_msg         => 'Beginning of Delete_Project_Set pvt'
                     ,x_log_level   => 5);

Line: 309


        delete_project_set_line(p_project_set_id   => l_project_set_lines_tbl(i).project_set_id
                               ,p_project_id       => l_project_set_lines_tbl(i).project_id
                               ,x_return_status    => l_return_status);

Line: 323


        PA_PROJECT_SETS_PKG.delete_row
               (p_project_set_id     => p_project_set_id,
                p_record_version_number => p_record_version_number,
                x_return_status      => l_return_status);

Line: 340


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PVT.Delete_Project_Set'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 346


END Delete_Project_Set;

Line: 373


  SELECT project_set_id
    INTO l_project_set_id
    FROM pa_project_sets_b
   WHERE project_set_id = p_project_set_id
     FOR UPDATE NOWAIT;

Line: 385


     PA_PROJECT_SETS_PKG.insert_row_lines(
          p_project_set_id    =>   p_project_set_id
         ,p_project_id        =>   p_project_id
         ,x_return_status     =>   x_return_status);

Line: 407


PROCEDURE delete_project_set_line
(  p_project_set_id     IN   pa_project_set_lines.project_set_id%TYPE
  ,p_project_id         IN   pa_project_set_lines.project_id%TYPE
  ,x_return_status     OUT   NOCOPY VARCHAR2    --File.Sql.39 bug 4440895
)
IS
  l_return_status    VARCHAR2(1);

Line: 423


  PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_PROJECT_SETS_PVT.Delete_Project_Set_Line.begin'
                     ,x_msg         => 'Beginning of Delete_Project_Set_Line pvt'
                     ,x_log_level   => 5);

Line: 435


     PA_PROJECT_SETS_PKG.delete_row_lines(
          p_project_set_id    =>   p_project_set_id
         ,p_project_id        =>   p_project_id
         ,x_return_status     =>   x_return_status);

Line: 446


                                ,p_procedure_name => 'Delete_Project_Set_line',
				p_error_text => SUBSTRB(SQLERRM,1,120)
				);

Line: 453


END delete_project_set_line;

Line: 455


PROCEDURE delete_proj_from_proj_set
( p_project_id         IN   pa_project_set_lines.project_id%TYPE
 ,x_return_status     OUT   NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
)
IS
BEGIN
  -- Initialize the return status to success
  x_return_status := FND_API.G_RET_STS_SUCCESS;

Line: 464


  DELETE FROM pa_project_set_lines
  WHERE project_id = p_project_id;

Line: 470


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SET_LINES_PKG.Delete_project_from_project_sets'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 476


END delete_proj_from_proj_set;