APPS.ZPB_EXCEPTION_ALERT SQL Statements

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

Line: 29

     select count(*) INTO countEx
       from ZPB_EXCP_RESULTS
       where TASK_ID = TaskID;

Line: 34

       select  value into ExplainReq
        from ZPB_TASK_PARAMETERS
        where TASK_ID = TaskID and NAME = 'EXPLANATION_REQUIRED_FLAG';

Line: 79

      select NAME, VALUE
      from ZPB_TASK_PARAMETERS
      where TASK_ID = TaskID and NAME <> 'SPECIFIED_TARGET_NAME';

Line: 110

                  elsif taskParamName = 'SAVED_SELECTION_NAME' then
                    value := v_tskparams.value;

Line: 115

                         FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_SELECT_LABEL');

Line: 121

          aname => 'EXCEPSELECTION',
          avalue => value);

Line: 162

    select value into l_authorIDT
       from  zpb_task_parameters
       where task_id = TaskID and name = 'OWNER_ID';

Line: 198

    select NAME, value
    from ZPB_TASK_PARAMETERS
    where TASK_ID = TaskID and name = 'SPECIFIED_NOTIFICATION_RECIPIENT';

Line: 291

   select TASK_NAME into TaskName
   from zpb_analysis_cycle_tasks
   where ANALYSIS_CYCLE_ID = InstanceID and task_id = taskid;

Line: 297

   select value into l_authorIDT
     from  zpb_task_parameters
     where task_id = TaskID and name = 'OWNER_ID';

Line: 304

   select VALUE
   into ExcType
   from ZPB_TASK_PARAMETERS
   where TASK_ID = TaskID and name = 'EXCEPTION_TYPE';

Line: 399

   select TASK_NAME
   into TaskName
   from zpb_analysis_cycle_tasks
   where ANALYSIS_CYCLE_ID = InstanceID and task_id = taskid;

Line: 409

   select INSTANCE_DESCRIPTION
   into InstanceDesc
   from ZPB_ANALYSIS_CYCLE_INSTANCES
   where INSTANCE_AC_ID = InstanceID;

Line: 465

      select NAME, VALUE
      from ZPB_TASK_PARAMETERS
      where TASK_ID = TaskID and ( NAME = 'WAIT_TYPE' or NAME = 'WAIT_VALUE' );

Line: 483

    select value into l_authorIDT
       from  zpb_task_parameters
       where task_id = TaskID and name = 'OWNER_ID';

Line: 494

     select  value into ntfType
       from ZPB_TASK_PARAMETERS
       where TASK_ID = TaskID and NAME = 'EXPLANATION_REQUIRED_FLAG';

Line: 498

     select  value into ntfTarget
       from ZPB_TASK_PARAMETERS
       where TASK_ID = TaskID and NAME = 'NOTIFICATION_RECIPIENT_TYPE';

Line: 502

     select  value into ExcType
       from ZPB_TASK_PARAMETERS
       where TASK_ID = TaskID and NAME = 'EXCEPTION_TYPE';

Line: 675

      select *
      from ZPB_EXCP_RESULTS
      where TASK_ID = TaskID;

Line: 689

     select value into l_dimname from ZPB_TASK_PARAMETERS
     where TASK_ID = TaskID and NAME = 'EXCEPTION_DIMENSION_NAME';

Line: 758

      select distinct OWNER
      from ZPB_EXCP_RESULTS
      where TASK_ID = TaskID
      order by OWNER;

Line: 823

      select *
      from ZPB_EXCP_RESULTS
      where TASK_ID = TaskID and OWNER = role;

Line: 900

      select distinct OWNER_ID, OWNER,  APPROVER_ID, APPROVER
      from ZPB_EXCP_RESULTS
      where TASK_ID = TaskID
      order by OWNER;

Line: 909

      select ITEM_KEY
      from WF_ITEMS_V
      where PARENT_ITEM_KEY = ParentItemKey;

