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

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

Line: 83


   g_team_template_id_tbl.DELETE;

Line: 94


          g_team_template_id_tbl.DELETE;

Line: 137


SELECT calendar_id, location_id
  FROM pa_projects_all
 WHERE project_id = p_project_id;

Line: 607


PROCEDURE Execute_Update_Team_Template
( p_team_template_id               IN     pa_team_templates.team_template_id%TYPE
 ,p_record_version_number          IN     pa_team_templates.record_version_number%TYPE
 ,p_team_template_name             IN     pa_team_templates.team_template_name%TYPE    := FND_API.G_MISS_CHAR
 ,p_description                    IN     pa_team_templates.description%TYPE           := FND_API.G_MISS_CHAR
 ,p_start_date_active              IN     pa_team_templates.start_date_active%TYPE  := FND_API.G_MISS_DATE
 ,p_end_date_active                IN     pa_team_templates.end_date_active%TYPE    := FND_API.G_MISS_DATE
 ,p_calendar_name                  IN     jtf_calendars_tl.calendar_name%TYPE          := FND_API.G_MISS_CHAR
 ,p_calendar_id                    IN     pa_team_templates.calendar_id%TYPE           := FND_API.G_MISS_NUM
 ,p_work_type_name                 IN     pa_work_types_vl.name%TYPE                   := FND_API.G_MISS_CHAR
 ,p_work_type_id                   IN     pa_team_templates.work_type_id%TYPE          := FND_API.G_MISS_NUM
 ,p_role_list_name                 IN     pa_role_lists.name%TYPE                      := FND_API.G_MISS_CHAR
 ,p_role_list_id                   IN     pa_team_templates.role_list_id%TYPE          := FND_API.G_MISS_NUM
 ,p_team_start_date            IN     pa_team_templates.team_start_date%TYPE       := FND_API.G_MISS_DATE
 ,p_workflow_in_progress_flag      IN     pa_team_templates.workflow_in_progress_flag%TYPE := FND_API.G_MISS_CHAR
 ,p_attribute_category             IN     pa_team_templates.attribute_category%TYPE    := FND_API.G_MISS_CHAR
 ,p_attribute1                     IN     pa_team_templates.attribute1%TYPE            := FND_API.G_MISS_CHAR
 ,p_attribute2                     IN     pa_team_templates.attribute2%TYPE            := FND_API.G_MISS_CHAR
 ,p_attribute3                     IN     pa_team_templates.attribute3%TYPE            := FND_API.G_MISS_CHAR
 ,p_attribute4                     IN     pa_team_templates.attribute4%TYPE            := FND_API.G_MISS_CHAR
 ,p_attribute5                     IN     pa_team_templates.attribute5%TYPE            := FND_API.G_MISS_CHAR
 ,p_attribute6                     IN     pa_team_templates.attribute6%TYPE            := FND_API.G_MISS_CHAR
 ,p_attribute7                     IN     pa_team_templates.attribute7%TYPE            := FND_API.G_MISS_CHAR
 ,p_attribute8                     IN     pa_team_templates.attribute8%TYPE            := FND_API.G_MISS_CHAR
 ,p_attribute9                     IN     pa_team_templates.attribute9%TYPE            := FND_API.G_MISS_CHAR
 ,p_attribute10                    IN     pa_team_templates.attribute10%TYPE           := FND_API.G_MISS_CHAR
 ,p_attribute11                    IN     pa_team_templates.attribute11%TYPE           := FND_API.G_MISS_CHAR
 ,p_attribute12                    IN     pa_team_templates.attribute12%TYPE           := FND_API.G_MISS_CHAR
 ,p_attribute13                    IN     pa_team_templates.attribute13%TYPE           := FND_API.G_MISS_CHAR
 ,p_attribute14                    IN     pa_team_templates.attribute14%TYPE           := FND_API.G_MISS_CHAR
 ,p_attribute15                    IN     pa_team_templates.attribute15%TYPE           := FND_API.G_MISS_CHAR
 ,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_max_msg_count                  IN     NUMBER                                       := FND_API.G_MISS_NUM
 ,p_validate_only                  IN     VARCHAR2                                     := FND_API.G_FALSE
 ,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_team_template_rec   team_template_rec;

Line: 655


  PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PUB.Execute_Update_Team_Template');

Line: 667


    SAVEPOINT   ASG_PUB_EXEC_UPDATE_TEAM_TEMP;

Line: 672


  PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.execute_update_team_template.begin'
                     ,x_msg         => 'Beginning of Execute_Update_Team_Template'
                     ,x_log_level   => 5);

Line: 710


  PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_TEAM_TEMPLATES_PUB.execute_create_team_template.before_calling_update_team_template'
                     ,x_msg         => 'Calling Update_Team_Template'
                     ,x_log_level   => 5);

