APPS.PA_XC_PROJECT_PUB SQL Statements

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

Line: 104

SELECT EMPLOYEE_ID
  FROM FND_USER
 WHERE UPPER(USER_NAME) = upper(l_login_user_name);

Line: 111

SELECT   PROJECT_ID
FROM     PA_TEMP_IMPORT_TASKS
WHERE    PROJECT_ID = c_project_id;

Line: 118

SELECT ppe.proj_element_id, ppe.name, ppe.element_number, ppe.description, ppe.pm_source_reference, ppe.manager_person_id, ppe.carrying_out_organization_id
FROM   PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev
WHERE  ppe.project_id = c_project_id
AND    ppe.project_id = ppev.project_id  -- 3693934 added for peformance fix
AND    ppe.object_type = 'PA_TASKS'
AND    ppe.proj_element_id = ppev.proj_element_id
AND    ppev.parent_structure_version_id = c_structure_version_id
AND    ppev.financial_task_flag = 'Y'
ORDER BY ppev.display_sequence;

Line: 133

SELECT  ppevs.scheduled_start_date, ppevs.scheduled_finish_date
FROM PA_PROJ_ELEMENT_VERSIONS ppev, PA_PROJ_ELEM_VER_SCHEDULE ppevs
WHERE  ppev.element_version_id = ppevs.element_version_id
AND    ppev.project_id = ppevs.project_id   -- 3693934 added for peformance fix
AND    ppev.object_type = 'PA_TASKS'
AND    ppev.proj_element_id = c_proj_element_id
AND    ppev.parent_structure_version_id = c_structure_version_id;

Line: 144

SELECT start_date, completion_date, long_task_name -- Modified for bug 5465108
FROM pa_tasks
WHERE task_id = c_task_id;

Line: 150

  SELECT ppev2.proj_element_id
    FROM PA_OBJECT_RELATIONSHIPS por,
         PA_PROJ_ELEMENT_VERSIONS ppev,
         PA_PROJ_ELEMENT_VERSIONS ppev2
    WHERE por.relationship_type = 'S'
    AND por.object_id_to1 = ppev.element_version_id
    AND por.object_type_from = 'PA_TASKS'
    AND ppev.proj_element_id =  c_proj_element_id
    AND ppev.parent_structure_version_id = p_structure_version_id -- Bug 2873691
    AND ppev2.element_version_id = por.object_id_from1;

Line: 174

   select  min(to_Number(ppe.pm_source_reference))
     FROM  PA_PROJ_ELEMENTS ppe, PA_PROJ_ELEMENT_VERSIONS ppev
    WHERE  ppe.project_id = c_project_id
      AND  ppe.object_type = 'PA_TASKS'
      AND  ppe.proj_element_id = ppev.proj_element_id
      AND  ppev.parent_structure_version_id = c_structure_version_id; */

Line: 187

    select task_id from pa_tasks
     where task_id = c_proj_element_id;

Line: 215

   pa_project_pub.G_tasks_in_tbl.delete;

Line: 226

        delete from PA_TEMP_IMPORT_TASKS where project_id = p_project_id;

Line: 268

          update pa_tasks
          set pm_task_reference = l_proj_elements_rec.pm_source_reference
          where task_id = l_proj_elements_rec.proj_element_id;

Line: 289

         update pa_tasks
            set pm_task_reference = l_pm_source_reference -- Bug 3302732 l_source_ref_count
          where task_id = l_exist_pa_task_id;

Line: 293

         update pa_proj_elements
            set pm_source_reference = l_pm_source_reference -- Bug 3302732 l_source_ref_count
          where proj_element_id = l_exist_pa_task_id;

Line: 368

     INSERT INTO PA_TEMP_IMPORT_TASKS
     ( PROJECT_ID
      ,TASK_REFERENCE
      ,TASK_ID)
     VALUES
     ( p_project_id
      ,l_pm_source_reference
      ,l_proj_elements_rec.proj_element_id);

Line: 518

   SELECT   task_id
   FROM     pa_tasks
   WHERE    project_id = p_project_id;

Line: 525

   SELECT   name
   FROM     pa_projects
   WHERE    project_id = p_project_id;

