APPS.PA_PROJECT_WF SQL Statements

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

Line: 34

PROCEDURE Select_Project_Approver (     itemtype    in varchar2,
                    itemkey     in varchar2,
                    actid       in number,
                    funcmode    in varchar2,
                    resultout   out NOCOPY varchar2    ) --File.Sql.39 bug 4440895
IS
--
CURSOR  l_approver_user_csr( p_approver_id NUMBER ) IS
SELECT  f.user_id
,       f.user_name
,       e.first_name||' '||e.last_name
FROM    fnd_user f
        ,pa_employees e
WHERE   f.employee_id = p_approver_id
AND     f.employee_id = e.person_id;

Line: 102

    PA_CLIENT_EXTN_PROJECT_WF.Select_Project_Approver
                (p_project_id                   => l_project_id
      , p_workflow_started_by_id          => l_workflow_started_by_id
      , p_project_approver_id                 => l_approver_employee_id
      );

Line: 171

    WF_CORE.CONTEXT('PA_PROJECT_WF','SELECT_PROJECT_APPROVER',itemtype, itemkey, to_char(actid), funcmode);

Line: 176

    WF_CORE.CONTEXT('PA_PROJECT_WF','SELECT_PROJECT_APPROVER',itemtype, itemkey, to_char(actid), funcmode);

Line: 181

    WF_CORE.CONTEXT('PA_PROJECT_WF','SELECT_PROJECT_APPROVER',itemtype, itemkey, to_char(actid), funcmode);

Line: 186

END Select_Project_Approver;

Line: 196

SELECT
      ps.workflow_item_type,
      ps.workflow_process
FROM pa_projects_all pap,  -- Bug#3807805 : Modified pa_projects to pa_projects_all
     pa_project_statuses ps
WHERE pap.project_id = l_project_id
AND   pap.project_status_code = ps.project_status_code;

Line: 238

      PA_WORKFLOW_UTILS.Insert_WF_Processes
      (p_wf_type_code        => 'PROJECT'
      ,p_item_type           => l_get_projinfo_rec.workflow_item_type
      ,p_item_key            => l_out_item_key
      ,p_entity_key1         => to_char(p_project_id)
      ,p_description         => NULL
      ,p_err_code            => l_err_code
      ,p_err_stage           => l_err_stage
      ,p_err_stack           => l_err_stack
      );

Line: 294

SELECT project_system_status_code
FROM   pa_project_statuses
WHERE  project_status_code = x_project_status_code;

Line: 305

 SELECT segment1
 FROM  PA_PROJECTS_ALL
 WHERE PROJECT_ID = p_project_id;

Line: 421

      UPDATE pa_projects
      SET    project_status_code = l_success_status_code,
             wf_status_code      = 'IN_ROUTE'
      WHERE  project_id = l_project_id;

Line: 430

                   UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
                   SET    project_status_code = l_success_status_code,
                          wf_status_code      = 'IN_ROUTE',
                          closed_date        = sysdate,
                          last_update_date    = sysdate,
                          last_updated_by     = fnd_global.user_id,
                          last_update_login   = fnd_global.login_id
                   WHERE  project_id = l_project_id;

Line: 439

                   UPDATE  pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
                   SET    project_status_code = l_success_status_code,
                          wf_status_code      = 'IN_ROUTE',
                          last_update_date    = sysdate,
                          last_updated_by     = fnd_global.user_id,
                          last_update_login   = fnd_global.login_id
                   WHERE  project_id = l_project_id;

Line: 449

                   UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
                   SET    project_status_code = l_success_status_code,
                          wf_status_code      = 'IN_ROUTE',
                          last_update_date    = sysdate,
                          last_updated_by     = fnd_global.user_id,
                          last_update_login   = fnd_global.login_id
                   WHERE  project_id = l_project_id;

Line: 457

                   UPDATE  pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
                   SET    project_status_code = l_success_status_code,
                          wf_status_code      = 'IN_ROUTE',
                          closed_date        = null,
                          last_update_date    = sysdate,
                          last_updated_by     = fnd_global.user_id,
                          last_update_login   = fnd_global.login_id
                   WHERE  project_id = l_project_id;

Line: 479

      UPDATE pa_projects
      SET    project_status_code = l_success_status_code,
             wf_status_code      = NULL
      WHERE  project_id = l_project_id;

Line: 486

         UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
         SET    project_status_code = l_success_status_code,
            wf_status_code      = NULL,
            closed_date         = sysdate,
            last_update_date    = sysdate,
            last_updated_by     = fnd_global.user_id,
            last_update_login   = fnd_global.login_id
         WHERE  project_id = l_project_id;

Line: 495

             UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
         SET    project_status_code = l_success_status_code,
            wf_status_code      = NULL,
	    closed_date         = null, --bug#8586702
            last_update_date    = sysdate,
            last_updated_by     = fnd_global.user_id,
            last_update_login   = fnd_global.login_id
         WHERE  project_id = l_project_id;

