APPS.BIS_CONCURRENT_MANAGER_PVT SQL Statements

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

Line: 149

        BIS_PMF_ALERT_REG_PVT.Delete_Parameter_Set
        ( p_registration_ID => l_Param_Set_tbl(i).registration_id
        , x_return_status   => x_return_status
        );

Line: 164

        BIS_UTILITIES_PUB.put_line(p_text =>i||'th param set did not get deleted.');

Line: 166

      BIS_UTILITIES_PUB.put_line(p_text =>i||'th deleted.');

Line: 215

  SELECT *
  FROM fnd_concurrent_requests
  WHERE Program_Application_ID = l_Application_ID
    And Concurrent_Program_ID  = l_Concurrent_Program_ID
    and argument3 = p_param_set_rec.target_level_id
    and argument5 = p_param_set_rec.plan_id
    and ((argument8 is null and p_param_set_rec.PARAMETER1_VALUE is null)
     or  (argument8 = p_param_set_rec.PARAMETER1_VALUE)
    )
    and ((argument11  is null and p_param_set_rec.PARAMETER2_VALUE IS NULL)
    or (argument11 = p_param_set_rec.PARAMETER2_VALUE)
    )
    and ((argument14  is null and p_param_set_rec.PARAMETER3_VALUE IS NULL)
    or (argument14 = p_param_set_rec.PARAMETER3_VALUE)
    )
    and ((argument17  is null and p_param_set_rec.PARAMETER4_VALUE IS NULL)
    or (argument17 = p_param_set_rec.PARAMETER4_VALUE)
    )
    and ((argument20  is null and p_param_set_rec.PARAMETER5_VALUE IS NULL)
    or (argument20 = p_param_set_rec.PARAMETER5_VALUE)
    )
    and ((argument23  is null and p_param_set_rec.PARAMETER6_VALUE IS NULL)
    or (argument23 = p_param_set_rec.PARAMETER6_VALUE)
    )
    order by request_id desc
    -- order by ACTUAL_START_DATE desc
    ;

Line: 244

  SELECT *
  FROM fnd_concurrent_requests
  WHERE Program_Application_ID = l_Application_ID
    And Concurrent_Program_ID  = l_Concurrent_Program_ID
    and argument1 = p_param_set_rec.performance_measure_id
    and (p_param_set_rec.TIME_DIMENSION_LEVEL_ID is null
--    and ((argument7 is null
--          and p_param_set_rec.TIME_DIMENSION_LEVEL_ID is null)
     or argument7 = p_param_set_rec.TIME_DIMENSION_LEVEL_ID
    )
    and argument3 IS NULL
    order by request_id desc
  --  order by ACTUAL_START_DATE desc
    ;

Line: 277

      select * into l_target_level_rec
      from bisbv_target_levels
      where target_level_id = p_param_set_rec.target_level_id;

Line: 404

  Select Concurrent_Program_ID, P.Application_ID
  Into x_Concurrent_Program_ID, x_Application_ID
  From Fnd_Concurrent_Programs P, Fnd_Application A
  Where Concurrent_Program_Name  = l_conc_program_name
  And P.Application_ID           = A.Application_ID
  And A.Application_Short_Name
    = BIS_UTILITIES_PVT.G_BIS_APPLICATION_SHORT_NAME;

Line: 910

    Select lower(meaning)
    Into l_repeat_unit
    From Fnd_Lookups
    Where upper (Lookup_Code) = upper (p_freq_unit_code)
    And Lookup_Type = 'CP_RESUBMIT_INTERVAL_UNIT';