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

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

Line: 38


   SELECT line.action_set_line_id,
          cond.action_set_line_condition_id
   BULK COLLECT INTO l_line_id_tbl,
          l_line_cond_id_tbl
   FROM pa_action_set_lines line,
        pa_action_set_line_cond cond
   WHERE line.action_set_id = p_action_set_id
     AND line.action_set_line_id = cond.action_set_line_id;

Line: 54


      PA_ACTION_SETS_PVT.Bulk_Update_Line_Number(
        p_action_set_line_id_tbl     => l_line_id_tbl
       ,p_line_number_tbl            => l_line_number_tbl
       ,x_return_status              => x_return_status
       );

Line: 93


    ,x_action_line_audit_tbl       OUT NOCOPY   pa_action_set_utils.insert_audit_lines_tbl_type
    ,x_action_line_result_code     OUT NOCOPY   VARCHAR2)
IS
  CURSOR c_proj_info(cp_project_id NUMBER) IS
    SELECT p.start_date proj_start_date,
           p.project_status_code proj_status_code
    FROM  pa_projects_all p
    WHERE p.project_id = cp_project_id;

Line: 259


    SELECT next_reporting_date report_date
    FROM pa_object_page_layouts
    WHERE TRUNC(next_reporting_date) = l_sysdate
      AND object_id      = cp_project_id
      AND object_type    = 'PA_PROJECTS'
      AND page_type_code = 'TPR';

Line: 321


   Select action_set_id
   from pa_action_sets
   where object_type = 'PA_PROJECTS'
   and object_id = p_project_id_from;

Line: 326


   SELECT
         pa_action_set_utils.get_action_set_id
              ('PA_TASK_PROGRESS','PA_PROJECTS',p_project_id_from) action_set_id
   FROM  dual
   WHERE pa_action_set_utils.get_action_set_id
         ('PA_TASK_PROGRESS','PA_PROJECTS',p_project_id_from) is not null;

Line: 390


PROCEDURE delete_action_set
 (p_action_set_id          IN    pa_action_sets.action_set_id%TYPE        := NULL
 ,p_action_set_type_code   IN   pa_action_sets.action_set_type_code%TYPE := 'PA_TASK_PROGRESS'
 ,p_object_type            IN    pa_action_sets.object_type%TYPE             := 'PA_PROJECTS'
 ,p_object_id              IN    pa_action_sets.object_id%TYPE               := NULL
 ,p_record_version_number  IN    pa_action_sets.record_version_number%TYPE   := NULL
 ,p_api_version            IN    NUMBER               := 1.0
 ,p_commit                 IN    VARCHAR2             := FND_API.G_FALSE
 ,p_validate_only          IN    VARCHAR2             := FND_API.G_TRUE
 ,p_init_msg_list          IN    VARCHAR2             := FND_API.G_TRUE
 ,x_return_status         OUT NOCOPY    VARCHAR2
 ,x_msg_count             OUT NOCOPY    NUMBER
 ,x_msg_data              OUT NOCOPY    VARCHAR2
   ) IS

  l_return_status VARCHAR2(1);

Line: 411


   PA_DEBUG.init_err_stack('PA_TASK_PROG_ACTSET.delete_action_set');

Line: 412


   PA_DEBUG.WRITE_LOG(x_Module        => 'pa.plsql.PA_TASK_PROG_ACTSET.delete_action_set.begin'
                    ,x_Msg          => 'in PA_TASK_PROG_ACTSET.delete_action_set'
                    ,x_Log_Level    => 6);

Line: 418


       select record_version_number
         into l_record_version_number
         from pa_action_sets
         where action_set_id = p_action_set_id;

Line: 423


   PA_ACTION_SETS_PUB.delete_action_set
     (p_action_set_id          => p_action_set_id
     ,p_action_set_type_code   => p_action_set_type_code
     ,p_object_type            => p_object_type
     ,p_object_id              => p_object_id
     ,p_init_msg_list          => p_init_msg_list
     ,p_record_version_number  => l_record_version_number
     ,p_commit                 => p_commit
     ,p_validate_only          => p_validate_only
     ,x_return_status          => x_return_status
     ,x_msg_count              => x_msg_count
     ,x_msg_data               => x_msg_data);

Line: 448


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.delete_action_set'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 454


END delete_action_set;

Line: 456


PROCEDURE update_action_set
 (p_action_set_id           IN    pa_action_sets.action_set_id%TYPE           := NULL
 ,p_action_set_type_code    IN    pa_action_sets.action_set_type_code%TYPE    := 'PA_TASK_PROGRESS'
 ,p_object_type             IN    pa_action_sets.object_type%TYPE             := 'PA_PROJECTS'
 ,p_object_id               IN    pa_action_sets.object_id%TYPE               := NULL
 ,p_perform_action_set_flag IN    VARCHAR2             := 'N'
 ,p_record_version_number   IN    pa_action_sets.record_version_number%TYPE   := NULL
 ,p_api_version             IN    NUMBER               := 1.0
 ,p_commit                  IN    VARCHAR2             := FND_API.G_FALSE
 ,p_validate_only           IN    VARCHAR2             := FND_API.G_TRUE
 ,p_init_msg_list           IN    VARCHAR2             := FND_API.G_TRUE
 ,x_new_action_set_id      OUT NOCOPY    NUMBER
 ,x_return_status          OUT NOCOPY    VARCHAR2
 ,x_msg_count              OUT NOCOPY    NUMBER
 ,x_msg_data               OUT NOCOPY    VARCHAR2
) IS
/*
  CURSOR c_action_set_info(cp_object_id NUMBER, cp_type pa_action_sets.action_set_type_code%TYPE,
                           cp_obj  pa_action_sets.object_type%TYPE ) IS
       select action_set_id,record_version_number
         from pa_action_sets
         where object_id          = cp_object_id
         AND object_type          = cp_obj
         AND action_set_type_code = cp_type;

Line: 483


       select action_set_id,record_version_number
         from pa_action_sets
         where action_set_id      = cp_action_set_id;

Line: 494


   PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.update_action_set');

Line: 495


   PA_DEBUG.WRITE_LOG(x_Module  => 'pa.plsql.PA_TASK_PROG_ACTSET.update_action_set.begin'
                    ,x_Msg          => 'in PA_TASK_PROG_ACTSET.update_action_set'
                    ,x_Log_Level    => 6);

Line: 538


        PA_ACTION_SETS_PUB.delete_action_set
            (p_action_set_id          => l_curr_action_set_id
            ,p_action_set_type_code   => p_action_set_type_code
            ,p_object_type            => p_object_type
            ,p_object_id              => p_object_id
            ,p_init_msg_list          => p_init_msg_list
            ,p_record_version_number  => l_record_version_number
            ,p_commit                 => p_commit
            ,p_validate_only          => p_validate_only
            ,x_return_status          => x_return_status
            ,x_msg_count              => x_msg_count
            ,x_msg_data               => x_msg_data);

Line: 597


       FND_MSG_PUB.add_exc_msg ( p_pkg_name => 'PA_TASK_PROG_ACTSET.update_action_set'
                                ,p_procedure_name => PA_DEBUG.G_Err_Stack );

Line: 603


END update_action_set;

Line: 607


 select billing_cycle_id,billing_cycle_name
  2  from pa_billing_cycles;