Line: 534

   SELECT   PM_TASK_REFERENCE, task_id
   FROM     pa_tasks
   WHERE    project_id = l_project_id
   MINUS
   SELECT   TASK_REFERENCE, task_id
   FROM     pa_temp_import_tasks
   WHERE    project_id = l_project_id
   ORDER BY 1;

Line: 546

   SELECT   PM_TASK_REFERENCE, task_id
   FROM     pa_tasks ttask
   WHERE    project_id = l_project_id
   AND      task_id not in
        (
           SELECT   task_id
           FROM     pa_temp_import_tasks
           WHERE    project_id = l_project_id
           AND      task_id = ttask.task_id
         )
   ORDER BY ttask.wbs_level desc;

Line: 567

  SELECT  name
  FROM PA_PROJECTS_ALL
  WHERE project_id = c_project_id
  FOR UPDATE of name NOWAIT;

Line: 577

  SELECT 'Y'
  FROM PA_PROJ_STRUCTURE_TYPES ppst,
       PA_STRUCTURE_TYPES pst
  WHERE ppst.proj_element_id = c_structure_id
  AND   ppst.structure_type_id = pst.structure_type_id
  AND   (pst.structure_type = 'FINANCIAL');

Line: 587

  SELECT 'Y'
  FROM PA_PROJ_STRUCTURE_TYPES ppst,
       PA_STRUCTURE_TYPES pst
  WHERE ppst.proj_element_id = c_structure_id
  AND   ppst.structure_type_id = pst.structure_type_id
  AND   pst.structure_type = 'WORKPLAN';

Line: 597

  SELECT 'Y'
  FROM DUAL
  WHERE NOT EXISTS
        (SELECT 'Y'
         FROM PA_PROJ_ELEM_VER_STRUCTURE
         WHERE proj_element_id = c_structure_id
         AND   published_date is not null);

Line: 611

  SELECT count(proj_element_id)
  FROM pa_proj_elements
  WHERE project_id = c_project_id
  and object_type = 'PA_STRUCTURES'
  GROUP BY proj_element_id;

Line: 620

  SELECT proj_element_id
  FROM pa_proj_elements
  WHERE project_id = c_project_id
    and object_type = 'PA_STRUCTURES';

Line: 631

  SELECT ppev.element_version_id
  FROM pa_proj_element_versions ppev, pa_proj_elem_ver_structure ppevs
  WHERE ppev.proj_element_id = c_structure_id
  AND   ppev.element_version_id = ppevs.element_version_id
  AND   ppevs.published_date is null;

Line: 642

  SELECT ppevs.element_version_id
  FROM pa_proj_elements ppev, pa_proj_elem_ver_structure ppevs
  WHERE ppev.proj_element_id = c_structure_id
  AND  ppev.project_id  = ppevs.project_id
  AND  ppev.proj_element_id = ppevs.proj_element_id
  AND  ppevs.published_date is null;

Line: 652

  SELECT proj_element_id
  FROM pa_proj_element_versions
  WHERE element_version_id = c_structure__version_id;

Line: 660

  SELECT 'Y'
  FROM pa_proj_element_versions
  WHERE project_id = c_project_id
    and proj_element_id = c_structure_id
    and element_version_id = c_structure_version_id;

Line: 669

  SELECT 'Y'
  FROM pa_proj_elements
  WHERE project_id = c_project_id
    and proj_element_id = c_structure_id;

Line: 678

  SELECT 'Y'
  FROM pa_proj_element_versions
  WHERE project_id = c_project_id
    and element_version_id = c_structure_version_id;

Line: 695

  select org_id from pa_projects_all where project_id = p_project_id;

Line: 911

  select org_id into l_org_id from pa_projects_all where project_id = p_project_id;

Line: 963

      pa_debug.debug('Update Project Detals : Error PA_XC_NO_DATA_FOUND');

Line: 1033

        pa_debug.debug('Import-Project : Delete_Task Program Starts ...');

Line: 1043

      PA_PROJECT_CORE.delete_task
      ( x_task_id => l_task_id
--bug 3010538       ,x_validation_mode     => 'R'     -- Bug 2947492
       ,x_err_code   => l_err_code
       ,x_err_stage  => l_err_stage
       ,x_err_stack  => l_err_stack);

Line: 1057

              pa_debug.debug('Import-Project : Error occured in PA_task_Utils.CHECK_DELETE_TASK_OK Procedure ');