Line: 506

             UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
         SET    project_status_code = l_success_status_code,
            wf_status_code      = NULL,
            last_update_date    = sysdate,
            last_updated_by     = fnd_global.user_id,
            last_update_login   = fnd_global.login_id
         WHERE  project_id = l_project_id;

Line: 514

             UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
         SET    project_status_code = l_success_status_code,
            wf_status_code      = NULL,
            closed_date         = null,
            last_update_date    = sysdate,
            last_updated_by     = fnd_global.user_id,
            last_update_login   = fnd_global.login_id
         WHERE  project_id = l_project_id;

Line: 563

               SELECT pps.project_system_status_code
               FROM   pa_project_statuses pps
               WHERE  pps.project_status_code = nvl(c_status_code,' ');

Line: 573

                SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id
                FROM dual;

Line: 585

                PA_OBJ_STATUS_CHANGES_PKG.INSERT_ROW
                ( X_ROWID                        => l_rowid,
                  X_OBJ_STATUS_CHANGE_ID         => l_obj_status_change_id,
                  X_OBJECT_TYPE                  => 'PA_PROJECTS',
                  X_OBJECT_ID                    => l_project_id,
                  X_STATUS_TYPE                  => 'PROJECT',
                  X_NEW_PROJECT_STATUS_CODE      => l_success_status_code,
                  X_NEW_PROJECT_SYSTEM_STATUS_CO => l_new_sys_status,
                  X_OLD_PROJECT_STATUS_CODE      => l_proj_stus_code,
                  X_OLD_PROJECT_SYSTEM_STATUS_CO => l_old_sys_status,
                  X_CHANGE_COMMENT               => l_note,
                  X_LAST_UPDATED_BY              => fnd_global.user_id,
                  X_CREATED_BY                   => fnd_global.user_id,
                  X_CREATION_DATE                => sysdate,
                  X_LAST_UPDATE_DATE             => sysdate,
                  X_LAST_UPDATE_LOGIN            => fnd_global.user_id);

Line: 611

                          x_update_db_YN         => 'Y',
                          x_populate_msg_yn      => 'Y',
                          x_err_code             => l_err_code );

Line: 686

                      x_update_db_YN         => 'Y',
                      x_populate_msg_yn      => 'N',
                      x_err_code             => l_err_code );

Line: 701

               SELECT pps.project_system_status_code
               FROM   pa_project_statuses pps
               WHERE  pps.project_status_code = nvl(c_status_code,' ');

Line: 715

                SELECT pa_obj_status_changes_s.NEXTVAL INTO l_obj_status_change_id
                FROM dual;

Line: 727

                PA_OBJ_STATUS_CHANGES_PKG.INSERT_ROW
                ( X_ROWID                        => l_rowid,
                  X_OBJ_STATUS_CHANGE_ID         => l_obj_status_change_id,
                  X_OBJECT_TYPE                  => 'PA_PROJECTS',
                  X_OBJECT_ID                    => l_project_id,
                  X_STATUS_TYPE                  => 'PROJECT',
                  X_NEW_PROJECT_STATUS_CODE      => l_failure_status_code,
                  X_NEW_PROJECT_SYSTEM_STATUS_CO => l_new_sys_status,
                  X_OLD_PROJECT_STATUS_CODE      => l_proj_stus_code,
                  X_OLD_PROJECT_SYSTEM_STATUS_CO => l_old_sys_status,
                  X_CHANGE_COMMENT               => l_note,
                  X_LAST_UPDATED_BY              => fnd_global.user_id,
                  X_CREATED_BY                   => fnd_global.user_id,
                  X_CREATION_DATE                => sysdate,
                  X_LAST_UPDATE_DATE             => sysdate,
                  X_LAST_UPDATE_LOGIN            => fnd_global.user_id);

Line: 830

                      x_update_db_YN         => 'N',
                      x_populate_msg_yn      => 'Y',
                      x_err_code             => l_err_code );

Line: 853

                             x_update_db_yn IN VARCHAR2,
                             x_err_code  OUT NOCOPY NUMBER ) IS --File.Sql.39 bug 4440895
BEGIN
     x_err_code := 0;

Line: 857

     IF x_update_db_yn = 'Y' THEN
        UPDATE pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
        SET project_status_code = x_failure_status_code,
            Wf_Status_code      = NULL,
            last_update_date    = sysdate, -- added who columns for bug 16243557
            last_updated_by     = fnd_global.user_id,
            last_update_login   = fnd_global.login_id
        WHERE project_id = x_project_id;

Line: 891

SELECT wf_success_status_code,
       wf_failure_status_code
FROM   pa_project_statuses
WHERE  project_status_code = l_proj_stus_code;

Line: 957

SELECT * FROM pa_projects_all /* Bug#6367069 replaced PA_PROJECTS with PA_PROJECTS_ALL */
WHERE project_id = x_project_id;