Line: 943

   select TASK_NAME
   into TaskName
   from zpb_analysis_cycle_tasks
   where ANALYSIS_CYCLE_ID = InstanceID and task_id = taskid;

Line: 948

   select INSTANCE_DESCRIPTION
   into InstanceDesc
   from ZPB_ANALYSIS_CYCLE_INSTANCES
   where INSTANCE_AC_ID = InstanceID;

Line: 1003

        select distinct display_name
           into NewDispName
           from wf_users
           where name = thisOwner;

Line: 1033

        select distinct display_name
           into NewDispName
           from wf_users
           where name = thisApprover;

Line: 1182

      select *
      from ZPB_EXCP_RESULTS
      where TASK_ID = TaskID and OWNER = DataOwner;

Line: 1196

     select value into l_dimname
       from ZPB_TASK_PARAMETERS
       where TASK_ID = TaskID and NAME = 'EXCEPTION_DIMENSION_NAME';

Line: 1303

      select distinct display_name
        into UserDispName
        from wf_roles
        where name = thisRole;

Line: 1581

      select ITEM_KEY
      from WF_ITEMS_V
      where PARENT_ITEM_KEY = ParentItemKey;

Line: 1588

      select value
      from ZPB_TASK_PARAMETERS
      where TASK_ID = TaskID and name = 'SPECIFIED_NOTIFICATION_RECIPIENT';

Line: 1624

   select TASK_NAME, LAST_UPDATED_BY
   into TaskName, thisApproverID
   from zpb_analysis_cycle_tasks
   where ANALYSIS_CYCLE_ID = InstanceID and task_id = taskid;

Line: 1629

   select INSTANCE_DESCRIPTION
   into InstanceDesc
   from ZPB_ANALYSIS_CYCLE_INSTANCES
   where INSTANCE_AC_ID = InstanceID;

Line: 1634

   select value
    into ApproverTYPE
    from ZPB_TASK_PARAMETERS
    where TASK_ID = TaskID and name = 'EXPLANATION_APPROVER';

Line: 1682

        select distinct display_name
           into NewDispName
           from wf_users
           where name = thisRecipient;

Line: 1711

        select distinct display_name
           into NewDispName
           from wf_users
           where name = thisApprover;

Line: 1862

      select NAME, value
      from ZPB_TASK_PARAMETERS
      where TASK_ID = TaskID;

Line: 1878

      select count(*) into thisCount
        from WF_ITEM_ACTIVITY_STATUSES
        where ITEM_TYPE = 'EPBCYCLE' and
        ITEM_KEY in (select ITEM_KEY from WF_ITEMS_V where PARENT_ITEM_KEY = ItemKey)
        and (ACTIVITY_STATUS = 'NOTIFIED' or ACTIVITY_RESULT_CODE = '#TIMEOUT');

Line: 1894

          select INSTANCE_DESCRIPTION
            into InstDesc
            from ZPB_ANALYSIS_CYCLE_INSTANCES
            where INSTANCE_AC_ID = InstanceID;

Line: 1915

                  elsif taskParamName = 'SAVED_SELECTION_NAME' then
                    value := v_tparams.value;

Line: 1921

                         FND_MESSAGE.SET_NAME ('ZPB', 'ZPB_NTF_SELECT_LABEL');

Line: 1927

          aname => 'EXCEPSELECTION',
          avalue => value);

Line: 1969

     SELECT ITEM_KEY, ASSIGNED_USER
       FROM WF_ITEM_ACTIVITY_STATUSES
       WHERE ITEM_TYPE = 'EPBCYCLE' and
       ITEM_KEY in  (select ITEM_KEY from WF_ITEMS_V where PARENT_ITEM_KEY = ItemKey)
       and (ACTIVITY_STATUS = 'NOTIFIED' or ACTIVITY_RESULT_CODE = '#TIMEOUT');

