APPS.BIS_PMV_PAGE_PARAMS_PUB SQL Statements

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

Line: 17

PROCEDURE RETRIEVE_LASTUPDATE_DATE
(p_user_name            IN  VARCHAR2
,p_page_id              IN  VARCHAR2
,p_session_id           IN  NUMBER default null
,x_last_update_date     OUT NOCOPY VARCHAR2
,x_return_Status        OUT NOCOPY VARCHAR2
,x_msg_count            OUT NOCOPY NUMBER
,x_msg_data             OUT NOCOPY VARCHAR2
)
IS
  /* Bug 2551994 Modifications to default as of date to sysdate for every login */
  CURSOR c_lastupdatedate IS
  SELECT to_char(bua.last_update_date,'RRRR/MM/DD HH24:MI:SS')last_update_date
  ,bua.attribute_name, bua.session_value, bua.user_id, bua.session_id, bua.function_name
  FROM bis_user_attributes bua, fnd_user fu
  WHERE bua.page_id=p_page_id
  AND   bua.user_id = to_char(fu.user_id)
  AND   fu.user_name = p_user_name;

Line: 41

  SELECT parameters
  FROM fnd_form_functions
  WHERE function_name = l_function_name and
  instr(parameters,'pRequestType=P') > 0
  and instr(parameters, 'pAsOfDate=') > 0;

Line: 70

  for c_rec in c_lastupdatedate loop
      if (c_rec.attribute_name = 'AS_OF_DATE') then
         l_asof_date := c_rec.session_value;

Line: 73

         x_last_update_date := c_rec.last_update_Date;

Line: 104

          l_asofdate_func := 'select to_char('||l_asofdate_func||',''DD/MM/YYYY'') from dual';

Line: 109

            update bis_user_attributes
            set session_value = l_new_asofdate
            ,session_description = l_new_asofdate
            , last_update_date = sysdate
            where page_id=p_page_id
            and user_id = l_user_id
            and attribute_name = l_attribute_name;

Line: 116

            x_last_update_date := to_char(sysdate,'RRRR/MM/DD HH24:MI:SS');

Line: 126

          update bis_user_attributes
          set session_value = to_char(sysdate,'DD/MM/YYYY')
          ,session_description = to_char(sysdate,'DD/MM/YYYY')
          --As of Date 3094234--dd/mm/yyyy format
          --set session_value = to_char(sysdate,'DD-MON-YYYY')
          --,session_description = to_char(sysdate,'DD-MON-YYYY')
          , last_update_date = sysdate
            where page_id=p_page_id
            and user_id = l_user_id
            and attribute_name = l_attribute_name;

Line: 136

            x_last_update_date := to_char(sysdate,'RRRR/MM/DD HH24:MI:SS');

Line: 166

  SELECT bua.attribute_name, bua.session_description
  FROM bis_user_attributes bua, fnd_user fu
  WHERE bua.page_id=p_page_id AND
        bua.user_id=to_char(fu.user_id) AND
        fu.user_name = p_user_name
  ORDER BY bua.attribute_name;

Line: 209

  SELECT bua.attribute_name, bua.session_description
  FROM bis_user_attributes bua
  WHERE bua.page_id=p_page_id AND
        bua.user_id=p_user_id
  ORDER BY bua.attribute_name;

Line: 293

  SELECT region_application_id, help_target
  FROM ak_regions
  WHERE region_code = pRegionCode ;

Line: 298

  SELECT target_name
  FROM fnd_help_targets
  WHERE target_name = p_Function_Name ;

Line: 382

    SELECT fa.APPLICATION_ID
    FROM fnd_application fa
    WHERE fa.APPLICATION_SHORT_NAME = SUBSTR(p_Function_Name,1,3) ;