Line: 1086

      pa_debug.debug('Import-Project : Execute_Update_Project Program Starts ...');

Line: 1095

    pa_project_pub.execute_update_project
    ( P_API_VERSION_NUMBER => G_API_VERSION_NUMBER
     ,p_commit             => FND_API.G_FALSE
     ,p_init_msg_list      => FND_API.G_FALSE
     ,p_msg_count          => p_msg_count
     ,p_msg_data           => p_msg_data
     ,p_return_status      => l_return_status
     ,p_workflow_started   => l_workflow_started
     ,p_pm_product_code    => l_pm_product_code2
     ,p_pass_entire_structure => 'Y'  );  -- Added for bug 3696234 : BUg 3627124

Line: 1117

  update PA_TASKS pt
  set pt.parent_task_id =
  (select a.task_id
     from pa_tasks b, pa_temp_import_tasks a
    where a.project_id = p_project_id
    and a.task_reference = b.pm_task_reference -- Bug 3302732: added this
--  Bug 3302732    and to_number(a.task_reference) = to_number(b.pm_task_reference) : Commented this line
      and b.task_id = pt.parent_task_id)
  where pt.project_id = p_project_id;

Line: 1128

  update PA_TASKS pt
  set pt.top_task_id =
  (select a.task_id
     from pa_tasks b, pa_temp_import_tasks a
    where a.project_id = p_project_id
      and a.task_reference = b.pm_task_reference
      and b.task_id = pt.top_task_id)
  where pt.project_id = p_project_id;

Line: 1139

    UPDATE PA_TASKS pt
    SET pt.task_id =
    (select task_id
     from PA_TEMP_IMPORT_TASKS temp
     where temp.project_id = p_project_id
     and   temp.task_reference = pt.pm_task_reference)
    WHERE pt.project_id = p_project_id;

Line: 1147

  UPDATE PA_PROJ_ELEMENTS e
  set e.pm_source_reference = (
   select PM_TASK_REFERENCE
     from PA_TASKS t
    where t.task_id = e.proj_element_id
  ) where e.project_id = p_project_id;

Line: 1320

   SELECT   task_id
   FROM     pa_tasks
   WHERE    project_id = c_project_id
   AND      pm_task_reference = c_pm_task_reference;

Line: 1378

   SELECT   proj_element_id
   FROM     pa_proj_elements
   WHERE    project_id = c_project_id
   AND      pm_source_reference = c_pm_task_reference;

Line: 1475

select 'N' into l_unique
from pa_proj_elements
where project_id = p_project_id
and pm_source_reference = p_new_task_reference
AND parent_structure_id = ( SELECT ppe.proj_element_id   --Added this subQry for bug# 3601700
                                FROM   pa_proj_elements ppe,
                                       pa_proj_structure_types ppst,
                                       pa_structure_types pst
                                WHERE  ppe.proj_element_id = ppst.proj_element_id
                                AND    ppe.project_id = p_project_id
                                AND    ppst.structure_type_id = pst.structure_type_id
                                AND    pst.structure_type = 'WORKPLAN' --specified as workplan as this will only called while publishing workplan strcuture
              )
AND OBJECT_TYPE = 'PA_TASKS'; */

Line: 1498

		SELECT COUNT(*)
		INTO L_COUNT
		FROM PA_PROJ_ELEMENTS
		WHERE PROJECT_ID = P_PROJECT_ID
		AND PM_SOURCE_REFERENCE = P_NEW_TASK_REFERENCE
		AND PARENT_STRUCTURE_ID = ( SELECT PPE.PROJ_ELEMENT_ID
		                             FROM  PA_PROJ_ELEMENTS PPE,
		                                   PA_PROJ_STRUCTURE_TYPES PPST,
		                                   PA_STRUCTURE_TYPES PST
		                             WHERE PPE.PROJ_ELEMENT_ID = PPST.PROJ_ELEMENT_ID
		                               AND PPE.PROJECT_ID = P_PROJECT_ID
		                               AND PPST.STRUCTURE_TYPE_ID = PST.STRUCTURE_TYPE_ID
		                               AND PST.STRUCTURE_TYPE = 'WORKPLAN'
		                          )
		AND OBJECT_TYPE = 'PA_TASKS' ;