Line: 1994

      select activity_id into l_activity_id
        from  WF_ITEM_ACTIVITY_STATUSES_V
        WHERE ITEM_TYPE = 'EPBCYCLE'
        AND ITEM_KEY = childItemKey
        AND activity_name = 'EXPREQNTF';

Line: 2041

      select activity_id into l_activity_id
        from  WF_ITEM_ACTIVITY_STATUSES_V
        WHERE ITEM_TYPE = 'EPBCYCLE'
        AND ITEM_KEY = childItemKey
        and activity_name = 'EXPAPPROVAL';

Line: 2142

      select distinct OWNER, OWNER_ID, APPROVER, APPROVER_ID
      from ZPB_EXCP_EXPLANATIONS
      where TASK_ID = TaskID and Notification_id = NID and STATUS = 2
      order by OWNER;

Line: 2171

   select ITEM_KEY into ItemKey
   from WF_ITEM_ACTIVITY_STATUSES_V
   where item_type = 'EPBCYCLE' and NOTIFICATION_ID = NID;

Line: 2196

         aname => 'EXCEPSELECTION');

Line: 2275

        select distinct display_name
           into NewDispName
           from wf_users
           where name = thisOwner;

Line: 2302

        select distinct display_name
           into NewDispName
           from wf_users
           where name = thisApprover;

Line: 2384

         aname => 'EXCEPSELECTION',
         avalue => ExcepSel);

Line: 2519

      select *
      from ZPB_EXCP_EXPLANATIONS
      where TASK_ID = TaskID and
      NOTIFICATION_ID = nid and
      OWNER = DataOwner and
      status = 2;

Line: 2540

     select value into l_dimname
       from ZPB_TASK_PARAMETERS
       where TASK_ID = TaskID and NAME = 'EXCEPTION_DIMENSION_NAME';

Line: 2620

      select distinct OWNER_ID, OWNER
      from ZPB_EXCP_RESULTS
      where TASK_ID = TaskID
      order by OWNER;

Line: 2629

      select ITEM_KEY
      from WF_ITEMS_V
      where PARENT_ITEM_KEY = ParentItemKey;

Line: 2654

   select TASK_NAME into TaskName
   from zpb_analysis_cycle_tasks
   where ANALYSIS_CYCLE_ID = InstanceID and task_id = taskid;

Line: 2659

    select value into l_authorIDT
       from  zpb_task_parameters
       where task_id = TaskID and name = 'OWNER_ID';

Line: 2666

   select INSTANCE_DESCRIPTION
   into InstanceDesc
   from ZPB_ANALYSIS_CYCLE_INSTANCES
   where INSTANCE_AC_ID = InstanceID;

Line: 2671

   select VALUE
   into ExcType
   from ZPB_TASK_PARAMETERS
   where TASK_ID = TaskID and name = 'EXCEPTION_TYPE';

Line: 2707

        select distinct display_name
           into NewDispName
           from wf_users
           where name = thisOwner;

Line: 2823

      select ITEM_KEY
      from WF_ITEMS_V
      where PARENT_ITEM_KEY = ParentItemKey;

Line: 2862

   select TASK_NAME, LAST_UPDATED_BY
   into TaskName, thisApproverID
   from zpb_analysis_cycle_tasks
   where ANALYSIS_CYCLE_ID = InstanceID and task_id = taskid;

Line: 2867

   select INSTANCE_DESCRIPTION
   into InstanceDesc
   from ZPB_ANALYSIS_CYCLE_INSTANCES
   where INSTANCE_AC_ID = InstanceID;

Line: 2872

   select value
    into ApproverTYPE
    from ZPB_TASK_PARAMETERS
    where TASK_ID = TaskID and name = 'EXPLANATION_APPROVER';

Line: 2917

        select distinct display_name
           into NewDispName
           from wf_users
           where name = thisRecipient;

Line: 2946

        select distinct display_name
           into NewDispName
           from wf_users
           where name = thisApprover;