APPS.BIS_PMV_PARAMETERS_PUB SQL Statements

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

Line: 14

  SELECT session_description,
         session_value,
         period_date,
         dimension,
         operator
  INTO   p_parameter_rec.parameter_description,
         p_parameter_rec.parameter_value,
         p_parameter_rec.period_date,
         p_parameter_rec.dimension,
         p_parameter_rec.operator
  FROM   BIS_USER_ATTRIBUTES
  WHERE  attribute_name = p_parameter_rec.parameter_name
  AND    user_id = p_page_session_rec.user_id
  AND    page_id = p_page_session_rec.page_id;

Line: 53

 SELECT attribute_name,
        session_description,
        session_value,
        period_date,
        dimension,
        operator
 FROM   BIS_USER_ATTRIBUTES
 WHERE  user_id = p_page_session_rec.user_id
 AND    page_id = p_page_session_rec.page_id
 AND   dimension <>  'TIME_COMPARISON_TYPE'
 AND   attribute_name <> 'AS_OF_DATE';

Line: 121

 SELECT customview.customization_code, customview.customization_application_id
 FROM ak_customizations customView, bis_ak_custom_regions bookmark
 WHERE customView.region_code=p_region_code AND
 customView.region_application_id=p_region_application_id AND
 customView.customization_code=bookmark.customization_code AND
 customView.customization_application_id=bookmark.customization_application_id AND
 customView.region_code=bookmark.region_code AND
 customView.region_application_id=bookmark.region_application_id AND
 customView.function_name=p_function_name AND
 customView.customization_level_id=30 AND
 bookmark.property_name='BOOKMARK_URL';

Line: 141

  	-- delete region items customization
    delete from AK_CUSTOM_REGION_ITEMS
    where CUSTOMIZATION_APPLICATION_ID = cr.customization_application_id
    and   CUSTOMIZATION_CODE           = cr.customization_code
    and   REGION_APPLICATION_ID        = p_region_application_id
    and   REGION_CODE                  = p_region_code;

Line: 152

	delete from AK_CUSTOM_REGION_ITEMS_TL
	where CUSTOMIZATION_APPLICATION_ID = cr.customization_application_id
	and   CUSTOMIZATION_CODE           = cr.customization_code
	and   REGION_APPLICATION_ID        = p_region_application_id
	and   REGION_CODE                  = p_region_code;

Line: 162

  	-- delete region customization
    delete from AK_CUSTOM_REGIONS
    where CUSTOMIZATION_APPLICATION_ID = cr.customization_application_id
    and   CUSTOMIZATION_CODE           = cr.customization_code
    and   REGION_APPLICATION_ID        = p_region_application_id
    and   REGION_CODE                  = p_region_code;

Line: 173

	delete from AK_CUSTOM_REGIONS_TL
	where CUSTOMIZATION_APPLICATION_ID = cr.customization_application_id
	and   CUSTOMIZATION_CODE           = cr.customization_code
	and   REGION_APPLICATION_ID        = p_region_application_id
	and   REGION_CODE                  = p_region_code;

Line: 183

  	-- delete customization
  	AK_CUSTOMIZATIONS_PKG.DELETE_ROW (
		X_CUSTOMIZATION_APPLICATION_ID	=> cr.customization_application_id
	,	X_CUSTOMIZATION_CODE           	=> cr.customization_code
	, 	X_REGION_APPLICATION_ID        	=> p_region_application_id
	,	X_REGION_CODE                  	=> p_region_code
  	);

Line: 195

  	-- delete bis region customization
    delete from BIS_AK_CUSTOM_REGIONS
    where CUSTOMIZATION_APPLICATION_ID = cr.customization_application_id
    and   CUSTOMIZATION_CODE           = cr.customization_code
    and   REGION_APPLICATION_ID        = p_region_application_id
    and   REGION_CODE                  = p_region_code
  	and   PROPERTY_NAME			       = 'BOOKMARK_URL';