Line: 716


  PA_TEAM_TEMPLATES_PUB.Update_Team_Template
     (p_team_template_rec           => l_team_template_rec
     ,p_calendar_name               => p_calendar_name
     ,p_work_type_name              => p_work_type_name
     ,p_role_list_name              => p_role_list_name
     ,p_api_version                 => p_api_version
     ,p_init_msg_list               => p_init_msg_list
     ,p_commit                      => p_commit
     ,p_max_msg_count               => p_max_msg_count
     ,x_return_status               => x_return_status
     ,x_msg_count                   => x_msg_count
     ,x_msg_data                    => x_msg_data);

Line: 736


          ROLLBACK TO ASG_PUB_EXEC_UPDATE_TEAM_TEMP;

Line: 740


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TEAM_TEMPLATES_PUB.Execute_Update_Team_Template'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 746


END Execute_Update_Team_Template;

Line: 749


PROCEDURE Update_Team_Template
( p_team_template_rec              IN     team_template_rec
 ,p_calendar_name                  IN     jtf_calendars_tl.calendar_name%TYPE          := FND_API.G_MISS_CHAR
 ,p_work_type_name                 IN     pa_work_types_vl.name%TYPE                   := FND_API.G_MISS_CHAR
 ,p_role_list_name                 IN     pa_role_lists.name%TYPE                      := FND_API.G_MISS_CHAR
 ,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_max_msg_count                  IN     NUMBER                                       := FND_API.G_MISS_NUM
 ,p_validate_only                  IN     VARCHAR2                                     := FND_API.G_FALSE
 ,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_team_template_rec          team_template_rec;

Line: 778


SELECT workflow_in_progress_flag
FROM   pa_team_templates
WHERE  team_template_id = p_team_template_rec.team_template_id
AND    record_version_number = p_team_template_rec.record_version_number;

Line: 786


  PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PUB.Update_Team_Templates');

Line: 793


    SAVEPOINT ASG_PUB_UPDATE_TEAM_TEMPLATE;

Line: 803


  PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_Team_Teamplates_PUB.Update_Team_Template.begin'
                     ,x_msg         => 'Beginning of Update_Team_Template'
                     ,x_log_level   => 5);

Line: 901


  PA_TEAM_TEMPLATES_PVT.Update_Team_Template(p_team_template_rec => l_team_template_rec
                                            ,p_commit => p_commit
                                            ,p_validate_only => p_validate_only
                                            ,x_return_status => x_return_status);

Line: 939


          ROLLBACK TO ASG_PUB_UPDATE_TEAM_TEMPLATE;

Line: 942


        FND_MSG_PUB.add_exc_msg( p_pkg_name       => 'PA_TEAM_TEMPLATES_PUB.Update_Team_Template'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 948


END Update_Team_Template;

Line: 951


PROCEDURE Delete_Team_Template
( p_team_template_id            IN     pa_team_templates.team_template_id%TYPE
 ,p_record_version_number       IN     NUMBER
 ,p_api_version                 IN     NUMBER                                          := 1
 ,p_init_msg_list               IN     VARCHAR2                                        := FND_API.G_TRUE
 ,p_commit                      IN     VARCHAR2                                        := FND_API.G_FALSE
 ,p_max_msg_count               IN     NUMBER                                          := FND_API.G_MISS_NUM
 ,p_validate_only               IN     VARCHAR2                                        := FND_API.G_FALSE
 ,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_msg_index_out                 NUMBER;

Line: 970


SELECT workflow_in_progress_flag
  FROM pa_team_templates
 WHERE team_template_id = p_team_template_id
   AND record_version_number = p_record_version_number;

Line: 978


  PA_DEBUG.init_err_stack('PA_TEAM_TEMPLATES_PUB.Delete_Team_Template');

Line: 985


    SAVEPOINT ASG_PUB_DELETE_TEAM_TEMPLATE;

Line: 995


  PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_Team_Teamplates_PUB.Delete_Team_Template.begin'
                     ,x_msg         => 'Beginning of Delete_Team_Template'
                     ,x_log_level   => 5);

Line: 1020


     PA_DEBUG.write_log (x_module      => 'pa.plsql.PA_Team_Teamplates_PUB.Delete_Team_Template.calling_pvt'
                        ,x_msg         => 'Calling delete team template pvt'
                        ,x_log_level   => 5);

Line: 1025


     PA_TEAM_TEMPLATES_PVT.Delete_Team_Template
                               (p_team_template_id => p_team_template_id
                               ,p_record_version_number => p_record_version_number
                               ,x_return_status => x_return_status);

Line: 1067


           ROLLBACK TO ASG_PUB_DELETE_TEAM_TEMPLATE;

Line: 1070


         FND_MSG_PUB.add_exc_msg( p_pkg_name       => 'PA_TEAM_TEMPLATES_PUB.Delete_Assignment'
                                 ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 1076


END Delete_Team_Template;