APPS.AMS_PROD_TEMPLATE_ATTR_PKG SQL Statements

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

Line: 9

 ,X_parent_select_all		IN       VARCHAR2
 ,X_attribute_code		IN       VARCHAR2
 ,X_default_flag		IN       VARCHAR2
 ,X_editable_flag		IN       VARCHAR2
 ,X_hide_flag			IN       VARCHAR2
 ,X_Owner			IN       VARCHAR2
 ,X_CUSTOM_MODE                 IN       VARCHAR2
) is

l_user_id   number := 0;

Line: 27

  select object_version_number
  from    ams_prod_template_attr
  where  template_attribute_id =  X_TEMPLATE_attribute_ID;

Line: 32

  select 'x'
  from   ams_prod_template_attr
  where  template_attribute_id =  X_TEMPLATE_attribute_ID;

Line: 37

   select ams_prod_template_attr_S.nextval
   from dual;

Line: 41

  select last_updated_by, nvl(object_version_number,1)
  from   ams_prod_template_attr
  where  template_attribute_id =  X_TEMPLATE_attribute_ID;

Line: 74

    INSERT INTO ams_prod_template_attr(
           TEMPLATE_ATTRIBUTE_ID,
           template_id,
           last_update_date,
           last_updated_by,
           creation_date,
           created_by,
           object_version_number,
           last_update_login,
           PARENT_ATTRIBUTE_CODE,
	   PARENT_SELECT_ALL  ,
	   ATTRIBUTE_CODE ,
	   DEFAULT_FLAG ,
	   EDITABLE_FLAG ,
	   HIDE_FLAG
     ) VALUES (
            l_template_attribute_id
            ,x_template_id
           ,SYSDATE
           ,l_user_id
           ,SYSDATE
           ,l_user_id
           ,1
           ,0
           ,x_PARENT_ATTRIBUTE_CODE
	   ,x_PARENT_SELECT_ALL
	   ,x_ATTRIBUTE_CODE
	   ,x_DEFAULT_FLAG
	   ,x_EDITABLE_FLAG
	   ,x_HIDE_FLAG );

Line: 117

        Update ams_prod_template_attr
        SET  last_update_date = sysdate,
           last_updated_by = l_user_id,
           object_version_number = l_obj_verno +1,
           last_update_login = 0,
           PARENT_ATTRIBUTE_CODE = x_PARENT_ATTRIBUTE_CODE ,
	   PARENT_SELECT_ALL  =   x_PARENT_SELECT_ALL,
	   ATTRIBUTE_CODE   =     x_ATTRIBUTE_CODE ,
	   DEFAULT_FLAG    =      x_DEFAULT_FLAG  ,
	   EDITABLE_FLAG   =      x_EDITABLE_FLAG  ,
	   HIDE_FLAG =        x_HIDE_FLAG
        WHERE TEMPLATE_attribute_ID =  X_template_attribute_id
        AND   object_version_number = l_obj_verno;