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_SUBTEAMS_PVT SQL Statements

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

Line: 48


   SELECT  rowid
   FROM pa_projects_all
   WHERE project_id =p_object_id;

Line: 53


  SELECT  rowid
  FROM pa_project_subteams
  WHERE name =p_subteam_name
  AND object_type = p_object_type
  AND object_id = p_object_id;

Line: 161


    PA_PROJECT_SUBTEAMS_PKG.Insert_Row
    (p_subteam_name                => p_subteam_name
    ,p_object_type                 => p_object_type
    ,p_object_id                   => p_object_id
    ,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_subteam_row_id              => x_subteam_row_id
    ,x_new_subteam_id              => x_new_subteam_id
    ,x_return_status               => x_return_status
    ,x_msg_count                   => x_msg_count
    ,x_msg_data                    => x_msg_data
  );

Line: 224


PROCEDURE Update_Subteam
(
 p_api_version                 IN     NUMBER :=  1.0,
 p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
 p_commit                      IN     VARCHAR2 := FND_API.g_false,
 p_validate_only               IN     VARCHAR2 := FND_API.g_true,
 p_validation_level            IN     NUMBER   := FND_API.g_valid_level_full,
 p_calling_module              IN     VARCHAR2 := 'SELF_SERVICE',
 p_debug_mode                  IN     VARCHAR2 := 'N',
 p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,
 p_subteam_row_id              IN     ROWID := null,
 p_subteam_id                  IN     pa_project_subteams.project_subteam_id%TYPE := FND_API.g_miss_num,
 p_subteam_name                IN     pa_project_subteams.name%TYPE              := FND_API.g_miss_char,
 p_object_type                 IN     pa_project_subteams.object_type%TYPE       := FND_API.g_miss_char,
 p_object_id                   IN     pa_project_subteams.object_id%TYPE        := FND_API.g_miss_num,
 p_description                 IN     pa_project_subteams.description%TYPE       := FND_API.g_miss_char,
 p_record_version_number       IN     pa_project_subteams.record_version_number%TYPE := FND_API.g_miss_num,
 p_attribute_category          IN     pa_project_subteams.attribute_category%TYPE    := FND_API.g_miss_char,
 p_attribute1                  IN pa_project_subteams.attribute1%TYPE                := FND_API.G_MISS_CHAR,
 p_attribute2                  IN pa_project_subteams.attribute2%TYPE                := FND_API.G_MISS_CHAR,
 p_attribute3                  IN pa_project_subteams.attribute3%TYPE                := FND_API.G_MISS_CHAR,
 p_attribute4                  IN pa_project_subteams.attribute4%TYPE                := FND_API.G_MISS_CHAR,
 p_attribute5                  IN pa_project_subteams.attribute5%TYPE                := FND_API.G_MISS_CHAR,
 p_attribute6                  IN pa_project_subteams.attribute6%TYPE                := FND_API.G_MISS_CHAR,
 p_attribute7                  IN pa_project_subteams.attribute7%TYPE                := FND_API.G_MISS_CHAR,
 p_attribute8                  IN pa_project_subteams.attribute8%TYPE                := FND_API.G_MISS_CHAR,
 p_attribute9                  IN pa_project_subteams.attribute9%TYPE                := FND_API.G_MISS_CHAR,
 p_attribute10                 IN pa_project_subteams.attribute10%TYPE               := FND_API.G_MISS_CHAR,
 p_attribute11                 IN pa_project_subteams.attribute11%TYPE               := FND_API.G_MISS_CHAR,
 p_attribute12                 IN pa_project_subteams.attribute12%TYPE               := FND_API.G_MISS_CHAR,
 p_attribute13                 IN pa_project_subteams.attribute13%TYPE               := FND_API.G_MISS_CHAR,
 p_attribute14                 IN pa_project_subteams.attribute14%TYPE               := FND_API.G_MISS_CHAR,
 p_attribute15                 IN pa_project_subteams.attribute15%TYPE               := FND_API.G_MISS_CHAR,
 x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
 --x_record_version_number     OUT    NUMBER ,
 x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
 x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
) IS

   l_count number;

