APPS.PA_TASK_UTILS SQL Statements

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

Line: 18

	select wbs_level
	from pa_tasks
	where task_id = x_task_id;

Line: 55

	select top_task_id
	from pa_tasks
	where task_id = x_task_id;

Line: 93

	select parent_task_id
	from pa_tasks
	where task_id = x_task_id;

Line: 132

	select alias
	from pa_resource_list_members
	where resource_list_member_id = x_rlm_id;

Line: 168

	select name
	from pa_proj_elements
	where proj_element_id = x_task_id;

Line: 204

	select element_number
	from pa_proj_elements
	where proj_element_id = x_task_id;

Line: 240

	select name
	from pa_projects_all
	where project_id = x_project_id;

Line: 276

	select segment1
	from pa_projects_all
	where project_id = x_project_id;

Line: 318

                select task_id from pa_tasks
                where project_id = x_project_id
                and task_number = substrb(x_task_number,1,25)  -- bug 5733285 added substrb
                and (x_ROWID IS NULL OR x_rowid <> PA_TASKS.ROWID);

Line: 363

              select 1
                from sys.dual
                where exists (SELECT null
                        FROM   PA_TASKS
                        WHERE  PROJECT_ID = x_project_id
                        and    task_id <> x_task_id
			and    task_id = top_task_id);

Line: 415

                select 1
                from sys.dual
                where exists (SELECT null
                        FROM   PA_TASKS
                        WHERE  TASK_ID <> x_TASK_ID
                        AND    PARENT_TASK_ID = x_PARENT_TASK_ID);

Line: 463

                select 1
                from sys.dual
                where exists (SELECT null
                        FROM pa_percent_completes
                        where  TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
                                START WITH TASK_ID = x_TASK_ID));

Line: 511

                select LABOR_COST_MULTIPLIER_NAME
                from pa_tasks
                where task_id = x_task_id
		and LABOR_COST_MULTIPLIER_NAME is not null;

Line: 576

    cursor p1 is select 1 from pa_project_types
                 where burden_sum_dest_task_id = x_task_id;*/

Line: 579

    cursor p1 is select 1 from pa_project_types_all
                 where burden_sum_dest_task_id = x_task_id
		 and org_id = (SELECT org_id --MOAC Changes: Bug 4363092: removed nvl usage with org_id
                        FROM   pa_projects_all
                        where  project_id = (select project_id from pa_tasks where task_id=x_task_id));

Line: 620

		select project_id into x_project_id
		from pa_proj_elements
		where proj_element_id = x_task_id
		and task_status is not null;

Line: 692

                         select 1
                         from   pa_fp_elements r,
                                pa_proj_fp_options m
                         where  r.task_id = x_task_id
                         and    (decode(r.element_type,
                                      'COST',cost_fin_plan_level_code,
                                      'REVENUE',revenue_fin_plan_level_code,
                                      'ALL',all_fin_plan_level_code) = 'L'
                                  or
                                  (decode(r.element_type,
                                      'COST',cost_fin_plan_level_code,
                                      'REVENUE',revenue_fin_plan_level_code,
                                      'ALL',all_fin_plan_level_code) = 'M'
                                   and x_task_id <> x_top_task_id))
                         and     m.proj_fp_options_id = r.proj_fp_options_id;

Line: 1313

SELECT NULL
FROM
SYS.DUAL
WHERE EXISTS
     (SELECT NULL
      FROM
          pa_expenditure_items_all paei,
          pa_cost_distribution_lines_all cdl
      WHERE
          paei.expenditure_item_id = cdl.expenditure_item_id
      AND paei.task_id             = x_task_id );

Line: 1326

SELECT NULL
FROM
SYS.DUAL
WHERE EXISTS
      (SELECT NULL
      FROM
          pa_expenditure_items_all paei,
          pa_cust_rev_dist_lines rdl
      WHERE
          paei.expenditure_item_id = rdl.expenditure_item_id
      AND paei.task_id             = x_task_id );

Line: 1339

SELECT NULL
FROM
SYS.DUAL
WHERE EXISTS
      (SELECT NULL
       FROM
          pa_draft_invoice_items dii
       WHERE dii.Task_id           = x_task_id );

Line: 1554

l_last_update_date        DATE;

Line: 1555

l_last_updated_by         NUMBER(15);

Line: 1556

l_last_update_login       NUMBER(15);

Line: 1562

select project_currency_code,project_rate_type,project_rate_date
from pa_projects_all
where project_id = p_project_id;

Line: 1568

 select meaning
 from   pa_lookups
 where  lookup_type = 'TRANSLATION'
 and    lookup_code = 'MASS_UPDATE_BATCH_DESC';

Line: 1575

 select meaning
 from   pa_lookups
 where  lookup_type = 'TRANSLATION'
 and    lookup_code = 'MANUAL';

Line: 1582

 select last_update_date,last_updated_by,last_update_login,carrying_out_organization_id
 from pa_tasks
 where task_id = p_task_id
 and project_id = p_project_id;

Line: 1654

     FETCH c4 INTO l_last_update_date,l_last_updated_by,l_last_update_login,l_old_org_id;

