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

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

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

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

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

Line: 390

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

Line: 393

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

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

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

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

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

Line: 1342

l_last_update_date        DATE;

Line: 1343

l_last_updated_by         NUMBER(15);

Line: 1344

l_last_update_login       NUMBER(15);

Line: 1350

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

Line: 1356

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

Line: 1363

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

Line: 1370

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

     FETCH c4 INTO l_last_update_date,l_last_updated_by,l_last_update_login,l_old_org_id;

Line: 1445

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

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

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

 select description
 from pa_resource_lists_all_bg
 where resource_list_id = p_resource_list_id;

Line: 1593

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

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

Line: 1633

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

Line: 1642

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

Line: 1706

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

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

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

Line: 2040

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

             x_err_stage   := 'API PA_FIN_PLAN_UTILS.CHECK_DELETE_TASK_OK FAILED';

Line: 2064

             SELECT project_id
             FROM   pa_proj_elements
             WHERE  proj_element_id = c_task_id;

Line: 2156

end check_delete_task_ok;

Line: 2174

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

Line: 2215

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