Line: 269


     SELECT  rowid
     FROM pa_projects_all
     WHERE project_id =p_object_id;

Line: 274


      SELECT  rowid
    FROM pa_project_subteams
    WHERE name = p_subteam_name
    AND object_type = p_object_type
    AND object_id = p_object_id
    AND project_subteam_id <> p_subteam_id;

Line: 284


  PA_DEBUG.init_err_stack('PA_PROJECT_SUBTEAMS_PVT.Update_Subteam');

Line: 294


    SAVEPOINT SBT_PVT_UPDATE_SBT;

Line: 395


    PA_PROJECT_SUBTEAMS_PKG.Update_Row
    (p_subteam_row_id              => p_subteam_row_id
    ,p_subteam_id                  => p_subteam_id
    ,p_record_version_number       => p_record_version_number
    ,p_subteam_name                => p_subteam_name
    ,p_object_type                 => p_object_type
    ,p_object_id                   => p_object_id
    ,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_return_status               => x_return_status
    ,x_msg_count                   => x_msg_count
    ,x_msg_data                    => x_msg_data
  );

Line: 442


          ROLLBACK TO SBT_PVT_UPDATE_SBT;

Line: 446


        FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SUBTEAMS_PVT.Update_Subteam'
                                 ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 452


END Update_Subteam;

Line: 455


PROCEDURE Delete_Subteam
(
 p_api_version                 IN     NUMBER :=  1.0,
 p_init_msg_list               IN     VARCHAR2 := fnd_api.g_true,
 p_commit                      IN     VARCHAR2                                        := FND_API.g_false,

 p_validate_only               IN     VARCHAR2                                        := FND_API.g_true,

 p_validation_level            IN     NUMBER                                        := FND_API.g_valid_level_full,

 p_calling_module              IN     VARCHAR2
     := 'SELF_SERVICE',

 p_debug_mode                  IN     VARCHAR2 := 'N',

 p_max_msg_count               IN     NUMBER := FND_API.g_miss_num,

 p_subteam_row_id              IN     ROWID := NULL,

 p_subteam_id                  IN     pa_project_subteams.project_subteam_id%TYPE := fnd_api.g_miss_num,

 p_record_version_number       IN     NUMBER                                          := FND_API.G_MISS_NUM,

 x_return_status               OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
 x_msg_count                   OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
 x_msg_data                    OUT    NOCOPY VARCHAR2 --File.Sql.39 bug 4440895

) IS

 l_count          NUMBER;

Line: 493


    SELECT ROWID
      FROM pa_project_subteam_parties
      WHERE project_subteam_id = p_subteam_id ;

Line: 499


  PA_DEBUG.init_err_stack('PA_PROJECT_SUBTEAMS_PVT.Delete_Subteam');

Line: 508


    SAVEPOINT SBT_PVT_DELETE_SBT;

Line: 553


    PA_PROJECT_SUBTEAMS_PKG.Delete_Row
    ( p_subteam_row_id     => p_subteam_row_id
     ,p_subteam_id         => p_subteam_id
     ,p_record_version_number => l_record_version_number
     ,x_return_status => x_return_status
     ,x_msg_count     => x_msg_count
     ,x_msg_data      => x_msg_data
    );

Line: 585


          ROLLBACK TO SBT_PVT_DELETE_SBT;

Line: 589


        FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SUBTEAMS_PVT.Delete_Subteam'
                                 ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 595


END Delete_Subteam;

Line: 615


   SELECT project_subteam_id
   INTO l_subteam_id
   FROM pa_project_subteams
   WHERE name = p_subteam_name
   AND object_type=p_object_type
   AND object_id = p_object_id;