APPS.EGO_UPGRADE_USER_ATTR_VAL_PUB SQL Statements

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

Line: 43

    SELECT CATEGORY_SET_ID
      FROM MTL_DEFAULT_CATEGORY_SETS
     WHERE FUNCTIONAL_AREA_ID = p_functional_area_id;

Line: 54

   SELECT CAT.CATEGORY_ID
      FROM MTL_CATEGORY_SET_VALID_CATS CAT, MTL_CATEGORY_SETS_B CATSET
     WHERE CAT.CATEGORY_SET_ID = CATSET.CATEGORY_SET_ID
       AND CATSET.CATEGORY_SET_ID = p_cat_set_id
       AND NOT EXISTS
                (SELECT CATEGORY_ID
                 FROM EGO_PRODUCT_CAT_SET_EXT
                 WHERE CATEGORY_SET_ID = CATSET.CATEGORY_SET_ID
				 AND CATEGORY_ID = CAT.CATEGORY_ID
                 AND ATTR_GROUP_ID = p_attr_group_id);

Line: 77

    SELECT ATTRS.ATTR_GROUP_ID, ATTRS.ATTR_GROUP_NAME
      FROM EGO_ATTR_GROUPS_V ATTRS
     WHERE ATTRS.ATTR_GROUP_NAME = 'SalesAndMarketing'
       AND p_functional_area_id = 11;

Line: 87

    SELECT ATTRS.ATTR_GROUP_ID
      FROM EGO_ATTR_GROUPS_V ATTRS
     WHERE ATTRS.ATTR_GROUP_NAME = attribute_group_name;

Line: 130

          	-- Now we update the Primary Key value, and clear out the Attr  --
          	-- Data table                                                 --
          	------------------------------------------------------------------
          	l_data_column_name_value_pairs(1).VALUE := cat_rec.CATEGORY_ID;

Line: 145

                  ,p_use_def_vals_on_insert      => FND_API.G_TRUE
		  ,x_return_status               => x_return_status
                  ,x_errorcode                   => x_errorcode
                  ,x_msg_count                   => x_msg_count
                  ,x_msg_data                    => x_msg_data
                  );

Line: 176

	   	-- Now we update the Primary Key value  --
           	------------------------------------------
           	l_data_column_name_value_pairs(1).VALUE := cat_rec.CATEGORY_ID;

Line: 190

       		   ,p_use_def_vals_on_insert      => FND_API.G_TRUE
		   ,x_return_status               => x_return_status
       		   ,x_errorcode                   => x_errorcode
       		   ,x_msg_count                   => x_msg_count
       		   ,x_msg_data                    => x_msg_data
    		   );