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

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

Line: 149


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                   := FND_API.G_MISS_CHAR
 ,p_party_id               IN    pa_project_sets_b.party_id%TYPE                := FND_API.G_MISS_NUM
 ,p_effective_start_date   IN    pa_project_sets_b.effective_start_date%TYPE    := FND_API.G_MISS_DATE
 ,p_effective_end_date     IN    pa_project_sets_b.effective_end_date%TYPE      := FND_API.G_MISS_DATE
 ,p_access_level           IN    pa_project_sets_b.access_level%TYPE            := FND_API.G_MISS_NUM
 ,p_description            IN    pa_project_sets_tl.description%TYPE            := FND_API.G_MISS_CHAR
 ,p_party_name             IN    hz_parties.party_name%TYPE                     := FND_API.G_MISS_CHAR
 ,p_attribute_category     IN    pa_project_sets_b.attribute_category%TYPE      := FND_API.G_MISS_CHAR
 ,p_attribute1             IN    pa_project_sets_b.attribute1%TYPE              := FND_API.G_MISS_CHAR
 ,p_attribute2             IN    pa_project_sets_b.attribute2%TYPE              := FND_API.G_MISS_CHAR
 ,p_attribute3             IN    pa_project_sets_b.attribute3%TYPE              := FND_API.G_MISS_CHAR
 ,p_attribute4             IN    pa_project_sets_b.attribute4%TYPE              := FND_API.G_MISS_CHAR
 ,p_attribute5             IN    pa_project_sets_b.attribute5%TYPE              := FND_API.G_MISS_CHAR
 ,p_attribute6             IN    pa_project_sets_b.attribute6%TYPE              := FND_API.G_MISS_CHAR
 ,p_attribute7             IN    pa_project_sets_b.attribute7%TYPE              := FND_API.G_MISS_CHAR
 ,p_attribute8             IN    pa_project_sets_b.attribute8%TYPE              := FND_API.G_MISS_CHAR
 ,p_attribute9             IN    pa_project_sets_b.attribute9%TYPE              := FND_API.G_MISS_CHAR
 ,p_attribute10            IN    pa_project_sets_b.attribute10%TYPE             := FND_API.G_MISS_CHAR
 ,p_attribute11            IN    pa_project_sets_b.attribute11%TYPE             := FND_API.G_MISS_CHAR
 ,p_attribute12            IN    pa_project_sets_b.attribute12%TYPE             := FND_API.G_MISS_CHAR
 ,p_attribute13            IN    pa_project_sets_b.attribute13%TYPE             := FND_API.G_MISS_CHAR
 ,p_attribute14            IN    pa_project_sets_b.attribute14%TYPE             := FND_API.G_MISS_CHAR
 ,p_attribute15            IN    pa_project_sets_b.attribute15%TYPE             := FND_API.G_MISS_CHAR
 ,p_record_version_number  IN    pa_project_sets_b.record_version_number%TYPE   := NULL
 ,p_api_version            IN    NUMBER                                         := 1.0
 ,p_init_msg_list          IN    VARCHAR2                                       := FND_API.G_FALSE
 ,p_commit                 IN    VARCHAR2                                       := FND_API.G_FALSE
 ,p_validate_only          IN    VARCHAR2                                       := FND_API.G_TRUE
 ,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_return_status          VARCHAR2(1);

Line: 193


  PA_DEBUG.init_err_stack('PA_PROJECT_SETS_PUB.Update_Project_Set');

Line: 206


    SAVEPOINT UPDATE_PROJECT_SETS_PUB;

Line: 211


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

Line: 216


  PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_PROJECT_SETS_PUB.Update_Project_Set.begin'
                     ,x_msg         => 'calling Update_Project_Set pvt'
                     ,x_log_level   => 5);

Line: 221


  PA_PROJECT_SETS_PVT.update_project_set(
           p_project_set_id         =>   p_project_set_id
          ,p_project_set_name       =>   p_project_set_name
          ,p_party_id               =>   p_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_party_name             =>   p_party_name
          ,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: 277


          ROLLBACK TO UPDATE_PROJECT_SETS_PUB;

Line: 285


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

Line: 291


END update_project_set;

Line: 294


PROCEDURE delete_project_set
 (p_project_set_id         IN    pa_project_sets_b.project_set_id%TYPE            := NULL
 ,p_record_version_number  IN    pa_project_sets_b.record_version_number%TYPE     := NULL
 ,p_api_version            IN    NUMBER                                           := 1.0
 ,p_init_msg_list          IN    VARCHAR2                                         := FND_API.G_FALSE
 ,p_commit                 IN    VARCHAR2                                         := FND_API.G_FALSE
 ,p_validate_only          IN    VARCHAR2                                         := FND_API.G_TRUE
 ,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_return_status          VARCHAR2(1);

Line: 315


  PA_DEBUG.init_err_stack('PA_PROJECT_SETS_PUB.Delete_Project_Set');

Line: 328


    SAVEPOINT Delete_PROJECT_SETS_PUB;

Line: 333


  PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_PROJECT_SETS_PUB.Delete_Project_Set.begin'
                     ,x_msg         => 'Beginning of Delete_Project_Set pub'
                     ,x_log_level   => 5);

Line: 338


  PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_PROJECT_SETS_PUB.Delete_Project_Set.begin'
                     ,x_msg         => 'calling Delete_Project_Set pvt'
                     ,x_log_level   => 5);

Line: 343


  PA_PROJECT_SETS_PVT.delete_project_set
          (p_project_set_id         =>   p_project_set_id
          ,p_record_version_number  =>   p_record_version_number
          ,x_return_status          =>   l_return_status);

Line: 375


           ROLLBACK TO Delete_PROJECT_SETS_PUB;

Line: 383


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

Line: 389


END delete_project_set;

Line: 492


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
 ,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
 ,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_return_status          VARCHAR2(1);

Line: 514


  PA_DEBUG.init_err_stack('PA_PROJECT_SETS_PUB.Delete_Project_Set_Line');

Line: 527


    SAVEPOINT Delete_PROJECT_SET_LINE_PUB;

Line: 532


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

Line: 537


  PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_PROJECT_SETS_PUB.Delete_Project_Set_Line.begin'
                     ,x_msg         => 'calling Delete_Project_Set_Line pvt'
                     ,x_log_level   => 5);

Line: 542


  PA_PROJECT_SETS_PVT.delete_project_set_line
          (p_project_set_id     =>   p_project_set_id
          ,p_project_id         =>   p_project_id
          ,x_return_status      =>   l_return_status);

Line: 574


          ROLLBACK TO Delete_PROJECT_SET_LINE_PUB;

Line: 582


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_PROJECT_SETS_PUB.Delete_Project_Set_Line'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 588


END delete_project_set_line;

Line: 618


    update PA_PROJECT_SETS_B
    set PARTY_ID              = p_to_fk_id,
        last_update_date      = hz_utility_pub.last_update_date,
        last_updated_by       = hz_utility_pub.user_id,
        last_update_login     = hz_utility_pub.last_update_login,
        record_version_number = nvl(record_Version_number,0) +1
    where PARTY_ID = p_from_fk_id;