Line: 1657

      pa_mu_batches_v_pkg.insert_row (
		X_ROWID                  => l_row_id,
		X_BATCH_ID               => l_batch_id,
		X_CREATION_DATE          => l_last_update_date,
		X_CREATED_BY             => l_last_updated_by,
		X_LAST_UPDATED_BY        => l_last_updated_by,
		X_LAST_UPDATE_DATE       => l_last_update_date,
		X_LAST_UPDATE_LOGIN      => l_last_update_login,
		X_BATCH_NAME             => l_batch_name,
		X_BATCH_STATUS_CODE      => 'C',
		X_DESCRIPTION            => l_description,
		X_PROJECT_ATTRIBUTE      => 'ORGANIZATION',
		X_EFFECTIVE_DATE         => trunc(sysdate),
		X_ATTRIBUTE_CATEGORY     => null,
		X_ATTRIBUTE1             => null,
		X_ATTRIBUTE2             => null,
		X_ATTRIBUTE3             => null,
		X_ATTRIBUTE4             => null,
		X_ATTRIBUTE5             => null,
		X_ATTRIBUTE6             => null,
		X_ATTRIBUTE7             => null,
		X_ATTRIBUTE8             => null,
		X_ATTRIBUTE9             => null,
		X_ATTRIBUTE10            => null,
		X_ATTRIBUTE11            => null,
		X_ATTRIBUTE12            => null,
		X_ATTRIBUTE13            => null,
		X_ATTRIBUTE14            => null,
		X_ATTRIBUTE15            => null
		);

Line: 1688

 update PA_MASS_UPDATE_BATCHES
 set batch_name = substr(l_batch_name,1,20)||'-'||to_char(l_batch_id)
 where rowid = l_row_id;

Line: 1692

  pa_mu_details_v_pkg.insert_row
  (
   X_ROWID                  => l_row_id,
   X_LINE_ID                => l_line_id,
   X_BATCH_ID               => l_batch_id,
   X_CREATION_DATE          => l_last_update_date,
   X_CREATED_BY             => l_last_updated_by,
   X_LAST_UPDATED_BY        => l_last_updated_by,
   X_LAST_UPDATE_DATE       => l_last_update_date,
   X_LAST_UPDATE_LOGIN      => l_last_update_login,
   X_PROJECT_ID             => p_project_id,
   X_TASK_ID                => p_task_id,
   X_OLD_ATTRIBUTE_VALUE    => l_old_org_id,
   X_NEW_ATTRIBUTE_VALUE    => p_new_org_id,
   X_UPDATE_FLAG            => 'Y',
   X_RECALCULATE_FLAG       => 'Y'
  );

Line: 1741

 select description
 from pa_resource_lists_all_bg
 where resource_list_id = p_resource_list_id;

Line: 1805

procedure check_delete_task_ok (x_task_id             IN        number
                        , x_validation_mode    IN VARCHAR2   DEFAULT 'U'    --bug 2947492
                        , x_err_code            IN OUT    NOCOPY number --File.Sql.39 bug 4440895
                        , x_err_stage           IN OUT    NOCOPY varchar2 --File.Sql.39 bug 4440895
                        , x_err_stack           IN OUT    NOCOPY varchar2) --File.Sql.39 bug 4440895
is

    old_stack      	varchar2(630);

Line: 1823

    cursor p1 is select 1 from pa_project_types
                 where burden_sum_dest_task_id = x_task_id;

Line: 1845

  SELECT count(1) from pa_events ev
   WHERE ev.project_id = x_project_id
     AND nvl(ev.task_id, -1) = x_task_id ;

Line: 1854

        x_err_stack := x_err_stack || '->check_delete_task_ok';

Line: 1918

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM  pa_fp_elements r
                        where r.TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
                                START WITH TASK_ID = x_task_id));

Line: 1951

                SELECT 1
                FROM    sys.dual
                where exists (SELECT NULL
                        FROM  pa_resource_assignments r
                        where r.TASK_ID IN
                               (SELECT TASK_ID
                                FROM   PA_TASKS
                                CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID
                                START WITH TASK_ID = x_task_id));

Line: 2250

             x_err_stage := 'PA_FIN_PLAN_UTILS.CHECK_DELETE_TASK_OK'||x_task_id;

Line: 2252

             PA_FIN_PLAN_UTILS.CHECK_DELETE_TASK_OK(
                   p_task_id                => x_task_id
                  ,p_validation_mode        => x_validation_mode
                  ,x_return_status          => l_return_status
                  ,x_msg_count              => l_msg_count
                  ,x_msg_data               => l_msg_data

               );

Line: 2267

             x_err_stage   := 'API PA_FIN_PLAN_UTILS.CHECK_DELETE_TASK_OK FAILED';

Line: 2276

             SELECT project_id
             FROM   pa_proj_elements
             WHERE  proj_element_id = c_task_id;

Line: 2368

end check_delete_task_ok;

Line: 2386

                select task_number parent_task_number
                from pa_tasks
                connect by prior parent_task_id = task_id
                start with task_id = c1.inid;

Line: 2427

                select 1
                from sys.dual
                where exists (SELECT null
                        FROM pa_tasks
                        where parent_task_id = x_task_id);

Line: 2650

      SELECT 1
      FROM dual
      WHERE EXISTS
      (SELECT NULL
        FROM PA_PROJ_ELEM_VER_SCHEDULE
        WHERE PROJECT_ID        = p_project_id
	AND  ELEMENT_VERSION_ID = p_element_version_id
        AND PROJ_ELEMENT_ID     = p_proj_element_id
        AND (attribute_category IS NOT NULL
             OR attribute1           IS NOT NULL
             OR attribute2           IS NOT NULL
             OR attribute3           IS NOT NULL
             OR attribute4           IS NOT NULL
             OR attribute5           IS NOT NULL
             OR attribute6           IS NOT NULL
             OR attribute7           IS NOT NULL
             OR attribute8           IS NOT NULL
             OR attribute9           IS NOT NULL
             OR attribute10          IS NOT NULL
             OR attribute11          IS NOT NULL
             OR attribute12          IS NOT NULL
             OR attribute13          IS NOT NULL
             OR attribute14          IS NOT NULL
             OR ATTRIBUTE15          IS NOT NULL));