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

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

Line: 53


   SELECT task_id
   FROM PA_TASKS
   WHERE project_id = p_project_id
   ORDER BY wbs_level;

Line: 60


   SELECT element_version_id
   FROM PA_PROJ_ELEM_VER_STRUCTURE
   WHERE project_id = p_project_id
   AND   latest_eff_published_flag = 'Y';

Line: 67


   SELECT a.scheduled_start_date, a.scheduled_finish_date
   FROM PA_PROJ_ELEM_VER_SCHEDULE a,
        PA_PROJ_ELEMENT_VERSIONS b
   WHERE b.parent_structure_version_id = c_structure_version_id
   AND   b.project_id = p_project_id
   AND   b.proj_element_id = c_task_id
   -- Bug Fix 4868867
   -- Ram Namburi
   -- Added the following AND condition to eliminate Full table scan and Merge Join Cartesian.
   AND   b.element_version_id = a.element_version_id;

Line: 81


   SELECT estimated_start_date, estimated_finish_date
   FROM PA_PROGRESS_ROLLUP
   WHERE project_id = p_project_id
   AND   object_id = c_task_id
   AND   object_type = 'PA_TASKS'
   AND   as_of_date = (
     select max(as_of_date) from pa_progress_rollup
      where project_id = p_project_id
        and object_id = c_task_id
        and object_type = 'PA_TASKS'
   );

Line: 95


   SELECT actual_start_date, actual_finish_date
   FROM PA_PROGRESS_ROLLUP
   WHERE project_id = p_project_id
   AND   object_id = c_task_id
   AND   object_type = 'PA_TASKS'
   AND   as_of_date = (
     select max(as_of_date) from pa_progress_rollup
      where project_id = p_project_id
        and object_id = c_task_id
        and object_type = 'PA_TASKS'
   );

Line: 109


   SELECT baseline_start_date, baseline_finish_date
   FROM PA_PROJ_ELEMENTS
   WHERE proj_element_id = c_task_id;

Line: 115


   SELECT scheduled_start_date, scheduled_finish_date
   FROM PA_PROJECTS_ALL
   WHERE project_id = p_project_id;

Line: 121


   SELECT actual_start_date, actual_finish_date
   FROM PA_PROJECTS_ALL
   WHERE project_id = p_project_id;

Line: 128


   SELECT estimated_start_date, estimated_finish_date
   FROM PA_PROJECTS_ALL
   WHERE project_id = p_project_id;

Line: 135


   SELECT baseline_start_date, baseline_finish_date
   FROM PA_PROJECTS_ALL
   WHERE project_id = p_project_id;

Line: 141


   SELECT record_version_number
   FROM PA_PROJECTS_ALL
   WHERE project_id = p_project_id;

Line: 147


   SELECT record_version_number
   FROM PA_TASKS
   WHERE task_id = c_task_id;

Line: 153


   SELECT a.proj_element_id
   FROM pa_proj_elements a,
        pa_proj_structure_types b,
        pa_structure_types c
   WHERE a.proj_element_id = b.proj_element_id
   AND a.object_type = 'PA_STRUCTURES'
   AND a.project_id = p_project_id
   AND b.structure_type_id = c.structure_type_id
   AND c.structure_type = 'WORKPLAN';

Line: 165


   select element_version_id
   from pa_proj_elem_ver_structure
   where project_id = p_project_id
   and proj_element_id = c_structure_id
   and status_code = 'STRUCTURE_PUBLISHED'
   and latest_eff_published_flag = 'Y';

Line: 174


   SELECT element_version_id
   from pa_proj_elem_ver_structure
   where project_id = p_project_id
   and proj_element_id = c_structure_id
   and status_code <> 'STRUCTURE_PUBLISHED';

Line: 182


   SELECT a.proj_element_id,
          a.element_version_id,
          a.object_type,
          a.wbs_level,
          b.object_id_from1,
          b.object_type_from
   FROM pa_proj_element_versions a,
        pa_object_relationships b
        ,pa_proj_elements c       --bug 4606475
   WHERE a.parent_structure_version_id = c_structure_version_id
   AND a.project_id = p_project_id
   AND a.element_version_id = b.object_id_to1
   AND b.object_type_to = 'PA_TASKS'
   AND b.relationship_type(+) = 'S'
 --bug 4606475
   AND c.proj_element_id = a.proj_element_id
   AND c.project_id=a.project_id
   AND c.object_type = a.object_type
   AND c.link_task_flag = 'N'
 --bug 4606475
   UNION
   SELECT c.proj_element_id,
          c.element_version_id,
          c.object_type,
          0,
          to_number(NULL),
          NULL
   FROM pa_proj_element_versions c
   WHERE c.element_version_id = c_structure_version_id;

Line: 213


     SELECT NVL(TXN_DATE_SYNC_BUF_DAYS,0)
     FROM PA_PROJ_WORKPLAN_ATTR
     WHERE PROJ_ELEMENT_ID = c_structure_id;

