APPS.ZPB_WF_ERROR SQL Statements

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

Line: 123

          select NAME into l_BUSINESSAREA
           from zpb_business_areas_vl
           where BUSINESS_AREA_ID = l_BUSINESSAREAID;

Line: 142

      select distinct display_name
       into l_NewDispName
       from wf_users
       where name = l_thisRecipient;

Line: 218

     update zpb_analysis_cycle_tasks
       set status_code = 'ERROR',
         LAST_UPDATED_BY =  fnd_global.USER_ID,
         LAST_UPDATE_DATE = SYSDATE,
         LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
       where task_id = l_TaskID;

Line: 230

      update zpb_ANALYSIS_CYCLES
       set status_code = 'ERROR',
       LAST_UPDATED_BY =  fnd_global.USER_ID,
       LAST_UPDATE_DATE = SYSDATE,
       LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
       where ANALYSIS_CYCLE_ID = l_InstanceID;

Line: 237

      update zpb_analysis_cycle_instances
       set last_update_date = sysdate,
       LAST_UPDATED_BY =  fnd_global.USER_ID,
       LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
       where instance_ac_id = l_InstanceID;

Line: 361

          select NAME into l_BUSINESSAREA
           from zpb_business_areas_vl
           where BUSINESS_AREA_ID = l_BUSINESSAREAID;

Line: 378

      select DISTINCT ACTIVITY_RESULT_CODE, ACTIVITY_RESULT_DISPLAY_NAME
         into l_result_code, l_req_resultDisp
         from wf_item_activity_statuses_v
         where item_type= itemtype
         and item_key= itemkey
         and ACTIVITY_RESULT_CODE
         in ('ERROR', 'CANCELLED', 'TERMINATED', 'WARNING');

Line: 398

       SELECT COUNT(r.STATUS_CODE)
          INTO l_count
          FROM Fnd_Concurrent_Requests r
               WHERE r.REQUEST_ID = l_request_id
          and r.PROGRAM_APPLICATION_ID = l_appID
          and r.REQUESTED_BY = l_ownerID;

Line: 407

         SELECT distinct R.STATUS_CODE, R.LOGFILE_NAME, CONCURRENT_PROGRAM_ID
            into l_req_status, l_reqlog, l_concprgID
          FROM Fnd_Concurrent_Requests r
               WHERE r.REQUEST_ID = l_request_id
          and r.PROGRAM_APPLICATION_ID = l_appID
          and r.REQUESTED_BY = l_ownerID;

Line: 415

         select USER_CONCURRENT_PROGRAM_NAME
          into l_ConcName
          from fnd_concurrent_programs_vl
          where APPLICATION_ID  = 210
          and CONCURRENT_PROGRAM_ID = l_concprgID;

Line: 463

     update zpb_analysis_cycle_tasks
       set status_code = 'ERROR',
         LAST_UPDATED_BY =  fnd_global.USER_ID,
         LAST_UPDATE_DATE = SYSDATE,
         LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
       where task_id = l_TaskID;

Line: 475

      update zpb_ANALYSIS_CYCLES
       set status_code = 'ERROR',
       LAST_UPDATED_BY =  fnd_global.USER_ID,
       LAST_UPDATE_DATE = SYSDATE,
       LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
       where ANALYSIS_CYCLE_ID = l_InstanceID;

Line: 482

      update zpb_analysis_cycle_instances
       set last_update_date = sysdate,
       LAST_UPDATED_BY =  fnd_global.USER_ID,
       LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
       where instance_ac_id = l_InstanceID;