APPS.ZPB_EXCP_PVT SQL Statements

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

Line: 39

    select name, value
    from zpb_task_parameters
    where task_id = p_task_id
          and ( name = EXCEPTION_LIMIT
          or name = QUERY_OBJECT_PATH
          or name = QUERY_OBJECT_NAME );

Line: 47

    select dimension_name dim, hierarchy_name hier
    from zpb_status_sql
    where (query_path = l_query);

Line: 92

  select analysis_cycle_id into l_instance_id
  from   zpb_analysis_cycle_tasks
  where  task_id = p_task_id;

Line: 135

    update zpb_excp_results z
      set owner = (
      select user_name
      from fnd_user f
      where f.user_id = z.owner_id),
                        LAST_UPDATED_BY =  fnd_global.USER_ID,
                        LAST_UPDATE_DATE = SYSDATE,
                        LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
      where task_id = l_task_id;

Line: 145

    update zpb_excp_results z
      set approver = (
      select user_name
      from fnd_user f
      where f.user_id = z.approver_id),
                        LAST_UPDATED_BY =  fnd_global.USER_ID,
                        LAST_UPDATE_DATE = SYSDATE,
                        LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
      where task_id = l_task_id;

Line: 266

  delete from zpb_excp_explanations
  where task_id = p_task_id
  and notification_id = p_notification_id;

Line: 271

  insert into zpb_excp_explanations(NOTIFICATION_ID, TASK_ID, MEMBER_ID, MEMBER_DISPLAY,
    OWNER_ID, OWNER, APPROVER_ID, APPROVER, STATUS, VALUE_flag, value_number,
    CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
  (select p_notification_id, e.TASK_ID, e.MEMBER_ID, e.MEMBER_DISPLAY,
    e.OWNER_ID, e.OWNER, e.APPROVER_ID, e.APPROVER, g_req_child_nodes, e.VALUE_flag, e.value_number,
    fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
  from zpb_excp_explanations e
  where e.task_id = p_task_id
  and e.owner_id = nvl(sys_context('ZPB_CONTEXT', 'shadow_id'), fnd_global.user_id));

Line: 281

  insert into zpb_excp_explanations(NOTIFICATION_ID, TASK_ID, MEMBER_ID, MEMBER_DISPLAY,
    OWNER_ID, OWNER, APPROVER_ID, APPROVER, STATUS, VALUE_flag, value_number,
    CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
  (select p_notification_id, e.TASK_ID, e.MEMBER_ID, e.MEMBER_DISPLAY,
    e.OWNER_ID, e.OWNER, e.APPROVER_ID, e.APPROVER, g_req_child_nodes, e.VALUE_flag, e.value_number,
    fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id
  from zpb_excp_results e
  where e.task_id = p_task_id
  and e.owner_id = nvl(sys_context('ZPB_CONTEXT', 'shadow_id'), fnd_global.user_id));

Line: 365

    select name, value
    from zpb_task_parameters
    where task_id = p_task_id
          and ( name = QUERY_OBJECT_PATH
          or name = QUERY_OBJECT_NAME );

Line: 372

    select dimension_name dim, hierarchy_name hier
    from zpb_status_sql
    where (query_path = l_query);

Line: 404

  select responsibility_key into l_resp_key
    from fnd_responsibility
    where responsibility_id = l_resp_id;

Line: 459

    update zpb_excp_explanations z
      set owner = (
      select user_name
      from fnd_user f
      where f.user_id = z.owner_id),
        LAST_UPDATED_BY =  fnd_global.USER_ID, LAST_UPDATE_DATE = SYSDATE,
        LAST_UPDATE_LOGIN = fnd_global.LOGIN_ID
      where task_id = p_task_id
      and notification_id = p_notification_id;