Line: 246


     SELECT ppev.proj_element_id,
            ppe.element_number
       FROM pa_proj_element_versions ppev,
            pa_proj_elements ppe
      WHERE ppev.element_version_id = c_task_version_id
        AND ppev.proj_element_id = ppe.proj_element_id
        AND ppe.link_task_flag = 'N'    --bug 4606475
        ;

Line: 339


      UPDATE pa_tasks
         set completion_date = NULL
       WHERE project_id=p_project_id;

Line: 492


       PA_PROJECT_DATES_PUB.Update_Project_Dates (
          p_init_msg_list          => p_init_msg_list
         ,p_commit                 => FND_API.G_FALSE
         ,p_validate_only          => FND_API.G_FALSE -- Bug 2786525
         ,p_calling_module         => p_calling_module
         ,p_debug_mode             => p_debug_mode
         ,p_project_id             => p_project_id
         ,p_date_type              => 'TRANSACTION'
         ,p_start_date             => l_rollup_table(l_cnt).start_date1
         ,p_finish_date            => l_rollup_table(l_cnt).finish_date1
         ,p_record_version_number  => l_proj_record_version_number
         ,x_return_status          => l_return_status
         ,x_msg_count              => l_msg_count
         ,x_msg_data               => l_msg_data );

Line: 537


/*  Not doing anything. Also I checked PA_TASK_MAINT_PUB and PVT.update_task. Its not using record version number
    so its useless here.
      OPEN get_task_record_ver_number(l_task_id);

Line: 556


 	   SELECT pt.parent_task_id,
 	          pt.start_date,
 	          pt.completion_date
 	   INTO   l_parent_task_id,
 	          l_tstart_date,
 	          l_tend_date
 	   FROM pa_tasks pt
 	   WHERE pt.task_id = l_proj_element_id2;

Line: 580


        PA_TASKS_MAINT_PUB.Update_Task (
         p_init_msg_list          => p_init_msg_list
        ,p_commit                 => FND_API.G_FALSE
        ,p_validate_only          => p_validate_only
        ,p_calling_module         => p_calling_module
        ,p_debug_mode             => p_debug_mode
        ,p_project_id             => p_project_id
--      ,p_task_id                => l_proj_elem_tbl(l_cnt)    --bug 2831656
        ,p_task_id                => l_proj_element_id2           --bug 2831656
        ,p_task_number            => l_element_number             --bug 3043580
        ,p_task_start_date        => l_rollup_table(l_cnt).start_date1
        ,p_task_completion_date   => l_rollup_table(l_cnt).finish_date1
        ,p_record_version_number  => l_task_record_version_number
        ,p_update_subtasks_end_dt => 'N'    --bug 4241863
	,p_dates_check            => 'N'    --bug 5665772
        ,x_return_status          => l_return_status
        ,x_msg_count              => l_msg_count
        ,x_msg_data               => l_msg_data );

Line: 921


PROCEDURE UPDATE_PROJECT_DATES
(  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_project_id                    IN NUMBER
  ,p_date_type                     IN VARCHAR2
  ,p_start_date                    IN DATE       := FND_API.G_MISS_DATE
  ,p_finish_date                   IN DATE       := FND_API.G_MISS_DATE
  ,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_api_name                      CONSTANT VARCHAR(30) := 'Update_Project_Dates';

Line: 951


   pa_debug.init_err_stack('PA_PROJECT_DATES_PUB.Update_Project_Dates');

Line: 954


      pa_debug.debug('PA_PROJECT_DATES_PUB.Update_Project_Dates BEGIN');

Line: 958


      savepoint update_project_dates;

Line: 991


   PA_PROJECT_DATES_PVT.UPDATE_PROJECT_DATES
   ( p_commit                    => FND_API.G_FALSE
    ,p_validate_only             => p_validate_only
    ,p_validation_level          => p_validation_level
    ,p_calling_module            => p_calling_module
    ,p_debug_mode                => p_debug_mode
    ,p_max_msg_count             => p_max_msg_count
    ,p_project_id                => p_project_id
    ,p_date_type                 => p_date_type
    ,p_start_date                => p_start_date
    ,p_finish_date               => p_finish_date
    ,p_record_version_number     => p_record_version_number
    ,x_return_status             => l_return_status
    ,x_msg_count                 => l_msg_count
    ,x_msg_data                  => l_msg_data );

Line: 1029


      pa_debug.debug('PA_PROJECT_DATES_PUB.Update_Project_Dates END');

Line: 1035


         rollback to update_project_dates;

Line: 1040


         rollback to update_project_dates;

Line: 1044


                              p_procedure_name => 'Update_Project_Dates',
                              p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 1048


         rollback to update_project_dates;

Line: 1052


                              p_procedure_name => 'Update_Project_Dates',
                              p_error_text     => SUBSTRB(SQLERRM,1,240));

Line: 1055


END UPDATE_PROJECT_DATES;