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

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

Line: 42


   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: 59


      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: 103


    ,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_report_info(cp_layout_id NUMBER) IS
    SELECT l.NEXT_REPORTING_DATE    report_date
           ,l.object_id             project_id
           ,p.project_status_code   proj_status_code
           ,l.effective_from        effective_from
           ,l.effective_to          effective_to
   FROM    pa_object_page_layouts l
           ,pa_projects_all p
    WHERE l.object_page_layout_id = cp_layout_id
            AND l.object_id       = p.project_id;

Line: 140


  g_action_line_audit_tbl.DELETE;

Line: 206


        perform_selected_action(
           p_project_id                   => l_project_id
          ,p_report_type_id               => l_report_type_id
          ,p_layout_id                    => p_action_set_details_rec.object_id
          ,p_action_set_type_code         => p_action_set_type_code
          ,p_action_set_line_rec          => p_action_set_line_rec
          ,p_action_line_conditions_tbl   => p_action_line_conditions_tbl
          ,x_action_performed             => l_action_performed
          ,x_return_status                => l_return_status
          ,x_msg_count                    => l_msg_count
          ,x_msg_data                     => l_msg_data);

Line: 373


PROCEDURE  perform_selected_action(
        p_project_id                     IN  NUMBER
       ,p_report_type_id                 IN  NUMBER
       ,p_layout_id                      IN  NUMBER
       ,p_action_set_type_code           IN  VARCHAR2
       ,p_action_set_line_rec            IN  pa_action_set_lines%ROWTYPE
       ,p_action_line_conditions_tbl     IN  pa_action_set_utils.action_line_cond_tbl_type
       ,x_action_performed               OUT NOCOPY VARCHAR2
       ,x_return_status                  OUT NOCOPY VARCHAR2
       ,x_msg_count                      OUT NOCOPY NUMBER
       ,x_msg_data                       OUT NOCOPY VARCHAR2)

IS
  l_return_status VARCHAR2(1)   := 'S';

Line: 390


  l_action_line_audit_tbl  pa_action_set_utils.insert_audit_lines_tbl_type;

Line: 430


END perform_selected_action;

Line: 442


   SELECT  lt.object_page_layout_id object_page_layout_id
          ,ast.action_set_id        action_set_id
          ,lt.report_type_id        report_type_id
   FROM pa_object_page_layouts lt
        ,pa_action_sets ast
   WHERE ast.object_type = 'PA_PROJ_STATUS_REPORTS'
   AND lt.page_type_code = 'PPR'
   AND lt.object_id      = p_project_id_from  --c_proj_id_from
   AND ast.object_id     = lt.object_page_layout_id;

Line: 452


  SELECT  lt.object_page_layout_id object_page_layout_id
         ,pa_action_set_utils.get_action_set_id
              ('PA_PROJ_STATUS_REPORT','PA_PROJ_STATUS_REPORTS',lt.object_page_layout_id) action_set_id
         ,lt.report_type_id        report_type_id
   FROM  pa_object_page_layouts lt
   WHERE lt.page_type_code = 'PPR'
   AND   lt.object_id      = p_project_id_from
   and pa_action_set_utils.get_action_set_id
         ('PA_PROJ_STATUS_REPORT','PA_PROJ_STATUS_REPORTS',lt.object_page_layout_id) is not null;

Line: 465


   SELECT object_page_layout_id
   FROM   pa_object_page_layouts
   WHERE object_id    = c_proj_id_to
   AND object_type    = 'PA_PROJECTS'
   AND report_type_id = rep_type_id
   AND page_type_code = 'PPR';

Line: 531


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_PROJ_STATUS_REPORT'
 ,p_object_type            IN    pa_action_sets.object_type%TYPE             := 'PA_PROJ_STATUS_REPORTS'
 ,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
/*
  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: 556


       select record_version_number
         from pa_action_sets
         where action_set_id      = cp_act_set_id;

Line: 566


   PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.delete_action_set');

Line: 567


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

Line: 594


   PA_ACTION_SETS_PUB.delete_action_set
     (p_action_set_id          => l_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          => FND_API.G_TRUE
     ,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: 614


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

Line: 620


END delete_action_set;

Line: 624


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_PROJ_STATUS_REPORT'
 ,p_object_type             IN    pa_action_sets.object_type%TYPE             := 'PA_PROJ_STATUS_REPORTS'
 ,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_act_set_id NUMBER ) IS
       select record_version_number
         from pa_action_sets
         where action_set_id      = cp_act_set_id;

Line: 655


   PA_DEBUG.init_err_stack('PA_PROJ_STAT_ACTSET.update_action_set');

Line: 656


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

Line: 683


        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: 741


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

Line: 747


END update_action_set;

Line: 751


 select billing_cycle_id,billing_cycle_name
  2  from pa_billing_cycles;